473,322 Members | 1,778 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Table Inactive Error

Anyone know why I might be seeing this error...

2005-11-08-12.17.18.916000-360 I13443859H513 LEVEL: Severe
PID : 2364 TID : 3700 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FRDMARTD
APPHDL : 0-83 APPID: *LOCAL.DB2.051108181555
FUNCTION: DB2 UDB, catalog services, sqlrlRecreateIndex, probe:99
RETCODE : ZRC=0x8004002E=-2147221458=SQLD_ACCESSRESTRICTED
"ACCESS TABLE WHEN IN RESTRICTED STATE"
DIA8070C Attempt to access a table in a restricted state.

Platform is Windows 2003 Server
DB2 is v 8.2

A load failed, I have successfully backed up the tablespace, but the
table can not be accessed...

thanks in advance!

Martin

Nov 12 '05 #1
2 9401
You might revisit the LOAD command in the command reference manual. Pay
particular attention to "LOAD .... TERMINATE". The failed load process
should still have the table locked.

Phil Sherman
mghale wrote:
Anyone know why I might be seeing this error...

2005-11-08-12.17.18.916000-360 I13443859H513 LEVEL: Severe
PID : 2364 TID : 3700 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FRDMARTD
APPHDL : 0-83 APPID: *LOCAL.DB2.051108181555
FUNCTION: DB2 UDB, catalog services, sqlrlRecreateIndex, probe:99
RETCODE : ZRC=0x8004002E=-2147221458=SQLD_ACCESSRESTRICTED
"ACCESS TABLE WHEN IN RESTRICTED STATE"
DIA8070C Attempt to access a table in a restricted state.

Platform is Windows 2003 Server
DB2 is v 8.2

A load failed, I have successfully backed up the tablespace, but the
table can not be accessed...

thanks in advance!

Martin

Nov 12 '05 #2
Thanks Phil. That worked perfect!!

Nov 12 '05 #3

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

Similar topics

8
by: Omey Samaroo | last post by:
I have had most of my questions answered in this forum and learned a lot from reading others post. In fact, I have even discovered answers to questions that I thought were totally impossible and...
2
by: martin | last post by:
Hi, I have a webuser control. The webuser control contains a single table webcontrol. The start of the yable looks like <asp:Table id="tblTabs" runat="server" BorderWidth="0"...
11
by: steve.keanie | last post by:
Hi ... we're a mainframe V7 shop planning an imminent upgrade to V8. My application team is converting an IMS DB into a DB/2 table ... approximately 40GB of uncompressed (~20 GB compressed) data...
8
by: salad | last post by:
I was wondering how you handle active/inactive elements in a combo box. Let's say you have a combo box to select an employee. Joe Blow has been selected for many record however Joe has left the...
0
by: norm10115 | last post by:
I have a single MySQL table named "monthly" that contains the following fields: Id, Name, Interface, Status, MonYear I want to query "Status" for the past 3 months, of each "Device" and...
2
by: Elainie | last post by:
I want to convert numbers to text within a table, how can I do this.... I have tried an update query but it didnt come up with anything... 1 = Inactive 2 = Due 3 = Received 4 = Problems 5 =...
0
by: ramyareddy | last post by:
Hi All, i am using mssql 2005 and i am facing a strange problem. i have two databases A , B.When i try to insert one row in A from my application it is inserting the row but after that it is...
4
osward
by: osward | last post by:
I had made a table colum sortable and paging the table, following are the code // Display Event List echo "<center>"._EVENTLIST."</center><br>"; $now = Date(Y-m-d); // sort table...
5
by: thatcollegeguy | last post by:
Below are my 3php and 2js files. I create a table using ajax/php and then want to change the values in the tables add(+ number for teamid) id's for each specific td in the table. I don't know...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.