473,695 Members | 2,575 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Determining Table Status?


Tables may be reorg pending or "set integrity pending". Can I run a
script to determine the status of a table?
Jun 27 '08 #1
2 11960
On May 1, 1:39*pm, Patrick Finnegan <finnegan.patr. ..@gmail.com>
wrote:
Tables may be reorg pending or "set integrity pending". *Can I run a
script to determine the status of a table?
you can
select status from syscat.tables where status<>'N';
'C' means check pending. you need to set integrity.
For the reorg, you can use
db2 list utilities to find the table in reorg.
thanks,
Jun 27 '08 #2
On May 1, 7:32 pm, zgh1970 <george.zh...@l ombard.cawrote:
On May 1, 1:39 pm, Patrick Finnegan <finnegan.patr. ..@gmail.com>
wrote:
Tables may be reorg pending or "set integrity pending". Can I run a
script to determine the status of a table?

you can
select status from syscat.tables where status<>'N';
'C' means check pending. you need to set integrity.
For the reorg, you can use
db2 list utilities to find the table in reorg.
thanks,
Excellent. Thanks.
Jun 27 '08 #3

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

Similar topics

0
4348
by: Jerry | last post by:
The "SHOW TABLE STATUS" command seems to return a result set, just like "SELECT * FROM SomeTable". Therefore, since the following is valid: SELECT * FROM (SELECT * FROM SomeTable) I inferred that this functionality would extend to the SHOW statement: SELECT * FROM (SHOW TABLE STATUS FROM SomeDataBase)
1
2562
by: Ken Elder | last post by:
I need to place the date a MySQL table was last updated into a PHP variable. SHOW TABLE STATUS provides lots of information, including update_time, for all of my tables. But how do I assign the value of update_time for my "members" table into the variable $dateLastUpdated? Thanks! Ken Elder
0
1550
by: bmichael... | last post by:
Hi, I've recently installed MySql 5.0.2 on a WinXp box and am always getting the above error every time I click on a schema in the Catalog. I can log on to the db fine, it always happens when I click on a schema. I've been struggling with this for hours....any and all help will be greatly appreciated.
1
1262
by: nospam | last post by:
Is there a really fast way to see if a table is marked as crashed? It seems check table and myisamchk are too slow large MyISAM tables (> 38GB) for such an operation. Any suggestions, hints? TIA
0
1749
by: 400PM | last post by:
Hi, I am using java to retrieve a resultset with "show table status" mysql command. I am having problem reading the and column. In the metadata object it is showing as VARCHAR but when I do getString() it is returning me the object string (e.g. "[B@1e3e7d2")and not the actual database value. I am using Mysql 4.1 and jdbc driver 3.1. I tried getB/Clob, getBytes, getCharacterStream() and none of them is working. Any assistance will...
2
15795
by: adri4n | last post by:
as wat ive mentioned in the title.. im would like to know whether the a particular record/table is being locked in my program. some of the methods which i would like to develop are as below: Lock(KEY, SQLCODE) - to create a lock. Returns 0 on success, 1 if a lock already exists and -1 on failure with SQLCODE. There is no necessity to use IsLock() for checking if a lock exists or not, just insert the record and check for
1
1846
by: Lee Crabtree | last post by:
Is there some way to find out if a stream is already open? In particular, I want to be able to switch from a NetworkStream to a FileStream depending on input. I know I can use a Stream object and cast it up, but how do I find out if the stream has been closed? The pseudocode would go a little something like this: public void OpenNetConnection(Socket connection) { if the stream is closed
1
2509
by: runway27 | last post by:
hi I am using MySQL - 4.1.22 when i use the following sql query $result = mysql_query("SHOW tablename STATUS FROM databasename;"); i have also tried = $result = mysql_query("SHOW tablename STATUS FROM databasename"); i get the following error message ====================================================
2
11531
by: Sudhakar | last post by:
hi I am using MySQL - 4.1.22 when i use the following sql query $result = mysql_query("SHOW tablename STATUS FROM databasename;"); i have also tried = $result = mysql_query("SHOW tablename STATUS FROM databasename"); i get the following error message
0
8649
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
8586
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
8838
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
7683
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...
0
5842
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
4351
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3025
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
2
2289
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1986
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.