-LCMD (List command)
For the Database Administration for DB2 and
BMC AMI Database Administration for Db2
solutions, the -LCMD command executes SQL that lists the LOB (auxiliary) table spaces that support the LOB column in the base table.
Db2 creates these objects implicitly for a partition-by-growth table space. The -LCMD command includes the following parameters:
- LOBTBO, which identifies the owner of the table
- LOBTBN, which identifies the name of the table
- LOBCOL, which identifies the name of the LOB column
Analysis issues the -LCMD command after the -BMCL command invokes the LOADPLUS utility to load all of the columns in the base table, except the LOB columns. The -LCMD command executes a START DATABASE ACCESS(FORCE) command on each LOB table space in the list. Analysis uses the -LSQL command to turn logging off for each LOB table space before it uses the -LOLB command to load data in the LOB columns.
Example of -LCMD command
LOAD DATA RESUME YES
INDSN('RDACRJ2.MIGRATE.SYSREC.SR000001')
ERRDDN SYSER001
PRELOAD CONTINUE
DISCARDS 1
DISCARDDN SYSDS001
DELETEFILES NO
ORDER YES
EBCDIC CCSID(37,0,0)
WORKDDN (SUT)
LOADDN SORT0001
UNIQUEINTO YES
INTO TABLE MGPBG21.TX12GS
(
COL1_VCHAR
POSITION(*) VARCHAR,
COL2_SMALL
POSITION(*) SMALLINT,
COL3_ROWID
POSITION(*) ROWID)
...
-LCMD 001400
LOBTBO MGPBG21
LOBTBN TX12GS
LOBCOL COL4_CLOB
START DATABASE (LOB ) SPACENAM (TS )
ACCESS(FORCE)
...
-LSQL 001500
LOBTBO MGPBG21
LOBTBN TX12GS
LOBCOL COL4_CLOB
ALTER TABLESPACE LOB.TS
LOG NO
-LOLB 001550
LOAD LOB
INTO MGPBG21.TX12GS
LOBDSN'RDACRJ2.DBDC.MIGRATE.SR000003.C004'
ROWIDCOL(COL3_ROWID)
LOBCOL(COL4_CLOB)
COMMITFREQ(2500)
COMMITSIZE(100)
MSGLVL(0)
Related topic