Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    5

    Unanswered: Import error - UDB version DB2/NT 8.2.8

    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?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Try rebinding the utilities packages:

    db2 bind @db2ubind.lst action replace grant public

  3. #3
    Join Date
    Mar 2011
    Posts
    5
    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
    ???

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Did the bind of db2ubind.lst complete successfully and was it done from the client machine?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •