SESAM/SQL files

The table below lists the session-related files which are created by the SESAM/SQL DBH

File default name	Meaning
:catid:$userid.SESAM.CO-LOG.ssss.iiii	request logging
:catid:$userid.SESAMkn.CURSOR.####	cursor files
:catid:$userid.SESLKkn.CURSOR.####	cursor files used with a linked-in DBH
:catid:$userid.SESAMkn.TA-LOG1 :catid:$userid.SESAMkn.TA-LOG2	transaction log files
:catid:$userid.SESLKkn.TA-LOG1 :catid:$userid.SESLKkn.TA-LOG2	transaction log files used with a linked-in DBH
:catid:$userid.SESAMkn.WA-LOG	log file for restart
:catid:$userid.SESLKkn.WA-LOG	log file for restart used with linked-in DBH

Table 70: Session-related files

Files created by a SESAM/SQL DBH which runs in a service task additionally have the service task id in their names, e.g.:
:catid:$userid.SESLKknst.TA-LOG1

File default name	Meaning
:catid:$userid.catalog.CATALOG :catid:$userid.catalog.space	Spaces of a database
:catid:$userid.catalog.CAT-REC	CAT-REC file
:catid:$userid.catalog.CAT-REC.COPY	copy of the CAT-REC file
:catid:$userid.replikat.CAT-REC.REPL	CAT-REC file of a replication
:catid:$userid.catalog.CATALOG.version :catid:$userid.catalog.space.version	backup of spaces
:catid:$userid.catalog.yyyymmddhhmmss.##	PBI file or HSMS work file
:catid:$userid.catalog.version.C.####	CAT-LOG file for catalog space
:catid:$userid.catalog.version.D.####	DA-LOG file for user space
:catid:$userid.catalog.space.EXC.L	error file for utility statement LOAD
:catid:$userid.catalog.space.EXC.U	error file for utility statement UNLOAD OFFLINE
:catid:$userid.catalog.space.EXC.C	error file for utility statement CHECK FORMAL
:catid:$userid.catalog.space.DDLTA	transaction log file for DDL

Table 71: Database-related files

The table below shows the file which is created by SESDCN.

File default name	Meaning
catid.dcn-id.SES.DLGk	SESDCN backup

Table 72: SESDCN-related file

The table below shows the utility monitor files.

File default name	Meaning
:catid:$userid.SESUTI.INPUTLOG.yyyymmddhhmmss	output file for statements
:catid:$userid.SESUTI.STDLOG.yyyymmddhhmmss	Default log file

Table 73: Utility monitor-related files

The table below contains an overview of the files used for tape backups

File default name	Meaning
:catid:$userid.archive-directory-file. ARC-PAR	ARCHIVE parameter file
:catid:$userid.SESAMkn.ARC-PAR	ARCHIVE parameter file
:catid:$userid.hsms-archiv-name.HSMS-PAR	HSMS parameter file
:catid:$userid.SESAMkn.HSMS-PAR	HSMS parameter file

Table 74: Utility monitor-related files

The table below contains an overview of the files required for diagnostic purposes

File default name	Meaning
:catid:$userid.SESAMkn.SYSLST	SYSLST log file of the DBH task
:catid:$userid.SESAMkn.SYSOUT	SYSOUT log of the DBH task
:catid:$userid.SESAMkn.SYSLST.SESST91	SYSLST log of the service task
:catid:$userid.SESAMkn.SYSOUT.SESST91	SYSOUT log of the service task

Table 75: Utility monitor-related files