Rollforward pending for tablespaces

Matthew Rhea

Rollforward pending for tablespaces
Hi, List. DB2 V8.1.4 for Windows here.

I restored two tablespaces using this command:

RESTORE DATABASE RPS01 TABLESPACE (TRABCNM, TRQSRC) ONLINE
FROM "E:\db2_backups" TAKEN AT 20051229205621 WITH 2 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;

I thought using the phrase WITHOUT ROLLING FORWARD would indicate that I
only wanted to restore to the backup. When I issued a get db cfg command,
I got the message that the database is not consistent and tablespaces are
in a rollforward pending status. The tablespaces are unavailable with the
message

SQL0290N Table space access is not allowed.

Explanation:

A process attempted to access a table space which is in an
invalid state for which the intended access is not allowed.

o If the table space is in a quiesced state, only processes
which also hold the table space in a quiesced state are
allowed access to the table space.

o If the table space is in any other state, only the process
which is performing the action specified is allowed access to
the table space.

o A system or user temporary table space cannot be dropped
which contains active system or declared temporary tables.

o The SET CONTAINER api cannot be used to set the container
list unless the table space is in a "restore pending"
state.

User Response:

Possible actions include:

o If the table space is in a quiesced state, attempt to acquire
a quiesced share or quiesced update state on the table space.
Or, attempt to quiesce reset the table space.

o If the table space is in any other state, wait until the
table space has returned to normal state before attempting to
access the table space.

Refer to the Administration Guide for further information about
the table space states.

I issued a ROLLFORWARD command and received a –818. The db2diag.log shows
the -818 sqlcode:

2006-01-03-11.15.20.130000 Instance:DB2 Node:000
PID:4432(db2bp.exe) TID:5812 Appid:*LOCAL.DB2.028043161520
data protection sqlpGetTspID Probe:100
Error encountered during rollforward. sqlcode= -818 with token=

I determined that I could drop and rebuild the tables, since the tables
are reloaded for every batch cycle. When I tried to drop the tables, I
got the same SQL -290.

What's the best way to get out of this mess? What package do I need to
rebind to get rid of the -818? db2bp.exe is working for other commands.
Is it db2bp.exe that is getting the -818? Is there a way to drop the
tables and regenerate them? I have the ddl created from the DB2LOOK
command.

Thanks,
Matthew

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Matthew Rhea

Re: Rollforward pending for tablespaces
(in response to Matthew Rhea)
I was able to access the tables in the tablespaces. I dropped and
recreated the tables and tablespaces. It didn't work the first time
because I was dropping the table, not the tablespace. (Blush)

Now when I issue a get db cfg for the database, it shows the rollforward
pending status:

Database is consistent = NO
Rollforward pending = TABLESPACE
Restore pending = NO

When I issue the rollforward command, I get this message, telling me the
database is not in rollforward pending.

D:\DB2\temp>DB2 ROLLFORWARD DB RPS01 TABLESPACE ONLINE

Rollforward Status

Input database alias = RPS01
Number of nodes have returned status = 1

Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = -
Last committed transaction = 2005-12-31-04.30.31.000000

Am I OK? Do I have to rollforward a specific tablespace and not the
entire database? What do I do about the conflicting messages? I can
select from all the tables in the database, so they appear to be
available.

On Tue, 3 Jan 2006 11:05:15 -0600, Matthew Rhea <[login to unmask email]>
wrote:

>Hi, List. DB2 V8.1.4 for Windows here.
>
>I restored two tablespaces using this command:
>
>RESTORE DATABASE RPS01 TABLESPACE (TRABCNM, TRQSRC) ONLINE
>FROM "E:\db2_backups" TAKEN AT 20051229205621 WITH 2 BUFFERS BUFFER 1024
>PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
>
>I thought using the phrase WITHOUT ROLLING FORWARD would indicate that I
>only wanted to restore to the backup. When I issued a get db cfg command,
>I got the message that the database is not consistent and tablespaces are
>in a rollforward pending status. The tablespaces are unavailable with the
>message
>
>SQL0290N Table space access is not allowed.
>
>Explanation:
>
>A process attempted to access a table space which is in an
>invalid state for which the intended access is not allowed.
>
>o If the table space is in a quiesced state, only processes
> which also hold the table space in a quiesced state are
> allowed access to the table space.
>
>o If the table space is in any other state, only the process
> which is performing the action specified is allowed access to
> the table space.
>
>o A system or user temporary table space cannot be dropped
> which contains active system or declared temporary tables.
>
>o The SET CONTAINER api cannot be used to set the container
> list unless the table space is in a "restore pending"
> state.
>
>User Response:
>
>Possible actions include:
>
>o If the table space is in a quiesced state, attempt to acquire
> a quiesced share or quiesced update state on the table space.
> Or, attempt to quiesce reset the table space.
>
>o If the table space is in any other state, wait until the
> table space has returned to normal state before attempting to
> access the table space.
>
> Refer to the Administration Guide for further information about
>the table space states.
>
>I issued a ROLLFORWARD command and received a –818. The db2diag.log shows
>the -818 sqlcode:
>
>2006-01-03-11.15.20.130000 Instance:DB2 Node:000
>PID:4432(db2bp.exe) TID:5812 Appid:*LOCAL.DB2.028043161520
>data protection sqlpGetTspID Probe:100
>Error encountered during rollforward. sqlcode= -818 with token=
>
>I determined that I could drop and rebuild the tables, since the tables
>are reloaded for every batch cycle. When I tried to drop the tables, I
>got the same SQL -290.
>
>What's the best way to get out of this mess? What package do I need to
>rebind to get rid of the -818? db2bp.exe is working for other commands.
>Is it db2bp.exe that is getting the -818? Is there a way to drop the
>tables and regenerate them? I have the ddl created from the DB2LOOK
>command.
>
>Thanks,
>Matthew
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

John Lendman

Re: Rollforward pending for tablespaces
(in response to Matthew Rhea)
I would run a "rollforward" with the complete option. That should make it OK

