469,623 Members | 1,053 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

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

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
3 10634
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
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
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.

Similar topics

4 posts views Thread by maricel | last post: by
7 posts views Thread by satish mullapudi | last post: by
3 posts views Thread by shawno | last post: by
4 posts views Thread by Mr. DOS | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.