 |
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 382 matches |
| Author | Message |
|---|---|
 Topic: performance issue in DB2 Stored procedure |
|
| Manas Biswal Replies: 1 Views: 1739 |
 Forum: Database Posted: Thu Sep 20, 2007 2:22 am Subject: performance issue in DB2 Stored procedure |
| rameshb,
Not sure of your exact situation here. Pls provide more details. Are you creating or declaring a GTT? Once the SP completes its execution GTTs should automatically be destroyed. And if th ... |
|
| Topic: DB2 Stored procedure |
|
| Manas Biswal Replies: 4 Views: 2670 |
Forum: Database Posted: Thu Sep 20, 2007 2:19 am Subject: DB2 Stored procedure |
| Agree with jsharon1248. Don't see a big performance improvement unless the INSERTS are invoked from a remote client.
Regards, Manas |
|
| Topic: Maximum length of string we can give in IN predicate |
|
| Manas Biswal Replies: 3 Views: 2457 |
Forum: Database Posted: Thu Sep 20, 2007 2:09 am Subject: Maximum length of string we can give in IN predicate |
| rameshb,
It looks like there is a mismatch in the column data type and host variable structure that you are trying to use in your IN predicate. If your column data type is VARCHAR, check that ... |
|
| Topic: Formatting character |
|
| Manas Biswal Replies: 8 Views: 3545 |
Forum: Database Posted: Thu Apr 26, 2007 2:40 pm Subject: Formatting character |
| kolusu,
I am a little fuzzy on this but won't a fieldproc decode the value back when there is a select or an unload. cobcurious, Do you need the "/" permanently changed to ", ... |
|
| Topic: Can i call Batch pgm from online pgm ? |
|
| Manas Biswal Replies: 9 Views: 12707 |
Forum: CICS and Middleware Posted: Thu Apr 26, 2007 11:04 am Subject: Can i call Batch pgm from online pgm ? |
| dbzTHEdinosauer,
Thanks for the info. Never really did that before. Was good information. Always thought that any program running on the CICS address space has to have a PPT entry defined. Will tr ... |
|
| Topic: Can i call Batch pgm from online pgm ? |
|
| Manas Biswal Replies: 9 Views: 12707 |
Forum: CICS and Middleware Posted: Thu Apr 26, 2007 11:00 am Subject: Can i call Batch pgm from online pgm ? |
| dbzTHEdinosauer,
Thanks for the info. Never really did that before. Was good information. Always thought that any program running on the CICS address space has to have a PPT entry defined. Will tr ... |
|
| Topic: Can i call Batch pgm from online pgm ? |
|
| Manas Biswal Replies: 9 Views: 12707 |
Forum: CICS and Middleware Posted: Thu Apr 26, 2007 10:59 am Subject: Can i call Batch pgm from online pgm ? |
| dbzTHEdinosauer,
Thanks for the info. Never really did that before. Was good information. Always thought that any program running on the CICS address space has to have a PPT entry defined. Will tr ... |
|
| Topic: Can i call Batch pgm from online pgm ? |
|
| Manas Biswal Replies: 9 Views: 12707 |
Forum: CICS and Middleware Posted: Wed Apr 25, 2007 1:30 pm Subject: Can i call Batch pgm from online pgm ? |
| toharmeet,
Don't know what your exact requirements are. But look up the following topics. Maybe they will help. 1. Calling CICS programs from non-CICS env - Search for EXCI or CICS External Cal ... |
|
| Topic: BIND PLAN with Package list and Performance |
|
| Manas Biswal Replies: 2 Views: 2062 |
Forum: Database Posted: Wed Apr 25, 2007 1:06 pm Subject: BIND PLAN with Package list and Performance |
| bauer,
Although I have no direct evidence (meaning actual numbers), but I would think that options 2 and 3 shld be a little more expensive than option 1. Simply because, for options 2 and 3, DB2 d ... |
|
| Topic: Data browsing using CICS and DB2 combination |
|
| Manas Biswal Replies: 6 Views: 3727 |
Forum: CICS and Middleware Posted: Wed Apr 25, 2007 7:09 am Subject: Data browsing using CICS and DB2 combination |
| nileshpalve,
My Question is, its always recommended that we should not use CICS-DB2 combination for browing data Online, since the cursors get closed and we have to repoint them during pseudocon ... |
|
| Topic: Lockmax-904 |
|
| Manas Biswal Replies: 4 Views: 3572 |
Forum: Database Posted: Mon Apr 16, 2007 9:09 am Subject: Lockmax-904 |
| abracadabra, mdizon02,
Whats the problem here. LOCKMAX set to -1 only means that you have set the LOCKMAX as SYSTEM in your tablespace create (or alter). This is always recommended in most situati ... |
|
| Topic: Can a database-trigger ( at row level) trigger a batch job |
|
| Manas Biswal Replies: 2 Views: 2227 |
Forum: Database Posted: Wed Apr 11, 2007 2:00 pm Subject: Can a database-trigger ( at row level) trigger a batch job |
| Dip,
I can think of an indirect way to do that. Define your trigger to call a DB2 stored procedure. Define a ddname pointing to the Internal Reader on your SPAS or WLM job (depending on whether yo ... |
|
| Topic: Daily job to delete data older than 15 day w/o EX access |
|
| Manas Biswal Replies: 6 Views: 3877 |
Forum: Database Posted: Wed Apr 11, 2007 10:12 am Subject: Daily job to delete data older than 15 day w/o EX access |
| vini_srcna,
If you requirement thinks that this data dont have to be logged, then you can avoid it from logging in the table definition. Can you prevent logging by specifying it in the table d ... |
|
| Topic: image copy failing on check pending status |
|
| Manas Biswal Replies: 9 Views: 7278 |
Forum: Database Posted: Wed Apr 11, 2007 9:35 am Subject: image copy failing on check pending status |
| vmbigot,
I think what you essentially want is a way to skip over some items in a list when using LISTDEF. The ITEMERROR option will do that for you. Here is the link - http://publib.boulde ... |
|
| Topic: DB2 Control center and DDL |
|
| Manas Biswal Replies: 6 Views: 3736 |
Forum: Database Posted: Fri Jun 02, 2006 1:10 pm Subject: DB2 Control center and DDL |
| vmbigot,
Do you get the generate DDL options for local DB2 UDB on Windows DB tables. Regards, Manas |
|
All times are GMT - 5 Hours |