Determining Table Status?

Patrick Finnegan

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

Subscribe Post Reply

11805

zgh1970

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

Patrick Finnegan

On May 1, 7:32 pm, zgh1970 <george.zh...@lombard.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

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

MySQL Database

Show Table Status question

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

MySQL Database

Error While Fetching Schema Table Status

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

MySQL Database

getting table status

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? ...

MySQL Database

Java mysql show table status

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

MySQL Database

ibm db2 lock (row/table) status/indication

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: ...

DB2 Database

determining the status of a stream

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

C# / C Sharp

Show Table Status

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

PHP

SHOW TABLE STATUS

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

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

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

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

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,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

Determining Table Status?

Similar topics