Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File names for SMS tables in UNIX

Status
Not open for further replies.
kozlow

kozlow

MIS
Mar 3, 2003
326
US
I am running db2 7.2 on an AIX 4.3.3 system. We have a mix of DMS and SMS tablespaces. I see unique names such as SQL00164.INX and SQL00168.DAT for the SMS tables. Is there anyway to convert these names to the table and index associated with them. I did a describe on syscat.indexes but do not see any fields that may translate to the 164....

Thanks in advance
 
Status
Not open for further replies.

Similar threads

MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
985
MichaelDe
MichaelDe
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
376
ANGELDANY
ANGELDANY
gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
337
gdg1976
gdg1976
handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
140
handle907
handle907
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
169
gdg1976
gdg1976

Part and Inventory Search

Sponsor

Back
Top