The bind error messages below are returned when running the db2batch
command on Windows NT against an AS/400 database. Most batch scripts
are running without error.
What files and and command need to be run to fix this error?
------------------------------------------
Client version
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\admindb>
D:\ibm\db2\BIN>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release
"SQL08015" with
level identifier "02060106".
Informational tokens are "DB2 v8.1.5.449", "s040212", "WR21334", and
FixPak
"5".
Product is installed at "D:\ibm\db2".
D:\ibm\db2\BIN>
Server version
db2 => connect to black user vw400
Enter current password for vw400:
Database Connection Information
Database server = OS/400 5.2.0
SQL authorization ID = VW400
Local database alias = BLACK
db2 =>
---------------------------------------------
SQL0525N The SQL statement cannot be executed because it was in error
at bind
time for section = "9" package = "TOOL1E00 " consistency
token =
X"NULLID". SQLSTATE=51015
SQL0525N The SQL statement cannot be executed because it was in error
at bind
time for section = "10" package = "TOOL1E00 " consistency
token =
X"NULLID". SQLSTATE=51015
---------------------------------------------
Statement number: 1
SET TRANSACTION ISOLATION LEVEL NO COMMIT
SQL0525N The SQL statement cannot be executed because it was in error
at bind
time for section = "1" package = "TOOL1E00 " consistency
token =
X"NULLID". SQLSTATE=51015
Elapsed Time is: 0.000 seconds
D:\ibm\db2\bnd>dir /w
Volume in drive D is DATA_DRIVE
Volume Serial Number is A004-805C
Directory of D:\ibm\db2\bnd
[.] [..] applycs.lst
applyur.lst
asnaapp.bnd asnacmp.bnd asnadmin.bnd
asnafet.bnd
asnaiso.bnd asnaman.bnd asnanalyze.bnd
asnanalyze.bnd2
asnappwk.bnd asnaprs.bnd asnawpn.bnd
asnccpwk.bnd
asncdins.bnd asncmon.bnd asnctsql.bnd
asndbcon.bnd
ASNDONE.bnd ASNLOAD.bnd asnmdata.bnd
asnmig4c.bnd
asnmig4c.bnd2 asnmig8.bnd asnmig8.bnd2
asnmoncs.lst
asnmonit.bnd asnmonit.lst asnmonur.lst
asnmsgt.bnd
asnmupdt.bnd asnprune.bnd asnreg.bnd
asnsqlcd.bnd
asnsqlcf.bnd asntxs.bnd asnuow.bnd
batchslv.bnd
bhunt.bnd capture.lst db2advis.bnd
db2ajgrt.bnd
db2arxcs.bnd db2arxnc.bnd db2arxrr.bnd
db2arxrs.bnd
db2arxur.bnd db2atld.bnd db2batch.bnd db2cat.bnd
db2cli.lst db2clipk.bnd db2clist.bnd
db2clpcs.bnd
db2clpnc.bnd db2clprr.bnd db2clprs.bnd
db2clpsy.bnd
db2clpur.bnd db2dclgn.bnd db2dropv.bnd
db2dsproc.bnd
db2evmon.bnd db2exdyn.bnd db2exfmt.bnd
db2exmig.bnd
db2expln.bnd db2exsrv.bnd db2gpmap.bnd
db2lk390.bnd
db2lkfun.bnd db2look.bnd db2move.bnd
db2pctsp.bnd
db2rbind.bnd db2reg2large.bnd db2satcs.bnd
db2schema.bnd
db2spcat.bnd db2spcdb.bnd db2sql92.bnd
db2ubind.lst
db2ucktb.bnd db2ueiwi.bnd db2uexpm.bnd
db2ugtpi.bnd
db2uiddl.bnd db2uigsi.bnd db2uiici.bnd
db2uiict.bnd
db2uimpm.bnd db2uimtb.bnd db2uipkg.bnd
db2ulxld.bnd
db2undgp.bnd db2updv8.bnd db2uqtnm.bnd
db2uqtpd.bnd
db2uredp.bnd db2urexp.bnd db2_recon_aid.bnd
ddcs400.lst
ddcsmvs.lst ddcsvm.lst ddcsvse.lst dxxadm.bnd
dxxbind.lst dxxcnuwo.bnd dxxcol.bnd
dxxcoll.bnd
dxxcomp.bnd dxxdb.bnd dxxds.bnd dxxlm.bnd
dxxMigv.bnd dxxMigv.lst dxxMigv81.bnd
dxxrcomp.bnd
dxxrdbi.bnd dxxscomp.bnd dxxsqlda.bnd
dxxsuwo.bnd
dxxtab.bnd dxxxof.bnd dxxxxll.bnd
gseClAdv.bnd
gseClIdx.bnd gseClSQL.bnd insertx.bnd main.bnd
mqlConfig.bnd mqlRun.bnd mqxml.bnd
promocat.bnd
promocol.bnd promoind.bnd promoreg.bnd
promosub.bnd
promotab.bnd promotbl.bnd promote.bnd
promote.lst
promots.bnd psmgtptp.bnd redistrb.bnd
retrieve.bnd
retrieve2.bnd retrievec.bnd sgSql.bnd shred.bnd
snaputil.bnd st_admin.bnd tbscont.bnd
tests2x.bnd
tests2xb.bnd tests2xc.bnd
156 File(s) 1,339,053 bytes
2 Dir(s) 47,433,908,224 bytes free
D:\ibm\db2\bnd>