Can't get table out of check pending state after load.

[Stephen]

This is probably something simple but I've been trying for a while now
and can't seem to get it.

I'm loading a table from an IXF file with the following command

'load from D:/db_scripts/load_test/nlm.ixf of ixf modified by
USEDEFAULTS method n (NOTIFY_LIST_ID,PUBLICATION_ID) insert into
mediaadm.NOTIFY_LIST_MEMBERS'

this works fine but afterwards the table goes into a 'check pending'
state that i can't seem to get rid of.

I tried to use the following command for SET INTEGRITY, as it describes
in the docs.

' SET INTEGRITY FOR notify_list_members IMMEDIATE CHECKED'
but it returns the error
'SQL0290N Table space access is not allowed. SQLSTATE=55039'

This is the only table in 'check pending' state that I can see when I
run the query.
select tabname,status,const_checked from syscat.tables where status='C'

Am I missing something?

It doesn't seem to matter If I run the load from the control center or
from the command line.

Thanks.
Stephen

[Pierre Saint-Jacques]

This probably happens because you are running under LOGRETAIN=RECOVERY which
will force the tablespace to go in backup pending after the load.
You'll need to backup the tablespace before running the set integrity which
will still be neede.
You can, in the future, get out of this by running the LOAD command with a
COPY YES option TO sometaerget filename.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Stephen" <sg******@mediabids.com> a écrit dans le message de news:
11**********************@t31g2000cwb.googlegroups. com...

This is probably something simple but I've been trying for a while now
and can't seem to get it.

I'm loading a table from an IXF file with the following command

'load from D:/db_scripts/load_test/nlm.ixf of ixf modified by
USEDEFAULTS method n (NOTIFY_LIST_ID,PUBLICATION_ID) insert into
mediaadm.NOTIFY_LIST_MEMBERS'

this works fine but afterwards the table goes into a 'check pending'
state that i can't seem to get rid of.

I tried to use the following command for SET INTEGRITY, as it describes
in the docs.

' SET INTEGRITY FOR notify_list_members IMMEDIATE CHECKED'
but it returns the error
'SQL0290N Table space access is not allowed. SQLSTATE=55039'

This is the only table in 'check pending' state that I can see when I
run the query.
select tabname,status,const_checked from syscat.tables where status='C'

Am I missing something?

It doesn't seem to matter If I run the load from the control center or
from the command line.

Thanks.
Stephen

[Peri]

Stephen,
At what state is the tablespace in?
Stephen wrote:

This is probably something simple but I've been trying for a while now
and can't seem to get it.

I'm loading a table from an IXF file with the following command

'load from D:/db_scripts/load_test/nlm.ixf of ixf modified by
USEDEFAULTS method n (NOTIFY_LIST_ID,PUBLICATION_ID) insert into
mediaadm.NOTIFY_LIST_MEMBERS'

this works fine but afterwards the table goes into a 'check pending'
state that i can't seem to get rid of.

I tried to use the following command for SET INTEGRITY, as it describes
in the docs.

' SET INTEGRITY FOR notify_list_members IMMEDIATE CHECKED'
but it returns the error
'SQL0290N Table space access is not allowed. SQLSTATE=55039'

This is the only table in 'check pending' state that I can see when I
run the query.
select tabname,status,const_checked from syscat.tables where status='C'

Am I missing something?

It doesn't seem to matter If I run the load from the control center or
from the command line.

Thanks.
Stephen

[Stephen]

I used the 'copy yes' option and it worked.

The database was set to retain the logs.

Thanks for taking the time to help me.
Stephen