http://www-1.ibm.com/support/docview.wss?rs=64&uid=swg27009129
Extracting SYSLGRNX content for loading to a user table Forum/discussion group
Abstract
This sample JCL and DDL unloads the contents of the DB2 directory table SYSIBM.SYSLGRNX and loads the data back to a user DB2 table for research purposes.
Content
To run this example, download the attached JCL and upload it to your z/OS® system. If you have access to DFSORT, download V32. Otherwise download V31.
Make changes to the JCL as indicated in the comments. If you don't have DFSORT, you may still want to reference V32 as it has additional queries which can help evaluate how to set PCLOSET and PCLOSEN.
Example submitted by: Mike Bracey, IBM® UK
Rate this example
Notice: This example is from the DB2® Examples Trading Post and is provided on an "as-is" basis. You may copy and modify this example in any form without payment to IBM, for the purposes of designing and developing application programs conforming to the application programming interface for the z/OS or OS/390® operating system for which these examples are written. This example has been tested, but it has not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of this example in your particular environment. Use this example as a model for your own situations.
Return to the DB2 Examples Trading Post
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group
DB2 Development
DB2 Information Management Software
