× 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.



There is a UDTF for a single library, provided by IBM - you can use *ALL for the object types - here is an example of its use -

SELECT * FROM TABLE (QSYS2/OBJECT_STATISTICS('VHTEST ','*ALL')) as x

It can do only one library. Oh, yeah, I said that already - heh!

Brief docs for this and other services are at -
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DB2%20for%20i%20-%20Services

On that page, click at "attachments" near the bottom for a link to a Powerpoint showing the various services, both DB2 and system -

Very cool stuff being provided by the database team at IBM.

HTH
Vern

On 8/5/2014 10:33 AM, CRPence wrote:
On 05-Aug-2014 08:36 -0500, Gqcy wrote:
Does someone have a SQL that I can run that will show the library
size?


A procedure [or ILE or OPM program] that gathers the result from requesting Size via the Retrieve Library Description (QLIRLIBD) API can be encapsulated in a scalar User Defined Function (UDF). The routine would be defined to the SQL via CREATE FUNCTION [external scalar].



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.