10/11/2002 12:11 PM Please respond to DB2 Data Base Discussion List
We do something similar on an update. I imagine you could use the same logic on an insert. At least it should give you and idea on what to play with. HTH.. [...]
13869 46 56_Re: Installing DB2 BMC Tools using OS/390 z/OS Installer11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Fri, 11 Oct 2002 14:40:56 -0500435_iso-8859-1 I did just a few weeks ago. They have a few bugs with the installer not doing things right, but I was able to install Copy Plus and Recover Manager with only a few, minor problems (the 2 Recovery Manager problems were an incorrect skelton used to generate the jcl, and a generated member with alter statements was incorrect). I'd go through the install clist again and make sure you've selected the products correctly. [...]
13916 50 34_Re: Parse a VARCHAR into elements?14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Fri, 11 Oct 2002 15:43:11 -0400545_iso-8859-1 Rajib,
If your SP language is Java, you can use: 1. String parsing using StringTokenizer 2. XML parsing using SAXParser.
If you need code examples, let me know.
Abhijit
-----Original Message----- From: Rajib Ray [mailto:Rajib.Ray@KP.ORG] Sent: Friday, October 11, 2002 3:19 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Parse a VARCHAR into elements?
Hello All,
Has anyone got a 'slick way' of parsing a string (VARCHAR) into its elements for it to be used in a STORE PROC. [...]
13967 111 22_Re: db2 connect issues14_Manas Dasgupta22_dasgupta@BELLSOUTH.NET31_Fri, 11 Oct 2002 15:53:59 -0400474_iso-8859-1 Irrespective of what the settings are, should the threads not terminate after the application closes the connection and terminates?
We're having a similar problem - only in our case, "list dcs applications" do not show any application on the gateway. We however see the thread in Omegamon on the mainframe even though the application was successfully ended in the client. We're on 7.2 FP 3 on gateway and client and 7.1 on os/390 with CMTSTAT=ACTIVE. [...]
14079 165 40_Re: EDM Pool Shortage on PT's - 00C9008913_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 11 Oct 2002 20:55:59 +0100390_us-ascii Can't answer your question but can someone tell me where Omegamon gets these package-level EDM Pool storage occupancy numbers from? I'd like to get below the simple page counts at the category level that SMF 100 gives me.
Thanks, Martin
Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584) [...]
14245 154 23_Re: bufferpool tuning -13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 11 Oct 2002 20:54:53 +0100539_us-ascii Hi Joel! I hope you'll make it over to UKCMG next year. It's in a very nice part of the world - near where I live in Oxfordshire. :-)
I'm sure you won't be surprised to know I too favour miss rates (I/Os) over hit ratios.
I have to say that 42-6's are getting "a little dodgy" these days due to things like PPRC screwing up the hit ratio. However I still think they're very valuable. I haven't yet played with IFCID 199s but think the two together could be quite interesting. Oh well, a project to keep me busy [...]
14400 72 31_Re: DB2 Connect code page error22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Fri, 11 Oct 2002 13:01:45 -0700447_- Hi Joe,
Hi Joe,
I found this in the Admin guide for performance:
A DB2 Product or Platform that does not have a supported conversion function to, or from EUC(extended unix code) or UCS-2 installed will receive an SQLCODE -332 (sqlstate 57017) when running your application. Page 81.. This may be related to DBCS on some of the tables that you guys have.. Not sure if the table you are trying to look at is DBCS.. HTH.. [...]
14473 65 30_Re: Replacement for DB Attach?10_Todd Burch22_tburch@CDBSOFTWARE.COM31_Fri, 11 Oct 2002 15:01:20 -0500353_iso-8859-1 Hi Gary. I'm work for a vendor, but not in that market, so I'm answering in the capacity of a fellow programmer - been there, done that.
You can fix this with programming on the application side. Create a subtask for attaching to DB2 that is the funnel through which all other tasks that need to communicate with DB2 communicate. [...]
14539 56 30_Re: Replacement for DB Attach?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 11 Oct 2002 15:58:48 -0400602_iso-8859-1 We run hundreds (perhaps thousands) of CAF programs per day and have not experienced problems like you describe.
Regards, Eric Pearson NS ITO DB2 support
-----Original Message----- From: Gary Fahrlander [mailto:gary.fahrlander@ZURICHNA.COM] Sent: Friday, October 11, 2002 3:07 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Replacement for DB Attach?
Greetings Venerable Listers! Right now we're using two products to attach to DB2, TSO Attach and Softbases' DB Attach. Our cost for DB Attach has risen significantly so we're looking for a replacement. [...]
14596 24 19_CA-Platinum Install24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 11 Oct 2002 13:29:32 -0700434_- Hi!
We're currently in the process of installing the CA-Platinum utilities into a new DB2 version 7 subsystem on Z/OS. We have not purchased the IBM utilities suites, and have no plans to do so.
The problem we've encountered is that the install process for the CA utilities executes some IBM utilities like LOAD and RUNSTATS. I'd like to know if other sites have encountered this and if so, how they resolved it. [...]
14621 65 30_Re: Replacement for DB Attach?12_michael bell24_mbell11@WORLDNET.ATT.NET31_Fri, 11 Oct 2002 15:49:38 -0500337_iso-8859-1 The only way I know to create that behavior is to use multiple TCB's and create and delete subtask's. Create/term thread is only a little more expensive in CPU than MVS ATTACH, etc. I don't know what would happen if one module was TSO attach and another was call attach - My guess would be an abend of some S04E variety. [...]
14687 13 30_Re: Replacement for DB Attach?11_Ramon Rivas15_RIVASWS@AOL.COM29_Fri, 11 Oct 2002 17:00:14 EDT275_US-ASCII fyi -
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
14701 37 32_Re: dynamic caching in Version 715_Shields Michael28_ShieldsMichael@JOHNDEERE.COM31_Fri, 11 Oct 2002 16:07:56 -0500410_iso-8859-1 I would appreciate any feedback on this as well. I have been told that this is an parm at the system level and not configurable at any finer level. I'd love to hear otherwise.
Thanks, Mike
-----Original Message----- From: Joseph T. Murray Jr. [mailto:joe.murray@SSA.GOV] Sent: Friday, October 11, 2002 10:35 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: dynamic caching in Version 7 [...]
14739 16 3_FYI12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 12 Oct 2002 10:37:02 +0200331_- ORACLE CRM PLAN GOES SOUTH, COSTS LEXMARK | ZDNet Oracle is making big, bad news today. A CRM project Oracle was handling for Lexmark went so far south that the client will be forced to eat a $15 million price tag. Lexmark would apparently rather suffer the loss than go forward with the remainder of their Oracle contract. [...]
14756 99 54_DB2 UDB on NT - Control Center Probs - thanks for now!16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Sat, 12 Oct 2002 17:55:50 +0200457_us-ascii Hello list,
just a quick note to thank the people who so kindly tried to help me with my waking nightmare ;-)
Thanks a lot to Marcus, Abhijit, Tim, Myron, and Bruno for all your input and I'm afraid you might be on my list of helpers :-D
I have done all my tasks and I am safely out of Switzerland (let's hope nothing nasty happens) and I think all in all I'll stick with the mainframe where I am not so totally ignorant. [...]
14856 96 14_List of lists?16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Sat, 12 Oct 2002 19:35:12 +0200422_us-ascii Hello there,
for quite a while I had been using my "List of Lists" at http://www.knutson.org/internet.htm as a reference point without too many bookmarks. It now seems to be dead, but maybe it's just moved!
Any ideas where I could find it nowadays? Please note that I already have another link to http://www.nauticom.net/www/softwise/mfdisc.htm - but I should like to know about the first one! [...]
14953 68 30_Re: Replacement for DB Attach?16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Sun, 13 Oct 2002 00:25:53 +0200420_- Gary,
we use CAF for some years and switch to RRSAF last year. I haven't seen this behaviour for CAF nor RRSAF.
All the application programs are compiled without any specific precompile option for CAF/TSO or whatever. Just the binder include is changed from DSNALI to DSNRLI. This means the application itself can't run without an interface to do the connect or whatever is needed to open a thread. [...]
15022 44 32_Re: dynamic caching in Version 716_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Sun, 13 Oct 2002 00:36:48 +0200660_iso-8859-1 Joseph,
the dynamic cache doesn't require so much, so why would you like to turn it off for some applicationsß
Roland
> -----Original Message----- > From: Joseph T. Murray Jr. [SMTP:joe.murray@SSA.GOV] > Sent: Friday, October 11, 2002 5:35 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: dynamic caching in Version 7 > > I am trying to turn on dynamic caching in DB2 version 7 for a particular > application. I do not want the entire subsystem to use dynamic caching, > just a handful of plans/packages. > > Does anyone have any info on how this is accomplished? > > ================================================ [...]
15067 118 22_Re: db2 connect issues10_John Lantz23_john.lantz@ZURICHNA.COM31_Sat, 12 Oct 2002 19:37:47 -0500531_- Some answers to your questions... We are at V7 on the mainframe... We are using DB2 Connect EE, We see the same thing in two different gateways though. One is a server just running DB2 Connect EE. The other gateway actually runs a local UDB database as well. They hang out there as well. On the mainframe we hae the thread set to go inactive. We also have tried playing around with leaving them active and letting them timeout after 5 minutes. If we do this, then we do see them go away after 5 minutes. So we are wondering [...]
15186 65 18_Re: List of lists?11_Mark Ediger22_MEDIGER@TRANSUNION.COM31_Sun, 13 Oct 2002 03:48:54 -0500477_US-ASCII Hi Aurora, You are right. That link is no longer valid but Sam's home page link is still there. Instead of the old one, try this one: http://www.cbttape.org/links.phtml
Mark Ediger
>>> Aurora_E_DellAnno@CANDLE.COM 10/12/02 12:35PM >>> Hello there,
for quite a while I had been using my "List of Lists" at http://www.knutson.org/internet.htm as a reference point without too many bookmarks. It now seems to be dead, but maybe it's just moved! [...]
15252 44 57_Re: Has anyone had success interfacing with XML via Rexx?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 13 Oct 2002 23:58:12 +1000492_US-ASCII Frank Lindenblatt posted a link to some REXX-XML code: "At http://www.geocities.com/flrx67/files/ there are two files:
xml.zip and xml.txt (this is in tso xmit format, but geocities does'nt all= ow .xmit !!!)
Both files contain a small $readme with some infos. At this time, the documentation is very small (not to say there is nothing= )... But I'm on the way to complete it, and when it's ready and you still find the tools usefull, I'll put it to the CBT tape. [...]
15297 44 45_Re: Stored Procedure Overloading on OS390 DB214_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 13 Oct 2002 23:58:13 +1000482_US-ASCII Joe,
I'm not sure what has given you the idea that you can overload stored procedures but, as several have said, you can't.
The thing that (at least in the current versions of DB2) stops you overloading is that DB2 uses the SPECIFICNAME to distinguish between overloaded routines. For UDFs DB2 will happily create a unique SPECIFICNAME for each overloading; for procedures it uses the procedure name as the SPECIFICNAME - hence sps are not overloadable. [...]