Community
Search Options
Search Options
Log in
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Data Management
Topic areas
Data Management Global
Db2
Db2 for z/OS and its ecosystem
Db2 Tools for z/OS
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
Upcoming Data Management Events
IBM TechXchange Webinars
All IBM TechXchange Community Events
Participate
Gamification Program
Community Manager's Welcome
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Data Management Users
All IBM TechXchange Community Users
Resources
IBM TechXchange Group
Data and AI Learning
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Support 101
IBM Technology Zone
IBM Training
IBM TechXchange Conference
Marketplace
Marketplace
IBM Data Management Community
Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.
Ask a question
Nominate for the IBM TechXchange Awards by 12 September!
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Data Management User Groups
Informix
View Only
Group Home
Discussion
8.1K
Library
109
Blogs
19
Events
1
Members
676
Expand all
|
Collapse all
sort by most recent
sort by thread
Unused Indexes
TOM GIRSCH
Mon January 25, 2021 11:33 AM
A few revisions of IDS 12.10 ago, HCL finally added a field to the oncheck -pt output that tells you ...
Scott Pickett
Mon January 25, 2021 11:50 AM
sysmaster:sysactptnhdr.pn_idx_acc_tm - active partitions sysmaster:sysptnhdr.idx_acc_tm - all partitions ...
TOM GIRSCH
Mon January 25, 2021 12:09 PM
I don't see a column in sysptnhdr that corresponds to the datetime at which an index was most recently ...
Scott Pickett
Mon January 25, 2021 02:49 PM
they are integers, think you have to convert to date Scott Pickett IBM ...
TOM GIRSCH
Mon January 25, 2021 02:57 PM
@Scott Pickett The relevant columns seem to be absent from 12.10.FC14XF. ------------------------------ ...
Scott Pickett
Mon January 25, 2021 03:25 PM
This was picked up from the sysmaster.sql file in $INFORMIXDIR/etc/sysmaster.sql for version 14.10.xC5. ...
TOM GIRSCH
Mon January 25, 2021 04:33 PM
So it looks like there's no way to get it from sysmaster in 12.10. Drat. ------------------------------------------- ...
TOM GIRSCH
Mon January 25, 2021 12:16 PM
sysactptnhdr.altstmp, maybe? SELECT n.tabname, ph.* FROM sysactptnhdr AS ph JOIN systabnames ...
1.
Unused Indexes
0
Like