1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2003, week 5
2 28 37_access db2 os/390 from control center9_jane mike18_ibm390@HOTMAIL.COM31_Fri, 29 Aug 2003 04:51:37 +0000556_- hi list,
I have installed DB2 enterprise server V 8.1 fix pack 1 in my win 2000 (SP4) machine. I have added my mainframe database ( DB2 UDB 6.1 on os/390 v2r9) using the configuration assistant. I am able to connect to mainframe database through the command center. When i try to expand the subsystem name of my mainframe database from the control center i dont get any db2 resources list (which i used to get when i was running db2 7.1 in my windows 2000). I have done a bind for the mainframe database for the following utilities: cli/odbc [...]
31 40 20_XML & DB2 for OS/39012_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 29 Aug 2003 09:31:20 +0200376_windows-1251 Good morning, collegues.
We have the need to store XML documents in DB2 for OS/390 V6 databases.
And we have to deal with this structured documents in our COBOL-based applications.
Has anyone done this successfully ? If so please share your experience with us.
Thanks in advance for any information you are willing to pass along. [...]
72 26 21_freeing invalid plans18_Barth, Steve (IHG)29_Steve.Barth@ICHOTELSGROUP.COM31_Fri, 29 Aug 2003 10:20:28 -0400302_iso-8859-1 It's pretty slow around here today so I thought I'd free some plans just to liven up the day. I've run rebinds on any plans marked valid = 'N' or operative = 'N'. Some of these rebinds were successful, some were left in the same condition, and some are valid = 'N' but operative = 'Y'. [...]
99 50 57_Candle (Omegamon / Z/OS / DB2 7.1) Reports Customizatoion11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Fri, 29 Aug 2003 09:53:08 -0500403_iso-8859-1 Hi All,
First a little about our environment we have two mainframe boxes, one is OLTP & another is Warehouse. We have these traces turned on
STAT 01,03,04,05 ACCTG 01,02,03
We load the SMF data into Omegamon Tables everyday and summarized it by Hr after that. We load replace detail Data everyday and make the Hourly summarized tables as the source for the Reports. [...]
150 43 29_DBADM authorities on views...14_Shankar Mridha31_shankar.mridha@SOMERFIELD.CO.UK31_Fri, 29 Aug 2003 18:25:44 +0100368_iso-8859-1 Hi all,
I am facing a strange problem. My user id has been given DBADM authority by the SYSADM. But still I can't create views and also cant do any select/update/delete functiontions using the views in the database on which I got the DBADM access. I can use these functions only when my ID is given explicit access for select/update and delete. [...]
194 16 6_NOMAIL13_Hougrand, Rob21_HougrandRW1@AETNA.COM31_Fri, 29 Aug 2003 12:56:48 -0400486_us-ascii
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna
===============================================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.
211 84 33_Re: DB2 stored procedure question9_Dan Lamas22_dlamas@DUKE-ENERGY.COM31_Fri, 29 Aug 2003 12:49:56 -0500538_us-ascii Tina,
Have been trying to do this same thing. DB2 lets me create the column but it only stores 255 chars then truncates the rest of the data. Do you have any suggestions?
We are on DB2 v710 / os/390
Thanks,
Dan Lamas DBA - Duke Energy Gas Transmission 713.627.4261
Tina Hilton cc: Sent by: DB2 Data Subject: Re: DB2 stored procedure question Base Discussion List [...]
296 13 19_Release of v8 / zos0_25_Susan.Birgeles@ALLTEL.COM31_Fri, 29 Aug 2003 14:43:34 -0400332_iso-8859-1 Has anyone heard anything recent about the release date for v8 ZOS?
===============================================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.
310 198 27_SQL Performance help needed11_Linda Ayeni22_lindaayeni@HOTMAIL.COM31_Fri, 29 Aug 2003 15:26:29 -0700321_- Hi Listers, I am experiencing a performance problem with the following dynamic SQL. It is taking about 5 minutes in response time and sometimes it "dies" on you completely. I would appreciate some suggestion on what I can do to speed up the response time: The SQL, Indexes, column card and EXPLAIN report follows: [...]