Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Indexing on Catlog Tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pankajsoni

New User


Joined: 21 Jun 2006
Posts: 9
Location: Zurich

PostPosted: Fri Jul 27, 2007 3:37 pm    Post subject: Indexing on Catlog Tables
Reply with quote

Hi all,

I have a small DB2 tool in Rexx and using the DSNREXX to connect with DB2.

This tool generates some catalog information in my desired format and have complex queries on DB2 catlog tables. But, unfortunately, I am not getting the good performance. There may be chance of improving my queries and that I would try to. But, I am just exploring the possibility of creating some indexes.

So, my questions are,
1) Can I create Indexes on Catlog Tables in any of my personal TABLESPACE ?
2) If yes, then How to make my query to use this Index in Rexx ?
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Mon Jul 30, 2007 1:42 am    Post subject:
Reply with quote

1) You can only create an index on the tables in their own TABLESPACE as far as I know. Try it and find out.
2) DB2 determines if it wants to use an index for your query, not you. DB2 will optimize as best as possible using available indexes it find.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts ISPF Tables Creation newsysprg TSO/ISPF 6 Wed Jul 13, 2016 2:21 pm
No new posts New DB2 tables creation kishpra DB2 3 Tue Feb 02, 2016 7:00 pm
No new posts TABLES/MS from Specialized Solutions ... Gary Jacek COBOL Programming 0 Thu Sep 03, 2015 12:08 am
No new posts TABLES/MS from Specialized Solutions ... Gary Jacek IMS DB/DC 0 Thu Sep 03, 2015 12:08 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us