By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Mar 28 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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


Mar 29 '06 #2

P: n/a
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


Mar 29 '06 #3

P: n/a
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

Mar 29 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.