Managing Caché
This chapter explains common Caché operations tasks including displaying process details, broadcasting messages, and monitoring processes. This chapter discusses the following topics:
• Maintaining Local Databases
• Controlling Caché Processes
• Using the Task Manager
3.1 Maintaining Local Databases
You can accomplish many database and global management tasks from the [Home] > [Databases] page of the System Management Portal. The portal displays a list of local databases. For each database, you see the following information:
Local Databases List Information Definition
Column Heading
The database name; click this name to display more details about this database.
Name
The system directory in which the database resides.
Directory
The maximum size allocated to which the database can grow, in gigabytes.
Max Size (GB)
The current allocated size of the database, in megabytes.
Size (MB)
Definition Column Heading
The status of the directory, which indicates if the database is mounted and with which permissions.
Status
Indicates whether or not the database is encrypted.
Encrypted
Indicates whether globals in the database are journaled with a Y or an N.
Journal
One of two action buttons to dismount or mount the database
Dismount / Mount
From this page you can perform the following database tasks:
• Show Free Space
• Check Database Integrity
• View Integrity Log
All the data structures used by Caché are self-balancing and do not suffer performance degradation over time. It is never necessary to take a system down to rebuild it nor to compress data or indices to regain performance.
3.1.1 Show Free Space
You can check the free space available on databases from the [Home] > [Databases] page of the System Management Portal.
Click Freespace to display a page which shows a list of local databases with the following free space information:
The system directory in which the primary volume of the database resides.
Directory
The maximum size allocated to which the database can grow, in gigabytes. The default is unlimited when you create a database.
Max Size
The current allocated size of the database, in megabytes.
Size
Size (in MB) by which to expand the database. The default and recommended setting is zero (0) when you create a database, which indicates to use system defaults (12% of the current size or 10 MB, whichever is larger).
Expansion Size
Definition Column Heading
The amount of free space (in MB) available in the database.
Available
The percentage of free space available in the database.
%Free
The amount of space free on the volume.
Disk Free Space
The status of the directory, which indicates if the database is mounted and with which permissions.
Status
You can retrieve similar information using the %FREECNT utility as described in the following section.
3.1.1.1 Show Free Space Using %FREECNT
Caché also provides an additional tool to monitor the storage growth of your databases. This utility is called %FREECNT. Its output shows the free space available in a database. From a namespace other than %SYS, the utility shows the free space of the databases in that namespace:
USER>Do ^%FREECNT
From the %SYS namespace, you may choose to display the free space of all databases by entering an asterisk (*) at the prompt, or enter one database directory name:
%SYS>Do ^%FREECNT
Database directory to show free space for (*=All)? * Databases Selected
c:\MyCache\mgr\cacheaudit\ Unlimited 1MB 0.52MB 52 42.72GB c:\MyCache\mgr\cachelib\ Unlimited 225MB 15MB 6.66 42.72GB c:\MyCache\mgr\cachetemp\ Unlimited 102MB 101MB 99.01 42.72GB c:\MyCache\mgr\docbook\ Unlimited 128MB 15MB 11.71 42.72GB c:\MyCache\mgr\samples\ Unlimited 51MB 2.4MB 4.7 <- 42.72GB c:\MyCache\mgr\user\ Unlimited 1MB 0.52MB 52 42.72GB
You may choose the device to which to send the information and choose the line length of the display.
3.1.2 Check Database Integrity
You can check the integrity of databases from the [Home] > [Databases] page of the System Management Portal:
1. Click Integrity Check to display a list of database names with check boxes.
2. Select the appropriate check boxes for the databases you want to check.
3. Enter the name and location of a log file. You can accept the default (integ.txt), click Browse to choose an existing file, or enter your own file name. The integrity check process runs in the background and saves the results to the file name in the text box.
4. Click OK to begin the integrity check.
3.1.2.1 Database Integrity Checking Utility
You can also use the utility routine ^Integrity. The name is case-sensitive and you call it from the Caché manager’s namespace with Do ^Integrity. This is the equivalent of running Integrity Check
from the [Home] > [Databases] page of the System Management Portal.
There are three additional entry points to this routine:
• Do CheckPointer^Integrity asks for a directory and a pointer block at which to start checking.
• Do Silent^Integrity(logfilename) starts a background process which does an integrity check on all databases and puts the output in a file specified by the logfilename parameter. This is the equivalent of doing Integrity Check from the [Home] > [Databases] page of the System Management Portal.
• Do Query^Integrity(logfilename,outdevice) does not run an integrity check, but puts the contents of the file specified by the logfilename parameter, the results saved from a pre-vious run, out on the current device or the device specified in the optional parameter outdevice.
If not specified, outdevice is the current terminal. Examples of outdevice are a printer, another display device, or another operating system file name. The latter makes a copy of logfilename.
3.1.3 View Integrity Log
You can view the log resulting from the background process:
1. From the [Home] > [Databases] page of the System Management Portal, click Integrity Log. 2. Enter the file name used in the Integrity Check process. The default named file displays if you
used that name. Otherwise click View File to display your integrity log file.
3. You can search for strings within the log file. Enter the string and click Search. Matching strings are highlighted.