Q:

I have created a new empty database in SQL Server 2005 named RMDB and then executed the commands in RM_Empty22_DDL_SQLServer.txt. In RM I have Added the database RMDB with type OLE but do not know what Connection String to fill in.  

A:

Here is a generic way of making Connection Strings for any OLEDB Provider:

Create a new empty text document, rename its extension from .txt to .udl
Doubleclick the udl-file and a form will open
1. Choose provider in the first tab and click Next (if your DB Provider is missing you need
    to install the DB Client for your DB on your computer first)
2. Fill in server name for the computer where the DB is, userid and password and choose
    DB (in your case you should find RMDB in the list).
3. Click Test Connection, should be ok
4. Check Allow saving password
5. Click OK to save and close the form
6. Open the file with Notepad or other text editor
7. Your Connection String is at the second line in the document (the whole line)

This should work for any type of database.

Q:

What is the difference between DB Type OLE and OLEuc?

A:

uc means UpperCase. All source loaded with OLEuc will be uppercase in the AMWord-
table. This will increase performance of RM but the languages loaded this way must not be case sensitive. It is suitable for large amounts of mainframe source.

Q:

I would like to start RM with an empty Query-form against a preset database, can I do that?

A:

Yes, open a new Query-form (File/New/Query for Statements), make sure it is connected to the database you want and save the document (File/Save As) to your desktop with a suitable name, for example RMQuery_MyDatabase.rmq.

Start RM by double click the saved rmq-file on your desktop. You might be asked for which program to open the rmq-file with, choose ResourceMiner.exe. Check 'Always use this program...' to avoid answer that question again next time.

Q:

I would like to start RM with a View-form against a preset database and preset to Dependencies-TopDown-Entry, can I do that?

A:

Yes, open a new View-form (File/New/View), make sure it is connected to the database you want, set the controlpanel as you want and save the document (File/Save As) to your desktop with a suitable name, for example RMViewEntrys_MyDatabase.rmv.

Start RM by double click the saved rmv-file on your desktop. You might be asked for which program to open the rmv-file with, choose ResourceMiner.exe. Check 'Always use this program...' to avoid answer that question again next time.

Q:

Must I have a 'Repository Get Latest Script'? What is it?

A:

RM loads source files from PC-folders in your computer or network file server. If the source files are available that way, a 'Repository Get Latest Script' is not needed.

If source files recides in a CM-tool repository like for example SourceSafe, PVCS, CVS etc, you need to run a script or program to extract the files to PC-folders. The RM-folder contains the example script vss.bat to get files from SourceSafe.

'Repository Get Latest Script' can also be used to FTP files from a file system in other environments, for example Unix, IBM Mainframe etc.

See ResourceMiner Manual.pdf for more information.

Q:

My source files is distributed in a tree of folders, do I have to point out each folder in the tree? 

A:

No, just point out the highest level in the tree. RM loads all files in the choosen folder and all its child folders recursive.

Q:

Is there requirements on how to fill in Systems Name, Computers Type and Location and Applications Name? 

A:

No, this information is up to you. It is useful when loading several systems or applications from different folders to clarify the structure of the system(s). The names can be changed after load by the Item Properties function in the View-form.

If you want another structure of System-Computer-Application you should restart with an empty database and fill in the load-form differently. Probably by pointing out the folders at a lower level, adding more rows in the form.

Q:

Some source files in the load folder are not loaded at all, why? 

A:

RM binds language definitions to the extension of the source file names. For example, the language definition for IBMCobol loads files with the extension .ibmcob.

The reason some files do not load may be: 

a) the file extension is not what RM expect it to be
b) the language definition for that type of file is missing or not licensed
c) the files are part of the language but not needed in RM
    (for example binary or backup files) 
d) the files did not load because of parse errors.

Check Tools/Settings/Languages to see what language definitions you have and the expected file extensions for those languages. If you are missing one or more language definitions, you must order a new license file allowing those extra languages. If you have the language and its extensions do match, check if parse errors exists in the file LoadLog.txt in the RM-folder.

RM presuppose that source files are syntactic correct, ie the source must have passed syntax check or a compiler. Loading incorrect source files makes RM throw parse errors or make RM show wrong information.

You may find more answers in the category Language specific questions below.

Q:

It took all night to load about 2000 source files, is this normal?

A:

Yes, every word of those files is inserted in the database and is indexed in a number of ways. After that all dependencies (cross references) within the source is searched for, which also take some time.

The majority of the time goes to writing to disk and creating indexes. Parsing the files, ie scan through the files to decide what is objects, entrys, variables etc, is a small part of the total time. 

Next time you load the same files, only changes will be handled, it will go much faster. If not satisfied with load or search times, add more memory or use a database server with good performance.

Q:

Loading takes longer than expected, can I stop RM? 

A:

Yes, you can 'kill' RM via Task Manager at any time. RM knows where it was interrupted and will continue from that point next time you start loading to the same database.

Q:

I have deleted some source files, how can I make them disappear from RM?  

A:

Next time you start loading from those folders, RM will discover that these files has disappeared and RM will delete them from the database.

Q:

I have added some source files, how can I make them addad to RM? 

A:

Next time you start loading from those folders, RM will discover that these files has been added and RM will load them into the database.

Q:

I have renamed a few source files, how do RM handle this? 

A:

Next time you start loading from those folders, RM will discover that these files has disappeared (because they have other names) but also discover that new files has been added (their new names). The source will first be deleted from the RM database and then loaded again with their new names.

Q:

Can I make RM autoload source files to make RM auto up-to-date?

A:

Yes, RM can be started with parameters to load a database. For example, it is possible to create a Schedule Task in Windows that loads a certain database at a certain time every day (See ResourceMiner Manual.pdf and the example script BackgroundLoad.bat in the RM-folder).

It is important to consider that the source to load must be syntactic correct, ie the source must have passed syntax check or a compiler, to minimize the risk of having RM show erranuos information. 

Another solution is to write a small program that continously looks for changed files, and when a change is discovered, the program initiate a load. The check should be on the binary file (output from the compiler) to make sure source is syntactical correct. If the compiler can be customized to execute user defined tasks after compilation, that might do the job.

One should also be aware of that RM will first delete changed source files from the database and then load the changed files. This means that the source will disappear from RM for a while and that a user that is working with RM on a database while that database is loading might get wrong information.  

The most common way of loading RM up-to-date, is doing it with the source that executes in the production environment, initiating new loads when source is checked in as finished or being put into production. Loading RM with source that is continuously changing because of work can be very disturbing. Production source status is good enough for most analysis tasks. If you have just a few releases per year, each build can be loaded. In this scenario it might be useful to have two databases, one for state-of-production and one for state-of-latest-build.

Q:

An object has only 5 Entrys in RM, but has in fact 8 Entrys. Why? 

A:

RM presuppose that source files are syntactic correct, ie the source must have passed syntax check or a compiler. Loading incorrect source files can make RM show wrong information. Compile or syntax check the source file, correct errors and reload.

Q:

An object has the name 'parse error in file'? 

A:

RM presuppose that source files are syntactic correct, ie the source must have passed syntax check or a compiler. Loading incorrect source files can make RM show wrong information. Compile or syntax check the source file, correct errors and reload.

Q:

An entry has the name ' parse error in file'? 

A:

RM presuppose that source files are syntactic correct, ie the source must have passed syntax check or a compiler. Loading incorrect source files can make RM show wrong information. Compile or syntax check the source file, correct errors and reload.

Q:

A Query for Statements give hits, but EntryName is blank? 

A:

The hits exists in an Object at classlevel, and is therefore not part of any Entry. If that is not true, compile or syntax check the source file, correct errors and reload.

Q:

A Query for Statements give hits, but ObjectName is a filename? 

A:

The hits do not exists in any Object, only within the filename you see.This is normal for languages where each source file can contain several objects, some code is outside any object. If that is not true, compile or syntax check the source file, correct errors and reload.

Q:

A:

Q:

A:

Q:

A:

Q:

IBMCobol

EXEC CICS START TRANS('ABCD')  is in fact a call to a program named ABCD0001 but that dependency is not in RM. Can it be solved?

A:

IBMCobol

Yes, it is possible to insert an extra record in the AMOBJECT-table as an interface making ABCD0001 as ABCD. A program or script can be written to insert these records from information extracted from a CICS-table. Example: AMFileID = 99999 (a file that not exists), AMObjectID = 1000, AMObjectName = ABCD0001, AMObjectIdentifier = ABCD, AMIcon = -1 (means this is an Interface). Rebuild All Dependencies and the dependency should be there.

Q:

A: