Based on some data expiration and other issues, we are planning for an automated growth monitor. I?ve some questions regarding the successful load message in system log. It's an AIX environment with CMOD 8.4.1.3, DB2 9.5.4 & TSM 5.4
1) Can you please explain what exactly do the highlighted areas (in red) mean? I?m getting confused because totals don?t match when I sum up.
2) Can we get the DB2 space utilized for this load out of System log message? If not, is there a way to get it?
Here is the entry in System log for a sample successful load03/03/10 13:13:18 ADMIN 7434294 Info Yes 87 Application Group Load: Name(TS2Statements) LoadId(1136-8-0-20522FAA-14671-14671) File(/storage/COLD_hold/fdr.stmtafp_od.cyc.02.032010.13.load)
InputSize(1621104995) OutputSize(332082427) Rows(50000) Time(386.7570) Appl(TS2Statements)
Details inside this log entry:arsload: Processing file >/storage/COLD_hold/fdr.stmtafp_od.cyc.02.032010.13.load<
arsload: 03/03/10 13:06:51 -- Indexing started,
1541225298 bytes to process0425-415 cc=yes
0425-415 cctype=a
0425-415 cpgid=500
0425-415 convert=yes
0425-415 trc=no
0425-415 dcfpagenames=yes
0425-415 fileformat=record
0425-415 imageout=asis
0425-415 indexobj=all
0425-415 indexstartby=1
0425-415 formdef=F1ONDMD1
0425-415 pagedef=P1V06483
0425-415 mcf2ref=cf
0425-415 userlib=/usr/lpp/ars/resources:/prod/home01/appl/print/psf_resources/exceptions:/prod/home01/appl/print/resources/fdr_resources
0425-415 reslib=/usr/lpp/ars/resources
0425-415 fontlib=/usr/lpp/psf/fontlib
0425-415 pdeflib=/usr/lpp/ars/resources
0425-415 fdeflib=/usr/lpp/ars/resources
0425-415 restype=all
0425-415 inputdd=/storage/COLD_hold/fdr.stmtafp_od.cyc.02.032010.13.load
0425-415 outputdd=/arsacif/acif2/fdr.stmtafp_od.cyc.02.032010.13.load.out
0425-415 indexdd=/arsacif/acif2/fdr.stmtafp_od.cyc.02.032010.13.load.ind
0425-415 resobjdd=/arsacif/acif2/fdr.stmtafp_od.cyc.02.032010.13.load.res
0425-440 ACIF AT PK91927 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
arsload: 03/03/10 13:10:32 Indexing completed
arsload: 03/03/10 13:10:32 -- Loading started,
1619006975 bytes to processResource /arsacif/acif2/fdr.stmtafp_od.cyc.02.032010.13.load.res will be added as resource >19668-8-0<. Compression Type(OD77)
Original Size(13870377) Compressed Size(3744874)OnDemand Load Id = >1136-8-0-20522FAA-14671-14671<
Loaded 50000 rows into the database
Document compression type used - OD77.
Bytes Stored = >332082427< Rows = >50000<
arsload: 03/03/10 13:13:18 Loading completed
arsload: Processing successful for file >/storage/COLD_hold/fdr.stmtafp_od.cyc.02.032010.13.load<
Thanks in advance for your help on this!
Regards,
Sandeep Veldi