John C. Lendman
IBM Certified Solutions Expert
IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS
Office 561-357-7523
Cell 772-485-1592
Email [login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Matthew Rhea
Sent: Tuesday, January 03, 2006 1:23 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Rollforward pending for tablespaces


I was able to access the tables in the tablespaces. I dropped and
recreated the tables and tablespaces. It didn't work the first time
because I was dropping the table, not the tablespace. (Blush)

Now when I issue a get db cfg for the database, it shows the rollforward
pending status:

Database is consistent = NO
Rollforward pending = TABLESPACE
Restore pending = NO

When I issue the rollforward command, I get this message, telling me the
database is not in rollforward pending.

D:\DB2\temp>DB2 ROLLFORWARD DB RPS01 TABLESPACE ONLINE

Rollforward Status

Input database alias = RPS01
Number of nodes have returned status = 1

Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = -
Last committed transaction = 2005-12-31-04.30.31.000000

Am I OK? Do I have to rollforward a specific tablespace and not the
entire database? What do I do about the conflicting messages? I can
select from all the tables in the database, so they appear to be
available.

On Tue, 3 Jan 2006 11:05:15 -0600, Matthew Rhea <[login to unmask email]>
wrote:

>Hi, List. DB2 V8.1.4 for Windows here.
>
>I restored two tablespaces using this command:
>
>RESTORE DATABASE RPS01 TABLESPACE (TRABCNM, TRQSRC) ONLINE
>FROM "E:\db2_backups" TAKEN AT 20051229205621 WITH 2 BUFFERS BUFFER 1024
>PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
>
>I thought using the phrase WITHOUT ROLLING FORWARD would indicate that I
>only wanted to restore to the backup. When I issued a get db cfg command,
>I got the message that the database is not consistent and tablespaces are
>in a rollforward pending status. The tablespaces are unavailable with the
>message
>
>SQL0290N Table space access is not allowed.
>
>Explanation:
>
>A process attempted to access a table space which is in an
>invalid state for which the intended access is not allowed.
>
>o If the table space is in a quiesced state, only processes
> which also hold the table space in a quiesced state are
> allowed access to the table space.
>
>o If the table space is in any other state, only the process
> which is performing the action specified is allowed access to
> the table space.
>
>o A system or user temporary table space cannot be dropped
> which contains active system or declared temporary tables.
>
>o The SET CONTAINER api cannot be used to set the container
> list unless the table space is in a "restore pending"
> state.
>
>User Response:
>
>Possible actions include:
>
>o If the table space is in a quiesced state, attempt to acquire
> a quiesced share or quiesced update state on the table space.
> Or, attempt to quiesce reset the table space.
>
>o If the table space is in any other state, wait until the
> table space has returned to normal state before attempting to
> access the table space.
>
> Refer to the Administration Guide for further information about
>the table space states.
>
>I issued a ROLLFORWARD command and received a -818. The db2diag.log shows
>the -818 sqlcode:
>
>2006-01-03-11.15.20.130000 Instance:DB2 Node:000
>PID:4432(db2bp.exe) TID:5812 Appid:*LOCAL.DB2.028043161520
>data protection sqlpGetTspID Probe:100
>Error encountered during rollforward. sqlcode= -818 with token=
>
>I determined that I could drop and rebuild the tables, since the tables
>are reloaded for every batch cycle. When I tried to drop the tables, I
>got the same SQL -290.
>
>What's the best way to get out of this mess? What package do I need to
>rebind to get rid of the -818? db2bp.exe is working for other commands.
>Is it db2bp.exe that is getting the -818? Is there a way to drop the
>tables and regenerate them? I have the ddl created from the DB2LOOK
>command.
>
>Thanks,
>Matthew
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Matthew Rhea

Re: Rollforward pending for tablespaces
(in response to John Lendman)
Thanks for the response.

Here's the command I issued along with the results:

ROLLFORWARD DATABASE RPS01 COMPLETE TABLESPACE ONLINE
SQL1261N Database "RPS01" is not in rollforward pending state on node
(s) "0",
so it does not need to be rolled forward on these nodes.

My get db cfg command is still showing tablespaces in rollforward status.
The database appears to be behaving, so I guess I'll just see how it
goes. I sure would like to get a "warm fuzzy" about this, but I'll just
keep monitoring.

Thanks,
Matthew

On Tue, 3 Jan 2006 13:53:30 -0500, John Lendman
<[login to unmask email]> wrote:

>I would run a "rollforward" with the complete option. That should make it
OK
>
>John C. Lendman
>IBM Certified Solutions Expert
>IBM Certified Database Administrator
>DB2 Universal Database V8.1 for zOS
>Office 561-357-7523
>Cell 772-485-1592
>Email [login to unmask email]
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Matthew Rhea
>Sent: Tuesday, January 03, 2006 1:23 PM
>To: [login to unmask email]
>Subject: Re: [DB2-L] Rollforward pending for tablespaces
>
>
>I was able to access the tables in the tablespaces. I dropped and
>recreated the tables and tablespaces. It didn't work the first time
>because I was dropping the table, not the tablespace. (Blush)
>
>Now when I issue a get db cfg for the database, it shows the rollforward
>pending status:
>
>Database is consistent = NO
>Rollforward pending = TABLESPACE
>Restore pending = NO
>
>When I issue the rollforward command, I get this message, telling me the
>database is not in rollforward pending.
>
>D:\DB2\temp>DB2 ROLLFORWARD DB RPS01 TABLESPACE ONLINE
>
> Rollforward Status
>
> Input database alias = RPS01
> Number of nodes have returned status = 1
>
> Node number = 0
> Rollforward status = not pending
> Next log file to be read =
> Log files processed = -
> Last committed transaction = 2005-12-31-04.30.31.000000
>
>Am I OK? Do I have to rollforward a specific tablespace and not the
>entire database? What do I do about the conflicting messages? I can
>select from all the tables in the database, so they appear to be
>available.
>
>On Tue, 3 Jan 2006 11:05:15 -0600, Matthew Rhea <[login to unmask email]>
>wrote:
>
>>Hi, List. DB2 V8.1.4 for Windows here.
>>
>>I restored two tablespaces using this command:
>>
>>RESTORE DATABASE RPS01 TABLESPACE (TRABCNM, TRQSRC) ONLINE
>>FROM "E:\db2_backups" TAKEN AT 20051229205621 WITH 2 BUFFERS BUFFER 1024
>>PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
>>
>>I thought using the phrase WITHOUT ROLLING FORWARD would indicate that I
>>only wanted to restore to the backup. When I issued a get db cfg
command,
>>I got the message that the database is not consistent and tablespaces are
>>in a rollforward pending status. The tablespaces are unavailable with the
>>message
>>
>>SQL0290N Table space access is not allowed.
>>
>>Explanation:
>>
>>A process attempted to access a table space which is in an
>>invalid state for which the intended access is not allowed.
>>
>>o If the table space is in a quiesced state, only processes
>> which also hold the table space in a quiesced state are
>> allowed access to the table space.
>>
>>o If the table space is in any other state, only the process
>> which is performing the action specified is allowed access to
>> the table space.
>>
>>o A system or user temporary table space cannot be dropped
>> which contains active system or declared temporary tables.
>>
>>o The SET CONTAINER api cannot be used to set the container
>> list unless the table space is in a "restore pending"
>> state.
>>
>>User Response:
>>
>>Possible actions include:
>>
>>o If the table space is in a quiesced state, attempt to acquire
>> a quiesced share or quiesced update state on the table space.
>> Or, attempt to quiesce reset the table space.
>>
>>o If the table space is in any other state, wait until the
>> table space has returned to normal state before attempting to
>> access the table space.
>>
>> Refer to the Administration Guide for further information about
>>the table space states.
>>
>>I issued a ROLLFORWARD command and received a -818. The db2diag.log
shows
>>the -818 sqlcode:
>>
>>2006-01-03-11.15.20.130000 Instance:DB2 Node:000
>>PID:4432(db2bp.exe) TID:5812 Appid:*LOCAL.DB2.028043161520
>>data protection sqlpGetTspID Probe:100
>>Error encountered during rollforward. sqlcode= -818 with token=
>>
>>I determined that I could drop and rebuild the tables, since the tables
>>are reloaded for every batch cycle. When I tried to drop the tables, I
>>got the same SQL -290.
>>
>>What's the best way to get out of this mess? What package do I need to
>>rebind to get rid of the -818? db2bp.exe is working for other commands.
>>Is it db2bp.exe that is getting the -818? Is there a way to drop the
>>tables and regenerate them? I have the ddl created from the DB2LOOK
>>command.
>>
>>Thanks,
>>Matthew
>>
>>-------------------------------------------------------------------------
-
>-------
>>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
>select "Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
>[login to unmask email] Find out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

John Lendman

Re: Rollforward pending for tablespaces
(in response to Matthew Rhea)
Any chance that this tablespace is in Rollforward pending on another node, different from the one you are running the rollforward on? I do believe that you are OK on that node where you received this message.

John C. Lendman
IBM Certified Solutions Expert
IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS
Office 561-357-7523
Cell 772-485-1592
Email [login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Matthew Rhea
Sent: Tuesday, January 03, 2006 2:01 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Rollforward pending for tablespaces


Thanks for the response.

Here's the command I issued along with the results:

ROLLFORWARD DATABASE RPS01 COMPLETE TABLESPACE ONLINE
SQL1261N Database "RPS01" is not in rollforward pending state on node
(s) "0",
so it does not need to be rolled forward on these nodes.

My get db cfg command is still showing tablespaces in rollforward status.
The database appears to be behaving, so I guess I'll just see how it
goes. I sure would like to get a "warm fuzzy" about this, but I'll just
keep monitoring.

Thanks,
Matthew

On Tue, 3 Jan 2006 13:53:30 -0500, John Lendman
<[login to unmask email]> wrote:

>I would run a "rollforward" with the complete option. That should make it
OK
>
>John C. Lendman
>IBM Certified Solutions Expert
>IBM Certified Database Administrator
>DB2 Universal Database V8.1 for zOS
>Office 561-357-7523
>Cell 772-485-1592
>Email [login to unmask email]
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Matthew Rhea
>Sent: Tuesday, January 03, 2006 1:23 PM
>To: [login to unmask email]
>Subject: Re: [DB2-L] Rollforward pending for tablespaces
>
>
>I was able to access the tables in the tablespaces. I dropped and
>recreated the tables and tablespaces. It didn't work the first time
>because I was dropping the table, not the tablespace. (Blush)
>
>Now when I issue a get db cfg for the database, it shows the rollforward
>pending status:
>
>Database is consistent = NO
>Rollforward pending = TABLESPACE
>Restore pending = NO
>
>When I issue the rollforward command, I get this message, telling me the
>database is not in rollforward pending.
>
>D:\DB2\temp>DB2 ROLLFORWARD DB RPS01 TABLESPACE ONLINE
>
> Rollforward Status
>
> Input database alias = RPS01
> Number of nodes have returned status = 1
>
> Node number = 0
> Rollforward status = not pending
> Next log file to be read =
> Log files processed = -
> Last committed transaction = 2005-12-31-04.30.31.000000
>
>Am I OK? Do I have to rollforward a specific tablespace and not the
>entire database? What do I do about the conflicting messages? I can
>select from all the tables in the database, so they appear to be
>available.
>
>On Tue, 3 Jan 2006 11:05:15 -0600, Matthew Rhea <[login to unmask email]>
>wrote:
>
>>Hi, List. DB2 V8.1.4 for Windows here.
>>
>>I restored two tablespaces using this command:
>>
>>RESTORE DATABASE RPS01 TABLESPACE (TRABCNM, TRQSRC) ONLINE
>>FROM "E:\db2_backups" TAKEN AT 20051229205621 WITH 2 BUFFERS BUFFER 1024
>>PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
>>
>>I thought using the phrase WITHOUT ROLLING FORWARD would indicate that I
>>only wanted to restore to the backup. When I issued a get db cfg
command,
>>I got the message that the database is not consistent and tablespaces are
>>in a rollforward pending status. The tablespaces are unavailable with the
>>message
>>
>>SQL0290N Table space access is not allowed.
>>
>>Explanation:
>>
>>A process attempted to access a table space which is in an
>>invalid state for which the intended access is not allowed.
>>
>>o If the table space is in a quiesced state, only processes
>> which also hold the table space in a quiesced state are
>> allowed access to the table space.
>>
>>o If the table space is in any other state, only the process
>> which is performing the action specified is allowed access to
>> the table space.
>>
>>o A system or user temporary table space cannot be dropped
>> which contains active system or declared temporary tables.
>>
>>o The SET CONTAINER api cannot be used to set the container
>> list unless the table space is in a "restore pending"
>> state.
>>
>>User Response:
>>
>>Possible actions include:
>>
>>o If the table space is in a quiesced state, attempt to acquire
>> a quiesced share or quiesced update state on the table space.
>> Or, attempt to quiesce reset the table space.
>>
>>o If the table space is in any other state, wait until the
>> table space has returned to normal state before attempting to
>> access the table space.
>>
>> Refer to the Administration Guide for further information about
>>the table space states.
>>
>>I issued a ROLLFORWARD command and received a -818. The db2diag.log
shows
>>the -818 sqlcode:
>>
>>2006-01-03-11.15.20.130000 Instance:DB2 Node:000
>>PID:4432(db2bp.exe) TID:5812 Appid:*LOCAL.DB2.028043161520
>>data protection sqlpGetTspID Probe:100
>>Error encountered during rollforward. sqlcode= -818 with token=
>>
>>I determined that I could drop and rebuild the tables, since the tables
>>are reloaded for every batch cycle. When I tried to drop the tables, I
>>got the same SQL -290.
>>
>>What's the best way to get out of this mess? What package do I need to
>>rebind to get rid of the -818? db2bp.exe is working for other commands.
>>Is it db2bp.exe that is getting the -818? Is there a way to drop the
>>tables and regenerate them? I have the ddl created from the DB2LOOK
>>command.
>>
>>Thanks,
>>Matthew
>>
>>-------------------------------------------------------------------------
-
>-------
>>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
>select "Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
>[login to unmask email] Find out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Matthew Rhea

Re: Rollforward pending for tablespaces
(in response to John Lendman)
No, it's only on one node. Thanks for your help.
On Tue, 3 Jan 2006 14:12:50 -0500, John Lendman
<[login to unmask email]> wrote:

>Any chance that this tablespace is in Rollforward pending on another
node, different from the one you are running the rollforward on? I do
believe that you are OK on that node where you received this message.
>
>John C. Lendman
>IBM Certified Solutions Expert
>IBM Certified Database Administrator
>DB2 Universal Database V8.1 for zOS
>Office 561-357-7523
>Cell 772-485-1592
>Email [login to unmask email]
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Matthew Rhea
>Sent: Tuesday, January 03, 2006 2:01 PM
>To: [login to unmask email]
>Subject: Re: [DB2-L] Rollforward pending for tablespaces
>
>
>Thanks for the response.
>
>Here's the command I issued along with the results:
>
>ROLLFORWARD DATABASE RPS01 COMPLETE TABLESPACE ONLINE
>SQL1261N Database "RPS01" is not in rollforward pending state on node
>(s) "0",
>so it does not need to be rolled forward on these nodes.
>
>My get db cfg command is still showing tablespaces in rollforward status.
>The database appears to be behaving, so I guess I'll just see how it
>goes. I sure would like to get a "warm fuzzy" about this, but I'll just
>keep monitoring.
>
>Thanks,
>Matthew
>
>On Tue, 3 Jan 2006 13:53:30 -0500, John Lendman
><[login to unmask email]> wrote:
>
>>I would run a "rollforward" with the complete option. That should make it
>OK
>>
>>John C. Lendman
>>IBM Certified Solutions Expert
>>IBM Certified Database Administrator
>>DB2 Universal Database V8.1 for zOS
>>Office 561-357-7523
>>Cell 772-485-1592
>>Email [login to unmask email]
>>
>>
>>
>>-----Original Message-----
>>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>>Behalf Of Matthew Rhea
>>Sent: Tuesday, January 03, 2006 1:23 PM
>>To: [login to unmask email]
>>Subject: Re: [DB2-L] Rollforward pending for tablespaces
>>
>>
>>I was able to access the tables in the tablespaces. I dropped and
>>recreated the tables and tablespaces. It didn't work the first time
>>because I was dropping the table, not the tablespace. (Blush)
>>
>>Now when I issue a get db cfg for the database, it shows the rollforward
>>pending status:
>>
>>Database is consistent = NO
>>Rollforward pending = TABLESPACE
>>Restore pending = NO
>>
>>When I issue the rollforward command, I get this message, telling me the
>>database is not in rollforward pending.
>>
>>D:\DB2\temp>DB2 ROLLFORWARD DB RPS01 TABLESPACE ONLINE
>>
>> Rollforward Status
>>
>> Input database alias = RPS01
>> Number of nodes have returned status = 1
>>
>> Node number = 0
>> Rollforward status = not pending
>> Next log file to be read =
>> Log files processed = -
>> Last committed transaction = 2005-12-31-04.30.31.000000
>>
>>Am I OK? Do I have to rollforward a specific tablespace and not the
>>entire database? What do I do about the conflicting messages? I can
>>select from all the tables in the database, so they appear to be
>>available.
>>
>>On Tue, 3 Jan 2006 11:05:15 -0600, Matthew Rhea
<[login to unmask email]>
>>wrote:
>>
>>>Hi, List. DB2 V8.1.4 for Windows here.
>>>
>>>I restored two tablespaces using this command:
>>>
>>>RESTORE DATABASE RPS01 TABLESPACE (TRABCNM, TRQSRC) ONLINE
>>>FROM "E:\db2_backups" TAKEN AT 20051229205621 WITH 2 BUFFERS BUFFER 1024
>>>PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
>>>
>>>I thought using the phrase WITHOUT ROLLING FORWARD would indicate that I
>>>only wanted to restore to the backup. When I issued a get db cfg
>command,
>>>I got the message that the database is not consistent and tablespaces
are
>>>in a rollforward pending status. The tablespaces are unavailable with
the
>>>message
>>>
>>>SQL0290N Table space access is not allowed.
>>>
>>>Explanation:
>>>
>>>A process attempted to access a table space which is in an
>>>invalid state for which the intended access is not allowed.
>>>
>>>o If the table space is in a quiesced state, only processes
>>> which also hold the table space in a quiesced state are
>>> allowed access to the table space.
>>>
>>>o If the table space is in any other state, only the process
>>> which is performing the action specified is allowed access to
>>> the table space.
>>>
>>>o A system or user temporary table space cannot be dropped
>>> which contains active system or declared temporary tables.
>>>
>>>o The SET CONTAINER api cannot be used to set the container
>>> list unless the table space is in a "restore pending"
>>> state.
>>>
>>>User Response:
>>>
>>>Possible actions include:
>>>
>>>o If the table space is in a quiesced state, attempt to acquire
>>> a quiesced share or quiesced update state on the table space.
>>> Or, attempt to quiesce reset the table space.
>>>
>>>o If the table space is in any other state, wait until the
>>> table space has returned to normal state before attempting to
>>> access the table space.
>>>
>>> Refer to the Administration Guide for further information about
>>>the table space states.
>>>
>>>I issued a ROLLFORWARD command and received a -818. The db2diag.log
>shows
>>>the -818 sqlcode:
>>>
>>>2006-01-03-11.15.20.130000 Instance:DB2 Node:000
>>>PID:4432(db2bp.exe) TID:5812 Appid:*LOCAL.DB2.028043161520
>>>data protection sqlpGetTspID Probe:100
>>>Error encountered during rollforward. sqlcode= -818 with token=
>>>
>>>I determined that I could drop and rebuild the tables, since the tables
>>>are reloaded for every batch cycle. When I tried to drop the tables, I
>>>got the same SQL -290.
>>>
>>>What's the best way to get out of this mess? What package do I need to
>>>rebind to get rid of the -818? db2bp.exe is working for other
commands.
>>>Is it db2bp.exe that is getting the -818? Is there a way to drop the
>>>tables and regenerate them? I have the ddl created from the DB2LOOK
>>>command.
>>>
>>>Thanks,
>>>Matthew
>>>
>>>------------------------------------------------------------------------
-
>-
>>-------
>>>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>>home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
>>select "Join or Leave the list". The IDUG DB2-L FAQ is at
>>http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
>>[login to unmask email] Find out the latest on IDUG conferences at
>>http://conferences.idug.org/index.cfm
>>
>>-------------------------------------------------------------------------
-
>-------
>>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
>select "Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
>[login to unmask email] Find out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm
>>
>>-------------------------------------------------------------------------
-
>-------
>>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
>select "Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
>[login to unmask email] Find out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm