Results 1 to 2 of 2

Thread: Load hangs

  1. #1
    Join Date
    Jul 2008
    Posts
    17

    Unanswered: Load hangs

    Hi all,

    i am trying to load into a table and it just hangs. any help is highly appreicated.

    Load cmd used is
    "load from /db/star/backup/TRACSPR/Export/TRANS_REQUESTS.ixf of ixf messages /db/star/backup/TRACSPR/Export/trans_req.msg insert into stprdb.trans_Requests nonrecoverable"

    this is what we see in db2diag.log


    2008-12-17-11.58.10.469998-480 I3423E521 LEVEL: Warning
    PID : 13554 TID : 47028608964512PROC : db2lfrm0 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
    DATA #1 : String, 138 bytes
    LOADID: 2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    Starting LOAD phase at 12/17/2008 11:58:10.466555. Table STPRDB .TRANS_REQUESTS

    2008-12-17-11.58.10.572676-480 I3945E961 LEVEL: Error
    PID : 13558 TID : 47028608964512PROC : db2lfrm4 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.573069-480 I4907E961 LEVEL: Error
    PID : 13560 TID : 47028608964512PROC : db2lfrm6 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.573497-480 I5869E961 LEVEL: Error
    PID : 13563 TID : 47028608964512PROC : db2lfrm9 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.574523-480 I6831E961 LEVEL: Error
    PID : 13555 TID : 47028608964512PROC : db2lfrm1 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.575529-480 I7793E961 LEVEL: Error
    PID : 13562 TID : 47028608964512PROC : db2lfrm8 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.572796-480 I8755E962 LEVEL: Error
    PID : 13565 TID : 47028608964512PROC : db2lfrm11 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.573279-480 I9718E961 LEVEL: Error
    PID : 13556 TID : 47028608964512PROC : db2lfrm2 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.574529-480 I10680E961 LEVEL: Error
    PID : 13557 TID : 47028608964512PROC : db2lfrm3 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2008-12-17-11.58.10.573095-480 I11642E961 LEVEL: Error
    PID : 13561 TID : 47028608964512PROC : db2lfrm7 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by blackhawk_123

    2008-12-17-11.58.10.572676-480 I3945E961 LEVEL: Error
    PID : 13558 TID : 47028608964512PROC : db2lfrm4 0
    INSTANCE: dbstar01 NODE : 000 DB : TRACSAR
    APPHDL : 0-22 APPID: *LOCAL.dbstar01.081217195655
    AUTHID : DBSTAR01
    FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea, probe:4998
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
    2954.2008-12-17-11.56.55.736352.0 (65530;32773)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLULDAT
    sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:
    C:\>db2 ? sql3025


    SQL3025N A parameter specifying a filename or path is not
    valid.

    Explanation:

    The parameter contains a path, directory, or file name that is
    not valid.

    For IMPORT and EXPORT, verify the datafile parameter.

    For LOAD, verify that each entry in the parameters of type
    sqlu_media_list : datafile should contain valid filenames;
    lobpaths copytarget , and workdirectory should contain valid
    paths on the server including the final separator and a null
    terminator.

    The pointer to lobpaths, copytarget and workdirectory must be
    valid or null.

    The pointer to the targets in these structures must be valid.

    Check that sessions and media_type are specified correctly.

    Also, if the lobpaths parameter is specified, check that the
    media_type is the same as that specified for the datafile
    structure.

    If the filetype is IXF, the length of the file name may be too
    long.
    ...........................
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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