What are CA Ramis database files named RAMDB2NAMES and RAMSQLID?

Document ID : KB000050352
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

My CA Ramis database has system files named RAMDB2NAMES and RAMSQLID. What are they and are they needed?

Solution:

CA Ramis system files RAMDB2NAMES and RAMSQLID have been obsolete since CA Ramis Version 7.2. Both files were part of the DB2 interface prior to the RDBMS Interface provided with CA Ramis Version 7.2, 7.3 and 7.4. As part of the upgrade/migrate procedures, RAMDB2NAMES and RAMSQLID data were migrated to system file RAMSQLMASTER. The migration process did not erase file RAMDB2NAMES and RAMSQLID and left it to the user to do so after their upgrade was completed.

Each file, if exists, can be deleted/erased using CA Ramis commands.

Note that password "DB2" is needed to erase these files:

PASS DB2   
ERASE*   
FILE RAMDB2NAMES   
END
ERASE* 
FILE RAMSQLID
END 

It is best practice to follow up with reorganization of system files RAMASTER and STORE after deleting file descriptions and files, with reports before and after to see the state of both system files.

Use the following CA Ramis commands:

RAMBLOCKS   
STATUS RAMASTER   
STATUS STORE   
RAMREORG RAMASTER   
RAMREORG RAMCLEAN   
RAMBLOCKS   
STATUS RAMASTER   
STATUS STORE