Sample z/VM EXEC Part 3

Operations › Sample z/VM EXEC Part 3—USNEXEC3

Sample z/VM EXEC Part 3—USNEXEC3

The sample z/VM EXEC for preparing comparative reports is shown below. Variables (shown in bold) are explained in the key that follows.

Note: Only statistics from a single release of CA IDMS/DB Analyzer can be compared.

/*  */
TRACE OFF; SIGNAL ON ERROR
/*                                                                   */
CA_LOADLIB_FN       = 'yourlib'
IDMS_LOADLIB_FN     = 'idmslib'
SORTLIB_FN          = 'sortlib'
/*                                                                   */
/* Link and access the Minidisks containing the required libraries */
/*                                                                   */
 'CP SPOOL PRINTER NOCONT CLOSE'
 'CP SPOOL PRINTER TO * NOHOLD CONT FORM OFF DIST OFF'
 'GLOBAL  LOADLIB ' CA_LOADLIB_FN IDMS_LOADLIB_FN
 'GLOBAL  TXTLIB ' SORTLIB_FN
/*                                                                   */
/* Product specific files.                                           */
/*                                                                   */
 'FILEDEF SYSLST   PRINTER'
 'FILEDEF SYSUDUMP PRINTER'
 'FILEDEF DBMSDMP  PRINTER'
 'FILEDEF DBMSOUT  PRINTER'
 'FILEDEF SORTMSG  PRINTER'
 'FILEDEF STAT1    DISK stat1_fn stat1_ft stat1_fm'
 'FILEDEF STAT2    DISK stat2_fn stat2_ft stat2_fm'
/*                                                                   */

/*  You must create a file 'SYSIDMS INPUT A' containing the SYSIDMS  */
/*  parameters you use to specify your runtime environment.          */
/*                                                                   */
 'FILEDEF SYSIDMS  DISK SYSIDMS INPUT A'
/*                                                                   */
/*                                                                   */
/*  You must create a file 'USNEXEC3 SYSIPT A' containing the input  */
/*  parameter statements prior to executing this EXEC.               */
/*                                                                   */
 'FILEDEF SYSIPT   DISK USNEXEC3 SYSIPT A'
/*                                                                   */
SAY 'STARTING DATABASE ANALYZER'
SIGNAL OFF ERROR
 'EXECOS OSRUN USNDRVR'
 USNEXEC3_RC = RC
IF USNEXEC3_RC > 4
 THEN DO
  CALL ERROR
 END
 'CP SPOOL PRINTER NOCONT'
 'CP CLOSE PRINTER NAME DBNLYZR LISTING'
 'CP SPOOL PRINTER OFF'
 SAY 'USNEXEC FINISHED WITH A RETURN CODE OF' USNEXEC3_RC
 'GLOBAL LOADLIB'
 'GLOBAL TXTLIB'
 'FILEDEF * CLEAR'
 EXIT USNEXEC3_RC
/*                                                                   */
/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ */
ERROR:
/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ */
 ERROR_RC = RC
 TRACE OFF; SIGNAL OFF ERROR
 SAY 'NON-ZERO RETURN CODE ENCOUNTERED IN EXEC AT LINE' SIGL
'CP SPOOL PRINTER NOCONT'
'CP CLOSE PRINTER NAME USNLYZR LISTING'
'CP SPOOL PRINTER OFF'
 'GLOBAL LOADLIB'
 'GLOBAL TXTLIB'
 'FILEDEF * CLEAR'
 EXIT ERROR_RC
/*                                                                   */

yourlib—The file name of the load library into which you downloaded CA IDMS/DB Analyzer.
idmslib—The file name of the load library containing your CA IDMS SUBSCHEMA and DMCL modules.
sortlib—The file name of the text library containing your sort modules.
stat1_fn stat1_ft stat1_fm—The file name, file type, and file mode assigned to your statistics file.
stat2_fn stat2_ft stat2_fm—The file name, file type, and file mode assigned to the statistics file used to produce comparative reports.

FILE	PROCESS	USE
SORTWK01-SORTWK03 or SORTWK1-SORTWK4	ACCUMULATE ALL	These are sort work files. ACCUMULATE and ALL cause statistics to be gathered and sorted.
SORTLIB	ACCUMULATE ALL	This PDS file contains your sort product.
sortmsg	ACCUMULATE ALL	This is the message file for your SORT product.
dbfil01-dbfilnn ALL	ACCUMULATE ALL	These are database files. ACCUMULATE and cause statistics to be gathered from the user database.
STAT1	ACCUMULATE ALL REPORTS	This is a file to which accumulated statistics are written. The sort function reads and rewrites STAT1 after statistics accumulation. The report functions always read STAT1.
STAT2	ALL ,COMPARE REPORTS	This is the "old" statistics file for comparative reports.
LDEL	ACCUMULATE ,LDEL ALL	LDEL is an output file containing the db-keys of database records that have been logically deleted. (For Release 10.2 or earlier, it is suitable for input to the IDMSLDEL utility.)
SYSPRINT		This file contains Pascal/VS run-time error messages.
SYSIPT		This file is always required for parameter statement input to be read.
SYSIDMS		This file is always required for the CA IDMS physical environment parameter input to be read. For instance, DMCL=xxxxxxxx must be specified, where xxxxxxxx is the name of the specific DMCL. See the CA IDMS Common Facilities Guide for more detailed information.
SYSLST		This file is always required for audit report output to be written. Computer Associates internal diagnostic routines write output to SYS012 and SYS013. These programmer logical units should normally be assigned to SYSLST.