{"id":2278,"date":"2017-08-16T09:18:03","date_gmt":"2017-08-16T08:18:03","guid":{"rendered":"https:\/\/www.threesl.com\/blog\/?p=2278"},"modified":"2019-01-31T11:12:50","modified_gmt":"2019-01-31T11:12:50","slug":"maintaining-repairing-cradle-databases","status":"publish","type":"post","link":"https:\/\/www.threesl.com\/blog\/maintaining-repairing-cradle-databases\/","title":{"rendered":"Maintaining and Repairing your Cradle Databases"},"content":{"rendered":"

Problems with your Database?<\/h2>\n

In the rare occasion that something has gone terribly wrong with you database, here are some things that you may find helpful:<\/p>\n

Retrieving Licence Statistics<\/h3>\n

If you are finding that you are running out of licenses or you just want to have an overview of license usage over a period of time you can use c_usage which can be run to output the information from Cradle into an excel file. You then copy this date from the excel file into a spreadsheet we supply called c_usage.xls which once the data has been pasted into the spreadsheet will then update it’s other worksheets which will display the corresponding information in graphs.<\/p>\n

For more information on how to retrieve licence statistics<\/a> please see our online help.<\/p>\n

Retrieving Specific Error Logs<\/h3>\n

All components of the Cradle<\/em> software distribution include crash resistance such that, in the event of an internal error occurring within the software component, internal recovery action is taken, and the software component remains running.<\/p>\n

In all cases, the recovery action includes adding an entry to an error log file that provides a complete description of the internal environment of the software component when the problem arose.<\/p>\n

This log could potentially become quite large over time and you may only want retrieve one or more entries from this log, c_errlog<\/em> can be used to retrieve one or more entries from the error log files produced by Cradle<\/em>.<\/p>\n

For more information on how to parse an error log file<\/a> please see our online help.<\/p>\n

Checking the Version of your Cradle PDB Files<\/h3>\n

Check the version of your database files
\nThe c_pdbver<\/strong> utility allows you to determine the version of your database files, it check the filesets<\/em> are compatible with a version number you specify and confirms whether or not each fileset<\/em> is in the specified version.<\/p>\n

\"pdb_ver
7.3 compatibility check<\/figcaption><\/figure>\n

For more information on how to check the version of database files<\/a> please see our online help.<\/p>\n

Checking and Repairing Database files<\/h3>\n

If you have had a machine crash or hardware failure when Cradle was writing to the database files you may want to check and repair the database file to ensure you don’t see any further corruption to your database. We supply a utility for this called dcheck<\/em> that checks and repairs damage to the ISAM<\/em> files within a Cradle PDB<\/em>.<\/p>\n

For more information on how to check\/repair database files<\/a> please see our online help.<\/p>\n

 <\/p>\n

 <\/p>\n