Import error - UDB version DB2/NT 8.2.8

dbforumsid · #1 (**permalink**) 03-31-11, 12:43

Attempting to import a file (export from our Z\OS Database)

Code:

import from m:\utility\DataRepl\data\TZG3D_km.del of del modified by datesiso decplusblank keepblanks chardel| commitcount 4000 messages m:\utility\DataRepl\log\IMP_TZG3d.log insert into TZG3D

I am getting this rather cryptic error:

Code:

2011-03-28-14.46.48.490000-240 I68706H542         LEVEL: Severe
PID     : 4548                 TID  : 2812        PROC : db2bp.exe
INSTANCE: DB2                  NODE : 000
APPID   : AC130C52.BF0B.110328184648
FUNCTION: <0>, <0>, <0>, probe:5295
MESSAGE : SQL0525N  The SQL statement cannot be executed because it was in 
          error at bind time for section = "" package = "" consistency token  = 
          X"".
DATA #1 : String, 12 bytes
sqluimtb.SQC
DATA #2 : String, 44 bytes
Error from Import/Export or Load Processing.

Does this mean that some package or packages are not bound? can anyone help out?

n_i · #2 (**permalink**) 03-31-11, 13:21

Try rebinding the utilities packages:

db2 bind @db2ubind.lst action replace grant public

dbforumsid · #3 (**permalink**) 03-31-11, 14:13

I ran these binds:

db2 bind @db2cli.lst blocking all grant public
db2 bind @db2ubind.lst blocking all grant public
db2 bind db2schema.bnd blocking all grant public

and it did not make a difference. I don't really know the difference between

db2 bind @db2cli.lst blocking all grant public
db2 bind @db2ubind.lst blocking all grant public
db2 bind db2schema.bnd blocking all grant public

and

db2 bind @db2ubind.lst action replace grant public

can I just rerun the bind as
db2 bind @db2ubind.lst action replace grant public
???

db2girl · #4 (**permalink**) 03-31-11, 21:58

Did the bind of db2ubind.lst complete successfully and was it done from the client machine?

Internet Services

Web Development

Digital Marketing

Consumer Tech