MVSFORUMS.com

dohellwithmf · Beginner Joined: 12 Jul 2007 Posts: 55 Topics: 23

I am loading table using DB2 load utility (DSNUTILB). Can I capture the statistics for load i.e. start time/end time/num of recs loaded/fail/discarded etc in a file? As of now I am getting all these stats in Spool. I want these in a file in formatted manner, so that i can use this file to load these stats into another statistic table.

Please help me in this.

CraigG · Posted: Tue Mar 04, 2008 7:52 am Post subject:

Direct the output to a dataset (instead of sysout=) and write a program to read that and save it into a statistic table.

dohellwithmf · Beginner Joined: 12 Jul 2007 Posts: 55 Topics: 23

Ya but parsing that file would be a problem. The stats wont come in the same line and column every time. We need to schedule jobs for getting stats and putting into the tables. Thats why I want have some formatted file kinda Runstat in COBOL DB2 programs.

Nic Clouston · Posted: Wed Mar 05, 2008 4:41 am Post subject:

run your print file through SORT and include the lines with the relevant message ids in your SORTOUT the process that file - you couold possibly get ICETOOL to do the formatting for you.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

jsharon1248 · Posted: Mon Mar 10, 2008 8:02 am Post subject:

I did this years ago using UNSTRING in COBOL. It's not too bad. You need to be aware of the different messages that DB2 writes under different circumstances. For example, the load writes different messages for partitioned and non-partitioned tablespaces.

dohellwithmf · Beginner Joined: 12 Jul 2007 Posts: 55 Topics: 23

Thank u every body for ur inputs Smile