IZ07986: LOAD FAILURE WITH -3026 (SQL3026N) WHEN DUMPFILE IS SPECIFIED

APAR status

• Closed as duplicate of another APAR.

Error description

• Load intermittently fails with -3026 (SQL3026NThe msgfile or
  tempfiles path parameter is not valid)
  .
  db2diag.log contains the following error:
  .
  2004-06-21-02.31.56.067121   Instance:TEST   Node:098
  PID:485822(db2agent (EWHP1) 98)   TID:1   Appid:*N98.test.0C7D91
  database utilities  DIAG_ERROR Probe:0   Database:TEST
  .
  LOADID: 485822.2004-06-21-02.31.55.201351.98 (880;4)
  Error initializing filetmod object. -3026, 0,  Detected in file:
  sqluCatalog.C,line 364
  .
  This error is related to the dumpfile load parameter. The error
  is comming from our parsing of the dumpfile and is generated
  when the dumpfile value is deemed invalid.
  
  
  ========================================================
  
  Or db2diag.log may have:
  
  2007-06-20-11.53.19.505726-300 I3086597A985       LEVEL: Error
  PID : 3252290 TID : 1 PROC : db2agent (E3BULKPR) 0
  INSTANCE: bronzadm             NODE : 000         DB   :
  E3BULKPR
  APPHDL  : 0-1371               APPID:
  *LOCAL.bronzadm.070620165319
  AUTHID  : EBB2BPRD
  FUNCTION: DB2 UDB, database utilities,
  sqluCFileTypeModifier::iInitialize, probe:256
  MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
            "SQLCA has already been built"
  DATA #1 : LOADID, PD_TYPE_LOADID, 43 bytes
  3252290.2007-06-20-11.53.19.492573.0 (7;50)
  DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
   sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -3026   sqlerrml: 8
   sqlerrmc: DUMPFILE
   sqlerrp : SQLUETOK
   sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
  0x00000000
             (4) 0x00000000      (5) 0x00000000      (6)
  0x00000000
   sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
             (7)      (8)      (9)      (10)        (11)
   sqlstate:
  
  2007-06-20-11.53.19.506844-300 I3087583A528       LEVEL: Error
  PID : 3252290 TID : 1 PROC : db2agent (E3BULKPR) 0
  INSTANCE: bronzadm             NODE : 000         DB   :
  E3BULKPR
  APPHDL  : 0-1371               APPID:
  *LOCAL.bronzadm.070620165319
  AUTHID  : EBB2BPRD
  FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
  DATA #1 : String, 146 bytes
  LOADID: 3252290.2007-06-20-11.53.19.492573.0 (7;50)
  Error initializing filetmod object. , -2146107283, 0, Detected
  in
  file:sqluCatalog.C, Line:372
  
  2007-06-20-11.53.19.507893-300 I3088112A409       LEVEL: Warning
  PID : 3252290 TID : 1 PROC : db2agent (E3BULKPR) 0
  INSTANCE: bronzadm             NODE : 000         DB   :
  E3BULKPR
  APPHDL  : 0-1371               APPID:
  *LOCAL.bronzadm.070620165319
  AUTHID  : EBB2BPRD
  FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:23
  MESSAGE : SQLEU_FLAG1_FORCE_RBK is set, doing rollback
  
  ============================================================
  

Local fix

• There is no workaround.
  

Problem summary

Problem conclusion

Temporary fix

Comments

• duplicate of IZ11262
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IZ01330

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels