| View previous topic :: View next topic |
| Author |
Message |
somuk
Beginner
Joined: 04 Feb 2003
Posts: 113
Topics: 37
|
 Posted: Tue Jun 24, 2003 10:52 am Post subject: How to get the SYSPRINT information for DSNUTILB |
 |
|
Hi,
I'm using DSNUTILB to load data into a table from a file.After the load process If I go to the SYSPRINT I could see a lot information as follows
| Code: |
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = SXILOAD.JSXID325
DSNU050I DSNUGUTC - LOAD DATA LOG NO REPLACE INDDN SYSREC
DSNU650I -DDBA DSNURWI - INTO TABLE SXI.T_EIM_ADDRESS
DSNU650I -DDBA DSNURWI - (IF_ROW_BATCH_NUM POSITION(1) INTEGER,
-----
---
DSNU350I -DDBA DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
DSNU231I -DDBA DSNURBDC - DICTIONARY WITH 4096 ENTRIES HAS BEEN SUCCESSFULLY BUI
SXI100DB.SXI102TS
DSNU234I -DDBA DSNURWT - COMPRESSION REPORT FOR TABLE SPACE SXI100DB.SXI102TS
|
Are these information available in any of the system table..? I need to capture some specific information from the SYSPRINT (eg:UTILID = SXILOAD.JSXID325)
. It'll be cumbersome if we capture the SYSPRINT to a dataset and write a program to loop thru this file and extract the information.. Can anybody give some suggestions..?
Thanks
-Somu |
|
| Back to top |
|
 |
CZerfas
Intermediate
Joined: 31 Jan 2003
Posts: 211
Topics: 8
|
| Posted: Thu Jun 26, 2003 3:03 am Post subject: |
|
|
Hi Somu,
the SYSPRINT report is the documentation of an individual utility run. There is no sense in saving this report within the DB2 catalog.
To my eyes writing a REXX procedure to parse a saved SYSPRINT file should not be that much of an effort.
regards
Christian |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
