UNLOAD

TYPE=accountingStatisticsTableType

Specifies the type of accounting or statistics table

Possible values are:

• ACCT
• SUMACCT
• DDFACCT
• SUMDDFACCT
• PKGACCT
• SUMPKGACCT
• BUFACCT
• SUMBUFACCT
• STAT
• SUMMSTAT
• DDFSTAT
• SUMDDFSTAT
• BUFSTAT
• SUMBUFSTAT

This required field has no default.

TYPE2=auditTableType

Specifies the type of audit table

Possible values are:

• AUDFAIL
• AUDGRV
• AUDDDL
• AUDDML
• AUDDMB
• AUDCHG
• AUDUTL
• AUDSUM

This required field has no default.

TYPE3=statisticsAuditTableType

Specifies the type of statistics or audit table

Possible values are:

• ASPCSTOR
• SYSTSTOR
• AUDCMD
• AUDATH
• AUDTRC

This required field has no default.

TYPE4=acceleratorSimBPTableType

Specifies the type of accelerator or simulated bufferpool table

Possible values are:

• ACCA
• ACCS
• SYMB

This required field has no default.

FROMTBL=tableName

Name of the table from which the rows are fetched

This required field has no default.

TODD=ddName

ddName assigned to the file to which the rows are written

This required field has no default.

UNLDSTART=yyyy-mm-dd,UNLDEND=yyyy-mm-dd

Limits the records that are unloaded.

For example, UNLDSTART=2002-01-08,UNLDEND=2002-01-09 limits the records unloaded to those for the day of 2002-01-08.