Info on gathering explain data for AS/400:
http://www.redbooks.ibm.com/redpapers/pdfs/redp0502.pdf...
lowpaydba
Last Activity: Nov 18 '09, 03:13 AM
Joined: Oct 30 '09
Location:
-
Are you using the DB2 Control Center to run this query? If so can you do a visual explain and attach that to the thread, that should show which indexes are used by the db2 optimizer as well as costs of doing joins, sorts etc to help find ways to optimize this query.
If you do not have access to the DB2 Control Center you can use the command line dynexpln or db2exfmt tools to gather the same information.Leave a comment:
-
Hi,
I don't know a great deal about Veritas , but it might be a good idea to check if this particular log i.e. "S0004615.L OG" actually exists where Veritas is archiving it to.
Looking at the db cfg file, the first active log file in use is S0004617.LOG.
Hence it appears that either S0004615.LOG was not archived properly by veritas which would explain why the db2 online backup is failing because...Leave a comment:
-
Hi,
I'm a bit surprised that this query is working in its current form. When I tried to run it i got the following:
-----------------------------------------------------------------------------------------------
SQL0338N An ON clause associated with a JOIN operator or in a MERGE statement is not valid.
Explanation:
An ON clause associated with a JOIN operator or in a MERGE
statement...Leave a comment:
-
Hi,
DB2 LUW has the get_dbsize_info (?, ?, ?, 0) stored procedure to calculate the size of the databases. I'm not sure if this procedure is available in z/OS, but you may want to verify this.
Also this general approach may be useful.
use db2_all command (not sure its available in z/OS!) to list the table space container info for the database in question.
db2_all "list tablespace containers...Leave a comment:
No activity results to display
Leave a comment: