Diagnostics documents for service tasks

The SESAM/SQL DBH relocates CPU-intensive activities, such as the sorting of intermediate-result sets or some utility functions, as service tasks (see the “ Core manual”).

The DBH start task logs activities that occur in connection with service tasks, such as the starting and termination of service tasks, to SYSOUT and SYSLST. Service-task-control calls are logged in the DBH stack.

As for the DBH task, SESAM/SQL creates a dump file for service tasks when necessary (see "Main-memory dump").

When SQL messages (SQLSTATEs) occur in service tasks, after certain utility statements, for example, diagnostics information is also stored in the following files:

File name	Meaning
catid.userid.DUMP[.jobname].tsn.n	Dump file of the DBH task
catid.userid.DUMP[.jobname].tsn.n	Dump file of the service task
catid.userid.SESAMcn.SYSLST. yyy.mm.ddhh:mm:ss.tsn	SYSLST log file of the DBH task
catid.userid.SESLKcn.SYSOUT. yyy.mm.ddhh:mm:ss.tsn	SYSOUT log file of the linked-in DBH task created during the RECOVER.
archive-filename.SYSLST	ARCHIVE log file: for SQLSTATEs after a COPY to tape with ARCHIVE or after a RECOVER from tape with ARCHIVE
hsms_archive-filename.SYSLST	HSMS log file: for SQLSTATEs after a COPY to tape with HSMS or after a RECOVER from tape with HSMS
catid.userid.catalog.space.EXC.C	Error file for the CHECK FORMAL utility statement (see also "Error files for SQL and utility statements")
catid.userid.catalog.space.EXC.L	Error file for the LOAD utility statement (see also "Error files for SQL and utility statements")
catid.userid.catalog.space.EXC.U	Error file for the UNLOAD utility statement (see also "Error files for SQL and utility statements")
catid.userid.SESAMkn.SYSLST.SESSTxx.tsn	SYSLST log file of the service task: for SQLSTATEs after a COPY to tape or a RECOVER from tape
catid.userid.SESAMkn.SYSOUT.SESSTxx.tsn	SYSOUT log file of the service task: for SQLSTATEs after a COPY to tape or a RECOVER from tape

Table 42: Files with diagnostic information for service tasks

File names

The table 42 contains the default names of all files containing diagnostics information for service tasks. The file names contain the following components:

jobname tsn i c n xx yyyy.mm.ddhh:mm:ss

Job name of the service task Task sequence number of the service task or DBH task Consecutive number identifying the nth dump in the task Configuration name (one byte) DBH name (one byte) Version number Timestamp