 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 16 matches |
| Author | Message |
|---|---|
 Topic: Rexx/DB2 Error Handling |
|
| grimpeur Replies: 10 Views: 7268 |
 Forum: Database Posted: Mon Aug 18, 2008 2:17 pm Subject: Rexx/DB2 Error Handling |
Thanks IEFBR14 I will look into that (unless anybody has a code snippet they would be willing to share  ) |
|
| Topic: Rexx/DB2 Error Handling |
|
| grimpeur Replies: 10 Views: 7268 |
Forum: Database Posted: Sat Aug 16, 2008 3:52 am Subject: Rexx/DB2 Error Handling |
| Hardcoding all the possible error messages is not a realistic option. I'm amazed there isn't an obvious way of doing this!
Thanks for the responses though... I tried displaying SQLCA.SQLMSG but cou ... |
|
| Topic: Rexx/DB2 Error Handling |
|
| grimpeur Replies: 10 Views: 7268 |
Forum: Database Posted: Fri Aug 15, 2008 1:32 pm Subject: Rexx/DB2 Error Handling |
| Sorry for any confusion - I stopped the TS deliberately to simulate an error.
My question is can I get from anywhere the full text of the error message (in this case "-904 UNSUCCESSFUL EXECUTI ... |
|
| Topic: Rexx/DB2 Error Handling |
|
| grimpeur Replies: 10 Views: 7268 |
Forum: Database Posted: Fri Aug 15, 2008 11:16 am Subject: Rexx/DB2 Error Handling |
| Hi,
I am bringing myself up to speed with Rexx/DB2 appl. programming and have a query regarding error message handling. If I get a negative SQL code in my program I would like to display the mea ... |
|
| Topic: Help with coding complex SQL (DB2 z/OS v8 CM) |
|
| grimpeur Replies: 6 Views: 3433 |
Forum: Database Posted: Tue Apr 08, 2008 8:01 am Subject: Help with coding complex SQL (DB2 z/OS v8 CM) |
| Thanks very much for your assistance Videlord. It needed a little tweaking, but is now working as desired.
Cheers! Grimps. |
|
| Topic: Help with coding complex SQL (DB2 z/OS v8 CM) |
|
| grimpeur Replies: 6 Views: 3433 |
Forum: Database Posted: Tue Apr 08, 2008 7:54 am Subject: Help with coding complex SQL (DB2 z/OS v8 CM) |
| Thanks very much for your assistance Videlord. It needed a little tweaking, but is now working as desired.
Cheers! Grimps. |
|
| Topic: Help with coding complex SQL (DB2 z/OS v8 CM) |
|
| grimpeur Replies: 6 Views: 3433 |
Forum: Database Posted: Mon Apr 07, 2008 9:39 am Subject: Help with coding complex SQL (DB2 z/OS v8 CM) |
| Hi Videlord,
Thanks for your reply... however, your SQL does not meet the requirements of all the rules. Please let me know if they are not clear. Any other takers for this SQL challenge??? Thanks ... |
|
| Topic: Help with coding complex SQL (DB2 z/OS v8 CM) |
|
| grimpeur Replies: 6 Views: 3433 |
Forum: Database Posted: Mon Apr 07, 2008 6:02 am Subject: Help with coding complex SQL (DB2 z/OS v8 CM) |
| Hi everyone,
Tearing my hair out a little bit with this one, if anybody is able to offer suggestions it would be most appreciated... It sounds fairly simple on the face of it, but I'm having troubl ... |
|
| Topic: Realtime Stats Anomoly - DB2 z/OS |
|
| grimpeur Replies: 6 Views: 3127 |
Forum: Database Posted: Wed Jan 09, 2008 10:43 am Subject: Realtime Stats Anomoly - DB2 z/OS |
| Yes the row has been updated as indicated by UPDATESTATSTIME. Reorg, Copy and Stats timestamps, and Total Rows are also all up-to-date. | |
| Topic: Realtime Stats Anomoly - DB2 z/OS |
|
| grimpeur Replies: 6 Views: 3127 |
Forum: Database Posted: Wed Jan 09, 2008 10:02 am Subject: Realtime Stats Anomoly - DB2 z/OS |
| Yes, RTS is working for other fields and other tablespaces - it is just this particular TS (in fact this a a few related ones) that have incorrect extents recorded. | |
| Topic: Realtime Stats Anomoly - DB2 z/OS |
|
| grimpeur Replies: 6 Views: 3127 |
Forum: Database Posted: Wed Jan 09, 2008 6:55 am Subject: Realtime Stats Anomoly - DB2 z/OS |
| Just to add, it is possible that there has been no insert/update activity since the reorg | |
| Topic: Realtime Stats Anomoly - DB2 z/OS |
|
| grimpeur Replies: 6 Views: 3127 |
Forum: Database Posted: Wed Jan 09, 2008 6:54 am Subject: Realtime Stats Anomoly - DB2 z/OS |
| We have a partitioned tablespace in DB2 z/OS v8 CM.
One particular partition is showing incorrect information in the EXTENTS field in SYSIBM.TABLESPACESTATS A Re-Org was run on the partition so that ... |
|
| Topic: How to identify sys load/proclibs used in particular shop? |
|
| grimpeur Replies: 4 Views: 2480 |
Forum: Job Control Language(JCL) Posted: Tue Oct 02, 2007 7:57 am Subject: How to identify sys load/proclibs used in particular shop? |
| Ahh, thanks - I tried a few search terms but none of those came up. | |
| Topic: How to identify sys load/proclibs used in particular shop? |
|
| grimpeur Replies: 4 Views: 2480 |
Forum: Job Control Language(JCL) Posted: Tue Oct 02, 2007 7:33 am Subject: How to identify sys load/proclibs used in particular shop? |
| Hi all,
Surprisingly couldn't find anything on this via search. I'm wondering how to go about working out which libraries will be searched when a program load module, rexx exec, JCL procedure etc i ... |
|
| Topic: DB2 z/OS - Compression |
|
| grimpeur Replies: 3 Views: 2287 |
Forum: Database Posted: Tue Jan 16, 2007 7:29 am Subject: DB2 z/OS - Compression |
| OK, thanks for that. | |
All times are GMT - 5 Hours |