Midrange News for the IBM i Community


Posted by: Joel Quisenberry
Anahiem, CA
Extract JOBD LIBL
has no ratings.
Published: 31 Jul 2012
Revised: 23 Jan 2013 - 4103 days ago
Last viewed on: 17 Apr 2024 (5618 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Extract JOBD LIBL Published by: Joel Quisenberry on 31 Jul 2012 view comments(4)

I looked on the web for ways to extract the JOBD LIBL into a file for analysis, and found a few, but the links are now broken. Any one out here know of a place to see examples of how to do it?

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: chrisp
Premium member *
Portland, OR
Comment on: Extract JOBD LIBL
Posted: 11 years 8 months 18 days 6 hours 58 minutes ago

Joel,

Does it have to be into a file? You can retrieve the libl with the RTVJOBA command and parse out the individual libraries.

Just an idea. Good luck.

Chris

Posted by: neilrh
Premium member *
Jackson, MI
Comment on: Extract JOBD LIBL
Posted: 11 years 8 months 18 days 5 hours 45 minutes ago

Use QWDRJOBD (google it and look for the publib.boulder.ibm.com url's).

To extract library list you need to extract the entire length of data available

360 168 BINARY(4) Offset to initial library list
364 16C BINARY(4) Number of libraries in initial library list
* * ARRAY (*) of CHAR(11) Initial library list
Posted by: qberryinc
Premium member *
Anahiem, CA
Comment on: Extract JOBD LIBL
Posted: 11 years 8 months 18 days 4 hours 38 minutes ago

File is best as it will end up in excel for analysis of the many, many jobds.

I did finally find an example on the web (might be one of cozzi's).

I have downloaded the source and will see what I get out of it!

Posted by: neilrh
Premium member *
Jackson, MI
Comment on: Extract JOBD LIBL
Posted: 11 years 8 months 17 days 14 hours 32 minutes ago

Sorry full solution would be:

  1. Create file for library list data.
  2. Create program that lists all jobd's on system into a userspace, then cycle through the entries in the userspace and retrieve the library list and other data of the jobd, an write a record for each into the file.
  3. Run the program.