Sample Output

Utility Statements › PRINT SPACE › Sample Output

Sample Output

The following report is produced by the PRINT SPACE utility after processing the PRINT SPACE statement by area with the FULL option.

IDMSBCF IDMS Batch Command Facility mm/dd/yy PAGE 1 SET BATCH WIDTH PAGE 80; Status = 0 PRINT SPACE FOR AREA EMPDEMO.EMP-DEMO-AREA FULL; AVAILABLE Space Distribution Report AVAIL NUMBER SPACE OF PAGES AREA EMPDEMO.EMP-DEMO-AREA PAGE SIZE 512 PAGES 1,310,001 THRU 1,310,010 91-100% 7 81-90 % 2 71-80 % 0 61-70 % 0 51-60 % 0 41-50 % 0 31-40 % 0 21-30 % 0 11-20 % 0 00-10 % 0 SMPS 1 TOTAL 10 FILE EMPDEMO.EMPDEMO PAGES 1,310,001 THRU 1,310,010 BLOCKS 1 THRU 10 Total Space Allocated 5,120 Total Space Available (Percent) 4,128 (80%) Total Space Used 992 AREA EMPDEMO.EMP-DEMO-AREA Distribution of USED Space Report Maximum Percent of Record Type Length Occurrences Total Space Used Total Used SR1002 40 3 120 12.09 **LD1002 24 3 72 7.25 Space Inv. 480 1 480 48.38 Overhead 32 10 320 32.25 *** logically deleted records FOUND *** Status = 0

The following report is produced by the PRINT SPACE utility after processing the PRINT SPACE statement by file.

IDMSBCF nn.n CA IDMS Batch Command Facility mm/dd/yy PAGE 1 PRINT SPACE FOR FILE EMPDEMO.EMPDEMO; AVAILABLE Space Distribution Report AVAIL NUMBER SPACE OF PAGES AREA EMPDEMO.EMP-DEMO-REGION PAGE SIZE 4,276 PAGES 75,001 THRU 75,100 91-100% 78 81-90 % 13 71-80 % 7 61-70 % 0 51-60 % 0 41-50 % 0 31-40 % 1 21-30 % 0 11-20 % 0 00-10 % 0 SMPS 1 TOTAL 100 FILE EMPDEMO.EMPDEMO BLOCKS 1 THRU 100 Total Space Allocated 427,600 Total Space Available (Percent) 394,120 (92.17%) Total Space Used 33,480 Logically Full Pages 0 Total Space Unusable (Percent) 0 ( 0.00%) AREA EMPDEMO.EMP-DEMO-REGION Distribution of USED Space Report Maximum Percent of Record Type Length Occurrences Total Space Used Total Used SR7 40 1 40 0.11 SR8 1,396 3 2,820 8.42 SR415 196 56 10,976 32.78 SR420 60 68 4,080 12.18 SR425 36 150 5,400 16.12 SR460 40 68 2,720 8.12 Space Inv. 4,244 1 4,244 12.67 Overhead 32 100 3,200 9.55 *** NO logically deleted records found *** Status = 0 SQLSTATE = 00000

Note: For more information about space utilization and database pages, see the Database Administration Guide.

PRINT SPACE FOR AREA SYSSQL.DDLCATX FULL; AVAILABLE Space Distribution Report AVAIL NUMBER SPACE OF PAGES AREA SYSSQL.DDLCATX PAGE SIZE 4,276 PAGE RESERVE 212 PAGES 10,001 THRU 13,000 91-100% 56 81-90 % 117 71-80 % 125 61-70 % 197 51-60 % 197 41-50 % 229 31-40 % 230 21-30 % 225 11-20 % 203 00-10 % 1,419 SMPS 2 TOTAL 3,000 FILE SYSSQL.DDLCATX BLOCKS 1 THRU 3,000 Total Space Allocated 12,828,000 Total Space Available (Percent) 3,240,368 (25.26%) Total Reserved Space Available (Percent) 511,128 ( 3.98%) Total Unreserved Space Available (Percent) 2,729,240 (21.28%) Total Space Used 9,587,632 Logically Full Pages 0 Total Space Unusable (Percent) 0 ( 0.00%) AREA SYSSQL.DDLCATX Distribution of USED Space Report Maximum Percent of Record Type Length Occurrences Total Space Used Total Used Null Line 8 54 432 0.00 SR5 48 1 48 0.00 SR7 40 12 480 0.00 SR8 1,404 28,567 9,482,184 99.93 Space Inv. 4,244 2 8,488 0.08 Overhead 32 3,000 96,000 0.98 *** NO logically deleted records found ***

PRINT TRACE

The PRINT TRACE utility prints all or selected trace entries that reside in a DDLDCTRC area, a DDLDCLOG area, or one or more archive files created by the ARCHIVE TRACE or ARCHIVE LOG utilities.

You can select entries for printing based on the following:

Type of information
Date and time
Taskid

Authorization

To	You Need This Privilege	On
To print trace information	DBAREAD	SYSTEM.DDLDCTRC or SYSTEM.DDLDCLOG areas

PRINT TRACE Syntax

The following diagram shows the syntax for the PRINT TRACE utility statement:

►►── PRINT TRACE ────────────────────────────────────────────────────────►

 ►─┬──────────────────────────────────────────────────────┬──────────────►
   └─ FROM ─┬─ DATABASE ────────────────────────────────┬─┘
            └─ ARCHIVE ──┬────────────────────────────┬─┘
                         └─DDNAME─┬──SYS001 ◄──────┬──┘
                                  │  ┌────,─────┐  │
                                  └──▼─ ddname ─┴──┘

 ►─┬──────────────────────┬──────────────────────────────────────────────►
   │  ┌─────────────────┐ │
   └──▼─┬─ SYSTRACE ──┬─┴─┘
        └─ EXTENDED ──┘
 ►─┬───────────────────────┬─────────────────────────────────────────────►
   │          ┌────,─────┐ │
   └─ TASKID ─▼ taskid ─┴─┘

 ►─┬─────────┬───────────────────────────────────────────────────────────►
   └─ UTC────┘

 ►─┬───────────────────────────────────┬─────────────────────────────────►
   └── START AT ' ┬── date ──────── ' ─┤
                  ├── date-time ┬──────┘
                  └── time ─────┘

 ►─┬──────────────────────────────────┬──────────────────────────────────►◄
   └── STOP AT ' ┬── date ──────── ' ─┤
                 ├── date-time ┬──────┘
                 └── time ─────┘

PRINT TRACE Parameters

This section describes the PRINT TRACE command parameters:

FROM

Indicates the location from which to print trace information: a database area or an archive file.

DATABASE

Prints trace information from either the DDLDCTRC or the DDLDCLOG area. If the DMCL contains a DDLDCTRC area, only trace information in that area is printed; otherwise, only trace information in the DDLDCLOG area is printed.

ARCHIVE

Prints trace information from one or more archive files.

DDNAME

Identifies the ddname of one or more archive files whose contents are to be printed. If more than one ddname is specified, trace information is merged and displayed in chronological sequence.

ddname

Specifies the ddname of an archive file.

Default: SYS001

Limit: 32 ddnames

Note: Printing trace information from multiple archive files is only available to z/OS users. z/VSE users need to consolidate multiple archive files into a single file (in the order in which they were created) and use this file with the PRINT TRACE utility.

SYSTRACE

Includes basic system trace information in the output.

EXTENDED

Includes extended trace information in the output.

Note: If you specify SYSTRACE or EXTENDED, only the specified type of information is printed. If you do not specify either option, both types of information are printed.

TASKID

Prints trace information for selected tasks.

taskid

Specifies the taskid of a task whose trace information is to be printed.

Default: Trace information associated with all tasks is printed.

Limit: 32 task identifiers.

START AT date-time

Prints only trace information recorded at or after the specified time.

Default: Prints information from the beginning of the database area or archive file.

STOP AT date-time

Prints only trace information recorded at or before the specified date and time.

Default: Prints information recorded in the database area or archive file (starting at the time specified in the START AT parameter, if any).

Expansion of date-time

date

Specifies a date, in one of the following formats:

yyyy-mm-dd
mm/dd/yyyy

The date components are:

yyyy specifies the year.
Limit: 0001–9999 (leading zeros are optional)
mm specifies the month within the year.
Limit: 01–12 (leading zeros are optional)
dd specifies the day within the month.
Limit: 01–31 (leading zeros are optional)

Note: The combined values of yyyy, mm, and dd must represent a valid date. For example, 1988-02-29 is a valid date but 1989-02-29 is not.

date-time

Specifies a date and time in one of the following formats:

yyyy-mm-dd-hh.mm.ss.ffffff
yyyy-mm-dd-hh.mm.ss

The date components are the same as those that can be specified for date.

The time components are:

hh specifies the hour on a 24-hour clock.
Limit: 00-23 (leading zeros are optional)
mm specifies the number of minutes past the hour.
Limit: 00-59 (leading zeros are optional)
ss specifies the number of seconds past the minute.
Limit: 00-59 (leading zeros are optional)
ffffff specifies the number of millionths of a second past the specified second.
Limit: 000000-999999 (trailing zeros are optional)

Default: 000000

time

Specifies a time in the following format:

hh:mm:ss

The time components are the same as those that can be specified for date-time.

Note: The date is assumed to be the current date.

UTC

Specifies that Start and Stop times are interpreted as UTC times instead of local times.

PRINT TRACE Usage

How to submit the PRINT TRACE statement

You submit a PRINT TRACE statement only through the batch command facility. You can run the batch command facility only in local mode.

When to use PRINT TRACE

Use the PRINT TRACE utility when the system trace is being written to the DDLDCTRC area or DDLDCLOG area, if no DDLDCTRC area is defined in the dictionary.

JCL Considerations

When you submit a PRINT TRACE statement through the batch command facility, the JCL to execute the facility must include statements to define:

The system trace area (DDLDCTRC) or system log area (DDLDCLOG) if you specify FROM DATABASE
The archive trace file whose contents you want to print if you specify FROM ARCHIVE
The system message area (DDLDCMSG)
The dummied journal file

Note: For more information about the generic JCL used to execute the batch command facility, see the chapter for your operating system in this guide.

Examples

Printing All Trace Entries

The following PRINT TRACE statement requests printing of all SYSTRACE and EXTENDED trace entries from the trace area.

PRINT TRACE FROM DATABASE;

Printing All Trace Information for a Specified Time Period

The following PRINT TRACE statement requests printing of all SYSTRACE and EXTENDED trace entries from the archive file, starting from March 02, 2011 at 4:12 p.m. until just before 4:30 p.m. on March 02, 2011 using the archive file with DDNAME SYS001.

PRINT TRACE FROM ARCHIVE
  DDNAME SYS001
  START AT '2011-03-02-21.12.00'
  STOP AT  '2011-03-02-21.30.00';

Printing SYSTRACE Entries from an Archive File

The following PRINT TRACE statement requests printing of all SYSTRACE trace entries from the archive file with DDNAME SYS001.

PRINT TRACE FROM ARCHIVE
  DDNAME SYS001
  SYSTRACE;

Printing SYSTRACE and EXTENDED TRACE Entries from an Archive File

The following PRINT TRACE statement requests printing of all trace entries from the ARCHIVE file with DDNAME LOGARC.

 PRINT TRACE FROM ARCHIVE
   DDNAME LOGARC;

PRINT TRACE Output for System Trace Entries

The following items are included in the PRINT TRACE output for system trace entries.

TOD TIME/DATE: The UTC time and date the trace entry was generated.
SCA: The relative SCA number of the subtask that generated the trace entry.
TASKID: Taskid of the task that generated the trace entry.
A(LTE): The address of the generating task’s LTE.
MOD: The internal module number and four-character identifier of the module generating the trace entry.
MAC: The issuing macro number or entry point.
CALL: The relative macro expansion within the issuing program.
R11/R2-R1/R8: The contents of registers 11 through 1 and 2 through 8 at the time the entry was generated.
TOD CLOCK: The contents of the TOD clock at the time the entry was generated.
<SYSTEM73>: Node or data sharing member name of issuing system.

PRINT TRACE Output for Extended Entries

The following PRINT TRACE statement requests printing of all SYSTRACE and EXTENDED trace entries from the archive file starting from March 02,2011 at 4:12 p.m. until just before 4:30 p.m. on March 02,2011 using the archive file with DDNAME SYS001.

PRINT TRACE FROM ARCHIVE
   DDNAME SYS001
   START AT '2011-03-02-21.12.00'
   STOP AT  '2011-03-02-21.30.00';

Sample Output

The following example shows the output from the Print Trace Utility:

PRINT TRACE; CA IDMS DB/DC Print Trace Utility CA IDMS DB/DC is a Proprietary Software Product DATE TIME AGE CAGJI0 Release 1800 Licensed from CA, Inc. 01/19/10 14:31:32 1 *** DDLDCTRC AREA FROM PAGES 000060001 TO 000062000 *** FIRST AND LAST PAGES SELECTED ARE 000060019 AND 000060041 *** Trace entries generated on: 2010-01-19 TRACE ENTRIES, ORDERED OLDEST TO NEWEST. TASKID/ TOD TIME/DATE SCA A(LTE) MOD MAC CALL R11/R2 R12/R3 R13/R4 R14/R5 R15/R6 R0/R7 R1/R8 TOD CLOCK 19.31.33.776391 00 122 292 22 13 801D8208 38BD5456 36EC82AC B8BD5500 382B4CB8 00027350 001D820C C5699CD3C0807706 SYSTEM73 36E2B7C8 MTSY TSKCEP1 36E99D88 00000000 0025E0C0 36E99D88 3701CFBC 39C07000 B8265E42 19.31.33.776391 00 122 5 240 1 801D8208 382B4CB8 36EC82D8 B82B4CC8 382B4CB8 00027350 001D820C C5699CD3C0807786 SYSTEM73 36E2B7C8 TSKC #GETSTK 36E99D88 00000000 0025E0C0 36E99D88 3701CFBC 39C07000 B8265E42 19.31.33.776391 00 122 5 12 4 36EC82D4 382B4CB8 36EC8320 B82B5326 3825C888 0025E030 36EC82D8 C5699CD3C0807906 SYSTEM73 36E2B7C8 TSKC RMGREP2 0025E680 0025E000 0025E700 000263F0 00000000 00000000 00000000 19.31.33.776393 00 122 5 9 5 36EC82D4 382B4CB8 36EC8320 B82B5558 38289CB8 00000000 00000000 C5699CD3C0809686 SYSTEM73 36E2B7C8 TSKC TIMPGET 0026EEC8 00000063 0025E700 0026E9C0 00000000 00000000 00000000 19.31.33.776393 00 122 14 240 1 0000003C 38289CB8 36EC834C B8289CCC 38289CB8 00000000 00000000 C5699CD3C0809706 . . .

PRINT TRACE; CA IDMS DB/DC Print Trace Utility CA IDMS DB/DC is a Proprietary Software Product DATE TIME AGE CAGJI0 Release 1800 Licensed from CA, Inc. 01/19/10 14:31:32 *** Trace entries generated on: 2010-01-19 19.31.33.872678 00 122 8 109 42 36EC8278 382B73B8 36EC82C4 B82B76C4 383D7BD8 00000001 36EC827C C5699CD3D8026486 SYSTEM73 36E2B7C8 TSKI TMGREP1 00000000 36E2B7C8 36E63708 379CAC88 00000000 38262798 382B83B8 19.31.33.872678 00 122 329 240 1 00000238 383D7BD8 36EC82EC B83D7C0C 383D7BD8 00000001 36EC827C C5699CD3D8026586 SYSTEM73 36E2B7C8 TMGR #GETSTK 36EC827C 0000008E 00000052 383D8D50 382B76CA 00000001 382B83B8 19.31.33.872678 00 122 442 TMGD TM1* SEQ=1 LTE=36E2B7C8 C5699CD3D8026E06 SYSTEM73 E3D4F15C 36E2B7C8 E3C5D5C4 00000000 00008000 00000000 00000000 0000007A *TM1*.S.HTEND...................:* 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................* 19.31.33.872679 00 122 442 TMGD TMR* SEQ=1 LTE=36E2B7C8 C5699CD3D8027906 SYSTEM73 E3D4D95C 36E2B7C8 E2A48299 E3C5D5C4 36E2B7C8 5BE3C3D6 D4404040 0000007A *TMR*.S.HSubrTEND.S.H$TCOM ...:* 19.31.33.872680 00 122 442 TMGD TMR* SEQ=1 LTE=36E2B7C8 C5699CD3D8028006 . .