MVSFORUMS.com

Dip · Beginner Joined: 24 Mar 2006 Posts: 27 Topics: 14

I am trying to load a DB2 table (Approx 2 M records with online traffic turned On) using DB2 utility under SHRLEVEL CHANGE
Per my knowledge if we specify SHRLEVEL CHANGE we can not specify LOG NO

Can we do a load under SHRLEVEL CHANGE using

1. LOG NO (dont want to replicate the data)
2. Is there any way to control the commit frequnecy? (let say i want to commit after every 100 records)

(I cant use COBOL- DB2 because of some architectural issues)

Thanks!
Dip.

kolusu · Posted: Wed Jul 11, 2007 4:43 am Post subject:

Dip,

Check this link which explains the SHRLEVEL parm in detail

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH13/2.12.1.2?SHELF=&DT=20020826194002&CASE=

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu