× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Paul,

I just fired off one long running query:
FROM files . . . . . . . . . QSYS2/SYSPARTITIONSTAT
SELECT fields . . . . . . . TABLE_SCHEMA, TABLE_NAME, TABLE_PARTITION,
SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME,
SYSTEM_TABLE_MEMBER
WHERE conditions . . . . . . system_table_member='SYSRO00001'

My shoot from the hip answer is to run a RCLSTG *DBXREF

You should be able to verify that with a call to IBM. Be a real downer if
you went through the political process to get permission to bring the
system down into a restricted state to do the RCLSTG *DBXREF only to find
out you should also apply some delayed PTF to fix it and have to get
permission, again.

Doing the *DBXREF isn't a long running process. You'll spend more time
getting the system down and back up again.
On systems with even an 11 hour full RCLSTG the *DBXREF normally only
takes 20 minutes.


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.