Hello Lucia,
I suppose that the storage for the messages is restricted by the Db2-Command-Processor (DSN), I don't know how this can be increased.
But it is possible to execute Db2-Commands by IFI-Calls (DSNWLI2, COMMAND). Once ago there was a good IDUG presentation on the web ('The Joy of DB2') with a good example, but it seems to be gone.
DSNWLI-calls can be done by programs or even by REXX, and here it is possible to control the size of the Return-Area. But of course, it needs some coding.
If you're interested in this point please let me know, I will look for an example.
Kind regards
Rolf
------------------------------
Rolf Drees
------------------------------
Original Message:
Sent: Wed April 09, 2025 11:55 AM
From: Lucia Santucci
Subject: Questions on a specific DB2 command
Hi all,
our customer has more than 5000 databases.
With our command "Display DB(*) ONLY LIMIT(*)" , the amount of Database returned is going to be limited by the space so we need an alternative to have a complete listing of all the Databases.
Options are:
- Try out the command with different LIMIT values to confirm this is what is happening.
- Try out command with SPACENAM(*) on their system to see if this completes ok.
- Try out command with SPACENAM filters specified in order to break up the query.
also:
- What exactly is the "space" that's limiting the outputs from the command?
- Is that space something that the customer can "increase", and what's the implication to the customer if they increase the space?
- If increasing the space is an appropriate action, how can that space be increased (specific command to use)?
Thanks a lot for your help!
------------------------------
Lucia Santucci
zAnalytics Support Team Lead
------------------------------