Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Load hangs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-08, 15:40
blackhawk_123 blackhawk_123 is offline
Registered User
  
Join Date: Jul 2008
Posts: 17
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:
Reply With Quote
  #2 (permalink)  
Old 12-17-08, 16:05
n_i n_i is offline
:-)
  
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
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:
Quote:
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.
...........................
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.