Additional Log Functions (package_spec) 
In addition to the entries in the log file of Loader (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 design of the command and the runtime data of the executed command.
Structure
SyntaxThe package_spec syntax element can be used in the following commands:
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 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 resulting values are deleted from the SYSLOADER.TRANSFORMATIONMODEL system table if all the values are in the required data stream.
Example
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 find all the specifications that completely describe the Loader command that was executed.
Content of the PACKAGE data stream mona_csv.package (excerpt):
"MONA","HOTEL","CITY","mona.data0001","0","1024","0","0","0","66560","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84", ...
"MONA","HOTEL","CUSTOMER","mona.data0001","0","66560","0","0","0","132096","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84", ...
"MONA","HOTEL","HOTEL","mona.data0001","0","132096","0","0","0","214016","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84", ...
"MONA","HOTEL","ROOM","mona.data0001","0","214016","0","0","0","279552","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84", ...
"MONA","HOTEL","EMPLOYEE","mona.data0001","0","279552","0","0","0","345088","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84", ...
"MONA","HOTEL","RESERVATION","mona.data0001","0","345088","0","0","0","410624","FALSE","010000003A29DCF9200F0000B0450000A6B717DE7CE1BF84", ...