Additional Log Functions (package_spec)

In addition to the entries in the Loader’s log file (loader.prt), you can also find detailed information about the actions that occur when a command is executed in the SYSLOADER.TRANSFORMATIONMODEL system table.

For many Loader commands, you can export the values belonging to a command from the SYSLOADER.TRANSFORMATIONMODEL system table to a data stream using the syntax element package_spec. This data stream contains all the specifications that completely describe the Loader command that was executed, including information about the command’s design and the executed command’s runtime data.

Syntax

<package_spec>       ::= PACKAGE <outstream_csv_spec>

<outstream_csv_spec> ::= data stream

Use

The package_spec syntax element can be used in the following commands:

EXPORT DB

IMPORT DB

EXPORT USER

IMPORT USER

EXPORT SCHEMA

IMPORT SCHEMA

EXPORT TABLE

IMPORT TABLE

Explanation

?     If you specify a data stream using PACKAGE <outstream_csv_spec>, the entries from the SYSLOADER.TRANSFORMATIONMODEL table that belong to the command are exported to this data stream.

?     If a data stream is not specified using PACKAGE <outstream_csv_spec>, the entries from the SYSLOADER.TRANSFORMATIONMODEL system table are not exported.

The PACKAGE data stream outstream_csv_spec is generated in the CSV format.

The column values from the SYSLOADER.TRANSFORMATIONMODEL system table are stored in the PACKAGE data stream outstream_csv_spec in the following order:

OWNER
SCHEMANAME
TABLENAME
DATASTREAMNAME
DATASTREAMHEADERBLOCK
DATASTREAMHEADERPOS
DATASTREAMTRAILERBLOCK
DATASTREAMTRAILERPOS
DATASTREAMDATABLOCK
DATASTREAMDATAPOS
EXCLUDE
PACKAGEGUID
TASKID
STEPID
SERVERNODE
SERVERDB
USERNAME
CODETYPE
CODEPAGEID
STORAGEDEVICE
TRANSACTIONSIZE
TRANSFORMATION
PART
TABLETYPE
CATALOGSTREAMNAME
CATALOGSTREAMTYPE
CATALOGSTREAMEBID
CATALOGSTREAMFORMAT
DATASTREAMTYPE
DATASTREAMEBID
DATASTREAMFORMAT
RESTART
RESTORE
PAGECOUNT
ROWCOUNT
STARTTIME
ENDTIME
REQUESTTIME
RECEIVETIME
IOTIME
LOGTIME

The values belonging to the command are deleted from the SYSLOADER.TRANSFORMATIONMODEL system table if all the values are in the required data stream.

Example

EXPORT USER
  DATA OUTSTREAM 'mona_pages.data' PAGES

  PACKAGE OUTSTREAM 'mona_csv.package'

The application data for database user MONA is exported. In the mona_csv.package data stream you will find all the specifications that completely describe the Loader command that was executed.

Content of the PACKAGE Data Stream mona_csv.package

"MONA","HOTEL","CITY","mona.data0001","0","1024","0","0","0","66560","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84","1","1","GENUA","TESTDB","MONA","ASCII","?","NONE","0","EXPORT","USER","TABLE","?","?","?","?","FILE","?","PAGES","FALSE","FALSE","0","0","20060116135730309000","20060116135730339000","0.000","0.000","0.000","0.000"

"MONA","HOTEL","CUSTOMER","mona.data0001","0","66560","0","0","0","132096","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84","1","2","GENUA","TESTDB","MONA","ASCII","?","NONE","0","EXPORT","USER","TABLE","?","?","?","?","FILE","?","PAGES","FALSE","FALSE","0","0","20060116135730349000","20060116135730359000","0.000","0.000","0.000","0.000"

"MONA","HOTEL","HOTEL","mona.data0001","0","132096","0","0","0","214016","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84","1","3","GENUA","TESTDB","MONA","ASCII","?","NONE","0","EXPORT","USER","TABLE","?","?","?","?","FILE","?","PAGES","FALSE","FALSE","0","0","20060116135730359000","20060116135730389000","0.000","0.000","0.000","0.000"

"MONA","HOTEL","ROOM","mona.data0001","0","214016","0","0","0","279552","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84","1","4","GENUA","TESTDB","MONA","ASCII","?","NONE","0","EXPORT","USER","TABLE","?","?","?","?","FILE","?","PAGES","FALSE","FALSE","0","0","20060116135730389000","20060116135730399000","0.000","0.000","0.000","0.000"

"MONA","HOTEL","EMPLOYEE","mona.data0001","0","279552","0","0","0","345088","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84","1","5","GENUA","TESTDB","MONA","ASCII","?","NONE","0","EXPORT","USER","TABLE","?","?","?","?","FILE","?","PAGES","FALSE","FALSE","0","0","20060116135730409000","20060116135730419000","0.000","0.000","0.000","0.000"

"MONA","HOTEL","RESERVATION","mona.data0001","0","345088","0","0","0","410624","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84","1","6","GENUA","TESTDB","MONA","ASCII","?","NONE","0","EXPORT","USER","TABLE","?","?","?","?","FILE","?","PAGES","FALSE","FALSE","0","0","20060116135730429000","20060116135730439000","0.000","0.000","0.000","0.000"