Hi

I have an error loading a table in a UDB 8.1 db on Sun Soloaris:

SQL3109N The utility is beginning to load data from file
"d:\export\ADU.UTADU_ADRESSE.IXF".
SQL3500W The utility is beginning the "LOAD" phase at time "08-28-2003
11:23:55.589546".
SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
"20030827", and time "105250".
SQL3050W Conversions on the data will be made between the IXF file code page
"850" and the application code page "819".
SQL3153N The T record in the PC/IXF file has name
"d:\export\ADU.UTADU_ADRESSE.IXF", qualifier "", and source " ".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3110N The utility has completed processing. "7561" rows were read from
the input file.
SQL3519W Begin Load Consistency Point. Input record count = "7561".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "08-28-2003
11:23:56.736822".
SQL3500W The utility is beginning the "BUILD" phase at time "08-28-2003
11:23:56.770879".
SQL3213I The indexing mode is "REBUILD".
SQL3515W The utility has finished the "BUILD" phase at time "08-28-2003
11:23:57.926580".
SQL3805N The state of the application or of one or more table spaces for the
table specified prohibits the loadapi action or quiescemode "10". Reason code
= "1".

I issued the followings statements, both of them give the SQL3805N error:
a)
'LOAD CLIENT FROM 'exportpath||dest.ind.table'.IXF OF IXF MESSAGES 'message' REPLACE INTO 'dest.ind.table' STATISTICS YES AND INDEXES ALL CPU_PARALLELISM 2'

b)
'LOAD CLIENT FROM 'exportpath||dest.ind.table'.IXF OF IXF MESSAGES 'message' REPLACE INTO 'dest.ind.table''


What can be wrong ?

Thanks Marc

Hi,
Can you pls check the state of the tablespaces by executing

db2 list tablespaces show detail

probably one of your tablespaces is not in normal status

Thanks
Sateesh

for an MPP system, please execute on all db2 nodes.