MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 382 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: performance issue in DB2 Stored procedure
Manas Biswal

Replies: 1
Views: 1571

PostForum: 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: 2425

PostForum: 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: 2234

PostForum: 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: 3218

PostForum: 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: 12037

PostForum: 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: 12037

PostForum: 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: 12037

PostForum: 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: 12037

PostForum: 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: 1829

PostForum: 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: 3462

PostForum: 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: 3159

PostForum: 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: 1967

PostForum: 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: 3585

PostForum: 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: 6605

PostForum: 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: 3247

PostForum: 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
 
Page 1 of 26 Goto page 1, 2, 3 ... 24, 25, 26  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group