473,839 Members | 1,437 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

tablespace queisced after load fail in partioned db

Hi.

I'm on DB2 9.5.0.1 on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and user data on 1 thru 3.

After a load failure (path to load file was wrong) I cannot access the
tables, even though the loads have been rerun with success.

set integrity for ..table..
results in SQL0290N Table space access is not allowed.
SQLSTATE=55039

Load query table says
Tablestate:
Set Integrity Pending

db2tbst 18 says
State = Load Pending

db2tbst 19
State = Quiesced Share
+ Load Pending

quiesce tablespaces for table ..HIST reset
says:
SQL3805N The state of the application or of one or more table spaces
for the
table specified prohibits the loadapi action or quiescemode "9".
Reason code =
"1".

I don't know how to get out of this state.
Any ideas?
/dg
Aug 21 '08 #1
5 6087
On Aug 21, 4:37 pm, danfa...@hotmai l.com wrote:
Hi.

I'm on DB2 9.5.0.1 on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and user data on 1 thru 3.

After a load failure (path to load file was wrong) I cannot access the
tables, even though the loads have been rerun with success.

set integrity for ..table..
results in SQL0290N Table space access is not allowed.
SQLSTATE=55039

Load query table says
Tablestate:
Set Integrity Pending

db2tbst 18 says
State = Load Pending

db2tbst 19
State = Quiesced Share
+ Load Pending

quiesce tablespaces for table ..HIST reset
says:
SQL3805N The state of the application or of one or more table spaces
for the
table specified prohibits the loadapi action or quiescemode "9".
Reason code =
"1".

I don't know how to get out of this state.
Any ideas?
/dg

u need to take backup of your tablespace to get out of this state.
make sure to give "nonrecover able or copy yes" option while
performing Load operation.
Regards,
Situ.

Aug 21 '08 #2
On Aug 21, 4:40 pm, situ <SRIDHAR...@red iffmail.comwrot e:
On Aug 21, 4:37 pm, danfa...@hotmai l.com wrote:
Hi.
I'm on DB2 9.5.0.1 on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and user data on 1 thru 3.
After a load failure (path to load file was wrong) I cannot access the
tables, even though the loads have been rerun with success.
set integrity for ..table..
results in SQL0290N Table space access is not allowed.
SQLSTATE=55039
Load query table says
Tablestate:
Set Integrity Pending
db2tbst 18 says
State = Load Pending
db2tbst 19
State = Quiesced Share
+ Load Pending
quiesce tablespaces for table ..HIST reset
says:
SQL3805N The state of the application or of one or more table spaces
for the
table specified prohibits the loadapi action or quiescemode "9".
Reason code =
"1".
I don't know how to get out of this state.
Any ideas?
/dg

u need to take backup of your tablespace to get out of this state.
make sure to give "nonrecover able or copy yes" option while
performing Load operation.

Regards,
Situ.
Hey sorry my mistake, since its load pending state just invoke Load
terminate or Load replace command

Regards,
Situ
Aug 21 '08 #3
On Aug 21, 1:44*pm, situ <SRIDHAR...@red iffmail.comwrot e:
On Aug 21, 4:40 pm, situ <SRIDHAR...@red iffmail.comwrot e:


On Aug 21, 4:37 pm, danfa...@hotmai l.com wrote:
Hi.
I'm on *DB2 9.5.0.1 *on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and *user data on 1 thru 3.
After a load failure (path to load file was wrong) I cannot access the
tables, even though the loads have been rerun with success.
set integrity for ..table..
results in SQL0290N *Table space access is not allowed.
SQLSTATE=55039
Load query table says
Tablestate:
* Set Integrity Pending
db2tbst 18 *says
State = Load Pending
db2tbst 19
State = Quiesced Share
* * * + Load Pending
quiesce tablespaces for table ..HIST reset
says:
SQL3805N *The state of the application or of one or more table spaces
for the
table specified prohibits the loadapi action or quiescemode "9".
Reason code =
"1".
I don't know how to get out of this state.
Any ideas?
/dg
u need to take backup of *your tablespace to get out of this state.
make sure to give "nonrecover able or copy yes" *option while
performing Load operation.
Regards,
Situ.

Hey sorry my mistake, since its load pending state just invoke *Load
terminate or Load replace command

Regards,
Situ- Hide quoted text -

- Show quoted text -
Hi.

I did run load .. replace , but the tablespaces still show load
pending.

I'll try to run a tablespace backup.
/dg
Aug 21 '08 #4
On Aug 21, 7:59*am, danfa...@hotmai l.com wrote:
On Aug 21, 1:44*pm, situ <SRIDHAR...@red iffmail.comwrot e:


On Aug 21, 4:40 pm, situ <SRIDHAR...@red iffmail.comwrot e:
On Aug 21, 4:37 pm, danfa...@hotmai l.com wrote:
Hi.
I'm on *DB2 9.5.0.1 *on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and *user data on 1 thru 3.
After a load failure (path to load file was wrong) I cannot access the
tables, even though the loads have been rerun with success.
set integrity for ..table..
results in SQL0290N *Table space access is not allowed.
SQLSTATE=55039
Load query table says
Tablestate:
* Set Integrity Pending
db2tbst 18 *says
State = Load Pending
db2tbst 19
State = Quiesced Share
* * * + Load Pending
quiesce tablespaces for table ..HIST reset
says:
SQL3805N *The state of the application or of one or more table spaces
for the
table specified prohibits the loadapi action or quiescemode "9".
Reason code =
"1".
I don't know how to get out of this state.
Any ideas?
/dg
u need to take backup of *your tablespace to get out of this state.
make sure to give "nonrecover able or copy yes" *option while
performing Load operation.
Regards,
Situ.
Hey sorry my mistake, since its load pending state just invoke *Load
terminate or Load replace command
Regards,
Situ- Hide quoted text -
- Show quoted text -

Hi.

I did run load *.. replace , but the tablespaces still show load
pending.

I'll try to run a tablespace backup.
/dg- Hide quoted text -

- Show quoted text -
I doubt the tbspce backup will succeed as the state is load pending
which is not normal state (required for backup).
As someone previously suggested, you need to cancel that load with a
LOAD TERMINATE command.
The result will be:
Tablespace is normal state. The table will also come out normal. If
the initial load was an INSERT then the table will come out as it was
before the load insert command. If the initial was a REPLACE then the
table will come out normal but empty.

You can then correct whatever caused the table load command to not
finish properly and reissue a load insert command.
Regards, Pierre.
Aug 22 '08 #5
Hi!

I had re-run the load successfully, so there was no Load to cancel or restart.
A tablespace backup cleared the problem.

:-)

/dg
Aug 24 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
16373
by: Paul | last post by:
I have several databases running on Solaris 2.8 and Oracle 8.1.7.4. I only have this problem with one of them. The temp tablespace always fills up and Oracle does not clear it out. If I expand the size of it, it still fills up. Even if all processes are finished, Oracle does not clear it out. Then I have programs fail with the "Unable to extend" error on the temp tablespace. We either have to bounce the DB, or drop and re-build the...
2
3616
by: Pablo | last post by:
I have observed a significant discrepancy between the amount of space used in a long tablespace when using import as compared to load. Can anyone explain the following? In an attempt to move data from one table/tablepace to another observed the following: Exported lobfile = 291 MB (average 60K / CLOB object)
3
21346
by: sandip | last post by:
Hi, i need to change the tablespace of a table, ie. use another tablespace for the table and stop the use of the existing tablespace. Is there any way i can accomplish this? One solution might be export the data from the table, re-create the tables in the new tablespace, drop the original tablespace and load the data. But i would prefer another simple and less time-consuming way. Any suggestions would be highly appreciated.
6
3681
by: Raj | last post by:
How can we do an online restore of a tablespace using the incremental backup's? we are on a partitioned database... Also, how could we use backup copy made by the load (using the copy to option in load) to revover the tablespace? Thanks, Raj
4
4655
by: Joachim Klassen | last post by:
DB2 V8.2 FP10 on Windows I tested the following HADR scenario: - a new tablespace on a new filesytem is created on the primary System - the replay on standby fails because of lacking permissions - the tablespace is backed up on the primary system - tables are created in the new tablespace and data is inserted (and a couple of logs are archived) - Takeover is done by the standby
10
2399
by: Sumanth | last post by:
Hi, I have a table that I would like to partition. It has a column c1 which has 100 distinct values. I was planning to partition the table on column c1 using a partioned index, and then apply data partitioned secondary indexes on the table. I then read about partioned table spaces, How do I get the same behaviour as above by creating a partioned table space?Do I create the partion table space, create the
3
3235
by: hikums | last post by:
Source/Production system: AIX 5.2, DB2 8.2 I have a full backup of sample db taken on 05/01/2006(logs included in backups) I have a tablespace backup of userspace1 taken on 05/03/2006(logs included in backups) There are other tablespaces in this db as well There is retention logging I want to restore the userspace1 tablespace of sampledb into newdb on
2
5575
by: db2dude | last post by:
Hello all, I have a database around 600GB and all tables were self-created by the application. Hence, we have only one huge SMS tablespace where all the tables are stored. To get better performance, we are planning to move the tables to a DMS tablespace with multiple containers. There are LOTS of tables and some tables have almost 40GB of data. Can you please suggest and efficient way of doing this. Also, I know that even a 32KB page...
4
6155
by: Patrick | last post by:
I have a tablespace that contains the LOB data for 3 tables which exist in other tablespaces. Even after reorging the LOB tablespace with the LONG option, the high water mark is still too high. I want to be able to shrink the tablespace below the current high water mark and return the excess space back to the filesystem. Is there another way to lower the HWM without exporting the data to another tablespace, dropping and recreating the...
0
9856
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9698
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10914
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10299
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9434
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7834
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7022
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5872
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4495
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.