Personal tools
You are here: Home DB2 How To's How to check the state and type from one table
Navigation
Log in


Forgot your password?
 
Document Actions

How to check the state and type from one table

Table information: state and type


The Status of the table object is showed below:

  • C = Set integrity pending
  • N = Normal
  • X = Inoperative

The  type of the table is  showed below

TYPE CHAR(1)
Type of object.
  • A = Alias
  • G = Global temporary table
  • H = Hierarchy table
  • L = Detached table
  • N = Nickname
  • S = Materialized query table
  • T = Table (untyped)
  • U = Typed table
  • V = View (untyped)
  • W = Typed view

To verify the table status and type, after to connect on database at command prompt type:

db2 "select substr(tabname,1,20) , status, type from syscat.tables \
where tabname = 'table_name'"

You will have something like:

TABNAME              STATUS    TYPE

Table_name             N          T


  1 record(s) selected.

    Using the Syscat.tables you can find much more information like Table Status,  Which tablespaces the tables reside,  table type ,etc.

    Access the URL below and on the search type : syscat.tables to see all options and informations that you can see about tables.

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls