|
View previous topic :: View next topic
|
| Author |
Message |
sravz chinnu
New User
Joined: 07 Dec 2011
Posts: 26
Location: India
|
|
|
|
Hello friends,
I am loading the table using the options
LOAD RESUME YES
COMMIT 2500
DELETEFILES YES
ENUMROWS (250000000,2000000)
into table XXXXXXX
I am getting the following error:
| Quote: |
| UNEXPECTED TOKEN 'COMMIT' ENCOUNTERED IN COMMAND |
.
Please let me know what option i can use to commit in LOAD. I have very big file to load.
I checked in IBM manuals but i could not find the COMMIT option in LOAD. |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| I think COMMITs in IBM DB2 Load process is internally handled by DB2. IIRC, if you use BMC LoadPlus for DB2, there is an option (or installation-specific) to code the commit count. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
suggest
you
read
the
manual
instead of
searching
for commit. |
|
| Back to top |
|
|
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
| which load utility are you using? |
|
| Back to top |
|
|
sravz chinnu
New User
Joined: 07 Dec 2011
Posts: 26
Location: India
|
|
|
|
| Gnanas N wrote: |
| I think COMMITs in IBM DB2 Load process is internally handled by DB2. IIRC, if you use BMC LoadPlus for DB2, there is an option (or installation-specific) to code the commit count. |
I am using BMC load. and i am using APCOMMIT.
When i use Only APCOMMIT 2500. I am not able to run the job
When i use SHarelevel option i am able to run my JCL.
Thanks for all your replies. |
|
| Back to top |
|
|
|
|
