1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2000, week 4
2 96 24_Re: Access path question10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Mon, 22 May 2000 07:57:08 GMT812_us-ascii Hi Sanjay, I am sorry for writing my previous mail in hurry and the queries i wrote was wrong. I am repeating those two queries and would like to get the response from you if this is a successful attempt .
Select R.PORTFOLIO_CD, R.PORTFOLIO_DSC, D.AS_OF_DT, sum(CASE WHEN D.DTD_GROSS_PL_AMT > 0.0 THEN DECIMAL(D.DTD_GROSS_PL_AMT + .5,15,0) ELSE DECIMAL(D.DTD_GROSS_PL_AMT - .5,15,0)END ) GrossPnl, sum(CASE WHEN D.DTD_GROSS_CRDT_AMT > 0.0 THEN DECIMAL(D.DTD_GROSS_CRDT_AMT + .5,15,0) ELSE DECIMAL(D.DTD_GROSS_CRDT_AMT - .5,15,0)END ) GrCrd, sum(CASE WHEN D.DTD_SALES_PAY_AMT > 0.0 THEN DECIMAL(D.DTD_SALES_PAY_AMT + .5,15,0) ELSE DECIMAL(D.DTD_SALES_PAY_AMT - .5,15,0)END) SalesPay, sum(CASE WHEN D.DTD_NET_PL_AMT > 0.0 THEN DECIMAL(D.DTD_NET_PL_AMT + .5,15,0) ELSE DECIMAL(D.DTD_NET_PL_AMT [...]
99 55 21_Re: Big DB2 V7 change13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 22 May 2000 10:16:00 +0100386_us-ascii The only thing I'm surprised about is that it's taken so long. For a long time IBM have had a big thing about users spending more on 3rd party utilities than they do on DB2, understandably so in my opinion. If their utilities are to be best of breed then they need the revenue for product development. It will be interesting to see how this affects the base price of DB2. [...]
155 19 34_DB2 Extender Programming with Java10_Reza Guity15_rgiti@YAHOO.COM31_Mon, 22 May 2000 04:10:23 -0500373_- Hello Everybody,
I want to write some java applets to perform image QBIC queries. My images are stored in a DB2 UDB 6.1 in Windows 2000 platform. I also have the DB2 extenders product, and I have consulted its documents. They only mention programming in C language. Where can I find resources (documents and java packages) for DB2 image extender programming? [...]
175 20 52_UDB Version 6 for OS/390, refresh tape and PUT level12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Mon, 22 May 2000 06:18:18 -0500506_iso-8859-1 My understanding is that the refresh tape coming out later this summer will have the same maintenance as Put0003, is that still true? When will the refresh tape be available?
The refresh tape is designed for the shops that do not have UDB version 6 installed, but if you have version 6 installed (say on your Tech system) you don't have to wait for the refresh tape - just be on maintenance level Put0003 before you migrate your test and production systems, is this assumption true? [...]
196 43 21_Re: Big DB2 V7 change10_Robert Ord21_robertord@HOTMAIL.COM29_Mon, 22 May 2000 11:22:33 GMT637_- What a shame ! As a relatively small shop we have always used IBM utilities. Another point to Oracle in the eyes of management. Just when things seemed to be going DB2's way for a change.
Rob
>From: "Burch, Todd" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Big DB2 V7 change >Date: Fri, 19 May 2000 16:22:05 -0500 > >For those that may have missed it, IBM annouced at IDUG on Monday that the >utilities for DB2 V7 for OS/390 would be a separate charge-for feature and >that there would be no "common utility" support delivered [...]
240 74 15_UDB->DB2 OS/39014_Popy A. Dimoka24_dimokap@INTERAMERICAN.GR31_Mon, 22 May 2000 15:29:49 +0300439_iso-8859-7 HELLO LIST!
WE ARE GOING TO MOVE AN APPLICATION FROM DB2 UDB FOR NT VER 6 TO THE MAINFRAME-DB2 FOR OS/390 VER 5.I HAVE GENERATED A FILE WITH ALL THE DEFINITIONS FOR TABLES,INDEXES AND VIEWS AND I HAVE TO CONVERT THAT FILE INTO SQL PROPER FOR DB2 FOR OS390.THERE ARE A LOT OF DIFFERENCES AND MAYBE THE MAIN DIFFICULTY IS THAT I HAVE TO CREATE NEW TABLESPACES,ONE PER TABLE. ANY IDEAS ON HOW TO AUTOMATE THIS PROCESS? [...]
315 52 18_Re: ddf won't stop12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 22 May 2000 05:36:42 -0700333_us-ascii My client had this problem for a while. They ended up canceling the IRLM to take DB2 down as an interim fix. This allowed DB2 to be restarted without IPLing.
However, after a number of PTFs were applied to DB2, the problem went away. I can't give the PTF numbers as it was part of a large amount of maintenance. [...]
368 71 19_Re: Sort pool usage19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 22 May 2000 07:37:43 -0500318_ISO-8859-1 Steve, as Joel already noted, this could be the perfect example of "helter skelter" ad hoc queries! Have you tried using DSNRLST? This might be a rather oblique way of getting better performing SQL done. It could also be that the SQL is fairly efficient and you are just going to have to up all sizes. [...]
440 28 18_Re: ddf won't stop11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Mon, 22 May 2000 07:52:46 -0500404_- Elmer,
You wrote "We usually stop then restart DDF when users get some problems connecting to DB2 thru DDF. Recently we've had several occassions when a -stop ddf command nor a -stop ddf mode(force) cannot bring DDF down."
When I have trouble bringing down DDF with DB2 commands, my next step is to vary inactive the luname of that distributed data facility: V NET,ID=luname,INACT,F [...]
469 64 18_Re: ddf won't stop19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 22 May 2000 08:22:25 -0500304_ISO-8859-1 Hi John, Please explain. I interpreted Elmers problem thusly: He was trying to stop and start DDF because DDF was no longer handling any new users and a stop force of DDF wouldn't work. I've never tried this; are you saying that varying the DDF luname inact will allow/force DDF to stop? [...]
534 46 21_Re: Consistency Token22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 22 May 2000 10:35:19 -0400657_- Make sure you do a CICS CEMT S PROG() NEWCOPY of the load module after it's re-link edited.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: Anli Chao[SMTP:anlichao@MS14.HINET.NET] > Sent: Monday, May 22, 2000 5:11 AM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Consistency Token > > Does anyone know how to interpret consistency token in DBRM or > in SYSIBM.SYSPACKAGE? > > We are running DB2 V6. DBRMs have been included into different > packages. > We would like to compare the time stamp in the load module with the > consistency > token in the package when SQL [...]
581 21 43_How to use the system date in an SQL Query?10_H C Diment17_hannahd@TBC.CO.UK31_Mon, 22 May 2000 09:14:55 -0500294_- Hello,
I am trying to create a view that uses the system date as one of its parameters e.g;
create view V_EDITIONS as select * from EDITIONS where START_DTE < date() and END_DTE > date()
I know that this will not work, but I am unsure as to how to code it properly. [...]
603 34 21_Re: Big DB2 V7 change17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Mon, 22 May 2000 09:38:50 -0500423_us-ascii Not good. This does not help when it is becoming increasingly difficult to justify OS/390 as a DB2 platform. So many packages are not written for OS/390 as it is (CRM, for instance). The cost benefit may be with OS/390 but when costs rise - as they more than likely will when paying for utilities separately - the cost gap quickly narrows and the words re-platform and Oracle will be heard far more often ... [...]
638 62 21_Re: Big DB2 V7 change19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Mon, 22 May 2000 16:46:38 +0200630_iso-8859-1 Is this something IBM are forced into as a result of anti trust laws, re Microsoft. Or is it that IBM want to make more money?
Regards Neil
-----Original Message----- From: Gerald Bustamente [mailto:ggbusta@LANDSEND.COM] Sent: Monday, May 22, 2000 4:39 PM To: DB2-L@RYCI.COM Subject: Re: Big DB2 V7 change
Not good. This does not help when it is becoming increasingly difficult to justify OS/390 as a DB2 platform. So many packages are not written for OS/390 as it is (CRM, for instance). The cost benefit may be with OS/390 but when costs rise - as they more than likely will [...]
701 68 21_Re: Consistency Token22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 22 May 2000 10:47:58 -0400668_- I should have been more clear. Do the NEWCOPY after the link edit and the bind are complete.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: Piontkowski Michael ML > Sent: Monday, May 22, 2000 10:35 AM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Consistency Token > > Make sure you do a CICS > CEMT S PROG() NEWCOPY > of the load module after it's re-link edited. > > > Mike Piontkowski > Voice/Fax: 302.886.4612 > mailto:michael.piontkowski@astrazeneca.com > > > ---------- > > From: Anli Chao[SMTP:anlichao@MS14.HINET.NET] > > Sent: Monday, May 22, 2000 5:11 AM > > To: [...]
770 32 21_Re: Consistency Token12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 22 May 2000 10:06:00 -0400616_- There is a lot of info on this in the DB2-L archives. http://jupiter.ryci.com/archives/db2-l.html
>>> DB2-L@RYCI.COM@inter2 05/21/00 10:03AM >>> Does anyone know how to interpret consistency token in DBRM or in SYSIBM.SYSPACKAGE?
We are running DB2 V6. DBRMs have been included into different packages. We would like to compare the time stamp in the load module with the consistency token in the package when SQL code -805 occurs. It is a CICS transaction, and the DBA claimed a BIND has performed after the load module was link edited. By the way, -805 has become a frequent issue in our site. [...]
803 78 19_Re: UDB->DB2 OS/39012_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Mon, 22 May 2000 16:10:00 +0100335_- My initial approach would be to start with one tablespace with everything in it and split things out over time. If you have BMC or Platinum tools they will size tablespaces for you as you split them. Split out everything you want to compress, isolate in a bufferpool, or partition first, then pick the rest off as time goes on. [...]
882 119 22_Re: Distributed Binds?0_18_damcon2@US.IBM.COM31_Mon, 22 May 2000 11:14:58 -0400552_us-ascii Manas,
This is in line with what I was thinking.
Thanks, Jay
Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW -----------------------------------------------------
Manas Dasgupta @RYCI.COM> on 05/19/2000 05:20:16 PM
Please respond to DB2 Data Base Discussion List [...]
1002 15 18_Re: ddf won't stop11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Mon, 22 May 2000 10:10:05 -0500328_- Rick,
The Admin guide (pg4-75,76) describes this method.
Regards, John
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1018 69 21_Re: Big DB2 V7 change13_OConner, John26_John.OConner@COURTS.WA.GOV31_Mon, 22 May 2000 08:26:08 -0700618_iso-8859-1 I think it would be irresponsible for a database vendor to sell their product without including any mechanism for backup/recovery, repair, or loads (for populating a potentially new database with large amounts of existing data). A database product is incomplete without these capabilities.
Like many shops, we use third party tools. We migrated to v6.1 before our tools vendor had exploitive tools. I guess that in the future we probably want to wait for the vendor tools to be exploitive before migrating to the next release. This could delay IBM's revenues by 6 to 12 months in our case. This [...]
1088 149 22_Re: Distributed Binds?0_18_damcon2@US.IBM.COM31_Mon, 22 May 2000 11:41:51 -0400571_us-ascii James,
Thank you for your response. However, I do have a question... With the scenario you have below, doesn't it force an implicit type 1 connection? According to the Command Reference under bind options for currentserver, even if there are explicit connects in the program recompiled with the default type 2 connect they are looked at as type 1. I should have clearer in my original note that this program will need to access multiple locations in one unit of work. This does, however, give another option for a situation without that requirement. [...]
1238 138 22_Re: Distributed Binds?18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Mon, 22 May 2000 11:40:11 -0400264_iso-8859-1 Jay, Keep in mind that the PLAN is bound on the local DB2 ss; PACKAGES are bound on the remote DB2 ss where the data is and where the SQL is actually run. You don't need to bind the packages on the local DB2 unless the programs run there too. Pete [...]
1377 88 32_Re: HSM migrating data to level212_Kirk Hampton16_khampto1@TXU.COM31_Mon, 22 May 2000 10:54:13 -0500612_us-ascii Hi all, Just catching up with this thread after being away attending IDUG. I hate to have to disagree with Max, because I generally agree whole-heartedly with him. We have ALL of our DB2 objects, except for the catalog, directory, bootstraps, and logs, under SMS management and eligible for HSM migration after 120 days of non-activity. To my knowledge, we have never suffered any data loss or problems with datasets that have been recalled. And although the catalogs are not SMS-managed, I have performed an HSM migrate/recall on those datasets after a catalog reorg to reduce the extents, and it [...]
1466 126 21_Re: Big DB2 V7 change0_29_STANLEY_GOODWIN@MECH.DISA.MIL31_Mon, 22 May 2000 12:10:13 -0400484_us-ascii OK, I think we have hashed over the issue of 'IBM charging for IBM utilities' with the advent of V7.1. I think it is time we stop ? and get in the boat and row, After all we wouldn't all be using this forum if we didn't think DB2 was not the best DBMS system on the market. And we complain that IBM is lees then open with vendors, Give me a break guys this is a free enterprise market, If IBM doesn't want to they don't have to tell anyone didley on anything about DB2. [...]
1593 161 22_Re: Distributed Binds?15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 22 May 2000 12:15:22 -0400491_iso-8859-1 When I execute a distribute package, I see a DESCRIBE statement executed corresponding to each select statement. Why this is executed in the remote location, even though I bound the SQL in the remote locations?
Thanks Sibimon Philip 972-813-5517 - Office
-----Original Message----- From: Bourgoine, Peter A [mailto:Peter.A.Bourgoine@JPFINANCIAL.COM] Sent: Monday, May 22, 2000 10:40 AM To: DB2-L@RYCI.COM Subject: Re: Distributed Binds? [...]
1755 44 18_Re: ddf won't stop19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 22 May 2000 10:43:00 -0500589_ISO-8859-1 John, Very good . . . Thanks Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
1800 62 16_Re: DRDA package13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 22 May 2000 12:09:15 -0500575_US-ASCII Hello Sibimon, I believe you have to use EXEC SQL DESCRIBE CURSOR to get the column names. HTH Kurt
>>> SPhilip@CSXLINES.COM 05/21/00 04:04PM >>> To all the list members,
We are trying to use DRDA to select and update DB2 tables in mainframe from Windows NT. OS version is 2.6 and DB2 version is 5.01. We used Grandvu's product to create a static package in DB2 from Windows NT. But when we execute this package, we are getting the column name in output as COL1, COL2...etc. Does anybody know how to get the actual column name from the static SQL [...]
1863 201 22_Re: Distributed Binds?0_18_damcon2@US.IBM.COM31_Mon, 22 May 2000 13:57:38 -0400467_us-ascii Are you using three part names? If you are V5 or earlier this will use private protocol which incurs a bind each time a remote SQL call is made.
Jay
Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW ----------------------------------------------------- [...]
2065 223 22_Re: Distributed Binds?15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 22 May 2000 15:43:28 -0400443_iso-8859-1 I did not use 3 part name. I used a connect inside the program. We are using DB2 Version 5.1 on OS/390 Version 2.6. I think it is using private protocol, but it was not binding the SQL.
Thanks Sibimon Philip 972-813-5517 - Office
-----Original Message----- From: damcon2@US.IBM.COM [mailto:damcon2@US.IBM.COM] Sent: Monday, May 22, 2000 12:58 PM To: DB2-L@RYCI.COM Subject: Re: Distributed Binds? [...]
2289 19 54_Database modelling products - evaluation criteria list14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Mon, 22 May 2000 16:11:38 -0400322_iso-8859-1 Hi everybody We are now in the process of evaluating database modeling products such as CA-Platinum Erwin and Embarcadero ER/Studio. Had any of you done such an evaluation? Could you share with us the criteria list you have used? Thank you very much Ze'ev Atlas TACT - The A Consuting Team zatlas@tact.com [...]
2309 105 21_Re: Big DB2 V7 change14_Steve Domarski26_sdom@PROPAPPR.MARION.FL.US31_Mon, 22 May 2000 16:35:39 -0400528_- Basically, Think about it. Your an OEM vendor. You have to build a better mouse trap so your customers will by your product in spite of the fact that the base product utilities work just as well. So as a vendor you say to the product manufacture look, if you make these parts of your product optional then I'll have a market to sell my wares competitively. That way I'll get a piece of the business, else, I and most vendors like me will not have any reason to support your product. So the question is will IBM offer the [...]
2415 21 21_Re: Big DB2 V7 change26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Mon, 22 May 2000 16:14:24 -0500513_- Yep, they(IBM) even tried it with HSM when it first came out. "Here use it, works great, don't need utilities." Well, stuff happens, bulldozers run thru power lines, lightening hits UPS's, and data gets corrupted. Who you gonna call? I'd think the support teams would be up in arms. DB/2 works really good most of the time, but when it breaks or is sabataged everybody needs to be on the same page. What would Spock say? "Illogical." Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...]
2437 24 43_Migration from DB2 on MVS to UDB on Solaris18_Seetharaman, Sudha17_SSeethar@VISA.COM31_Mon, 22 May 2000 14:29:19 -0700551_iso-8859-1 Hi,
I am looking at ways to migrate table schema from Db2 on MVS to DB2 on Solaris. Could some one help me with the various import/export options available in DB2 on MVS. I tried exporting data to IXF format and tried importing to UDB but since the character set id EBCDIC in Mainframes and ascii in unix I could not do that. Could someone throw more light on the various options available for this or could someone point me to sites where I can get more information on this. I have gone through the documents in IBM's site but [...]
2462 55 34_Re: WLM Stored procedures DSNTPSMP9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 22 May 2000 17:03:44 -0500402_- It looks like your TSO commands are not installed in the linklist. You will either need to allocate the PDS containing TSO commands to the Stored procedure STEPLIB or get your MVS systems programmer to include them in the linklist.
Regards,
Jim Ruddy IBM DB2 for OS/390 Development
On Mon, 15 May 2000 15:25:46 CEST, Michael Arlebrandt wrote: [...]
2518 35 47_Re: How to use the system date in an SQL Query?10_David Cohn19_dcohn@ATTGLOBAL.NET31_Mon, 22 May 2000 15:37:54 -0700559_us-ascii Hi H.C., use: SELECT * FROM X WHERE CURRENT_DATE BETWEEN START_DATE AND END_DATE; Remember that between is inclusive. hope this helps, Dave
H C Diment wrote:
> Hello, > > I am trying to create a view that uses the system date as one of its > parameters e.g; > > create view V_EDITIONS as select * from EDITIONS where START_DTE < date() > and END_DTE > date() > > I know that this will not work, but I am unsure as to how to code it > properly. > > Many thanks. > > ================================================ > To change your [...]
2554 89 33_Re: SYSLGRNX records left by DROP16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Mon, 22 May 2000 15:52:15 -0700468_iso-8859-1 The point is: based on the discussion in this news group, and the fact that fixes had been requested for it, it appears that customers consider it a bug. Saying that it's working as designed doesn't make that go away. If an APAR was issued back in v3, and the customers still appear to want it, whether it's called a fix, upgrade, enhancement, or whatever, maybe it should be changed, unless there's a need to keep it the way it is (hence the "why?"). [...]
2644 62 54_Re: Getting Data for Test environment from Production.11_Kwan, James18_James_Kwan@BMC.COM31_Mon, 22 May 2000 16:40:38 -0500538_ISO-8859-1 Linda,
Here are some methods you might want to consider.
1) Using Unload and load with where clause to select a subset of the data. It is simple and can be easily done. However if you have a lot of tables, it might takes a while to write all the jcl. 2) Using dsn1copy to copy with obid translation. You can use image copy from the production so it will not impact your production system. You have to know all old and new object ids and it will only give you the whole data. 3) Using a third party migration [...]
2707 43 17_Consistency Token0_16_JJaiwant@AOL.COM29_Mon, 22 May 2000 22:25:45 EDT346_US-ASCII Anli,
The consistency token can be viewed as a 16 byte HEX string in the DBRM and also in the CONTOKEN column in SYSIBM.SYSPACKAGE. You can get this information using the query suggested by Deepak, which is given below:
SELECT NAME, HEX(CONTOKEN), FROM SYSIBM.SYSPACKAGE WHERE COLLID = ''collid" AND NAME = '"pkgname" [...]
2751 50 32_Double Byte Character Set (DBCS)11_John Matear27_John.Matear@BANKWEST.COM.AU31_Tue, 23 May 2000 13:15:49 +0800580_us-ascii I'm hoping that somebody on the List can give me some advice regarding DBCS.
The company I work for are looking at the Asia Pacific market. Being able to support DBCS would be a requirement.
Does anybody on the list have any first hand experience of using/supporting DBCS? Is it possible to have one subsystem that can handle both SBCS and DBCS? Can you only try out DBCS by first changing to MIXED DATA YES in DSNHDECP? What are the unpleasant (if any) ramifications of doing this? What sort of system changes (if any) may be required to, for example [...]
2802 81 15_UDB->DB2 OS/39014_Popy A. Dimoka24_dimokap@INTERAMERICAN.GR31_Tue, 23 May 2000 08:54:35 +0300511_iso-8859-7 Sorry if this is a repost..... ---------------------------------------- HELLO LIST!
WE ARE GOING TO MOVE AN APPLICATION FROM DB2 UDB VER 6 FOR NT TO THE MAINFRAME-DB2 FOR OS/390 VER 5.I HAVE GENERATED A FILE WITH ALL THE DEFINITIONS FOR TABLES,INDEXES AND VIEWS AND I HAVE TO CONVERT THAT FILE INTO SQL PROPER FOR DB2 FOR OS390.THERE ARE A LOT OF DIFFERENCES AND MAYBE THE MAIN DIFFICULTY IS THAT I HAVE TO CREATE NEW TABLESPACES,ONE PER TABLE. ANY IDEAS ON HOW TO AUTOMATE THIS PROCESS? [...]
2884 56 21_Re: Big DB2 V7 change14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 23 May 2000 09:47:13 +0200440_iso-8859-1 My first thought was %&$£-integro-differential-pig*^## etc etc.
My second thought was: ok, IBM wants to play in tools arena.
May be useful a competition between IBM and other vendors, expecially if IBM prices
will be lower with a good quality AND/OR DB2 will cost lesser (I hope, as you haven't an
important part of the product; why I have to pay a car without some accessories as a car with all [...]
2941 15 21_Re: Big DB2 V7 change14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 23 May 2000 09:56:21 +0200354_us-ascii And someone is wondering why many customers are migrating to UNIX/ORACLE.....
Regards Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
2957 46 21_Re: Big DB2 V7 change19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Tue, 23 May 2000 10:13:54 +0200484_iso-8859-1 The bottom line for us, is that we will be delaying and move to a new version of DB2. As it would be difficult to justify the additional cost to the business.
Does this mean that DB2 V7 is not downwardly compatible with previous versions because the basic utilities won't work. Or are we discussing new utilities that will shipped with DB2 V7. So you will get the current utilities but the new fangled dangled utilities are not shipped unless you pay for them? [...]
3004 28 12_SQLCODE +10114_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Tue, 23 May 2000 10:28:36 +0100109_us-ascii Hi everyone,
has anyone ever experienced the sqlcode +101 ?
TIA Ruediger Kurtz
3033 131 11_Remote Bind15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM31_Tue, 23 May 2000 18:28:56 +1000600_iso-8859-1 The recent thread on Distributed Binds prompts me to ask if there is any way to achieve a remote Bind.
Our Client/Server Application ( C++ / OS 390 DB2 V5.1, DRDA ) runs on a Development LPAR and a remote Production LPAR. Our gateway server is DB2 Connect.
In Development we BIND the DB2 packages once and subsequently progress them through the development/test phases using BINDCOPY. It would be very handy if we could use something similar to migrate tested packages to the remote Production subsystem, but this doesn't seem possible from the manuals - is this right? [...]
3165 57 32_Re: HSM migrating data to level214_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 23 May 2000 10:53:48 +0200351_us-ascii Hi Kirk, of course your opinions are welcome. Sorry for delayed response, I was out of office.
I debated with many collegues if HSM have to manage DB2 datasets in a production
environment, and it's the first time I hear this.
In previous shop where I worked, in a test environment, we had several problems recalling [...]
3223 41 16_Re: SQLCODE +10117_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Tue, 23 May 2000 14:16:07 +0530349_- Can u give the SQLSTATE??? Are u sure it is +101??
VIJAY
-----Original Message----- From: Ruediger Kurtz [SMTP:ruediger.kurtz@HUK-COBURG.DE] Sent: Tuesday, May 23, 2000 2:59 PM To: DB2-L@RYCI.COM Subject: SQLCODE +101
Hi everyone,
has anyone ever experienced the sqlcode +101 ?
TIA Ruediger Kurtz
3265 72 16_Re: SQLCODE +10110_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 23 May 2000 09:06:07 GMT437_us-ascii Yes, i am also not sure if it is +101.I have not found anything documented till DB2 V6 for OS/390 and UDB V5.1 for NT.So , i would like to ask the platforms and if it is really +101 in DB2 for OS/390
Regards
Sanjeev
Vijay Subramanyam @RYCI.COM> on 05/23/2000 03:16:07 PM
Please respond to DB2 Data Base Discussion List [...]
3338 74 16_AW: SQLCODE +10112_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 23 May 2000 11:01:03 +0200483_iso-8859-1 Any positive SQLCODE value (forget +100) indicates that the SQL statement completed, but with a warning. Warnings might require subsequent attention, or they may be inconsequential.....
HTH.
By the way: Did you receive a SQLSTATE value also ? If so please check the first two-character class code and the three-character subclass code. The first value indicates the type of error and the subclass code details the explicit error within that error type. [...]
3413 101 16_Re: SQLCODE +10114_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Tue, 23 May 2000 11:42:44 +0100341_us-ascii Well .... what I have to offer is:
We're on DB2 for OS/390, Version 5 (not sure about the ptf-level), and yes, I'm positive it's a +101. I couldn't find anything in the documentation either.
I didn't get the strange sqlcode myself, it came to me via a hard-copy from a colleague. What it says in the hardcopy is: [...]
3515 51 16_Re: SQLCODE +10110_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 23 May 2000 10:42:59 GMT615_UTF-8
Hi , The DSNT413I message says that : ----> DSNT413I SQLCODE = xxxx, INVALID SQLCODE Explanation: The SQL return code is not a valid value. This message is issued by the following CSECT: DSNTIAR System Programmer Response: Either the SQLCA area is invalid or the maintenance was not coordinated correctly. As a result, the SQL return code was added to the DB2 subsystem but not to the formatting routine. An invalid SQLCA area is usually the result of one of the following: Calling the DSNTIAR formatting routine before an SQL statement initializes the area Overlaying the SQLCA area Passing the [...]
3567 93 16_Re: SQLCODE +10114_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Tue, 23 May 2000 13:09:36 +0100585_us-ascii Sanjeev,
thanks a lot for your help, I passed the information on to the people who wrote the program; let's see what they do about it.
Once again, thank you
Ruediger
Sanjeev .. schrieb: > > Hi , > The DSNT413I message says that : > ----> > DSNT413I SQLCODE = xxxx, INVALID SQLCODE > Explanation: The SQL return code is not a valid value. > This message is issued by the following CSECT: DSNTIAR > System Programmer Response: Either the SQLCA area is invalid or the maintenance was not coordinated > correctly. As a result, the SQL return code [...]
3661 19 13_Oracle to DB212_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Tue, 23 May 2000 11:27:00 +0100529_- We are actually thinking of moving in the right direction for once, anyone know of any documentation of the differences and/or a migration guide?
Colin Allen Abbey National
Any views expressed are strictly personal, especially the one about moving in the right direction.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
3681 47 48_Badly performing asynchronous i/o - DB2 os390 v49_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Tue, 23 May 2000 12:38:57 +0100374_iso-8859-1 I have a frequently sequentially accessed table. When I look on TMON (my monitor) it shows an async i/o count of 642349 and an async i/o page count as 288135. Also looking at a buffer pool list stats for this table summed over a number of online days it shows an async i/o count of 516004 and an async i/o page count as 896550, which is a page rate of 1.74. [...]
3729 45 43_DL1 and DB2 and dynamic call, sqlcode -927!15_Bodingh, Anders22_anders.bodingh@EDS.COM31_Tue, 23 May 2000 13:10:48 +0100548_iso-8859-1 Hello!
I try to explain the case.
A simple batch-program makes call to 4 subroutines - 1 with DL1 and because of that the main program must be compiled as DL1-program. - 1 with DB2 linked with DSNELI - 1 with DB2 linked with DSNELI and 1 new call to another DB2 linked with DSNELI. - 1 with only makes call to 4 other subroutines with DB2 linked with DSNELI. When we have static calls there is no problem but when we change to dynamic calls it allways result in -927 somwhere. We have tried to change DSNELI to DSNHLI [...]
3775 47 17_Re: Oracle to DB223_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 May 2000 13:15:08 +0100427_iso-8859-1 Colin I thought that there was an IBM Redbook on this?
regards Leslie
-----Original Message----- From: Allen, Colin [mailto:Colin.Allen@ABBEYNATIONAL.CO.UK] Sent: Tuesday, May 23, 2000 11:27 AM To: DB2-L@RYCI.COM Subject: Oracle to DB2
We are actually thinking of moving in the right direction for once, anyone know of any documentation of the differences and/or a migration guide? [...]
3823 23 17_Re: Oracle to DB214_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 23 May 2000 14:28:21 +0200480_us-ascii Try this link
http://www-4.ibm.com/software/data/db2/migration/
It's an IBM home page about migration from some RDBMS to DB2. It may be useful...:-)))
HTH Regards
Max Scarpa 'ghost' Data & System Admin
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
3847 88 52_Re: Badly performing asynchronous i/o - DB2 os390 v410_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 23 May 2000 12:41:46 GMT523_us-ascii Hi Jim, What i can think from the details given by you is that your sequential I/O is giving about 2 pages per I/O( i think very poor) and for every sequential processing to start one synch I/O is issued for triggering the sequential process.I can make a quick guess , that the table is poorly clustered or the index which is used to access the table most of the time is having poor cluster ratio and list prefetch is not performed most of the time . In this case synch I/O is used for the access to the data [...]
3936 34 17_Re: Oracle to DB29_SrinivasG17_SRINIVASG@INF.COM31_Tue, 23 May 2000 18:24:41 +0530428_iso-8859-1 SG245478 is the Redbook Titled 'Converting from Oracle AIX to DB2 for OS/390'.
-----Original Message----- From: Allen, Colin [mailto:Colin.Allen@ABBEYNATIONAL.CO.UK] Sent: Tuesday, May 23, 2000 3:57 PM To: DB2-L@RYCI.COM Subject: Oracle to DB2
We are actually thinking of moving in the right direction for once, anyone know of any documentation of the differences and/or a migration guide? [...]
3971 18 52_Re: Badly performing asynchronous i/o - DB2 os390 v414_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 23 May 2000 14:57:12 +0200391_us-ascii Hi Jim, just an information: have you many dynamic prefetch ? Can you post a 'snapshot'
of TMON report(s) ?
Regards Max SCarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
3990 30 47_Re: DL1 and DB2 and dynamic call, sqlcode -927!13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 23 May 2000 09:08:06 -0400435_iso-8859-1 Try link-editing the subroutines with the NCAL parameter. This tells the binder(formerly known as link-edit) not to resolve any external references.
You then just need to make sure the DB2 loadlib and other subroutine and interfaces libraries are available at execution time.
How are you running these batch programs? Are they IMS BMPs or DLI(pgm=DFSRRC00)? TSO batch(pgm=ikjeft**)? CAF(pgm=Yourpgmname)? [...]
4021 20 45_DB2 Connect and Windows 2000 min requirement.0_14_dcreed@CSC.COM31_Tue, 23 May 2000 08:08:35 -0500519_us-ascii I am running DB2 Connect V5.2 and CAE V5.2. What minimum software at the server level and at the client level will run on Windows 2000?
Thanks I can only find information for the newer versions.
Any help will be appreciated.
Regards Danny S. Creed
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4042 73 52_Re: Badly performing asynchronous i/o - DB2 os390 v411_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 23 May 2000 09:09:37 -0400524_ISO-8859-1 Jim
The figures you see in BP LSTATS is not an indicator of problems. It shows that the BP is performing quite well. You do not give figures fo the number of prefetch requests, which would really help. Each Prefetch Request is for 32 pages. DB2 checks to see if those pages are already in the BP. Only those pages not in the BP are put on the I/O list. A Prefetch (asynch) I/O is only started if at least one page needs to be read (i.e. is not already in the BP). You are doing Prefetch I/Os, but for [...]
4116 52 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 23 May 2000 08:48:29 -0500662_ISO-8859-1 Hi All, Yet another wrinkle on the subject! My research found this in Redbook SG24-5351, DB2 UDB for OS/390 Version 6 Performance Topics:
5.1.2.5 Performance Considerations The parameter with the most leverage for DB2 restart is LOGLOAD. Even with FLA, this study conclusively illustrates that restart times have a direct linear relationship to LOGLOAD values; the higher the LOGLOAD value, the longer restart takes. Adjusting the LOGLOAD parameter to suit your needs for all types of activity for the DB2 subsystem is not simple. For consistent DB2 restart times following abnormal subsystem termination, LOGLOAD should not be set at too [...]
4169 30 15_SQL Performamce13_Moss, William15_MossW@AETNA.COM31_Tue, 23 May 2000 09:46:28 -0400276_- I have this SQL statement that searches each byte of a 36 byte address field looking for low values, but it uses a lot of cpu time and it's not feasible to use it with a 50 million row table. Is there a more efficient way to do this ? My environment is DB2 V5, OS/390. [...]
4200 102 47_Re: DL1 and DB2 and dynamic call, sqlcode -927!0_19_Tim.Lowe@STPAUL.COM31_Tue, 23 May 2000 08:46:48 -0500557_us-ascii Anders, You said that you "switched to dynamic call", by any chance did you also use the "DYNAM" compiler option? If that is the case: IBM currently does not support the DYNAM compiler option with the CAF DB2 attach (DSNELI), or with the CICS DB2 attach (DSNCLI). There are several ways that you can do this, but it is up to you. In my opinion, the simplest method is to create 2 new libraries, 1 for each of these DB2 attach routines, and to linkedit each attach into the appropriate library with aliases of DSNHLI and DSNHLI2, then add this [...]
4303 69 19_Re: SQL Performamce13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Tue, 23 May 2000 10:15:10 -0400394_us-ascii The following looks really stupid, but I suggest you try it and see if it performs all right:
SELECT * FROM GAHPP00D.CUMB_ENT WHERE CUMB_ADDRLINE1_TXT LIKE "% %" WITH UR;
A ================================+
Where the character between the "%"s is a Hex "00". (I do this in SPUFI by turning HEX ON on the Command line, and overtyping hex zeroes in that byte.) [...]
4373 28 21_Re: Big DB2 V7 change17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Tue, 23 May 2000 09:17:21 -0500681_us-ascii Right on. The issue is not just one of technical superiority of a product. The issue includes, for better or worse, how the business subjectively perceives the value of a specific platform. The technical details are important but not paramount.
Jerry Bustamente
Massimo Scarpa wrote:
> And someone is wondering why many customers are migrating to UNIX/ORACLE..... > > Regards > Max Scarpa > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
4402 172 19_Re: SQL Performance27_Radonjic, Bora (Consultant)23_BRadonjic@ACNIELSEN.COM31_Tue, 23 May 2000 09:28:34 -0500482_- It depends what are you trying to do. If you just want to check for existence and find those x'00' you would be better off unloading Unique_row_id, Cumb_Addrline to a flat file and doing FIND x'00'. If you need it in SQL could you use a program, receive Cumb_Addrline in the host_variable end examine there. If you need it in ad-hock SQL then LIKE '% %' where space between two "%" is low_value. That would be bit more efficient than hex(SUBSTR(...)) for every position. HTH [...]
4575 23 21_Re: Big DB2 V7 change14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 23 May 2000 16:34:08 +0200360_us-ascii I don't know what is the situation in other countries, but in Italy there are crowd of IT managers
who are waiting a minimum excuse to fire DB2 and to migrate to UNIX/ORACLE mainframe-like
using their beloved motto: 'Unix do it better at less cost'. Even if, at the very end, they spend double. But then it's too late to come back. [...]
4599 123 52_Re: Badly performing asynchronous i/o - DB2 os390 v49_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Tue, 23 May 2000 15:48:54 +0100584_iso-8859-1 Thanks to Mike, Max and Sanjeev for responding.
As Mike has explained the low page rate of 1.74 is a good result as a large number of pages requested are already in the buffer pool. Sanjeev; most accesses pass through the clustering index, which has a cluster ratio of 100%.
The remaining query is the TMON output; Mike asked for prefetch counts and Max and Sanjeev questioned the prefetch type counts (i.e. seq, dynamic or list). The only way I can see of obtaining this information is to place the dataset into its own bufferpool, which I will do over [...]
4723 115 8_MRL Rexx23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 May 2000 15:46:13 +0100374_iso-8859-1 /* REXX --------------------------------------------------------------*/ Trace O /* Trace initially off */ yes = 1 no = 0 "EXECIO * DISKR SYSOUT(STEM data. FINIS" j = data.0 if j > 2000 then j = j - 2000 do i=data.0 to j by -1 say strip(data.i) end timenow = TIME() datenow = DATE('O') timenow1= substr(timenow,1,2)||substr(timenow,4,2)||substr(timenow,7,2) [...]
4839 129 7_MRL JCL23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 May 2000 15:46:55 +01001023_iso-8859-1 //PENDLL30 JOB ,'DB2 REXX',CLASS=A,MSGCLASS=X,REGION=0M //***************************************************** //* THIS IS A TEST REXX FOR DB2 * //***************************************************** //JOBLIB DD DISP=SHR,DSN=DSN510.SDSNLOAD // DD DISP=SHR,DSN=SYS2.ISPF.ISPLLIB //GETMRL2 EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSEXEC DD DISP=SHR,DSN=PENDLL.REXX.EXEC //SYSTSPRT DD DSN=PRCDBA.MRL.RPT(+1), // DISP=(NEW,CATLG,DELETE),UNIT=SYSDA, // SPACE=(TRK,(1,1),RLSE), // DCB=(RECFM=FBA,LRECL=133) //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSTSIN DD * DSN SYS(PRC) -DISPLAY GROUP END //GETMRL2 EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSEXEC DD DISP=SHR,DSN=PENDLL.REXX.EXEC //INPUT DD DSN=PRCDBA.MRL.RPT(+1),DISP=OLD //SYSOUT DD DSN=PRCDBA.MRL.INFO,DISP=MOD //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSTSIN DD * %MRL //JOBDEL EXEC PGM=SDSF,PARM='++99,132' //ISFOUT DD SYSOUT=* //ISFIN DD * RESET ST RESET PRE PENDLL30 RESET SORT QUEUE D RESET FIND 'PENDLL30' ++P RESET ++1 RESET [...]
4969 284 47_Help ! Perfomance Problem with SUM(*) in db2 v56_monica19_monica@BANEB.COM.BR31_Tue, 23 May 2000 11:56:16 -0300360_iso-8859-1 Hi, all,
We are experiencing a problem, and we could not find a solution till now. I would like to share our problem with you and ask for help. The situation is : we have a program that used to run in about 30 min, and, after we've migrated to v5, and converted our indexes to type 2, the same program is now running in 6 - 7 hours !!!. [...]
5254 24 13_creating view11_Chris Flink17_cflink@AWGINC.COM31_Tue, 23 May 2000 09:53:30 -0500723_us-ascii How would one create a view where a column in the view is a substring of the source table. I have tried select as div = substr(colmn,2,5) but receive a sql error. Any help would be appreciated. Floundering in Kansas.
********************************************************************** This e-mail and any attachment contains information which is private and confidential and is intended for the addressee only. If you are not an addressee, you are not authorized to read, copy or use the e-mail or any attachment. If you have received this e-mail in error, please notify the sender by return e-mail and then destroy it. ********************************************************************** [...]
5279 36 17_Re: creating view13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 23 May 2000 10:09:51 -0500649_us-ascii create view new_view (div, col2, col3) as select all substr(colmn,2,5) as div, col2, col3 from source_table;
Chris Flink wrote:
> How would one create a view where a column in the view is a substring of the > source table. I have tried > select as div = substr(colmn,2,5) but receive a sql error. Any help would be > appreciated. Floundering in Kansas. > > ********************************************************************** > This e-mail and any attachment contains information which is private > and confidential and is intended for the addressee only. If you are > not an addressee, you are not authorized to read, [...]
5316 47 17_Re: creating view0_19_mike.holmans@BT.COM31_Tue, 23 May 2000 16:02:16 +0100623_- The CREATE VIEW syntax is, effectively, CREATE VIEW (list of view column names) AS SELECT (list of expressions). So you might try:
CREATE VIEW XYZ (col1, col2, DIV, col3....) AS SELECT col1, col2, SUBSTR(COLMN, 2,5), col3 ... FROM MY.TABLE
Mike Holmans BT ISE Technical Design mike.holmans@bt.com
> -----Original Message----- > From: Chris Flink [SMTP:cflink@AWGINC.COM] > Sent: 23 May 2000 15:54 > To: DB2-L@RYCI.COM > Subject: creating view > > How would one create a view where a column in the view is a substring of > the > source table. I have tried > select as div = substr(colmn,2,5) but [...]
5364 92 51_Re: Help ! Perfomance Problem with SUM(*) in db2 v518_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Tue, 23 May 2000 11:24:43 -0400411_iso-8859-1 You are going from v3 to v5? We had performance problems with v3 to v4 because CURRENTDATA default went from NO (in 3 & 4) to YES (in v5). Check your binds and include CURRENTDATA(NO) and see what happens.
-----Original Message----- From: monica [mailto:monica@BANEB.COM.BR] Sent: Tuesday, May 23, 2000 10:56 AM To: DB2-L@RYCI.COM Subject: Help ! Perfomance Problem with SUM(*) in db2 v5 [...]
5457 110 19_Re: UDB->DB2 OS/3900_22_Rohn.Solecki@MTS.MB.CA31_Tue, 23 May 2000 10:21:16 -0500629_us-ascii I'd recommend against the random name approach. You have the opportunity to organize your tables and tablespaces into logical groups, i.e. by application or subsystem, and sequences, i.e. parent-child relationships. When I say logical, I also mean logical to the developers, not just DBA. For example, when we migrated to DB2 the consultants kept our Application/Subsystem categorization, but put numbers on the end to make TS names unique, i.e. TSAAA### (granted they made the best of a tough situation due to the 8 char limit on TS NAMES). But now the developers cannot relate the table names which they normally [...]
5568 141 51_Re: Help ! Perfomance Problem with SUM(*) in db2 v50_20_John_Lendman@FPL.COM31_Tue, 23 May 2000 11:29:42 -0400350_iso-8859-1 I had the same type of problem when I converter to type 2 indexes for one batch program. The progam was doing a lot of inserts and deletes. I had to convert this one tables indexes back to type 1 to get around the problem. This was supposed to be fixed with some latest maintenance on DB2, but I do not remember the exact PTF number. [...]
5710 100 51_Re: Help ! Perfomance Problem with SUM(*) in db2 v518_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Tue, 23 May 2000 11:28:51 -0400479_iso-8859-1 correction CURRENTDATA default changed from v3 to v4... -----Original Message----- From: Bourgoine, Peter A Sent: Tuesday, May 23, 2000 11:25 AM To: 'DB2 Data Base Discussion List' Subject: RE: Help ! Perfomance Problem with SUM(*) in db2 v5
You are going from v3 to v5? We had performance problems with v3 to v4 because CURRENTDATA default went from NO (in 3 & 4) to YES (in v5). Check your binds and include CURRENTDATA(NO) and see what happens. [...]
5811 72 17_Re: creating view12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 23 May 2000 08:30:46 PDT706_- OR you can use:
Create view as Select col1, col2, substr(colmn,2,5) AS DIV, col3.....
Craig Patton PeopleSoft Specialist DBA
>From: mike.holmans@BT.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: creating view >Date: Tue, 23 May 2000 16:02:16 +0100 > >The CREATE VIEW syntax is, effectively, CREATE VIEW (list of view column >names) AS SELECT (list of expressions). So you might try: > >CREATE VIEW XYZ (col1, col2, DIV, col3....) AS SELECT col1, col2, >SUBSTR(COLMN, 2,5), col3 ... FROM MY.TABLE > >Mike Holmans >BT ISE Technical Design >mike.holmans@bt.com > > > -----Original Message----- > > From: Chris Flink [...]
5884 95 32_Re: HSM migrating data to level212_Kirk Hampton16_khampto1@TXU.COM31_Tue, 23 May 2000 10:41:38 -0500472_us-ascii Hello Max, I believe there were problems at early maintenance levels with HSM corrupting DB2 datasets, but my point was that at current levels we are doing this successfully, and that users need not fear this because it may be of some use to them.
Sure, the time criteria we chose may not be good for everyone, in fact it is most probably not good for every dataset that we have in this shop. But the process is working at our shop without data loss. [...]
5980 111 21_Re: Big DB2 V7 change0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 23 May 2000 10:42:46 -0500568_us-ascii I was hoping that IBM would say it was all a bad joke. I assume that IBM made this type of early, vague announcement to get customer reactions. So'll I add my 2 cents ($Can) worth ...
My first (rather imprecise) thought was "... that sucks! ..." . My second thought was "... well look at that, they've taken a whole chapter from the 'Microsoft Monopoly Money-grab Marketing Manual' (even though DB/2 is no where near a monopoly position!) ..." Then my third thought was "... so now that IBM marketing has finally all but killed off OS/2, they get [...]
6092 77 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 23 May 2000 18:50:54 +0200658_x-user-defined Hi,
It really means that you "must pay", you may choose between paying at checkpoint or paying at restart... So, the traditional "It Depends" comes alive...
Isaac Yassin
"DAVIS, RICK (SBCSI)" wrote: > > Hi All, > Yet another wrinkle on the subject! My research found this in > Redbook SG24-5351, DB2 UDB for OS/390 Version 6 Performance Topics: > > 5.1.2.5 Performance Considerations > The parameter with the most leverage for DB2 restart is LOGLOAD. > Even with FLA, this study conclusively illustrates that restart times have a > direct linear relationship to LOGLOAD values; the higher the LOGLOAD [...]
6170 108 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Tue, 23 May 2000 08:56:26 -0700444_iso-8859-1 Yes I think from the very beginning , the main reason of keeping the buffer pool thresholds is to distribute the writes 'more evenly' across checkpoints so that there is no surge of writes at checkpoint.
As DB2 momentarily 'halts' at checkpoint, I am of the opinion of keeping a relatively large value of checkpoint and keep my fingers crossed in case of a DB2 restart , which anyway is a rare phenomenon in most places. [...]
6279 22 37_Password Management Using DRDA Flows.10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Tue, 23 May 2000 10:52:16 -0500365_- Hello List,
Our GUI application needs password management to Mainframe / RACF. I am using DRDA to this; it's working OK. We want to put as much intelligence (validations etc..) as possible in the GUI.
If any one on the list has used DRDA to manage the password change to RACF, please suggest me what & where I should look for more information. [...]
6302 39 22_APAR PQ20027 on DB2 V513_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 23 May 2000 12:23:29 -0400629_us-ascii Our system administrator is applying V5 APARs and asked me if we should turn this one (PQ20027) on. Here's the description of the apar;
In some environments, the DB2 Optimizer may choose to not perform a sort when it would be more efficient if a sort was performed. These cases generally involve queries with very large result sets, and the entire result set is retrieved by the application. RESPONDER CONCLUSION: The DB2 sort cost formula is changed to favor sorting (more than is previously did) under certain situations. This change, however, is only enabled when an installation parameter (zparm)is turn [...]
6342 132 24_Re: Access path question23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Tue, 23 May 2000 12:38:11 -0400315_iso-8859-1 Sanjeev,
Thank you for response. We were able to change the code on Friday. We changed the co-related sub-query to non-corelated subquery and that reversed the order of table join. The query ran in 3 seconds. I did try your suggestion of disabling access via X1 on table2 and that works too. [...]
6475 105 51_Re: Help ! Perfomance Problem with SUM(*) in db2 v514_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Tue, 23 May 2000 12:45:40 -0400558_us-ascii The bind default option that changes in the transition from V4 to V5 is Degree, from 1 to any as the default = I believe ... Check it, change it, try it - Good luck
HTH Bill G.
Bourgoine, Peter A wrote:
> correction CURRENTDATA default changed from v3 to v4... > -----Original Message----- > From: Bourgoine, Peter A > Sent: Tuesday, May 23, 2000 11:25 AM > To: 'DB2 Data Base Discussion List' > Subject: RE: Help ! Perfomance Problem with SUM(*) in db2 v5 > > You are going from v3 to v5? We had performance problems with [...]
6581 127 51_Re: Help ! Perfomance Problem with SUM(*) in db2 v511_rick creech18_ykcirc@HOTMAIL.COM29_Tue, 23 May 2000 09:48:58 PDT444_- Have you checked the access path? Did it change. We had a similar problem when we went to version 5. In our case, version 5 sometimes took a less than optimal access path unless the particular tablespace was better organized. The same tablespace at the same level of organization was accessed with no problem in version 4. Solution for us: make sure the tablespace was better organized and with stats that reflected it. HTH, Rick Creech [...]
6709 69 48_Re: Landmarks TMON for DB2 / SQL Capture feature11_Suresh Sane21_data_arch@HOTMAIL.COM29_Tue, 23 May 2000 12:54:07 CDT549_- Steve: I currently use and I think it is a good tool for quick real-time analysis of a performance issue. There is overhead (less than a sql trace) for all statements - even those not captured due to the need to check if it needs to be captured.
I use it very selectively - turning it on for short periods (e.g. 30 minutes) for specfic packages. If the package is heavily used, it does produce large amounts of data. You can then filter it using threaholds for cpu time, iowait, getpages etc. Note that it is available only in "online [...]
6779 11 8_Dsn1copy0_27_Bud.Greenman@ONONDAGA.NY.US31_Tue, 23 May 2000 14:11:55 -0400372_- I am using dsn1copy to rebuild a test tablespace from a production IC. Must I first drop then redefine the tablespace and table?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6791 17 21_Bachman to Erwin Port16_Jaiwant Jonathan25_jkjonath@DOAS.STATE.GA.US31_Tue, 23 May 2000 14:06:56 -0400422_US-ASCII Hi, Has anyone tried to port a data model from Bachman to Erwin. If someone has had any experience or information to share in this regard it would be appreciated. ...Jaiwant
===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6809 151 21_Re: Big DB2 V7 change19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 23 May 2000 13:24:27 -0500570_ISO-8859-1 Hi IBM,
You guys listening . . . many folks out here are upset!
I lifted Rohn's words because he has put it so well:
"If you are going to sell a high end tool like DB2, then include the basic utilities people need to make it work in a reasonable fashion. If you want to sell "designer" utilities with more/better functionality fine, but leave the basics in! This may not be a good thing to be the market leader in. If the competition, Oracle, Sybase, Microsoft etc continue to offer "free" utilities, then I agree, over time DB/2 is [...]
6961 19 12_Re: Dsn1copy16_Jaiwant Jonathan25_jkjonath@DOAS.STATE.GA.US31_Tue, 23 May 2000 14:28:24 -0400525_US-ASCII You can use the OBIDXLAT parameter of DSN1COPY. You need to map the DBID, PSID and OBID in SYSXLAT DD card.
Or you can DSN1COPY the image copy into a sequential dataset and then use that to load the test system. In this case, you do not need OBIDXLAT.
...Jaiwant
===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6981 35 21_Re: Big DB2 V7 change29_=?iso-8859-1?Q?Jos=E9_Moura?=25_jose.antonio.moura@CGD.PT31_Tue, 23 May 2000 19:29:42 +0100389_us-ascii This remembers me a nice game, I think it's called... poker.
The bluff here is just the suggestion... and that will be further customized by superior marketing channels. Maybe what we will face is:
DB2 V7 with "normal" utilities in a single price let's say: $ AAA but, at the same time, the "turbo" utiliies will have an additional 'cost' perhaps a little bit: [...]
7017 66 36_Re: Double Byte Character Set (DBCS)11_Gil, Victor23_Victor.Gil@NEONSOFT.COM31_Tue, 23 May 2000 12:31:07 -0600486_- John,
A couple of years ago (at a previous job) I was asked to DBCS-enable an existing on-line product (which had nothing to do with DB2).
Here's what I remember: 1) The DBCS strings are easily displayed on a DBCS terminal, but in order to allow their input the screen fields must be formatted using special extended attributes. To distinguish them from the SBCS-only fields I'd suggest to display them with just another extended attribute, such as reversed video. [...]
7084 40 12_recent posts23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 May 2000 19:31:15 +0100292_iso-8859-1 Guys sorry for the info I sent out earlier .. if you are in a datasharing environment then it will help you(the rexx and the batch SDSF wrapper) to easily monitor the number of locks held in the portion of the lock structure(in the CF) called the Modified Resource List.(MRL) [...]
7125 175 21_Re: Big DB2 V7 change14_James R. Brown25_brownjr@CI.RICHMOND.VA.US31_Tue, 23 May 2000 14:38:58 -0400322_iso-8859-1 For what it's worth, I also agree with this concept . For some smaller shops the standard utilities are more than adequate. We (the smaller shops) also have strict budget constraints that have to be adhered to and paying extra for "bells and whistles" that we cannot take advantage of just isn't feasible. [...]
7301 35 12_Re: Dsn1copy16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Tue, 23 May 2000 11:49:16 -0700512_- Only if the definition between the test and production tablespace/table is different in some way. Check for differences in SEGMENT sizes, COMPRESS yes or no, PRIQTY sizes (should be close but don't have to exactly match),etc. If there are major differences in the two definitions then you will need to drop and recreate the test tablespace and table to be like the production tablespace and table. Oh, one other thing, have you added a column to either table and not done a reorg? This can cause trouble. [...]
7337 146 57_Re: DB2-L Digest - 22 May 2000 to 23 May 2000 (#2000-151)10_STEVE HOWE15_SHOWE@BCBSM.COM31_Tue, 23 May 2000 15:12:27 -0400716_iso-8859-1 Joel, The vpsize is 9000 (4k)buffers.
Steve Howe (313) 225-6151 S254
Date: Fri, 19 May 2000 17:36:21 -0400Reply-To: DB2 Data Base Discussion List Sender: DB2 Data Base Discussion List From: Joel Goldstein Subject: FW: Sort pool usage Content-Type: text/plain; charset=ISO-8859-1 Steve,The critical piece you omotted is the size of your VP for the DB07 objects. You want to be careful about increasing the 8Meg sortpool size, sincethis a a max per user.... so multiple users may cause the system pagingrateto increase.Re # 2 below, this is a direct indication that the number of buffers forthe poolis too low.Re # 3 [...]
7484 36 12_Re: Dsn1copy11_Burch, Todd18_Todd_Burch@BMC.COM31_Tue, 23 May 2000 14:16:39 -0500692_ISO-8859-1 Remember to specify the DSN1COPY option to "RESET" the page logrbas as you apply it to the test system.
Todd Burch.
> -----Original Message----- > From: Bud.Greenman@ONONDAGA.NY.US [SMTP:Bud.Greenman@ONONDAGA.NY.US] > Sent: Tuesday, May 23, 2000 11:12 AM > To: DB2-L@RYCI.COM > Subject: Dsn1copy > > I am using dsn1copy to rebuild a test tablespace from a production IC. > Must I > first drop then redefine the tablespace and table? > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can > be reached at [...]
7521 36 23_Priced Utility Features28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 23 May 2000 10:53:13 PDT325_- I can't sign my name above "DB2 Utilities Development" every day and remain silent while you all stress over this. The absence of information in this case is worse than the reality. We'll try to fill in the blanks as soon as possible but there are still decisions to be made and work to be done before we can do that. [...]
7558 30 29_SYSLGRNX records left by DROP28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 23 May 2000 12:34:06 PDT616_- Tony,
Your point is well taken. Thanks for taking the time to explain and repost the original. I'll keep pursuing this and post an update when I learn something.
Dan DB2 Utilities Development dcourter@us.ibm.com
>The point is: based on the discussion in this news group, and the fact that >fixes had been requested for it, it appears that customers consider it a >bug. Saying that it's working as designed doesn't make that go away. If an >APAR was issued back in v3, and the customers still appear to want it, >whether it's called a fix, upgrade, enhancement, or whatever, maybe [...]
7589 143 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 23 May 2000 14:45:57 -0500528_ISO-8859-1 Ashish, Thanks for your comments. Your statement: "I am of the opinion of keeping a relatively large value of checkpoint and keep my fingers crossed in case of a DB2 restart , which anyway is a rare phenomenon in most places." IT DEPENDS! Some shops need rapid DB2 restart. Consider a brokerage house. For whatever reason DB2 is restarting, its important that it be back up before the stock market closes! Things always seem to fail at the worst time; for example, when I'm DB2 Oncall support -- its always 3AM! [...]
7733 228 21_Re: Big DB2 V7 change0_19_Tim.Lowe@STPAUL.COM31_Tue, 23 May 2000 14:10:48 -0500554_us-ascii I think that it is too early to take such a "hard stand" on this issue. There has not be anything on what the actual pricing will look like yet. It would seem entirely possible that this is occurring because of legal pressure FROM the third-party vendors, and it might therefore be improper for anyone to blame IBM for this move. After all, what if this change IS actually revenue-neutral? It COULD actually be a savings for some sites that already have third-party vendor products, and others MAY not be impacted. It is too early to tell. [...]
7962 105 27_Re: Priced Utility Features0_24_greg_p_mucha@CARADON.COM31_Tue, 23 May 2000 14:36:49 -0600528_us-ascii Thank you very much for your considered response, Dan.
But I think you may have misunderstood something.
These issues you list aren't just issues; they are BOUNDARIES. If you cross this line with your customers, as has been the custom of IBM in the distant past (10-20 years or so ago), you will lose customer install base for alot of ecommerce and web-based development applications. That's not a threat, it's a fact. We can't tolerate being doinked with by both Microsoft and IBM at the same time. [...]
8068 149 47_Re: DL1 and DB2 and dynamic call, sqlcode -927!20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 23 May 2000 15:59:47 -0400379_us-ascii Tim
In my IDUG presentation this year. I have suggested two techniques to customize LI to make user program attachment independent as well as dynam calls for CAF and RRSAF.
I have tested and used it for CICS, CAF, TSO and RRSAF. Result - One load module, which runs under any attachment. The thing I have not tested is IMS but I assume it would work. [...]
8218 289 21_Re: Big DB2 V7 change24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 23 May 2000 13:05:04 -0700352_iso-8859-1 Hi Everyone!
I listened to the announcement at IDUG, and initially I was also disappointed. To expect the combined cost of DB2 and the utilities to be the same as you pay today is unrealistic. Every new release of DB2 costs more than the prior release. Someone needs to pay for the enhancements, both in speed and functionality. [...]
8508 242 24_Nested Stored Procedures23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Tue, 23 May 2000 17:58:56 -0400599_iso-8859-1 Greetings !!!!
Does any one know if Nested Stored Procedures (i.e. One stored procedure calling another) are supported on UDB ver 6 for OS/390. I have been unable to find any document on it.
TIA
Sanjay
> -----Original Message----- > From: damcon2@US.IBM.COM [SMTP:damcon2@US.IBM.COM] > Sent: Monday, May 22, 2000 1:58 PM > To: DB2-L@RYCI.COM > Subject: Re: Distributed Binds? > > Are you using three part names? If you are V5 or earlier this will use > private protocol which incurs a bind each time a remote SQL call is made. > > Jay > > > Jay Reavill > [...]
8751 287 28_Re: Nested Stored Procedures0_19_Tim.Lowe@STPAUL.COM31_Tue, 23 May 2000 17:01:55 -0500594_us-ascii Sanjay, The DB2 UDB for OS/390, V6 Release Planning Guide states that nesting stored procedures will now be possible. See "Changes to stored procedure invocation", Chapter 5, page #102.
Thanks, Tim
"Jain, Sanjay (Exchange)" on 05/23/2000 04:58:56 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: Nested Stored Procedures [...]
9039 299 28_Re: Nested Stored Procedures12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 23 May 2000 17:32:03 -0500488_us-ascii Absolutely.
We do quite a bit of this.
One thing to consider is when an "after" Trigger fires a stored procedure, you may run into an issue with the definition of OUT and INOUT parms.
"Commit on Return" can also trip you up, because it may not be allowed when the stored procedure is fired in a nested manner which included triggers. (I forget the exact combination which caused this, but the SQL error I got was quite clear in indicating the problem.) [...]
9339 29 27_ESS/Shark DASD expectations10_Mark Labby16_mlabby@PHEAA.ORG31_Tue, 23 May 2000 18:49:00 -0400435_us-ascii At IDUG there were several presenters who were touting IBM's ESS or "Shark" DASD as the greatest thing since sliced bread and giving all kinds of impressive figures showing how much faster it was than other DASD. Well, we are getting in some of these new storage units and I was looking at the white papers and redpieces that IBM was pointing to, but al of their comparisons are always against other IBM storage devices. [...]
9369 44 49_Re: DB2 Connect and Windows 2000 min requirement.0_15_leon@CA.IBM.COM31_Tue, 23 May 2000 18:50:37 -0400424_us-ascii V6.1 of DB2 Connect and DB2 Run-time Client (DB2 CAE) were both tested with Windows 2000. I don't think V5.2 was tested on Windows 2000 but it may still work OK. It will be strictly a matter of support.
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com
dcreed@CSC.COM on 05/23/2000 09:08:35 AM
Please respond to DB2 Data Base Discussion List [...]
9414 42 31_Java and Stored Procedures Help0_24_db46@DAIMLERCHRYSLER.COM31_Tue, 23 May 2000 11:58:00 -0400619_us-ascii I would appreciate some help using Java client side applications calling DB2 (version 5) MVS stored procedures.
We are writing a new system that at present gathers data from different sites using datajoiner.
The problem is that we need to do a bill of material on a single table that involves recursion. The present MVS/COBOL/DB2 system obviously builds this list with normal programming since the table has the basic PART, COMPONENT_PART structure that can go up to 15 levels deep. The original specs called for this to be done in SQL, but after much convincing, I convinced them that this [...]
9457 25 25_Re: Bachman to Erwin Port13_Al DiGiovanni13_al-d@HOME.COM31_Tue, 23 May 2000 20:54:13 -0400632_us-ascii We are evaluating and testing a product called ToolBus that takes a Cayenne model(after Bachman merge) and converts to ERWIN. Will keep you posted on our findings as the product is not 100%
Jaiwant Jonathan wrote: > > Hi, > Has anyone tried to port a data model from Bachman to Erwin. If someone has had any experience or information to share in this regard it would be appreciated. > ...Jaiwant > > ============================================== > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at [...]
9483 39 11_Replication12_Geoff Davies31_geoffrey.davies@APAC.DMR.COM.AU31_Wed, 24 May 2000 10:30:39 +0800333_us-ascii Hi all,
We're thinking about venturing into the brave new world of replication and are after any advice on this topic. All of our applications are currently on OS/390 (including a data warehouse - this may possibly be moving to UDB/NT) and we may building some web applications on UDB/NT in the near-ish future. [...]
9523 155 15_Re: Remote Bind14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 May 2000 13:17:50 +1000577_iso-8859-1 BIND PACKAGE(remote_server.remote_collection) COPY(local_collection.package_id) ...
run on the system where the package already exists
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au
-----Original Message----- From: Mallett, Steven [mailto:Steven.Mallett@TEAM.TELSTRA.COM] Sent: Tuesday, May 23, 2000 6:29 PM To: DB2-L@RYCI.COM Subject: Remote Bind
The recent thread on Distributed Binds prompts me to ask if there is any way to achieve a remote Bind. [...]
9679 49 21_partition on db2 date15_MAHSOUN, KHALID29_kmahsoun@SAUDIAIRLINES.COM.SA31_Wed, 24 May 2000 08:11:20 +030049_- Hi Can we partition on column which is db2 date
9729 38 27_Re: Priced Utility Features14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 24 May 2000 09:13:49 +0200355_us-ascii I agree with Greg, all the posts in DB2-L about priced utility features express the fact that many IBM customer, who have to pay high costs for 3rd party software (and often utilities are non-IBM) cannot tolerate to pay for tools they 'never' payed.Actually they pay them, but it's an 'hidden' cost . It's a boundary that cannot be crossed. [...]
9768 45 36_Re: Double Byte Character Set (DBCS)10_Michale Yu19_yubin@MAIL.DCAC.COM31_Wed, 24 May 2000 14:36:04 +0800544_iso-8859-1 John:
I am DBA who worked in CHINA, I have used DBCS for almost 10 years on MVS or OS/390, especially CICS/DB2 environment. I think that there is less problem on this topic except some definition in CICS & DB2.
Recently, when I connect to DB2 for OS/390 from DB2 PE on WIN/95 through DB2 connect EE on WINDOWS NT, I have encountered a very big problem with CCSID which is used to convert code set between EBCDIC (DBCS) and ASCII(DBCS), finally I have solved this problem after I have tested a lot of paires CCSID. [...]
9814 59 31_Re: ESS/Shark DASD expectations32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Wed, 24 May 2000 10:44:48 +0300339_- Here are some 'draft' figures. This test is done in the TEST system during non busy hours.
10 part. table space with 935,978 records. SQL access this table with ts scan. Large BP w/o Hiper.
7700E
1. Run: TOTAL TCB CPU TIME= 5.97 TOTAL ELAPSED TIME= 10.7 2. Run TOTAL TCB CPU TIME= 6.03 TOTAL ELAPSED TIME= 10.6 [...]
9874 27 32_Re: HSM migrating data to level214_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 24 May 2000 09:56:31 +0200472_us-ascii Hi Kirk nice to meet you again.
yes, some problems in recalling dataset were at early manteinance levels, but nertheless the risk of losing some tablespace still remains in long-period application. You must resolve this problem with a very high retention period. And my HSM admin warned me that if there are problems in xxDS files some DB2 files cannot be recalled without a manual intervention. And if this happens at 3.00 A.M......as Murphy teachs. [...]
9902 17 18_DB2 Recovery Issue10_Lee Mandel16_DBMSUser@AOL.COM29_Wed, 24 May 2000 06:09:37 EDT420_US-ASCII Is their any DB2 Recovery Tool that simplify and automate the recovery of DB2 resources (On-Site and Off-Site Disaster Recovery) that do not cost an arm and leg? TIA Lee
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9920 19 16_compress backups16_Tyapuhin, Andrew42_Tyapuhin@SCIENCESOFT.INVENTION-MACHINE.COM31_Wed, 24 May 2000 13:28:04 +0300493_iso-8859-1 Hello all I have many large backups (4 -20 Gb) ,but disk space is not rubber . Existing compressors (winzip ,winrar and others) can't pack that files. My questions : Which tool I can use for compress my backups ?
Thanks
Andrew
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9940 25 41_DBRM Checker by Software Engineering GMBH6_JS DBA18_js_dba@HOTMAIL.COM29_Wed, 24 May 2000 11:48:06 BST463_- Hi,
Has anyone any experience of the Product DBRM Checker written by Software Engineering?
Having run it on our system I can see a large benefit for Quality assurance with this product.
Any comments you have either negative or positive would be greatly appreciated.
Richard Newnham ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com [...]
9966 191 36_Re: Online REOG ABEND 04E RC00E400090_18_mebert@AMADEUS.NET31_Wed, 24 May 2000 10:38:56 +0100321_us-ascii This is the explanation for the Reason code:
00C200EA
Explanation: DB2 is unable to perform the drain function on an object (a table space, an index space, or a partition) because the object was held by other claimers and the drain request timed out waiting for the claim count to reach zero. [...]
10158 149 61_Re: Is posible recover a tablespace without prior Image copy?0_18_mebert@AMADEUS.NET31_Wed, 24 May 2000 10:23:46 +0100428_us-ascii I think this is somewhat misleading and incomplete. Unless I am completely mistaken, DB2 can start a recovery from any of these points in time (Logs are required for the changes after these points in time to the current time): 1. TS Creation 2. LOG YES operations (REORG, LOAD) 3. Imagecopy Furthermore, DB2 cannot do a recovery across any LOG NO operation. That's why these set the Copy Pending restricted state. [...]
10308 72 31_Re: ESS/Shark DASD expectations23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 11:54:24 +0100460_iso-8859-1 MArk whilst I cannot answer your questions directly I will give you some feelings I have about the devices :
1. Yes you will get great gains in performance from the 20 logical addresses per device - but as always DATASET PLACEMENT WILL MATTER 2. Go to ESS and you loose SNAP (major loss) 3. I do beleive there are some other bits and pieces you loose 4. GReat for Sortworks DSNDB07 (WRK blah blah for Datasharing) 5. Great for Unix bits [...]
10381 48 74_SAP Site - should I or should I not turn on &SPRMOPT to favour So rts more23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 12:07:55 +0100335_iso-8859-1 Hi all, just a quick one.
I see that in APAR PQ20027 you can switch a bit to ask the optimizer to favour Sorts a little more.
When you consider we going to split our sort work databases over manay datasets on SHARK DASD (amazing performance) I was wondering if we should now go back and review the above. [...]
10430 53 22_Re: DB2 Recovery Issue23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 12:11:02 +0100435_iso-8859-1 Lee yes BMC and CA do one.
We use the CA one and it works very weel for us ... however I do beleive the BMC one (which I have used aswell briefly) is a very mature product aswell.
If you would like more detailed information Recovery (by the CA products) then please let me know via private e-mail. I presented a paper on it at a recent conference .. I can send you some information from that if you like? [...]
10484 103 52_Re: Badly performing asynchronous i/o - DB2 os390 v410_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 24 May 2000 11:18:58 GMT531_us-ascii Hi Jim, Thanks for the details.I think you are right that your buffer pool is small . There are three things which i can conclude : 1) Number of pages read through async. read vs total number of pages in the tablespace.This can give the clear picture of pages re-read if async. read is always high as compared to the total number of pages in the tablespace ,if DB2 is reading the pages from the disk again and again even if those are not updated and written back due to any reason.1.74 per i/o is good if you are not [...]
10588 68 26_Re: APAR PQ20027 on DB2 V523_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 12:25:21 +0100345_iso-8859-1 Lynne just been reviewing my list mails .. and saw this note of yours . I just sent out nearly the same mail .. oooppps. have you had any replies?
Leslie
-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Tuesday, May 23, 2000 5:23 PM To: DB2-L@RYCI.COM Subject: APAR PQ20027 on DB2 V5 [...]
10657 46 15_DB2 table names13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Wed, 24 May 2000 07:58:51 -0400443_us-ascii I am forwarding a problem which I faced regarding table names , and Sanjeev's response to it . Any other explanations would be most welcome . --------------------------------------------------------------------------------------------- Sanjeev , A small DB2 puzzle for you ;
A new table has been created with name : 8xx_numbers . The creator is wom . The create is successful , as it has valid entries in the SYS tables . [...]
10704 37 25_Re: partition on db2 date19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 24 May 2000 07:06:26 -0500604_ISO-8859-1 Khalid, for DB2 for OS390, yes.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
10742 48 22_Re: DB2 Recovery Issue19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 24 May 2000 07:08:44 -0500609_ISO-8859-1 Hi Lee, "Is their any DB2 Recovery Tool . . . that do not cost an arm and leg?" NO.
Regards, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, [...]
10791 41 22_Re: DB2 Recovery Issue20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 24 May 2000 08:58:08 EDT515_US-ASCII Hello Lee, We have a tool that you may wish to look at. I will be happy to send you some sample panels to see if this is what you are seeking and the price is right. In fact if you are interested in the next month or so I can offer you a 50% discount off the already low price. Contact me off-list. Keep your eye open for a Press Release of the product next week. Below is a summary of the automation tool. Timely recovery of your DB2/MVS resources is essential. This include the Recovery of the User [...]
10833 80 31_Re: ESS/Shark DASD expectations19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 24 May 2000 08:10:29 -0500627_ISO-8859-1 Hi Leslie, Forgive my lack of knowledge, but have you heard if SnapShot will become available for ESS/Shark DASD or is it simply architecturally incapable? Or not applicable?
Regards, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your [...]
10914 77 22_Re: DB2 Recovery Issue12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Wed, 24 May 2000 14:13:00 +0100299_- It depends what your batch window is and where you want to recover to. For one of our systems we use full volume dumps. Its very quick to back up, you can roll forward with the recover logonly option if required, and your indexes are backed up even if you aren't on version 6, and it's free. [...]
10992 74 15_Re: Replication10_Mike Paris14_MPARIS@TUC.COM31_Wed, 24 May 2000 08:17:23 -0500425_US-ASCII Geoffrey,
We've been using IBM Data Propagator for the past two years on the OS390 and AIX DB2 platforms with very little problems.
Contact me direct if you wish more info.
Michael Paris
Senior Database Analyst IBM Certified Solutions Expert DB2 UDB Database Administration IBM Certified Advanced Technical Expert Data Replication
Trans Union 555 West Adams Chicago, IL 60616 [...]
11067 68 22_Re: DB2 Recovery Issue0_19_mike.holmans@BT.COM31_Wed, 24 May 2000 14:20:31 +0100553_- Oh yes there is. Use IBM's Propagator to maintain hot standby. That doesn't cost an arm and a leg - more like both arms, both legs, and most of your vital organs.
Mike Holmans BT ISE Technical Design mike.holmans@bt.com
> -----Original Message----- > From: DAVIS, RICK (SBCSI) [SMTP:RD8246@MOMAIL.SBC.COM] > Sent: 24 May 2000 13:09 > To: DB2-L@RYCI.COM > Subject: Re: DB2 Recovery Issue > > Hi Lee, > "Is their any DB2 Recovery Tool . . . that do not cost an arm and > leg?" > NO. > > Regards, > Rick Davis > > "This e-mail and any [...]
11136 112 31_Re: ESS/Shark DASD expectations23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 14:20:12 +0100447_iso-8859-1 Rick Hi. As far as I know SNAP will be coming along (albeit under a different name) . Like all things it might change in the future.
the main things is when will they deliver snap .. and I think the answer is Do not know ..
Les
-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Wednesday, May 24, 2000 2:10 PM To: DB2-L@RYCI.COM Subject: Re: ESS/Shark DASD expectations [...]
11249 97 22_Re: DB2 Recovery Issue23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 14:22:35 +0100321_iso-8859-1 Ahhhhhhhhhhhhh.....but are youa 24 by 7 site? we are and a pain that is .. so it is shrlevel change or nothing .. unless you implement the log write suspend fix from IBM and then do a system snap .. but you have to get that snap off site somehow .. this is an option we are considering .. but not yet ... [...]
11347 23 31_Re: ESS/Shark DASD expectations14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 24 May 2000 15:28:39 +0200307_us-ascii Just an hour ago two IBM sales agents (I lectured them for the problem with utilities in V 7 but
they didn't know anything) said that in september IBM will release a 'snapshot copy' or a some
kind of 'instant' logical copy for Shark for s/390 and UNIX systems (later for AS400). [...]
11371 30 31_Re: ESS/Shark DASD expectations20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 24 May 2000 09:31:53 -0400389_us-ascii How about number of I/Os ? Were they same in both cases? If you could provided # of getpages, # of seq pref request and # of i/o along with, it would be great.
Thanks
-----Original Message----- From: Cuneyt Goksu (Garanti Teknoloji) [SMTP:CuneytG@GARANTI.COM.TR] Sent: Wednesday, May 24, 2000 3:45 AM To: DB2-L@RYCI.COM Subject: Re: ESS/Shark DASD expectations [...]
11402 180 65_=?iso-8859-1?q?R=E9f=2E_=3A_Re=3A_ESS=2FShark_DASD_expectations?=14_Denzil Coalter26_denzil.coalter@UNICIBLE.CH31_Wed, 24 May 2000 15:35:40 +0200528_iso-8859-1 Hi,
Looking at the ESS Models F10 and F20 they talk about the FlashCopy capability. Does this offer the same functionality as SNAP?
"Pendlebury-Bowe, Leslie" @RYCI.COM> le 24.05.2000 15:20:12
Veuillez répondre à DB2 Data Base Discussion List
Envoyé par : DB2 Data Base Discussion List
Pour : DB2-L@RYCI.COM cc :
Objet : Re: ESS/Shark DASD expectations [...]
11583 92 26_Re: APAR PQ20027 on DB2 V513_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 24 May 2000 09:36:58 -0400633_us-ascii Great minds think alike! :-)
Unfortunately, I have not gotten any replies and even more unfortunately our DASD is ancient...
> -----Original Message----- > From: Pendlebury-Bowe, Leslie [SMTP:Leslie.Pendlebury-Bowe@EU.SONY.COM] > Sent: Wednesday, May 24, 2000 7:25 AM > To: DB2-L@RYCI.COM > Subject: Re: APAR PQ20027 on DB2 V5 > > Lynne > just been reviewing my list mails .. and saw this note of yours . > I just sent out nearly the same mail .. oooppps. > have you had any replies? > > Leslie > > -----Original Message----- > From: Lynne Flatley [mailto:LFlatley@NEFN.COM] > Sent: Tuesday, May 23, 2000 [...]
11676 219 61_Re: Is posible recover a tablespace without prior Image copy?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 24 May 2000 09:37:58 -0400479_iso-8859-1 One more option is to restore the underlying vsam from DASD backups and use "RECOVER ... LOGONLY TORBA".
But there should not be any LOG NO kind of operation from the header RBA of the restored vsam till TORBA and also LOGs should be present.
-----Original Message----- From: mebert@AMADEUS.NET [SMTP:mebert@AMADEUS.NET] Sent: Wednesday, May 24, 2000 5:24 AM To: DB2-L@RYCI.COM Subject: Re: Is posible recover a tablespace without prior Image copy? [...]
11896 197 87_=?iso-8859-1?Q?RE=3A_R=E9f=2E_=3A_Re=3A_ESS/Shark_DASD_expecta?= =?iso-8859-1?Q?tions?=23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 14:56:16 +0100464_iso-8859-1 ....there are restrictions .. I think the time to do a flash is longer than snap ..
Leslie
-----Original Message----- From: Denzil Coalter [mailto:denzil.coalter@UNICIBLE.CH] Sent: Wednesday, May 24, 2000 2:36 PM To: DB2-L@RYCI.COM Subject: Réf. : Re: ESS/Shark DASD expectations
Hi,
Looking at the ESS Models F10 and F20 they talk about the FlashCopy capability. Does this offer the same functionality as SNAP? [...]
12094 32 26_Re: APAR PQ20027 on DB2 V511_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Wed, 24 May 2000 08:52:41 -0500396_- Lynne, This PTF is applied and implemented at my site, but I have no testimony, pro or con from DBAs or users to give you any feedback.
As the APAR continues, it requires an edit of SDSNMACS(DSN6SPRC), which is included in the DSNTIJUZ asm of DSNZPARM. This is global variable SPRMOPT ('0' is default, '1' to use new optimizer cost formula). Not a traditional 'zparm' value in MHO. [...]
12127 93 26_Re: APAR PQ20027 on DB2 V512_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 24 May 2000 07:12:46 -0700595_us-ascii I've been waiting to see if Pat Bossman (IBM now) was going to answer this.
This APAR should be approached very very carefully. It was designed by IBM for a site (large data warehouse application) that has some very complex SQL with lots of large joins (involving several 50-100 million tables). The result answer set returned via the query usually averages between 2-3 million rows. With the complex WHERE clauses on each table involved in the join, for this type of queries, it seemed to be much more advantageous to have the DB2 Optimizer process each table in the join, [...]
12221 108 26_Re: APAR PQ20027 on DB2 V520_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 24 May 2000 10:24:42 -0400394_us-ascii I met him at IDUG and I am not sure if Pat is still on the list. I guess we can ask him at his e-mail address directly.
-----Original Message----- From: Myron Miller [SMTP:myronwmiller@YAHOO.COM] Sent: Wednesday, May 24, 2000 10:13 AM To: DB2-L@RYCI.COM Subject: Re: APAR PQ20027 on DB2 V5
I've been waiting to see if Pat Bossman (IBM now) was going to answer this. [...]
12330 326 43_Repost: IBM Software Group Launches New Ads13_Morrill, John12_JohnM@VP.NET31_Wed, 24 May 2000 08:47:35 -0600735_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties,
A comprehensive ad campaign was launched this week by DB2's division within IBM, the IBM Software Group (see below), which aims to increase the awareness of IBM's software prowess. Television commercials are now hitting major network shows including ABC's 20/20, NBC's Tonight show and Fox's Xfiles. A print campaign will [...]
12657 87 36_Re: Double Byte Character Set (DBCS)16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Wed, 24 May 2000 08:22:32 -0700593_iso-8859-1 Yes, one subsystem can handle both SBCS and DBCS. CHAR-type columns are defined with 'FOR SBCS DATA', 'FOR MIXED DATA', or 'FOR BIT DATA'. This sets a flag in the FOREIGNKEY column of SYSCOLUMNS.
Two caveats: 1. The 'FOR BIT DATA' is necessary for any CHAR-type column that could contain binary data, otherwise if it happens to contain a shift-out or shift-in value in the binary string (hex '0E' or '0F'), you could get an SQL error (like -113 or -191). 2. If 'FOR SBCS DATA' wasn't specified when creating tables previously (which is probably the case, since it's the [...]
12745 22 26_DB2 v6.1 upgrade on AIX...12_Ragam, Sai J18_Sai.Ragam@BNSF.COM31_Wed, 24 May 2000 10:26:18 -0500526_iso-8859-1 Hello All,
Would anybody like to share their experiences with DB2 v6.1 upgrade from DB2 v5.2 on AIX. Any feedback along with a checklist of things to look for during migration etc. will be appreciated.
Thanks. Sai.
Standard Disclaimer applies..........
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12768 107 26_Re: APAR PQ20027 on DB2 V513_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 24 May 2000 11:48:18 -0400601_us-ascii Thanks for the feedback...this APAR doesn't really sound applicable to us.
> -----Original Message----- > From: Myron Miller [SMTP:myronwmiller@YAHOO.COM] > Sent: Wednesday, May 24, 2000 10:13 AM > To: DB2-L@RYCI.COM > Subject: Re: APAR PQ20027 on DB2 V5 > > I've been waiting to see if Pat Bossman (IBM now) was > going to answer this. > > This APAR should be approached very very carefully. It > was designed by IBM for a site (large data warehouse > application) that has some very complex SQL with lots > of large joins (involving several 50-100 million > tables). The result [...]
12876 161 26_Re: APAR PQ20027 on DB2 V515_Patrick Bossman18_bossman@US.IBM.COM31_Wed, 24 May 2000 11:48:18 -0400440_us-ascii Hello,
My personal experiences with this APAR have been good.
In my experience queries which joined many rows against tables in different clustering sequences are more likely to sort to eliminate the high syncronous I/O. Queries which join many rows against tables in the same clustering (and join) sequence or join few rows are not likely to sort (because sort is not free, and index eliminates need for sort). [...]
13038 45 25_Re: Bachman to Erwin Port12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM31_Wed, 24 May 2000 09:06:05 -0700514_iso-8859-1 Al: Does this Toolbus product handle just Bachman (Cayenne) to ERwin, or other tools as well?
Wayne Kline Ingram Micro
-----Original Message----- From: Al DiGiovanni [mailto:al-d@HOME.COM] Sent: Tuesday, May 23, 2000 5:54 PM To: DB2-L@RYCI.COM Subject: Re: Bachman to Erwin Port
We are evaluating and testing a product called ToolBus that takes a Cayenne model(after Bachman merge) and converts to ERWIN. Will keep you posted on our findings as the product is not 100% [...]
13084 237 22_Re: DB2 Recovery Issue10_Wang.James24_Wang.James@AAA-CALIF.COM31_Wed, 24 May 2000 09:08:07 -0700346_iso-8859-1 Yes, we use a tool call DB2I2 from JRH GoldenState Software, Inc.; WWW.DB2I2.COM .
Last time we have a DASD hit where 6 major production DB2 tables went bye-bye. We were able to recovery in less than 2 hours from generating the recovery jobs until making these tables available again for production. [...]
13322 183 26_Re: APAR PQ20027 on DB2 V512_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 24 May 2000 09:08:33 PDT659_- Phil, Do WE at BOSCOV'S have this APAR?? It sounds like we could benefit from this with some of the NVISION and Crystal reports.
Respectfully, Craig
>From: Patrick Bossman >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: APAR PQ20027 on DB2 V5 >Date: Wed, 24 May 2000 11:48:18 -0400 > >Hello, > >My personal experiences with this APAR have been good. > >In my experience queries which joined many rows against tables in different >clustering sequences are more likely to sort to eliminate the high >syncronous I/O. Queries which join many rows against tables in the [...]
13506 39 27_Re: Priced Utility Features9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 24 May 2000 11:03:14 -0500645_- These are not rumors. This is text pulled from the DB2 for OS/390 Version 7 Announcement letter:
"A basic set of core utilities are included as part of DB2 since Version 1 was first delivered. These utilities initially provided a basic level of services to allow customers to manage data. Some customers have preferred to obtain such functions, however, from independent software vendors that have developed utility and tools offerings that offered additional performance, function, and features beyond that contained in the DB2 core utilities. With recent releases of DB2 for OS/390, in response to clear customer demand, IBM has [...]
13546 36 30_Re: DB2 v6.1 upgrade on AIX...15_Whiting, George30_George.Whiting@TWC.STATE.TX.US31_Wed, 24 May 2000 11:26:13 -0500621_- Is v5.2 the most current AIX?
> -----Original Message----- > From: Ragam, Sai J [SMTP:Sai.Ragam@BNSF.COM] > Sent: Wednesday, May 24, 2000 10:26 AM > To: DB2-L@RYCI.COM > Subject: DB2 v6.1 upgrade on AIX... > > Hello All, > > Would anybody like to share their experiences with DB2 v6.1 upgrade from > DB2 > v5.2 on AIX. > Any feedback along with a checklist of things to look for during migration > etc. will be appreciated. > > Thanks. > Sai. > > Standard Disclaimer applies.......... > > ================================================ > To change your subscription options or to cancel your subscription [...]
13583 61 26_Re: APAR PQ20027 on DB2 V522_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 24 May 2000 12:35:28 -0400668_- John -
Have you considered applying your edit with a SMP/E usermod on SDSNMACS(DSN6SPRC)? SMP/E will raise a flag when future PTFs modify the macro.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: John Rosser[SMTP:jhrosser@DUKE-ENERGY.COM] > Sent: Wednesday, May 24, 2000 9:52 AM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] APAR PQ20027 on DB2 V5 > > Lynne, > This PTF is applied and implemented at my site, but I have no testimony, > pro or con from DBAs or users to give you any feedback. > > As the APAR continues, it requires an edit of SDSNMACS(DSN6SPRC), which [...]
13645 228 36_Re: Double Byte Character Set (DBCS)27_Radonjic, Bora (Consultant)23_BRadonjic@ACNIELSEN.COM31_Wed, 24 May 2000 11:39:40 -0500628_- If DBCS is turned on, is any ALTER of the tables recomended to avoid defaulting? What kind of table reorgs need to be run? What happens with the programs, does precompiler know to use KATAKANA. Any BIND considerations? TIA Bora Radonjic (consultant) (All opinions ... and other disclaimers...)
On Wednesday, May 24, 2000 10:23 AM, Provenzola, Tony [SMTP:Tony.Provenzola@NIKE.COM] wrote: > Yes, one subsystem can handle both SBCS and DBCS. CHAR-type columns are > defined with 'FOR SBCS DATA', 'FOR MIXED DATA', or 'FOR BIT DATA'. This > sets a flag in the FOREIGNKEY column of SYSCOLUMNS. > > Two caveats: [...]
13874 71 19_Re: DB2 table names13_OConner, John26_John.OConner@COURTS.WA.GOV31_Wed, 24 May 2000 09:47:38 -0700688_iso-8859-1 Have you tried double quotes?
select * from wom."8xx_numbers"
John O'Conner DB2 DBA Office of the administrator for the courts (360) 705-5210 Mailto:john.oconner@courts.wa.gov
-----Original Message----- From: Jaydeep Ghosh [mailto:Jaydeep_Ghosh@PROGRESSIVE.COM] Sent: Wednesday, May 24, 2000 4:59 AM To: DB2-L@RYCI.COM Subject: DB2 table names
I am forwarding a problem which I faced regarding table names , and Sanjeev's response to it . Any other explanations would be most welcome . ---------------------------------------------------------------------------- ----------------- Sanjeev , A small DB2 puzzle for you ; [...]
13946 13 19_Re: Db2 Table names13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Wed, 24 May 2000 12:57:32 -0400337_us-ascii Yes , I did try double quotes and other combinations . It still gave error . Jaydeep .
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
13960 153 19_Re: Index Screening14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 24 May 2000 13:11:44 -0400483_iso-8859-1 Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS
----- Original Message ----- From: Pillay, Venkat (PCA) Newsgroups: bit.listserv.db2-l To: Sent: Friday, March 31, 2000 12:47 PM Subject: Re: Index Screening
Probably you misunderstood me. I said C3 is used for index-screening unless you have a list-prefetch ( & lower version of DB2). [...]
14114 77 27_Re: Priced Utility Features0_25_Don.Alden@I-STRUCTURE.COM31_Wed, 24 May 2000 10:52:14 -0600455_iso-8859-1 I agree with Massimo, DB2 users have been getting support utilities for FREE over the years and "all of a sudden" IBM improves them to act and feel like BMC and Platinum tools and asks for some money.
What I am seeing come across the DB2 Listserv is someting called "culture shock". I've gon out to the IBM DB2 website and read about the V7 utilities and they can do anything that BMC or CA(formerly Platinum) can offer in DB2land. [...]
14192 16 26_Re: APAR PQ20027 on DB2 V526_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Wed, 24 May 2000 12:15:01 -0500396_- Just as an aside whois.ibm.com url will search for IBMers company eMail address. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
14209 135 47_Re: How to use the system date in an SQL Query?14_Peter Backlund15_pbacklu@IBM.NET31_Wed, 24 May 2000 19:10:20 +0200531_us-ascii From a performance point of view, t is better to write WHERE START_DATE <= CURRENT DATE AND END_DATE >= CURRENT DATE
Peter
David Cohn wrote:
> Hi H.C., > use: SELECT * FROM X WHERE CURRENT_DATE BETWEEN START_DATE AND END_DATE; > Remember that between is inclusive. > hope this helps, > Dave > > H C Diment wrote: > > > Hello, > > > > I am trying to create a view that uses the system date as one of its > > parameters e.g; > > > > create view V_EDITIONS as select * from EDITIONS where START_DTE [...]
14345 29 23_QMF for Windows Ver 6.125_Skelton, Terry (corp) USX21_tskelton.inc@MOOG.COM31_Wed, 24 May 2000 13:40:20 -0400492_- Hello, We're experiencing an intermittant problem with receiving the following time out message in QMF for Windows Ver 6.1:
"An error occurred while retrieving the object list. Communications error with TCP return code = WSAETIMEDOUT. "
We're running DB2 ver 5.1 and TCP/IP Ver 3.2. We seem to have abandoned sessions shown with our TCP/IP monitor. No other QMF for Windows sessions can execute until we stop and restart DDF. Any assistance would be appreciated. Thanks, [...]
14375 94 27_Re: Priced Utility Features0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 24 May 2000 13:13:32 -0500384_us-ascii Thanks Jim for the clarification. The text of the announcement <> ... IBM has invested in the improvement of the performance and functional characteristics of these core utilities.
With Version 7, many of these enhanced utility functions have been separated from the base product and are now offered as optional features of DB2 UDB for OS/390. <> [...]
14470 150 55_En: Re: Help ! Perfomance Problem with SUM(*) in db2 v56_monica19_monica@BANEB.COM.BR31_Wed, 24 May 2000 15:27:30 -0300491_iso-8859-1 Hi, all,
Thank you for all your answers, and excuse me for my anxiety sending the note. I'm really desapointed, but I have to assume that it was a obvious logical mistake : the join predicate wasn't really ok, so db2 did a cartesian product, which was the right thing to do. The most incredible thing was that, doing that, the result of the SUM was obviosly wrong, but this wasn't noted for years, because the program "just do the SUM, and ignore it"!!!!!! Weird !!!! [...]
14621 16 27_Re: Priced Utility Features9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 24 May 2000 14:32:34 -0500359_- Rohn, You are interpreting "enhanced utility functions" in a more granular form than you should. For example, LOAD is an "enhanced utility function". You get to choose which vendor will provide your utilities. Pick the vendor that provides the price/function/performance that best fits your needs.
Jim Ruddy DB2 for OS/390 Utilities Development [...]
14638 41 27_Re: Priced Utility Features12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 24 May 2000 12:57:05 PDT701_- So 'LOAD' is NO longer included WITH V7 UDB/DB2 for OS/390???????
How completely OUTRAGES!!! I guess it's time to take those Oracle classes now!
Craig Patton DB2 DBA
>From: Jim Ruddy >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Priced Utility Features >Date: Wed, 24 May 2000 14:32:34 -0500 > >Rohn, You are interpreting "enhanced utility functions" in a more granular >form than you should. For example, LOAD is an "enhanced utility function". >You get to choose which vendor will provide your utilities. Pick the vendor >that provides the price/function/performance that best fits your needs. > [...]
14680 32 27_Re: Priced Utility Features13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Wed, 24 May 2000 15:03:41 -0500500_us-ascii How can you have a database without a utility as basic as LOAD? How can you call DB2 a complete database when you don't even supply it with the basic utilities to maintain it? Can it even meet the requirements of a "DATABASE" anymore? Are you taking away the backup and recovery functions too? When you start removing functionally, you take away all the things I used to brag about to the Oracle users. You make it real hard to complete in a shop which is already moving toward Oracle. [...]
14713 28 27_Re: Priced Utility Features0_31_truman.g.brown@BELLATLANTIC.COM31_Wed, 24 May 2000 16:13:24 -0400427_us-ascii Lots of complaints.
At one point it looked like IBM was going to "freeze out" 3rd party DB2 software utility vendors - I would imagine that caused some flack and threats of anti-trust suits.
Remember that big blue has had anti-trust problems before (the "consent decree" days), and by offering DB2 cafeteria style can point out that they're supplying a level playing field for BMC, Platinum, et al. [...]
14742 34 30_Re: Priced Utility Features V79_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 24 May 2000 14:31:51 -0600614_us-ascii Jim,
Can you release the source IBM bought the new "LOAD" utility from and did the purchasing of the LOAD utility weigh heavily in the decision to charge for it separately or was that a pure marketing decision?
Thanks,
Rob
Jim Ruddy wrote: > > Rohn, You are interpreting "enhanced utility functions" in a more granular > form than you should. For example, LOAD is an "enhanced utility function". > You get to choose which vendor will provide your utilities. Pick the vendor > that provides the price/function/performance that best fits your needs. > > Jim Ruddy > DB2 for [...]
14777 50 30_X'00E40322' in an online reorg23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 May 2000 21:21:56 +0100417_- Whilst I was performing an online reorg this week of a multi-tablespace I received the following and it abended ... anybody have any ideas why?
I can see it was upset about the index on the mapping table .. but why. I had 6 streams running reorg multi-table tablespace .. and one or two went over with this. I thought it may be due to the number running .. but not so as I got this when run on its own. [...]
14828 182 35_Re: Java and Stored Procedures Help13_OConner, John26_John.OConner@COURTS.WA.GOV31_Wed, 24 May 2000 13:32:08 -0700352_iso-8859-1 Below is the source from a test I did a while back. The Java program that is listed below was run from unix system services on OS/390 (I think 2.5), and the Stored Procedure source code is include below that.
Some things have changed since I last ran this (a year ago?), but it did work at one time. We were DB2 5.1 at the time. [...]
15011 38 11_DB2 connect15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Wed, 24 May 2000 16:39:11 -0400364_iso-8859-1 To all list users.
I should say thank you to all of you for helping me many many time. Now I have another question.
I was trying to connect to DB2 from SQLserver using Linked server. This is like DRDA. We can write distributed SQL using both SQLserver table and DB2 table. I used DB2 Connect ODBC driver and getting following message [...]
15050 44 26_DB2 V6 on AIX weirdness...10_Mike Wiles14_mwiles@UCG.COM31_Wed, 24 May 2000 16:40:12 -0400492_iso-8859-1 Hi everybody!
I am running DB2 V6 on AIX. Last night I started a db2move of some data from an NT V5 database. I had a lot of time, and this migration was more of a test than anything, so I let it go. I assumed that it would be fininshed by the time I came in the next morning. It wasn't. I am not aware of any way to check the status of a db2move, so I dug around in the db2diag.log and found that the log files had been filled by 7am. In haste, I stopped the terminal [...]
15095 30 44_DB2connect : SQL10007N Message "-1092" on NT13_Tierney, Mark20_mtierney@FIRSTAM.COM31_Wed, 24 May 2000 16:08:01 -0500529_- Greetings.....
I know that this has been addressed previously, but not being an NT person I have a follow-on question. The problem has been described as the installer needing local NT administrator privilege to the workstation that the software is being installed on. Does that mean that the admin id would be used when logging onto only the local machine/domain? Do we bypass the logon prompt since the install is only on the local machine? Any additional information describing this would be greatly appreciated. [...]
15126 31 29_VSAM, DB2 coordination on VSE14_Frank Fillmore26_frank_fillmore@HOTMAIL.COM29_Wed, 24 May 2000 17:21:12 EDT397_- Hey clan, I have a customer that want to modify an existing VSAM file application so that all adds, changes, and deletes will be reflected in DB2 tables - sort of like two-phase commit between VSAM and DB2. In essence, the VSAM files and DB2 tables will be full copies of one another. I know there are tools to do this, but we're trying to accomplish it on an application basis. Questions: [...]
15158 59 33_Re: VSAM, DB2 coordination on VSE20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 24 May 2000 17:36:06 -0400297_us-ascii For batch you could consider RRSAF. It may be a bit complicated to start with but it is a great attachment facility for two phase commits. You need to define VSAM as a resource in RRS and then issue SRRCMIT in your application instead of DB2 commit to take care of two phase commit. [...]
15218 18 27_Re: Priced Utility Features9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 24 May 2000 16:32:47 -0500328_- No one said that the function was "being taken away". To get the same function (more actually, much more in-fact) than you have with V6, you just have to specify more options when you order V7. The pricing will be more granular than V6.
How does this drive you to Oracle? They charge separately for service calls. [...]
15237 103 27_Re: Priced Utility Features0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 24 May 2000 16:45:51 -0500528_iso-8859-1 , snicker, chuckle,
Jim, boy did your response hit a nerve with some people on the list
I guess it is a matter of definitions. When we buy DB2 are we buying a database or a Database Management System (DBMS). I guess most of us believed the former IBM position, as stated in the extract below that "DB/2" is a DBMS. But now you are telling us that as of V7 all we get is the DB, the "MS" we have to pay someone extra for! I'm real glad that the price not coming directly out of my pocket. [...]
15341 15 30_Re: Priced Utility Features V79_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 24 May 2000 16:45:16 -0500449_- We don't have a "new" LOAD utility - we have been enhancing the utilities significantly over the last several releases. We believe we are now fully competitive.
Jim Ruddy IBM DB2 Utility Development
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15357 70 48_Re: DB2connect : SQL10007N Message "-1092" on NT0_15_leon@CA.IBM.COM31_Wed, 24 May 2000 17:58:33 -0400581_us-ascii The install program for DB2 Connect needs to create Windows NT system services that will start every time DB2 Connect is started. It also needs to create user id (db2admin) under which these services will run. To perform both of these operations you need to have sufficient authority on the machine where DB2 Connect is being installed to create services and to create ids. The authority that is required is "Local Administrator". That means that when you sign on to do an install you need to sign on with the user id that belongs to he "Administrators" group on the [...]
15428 31 30_Re: Priced Utility Features V713_Toppins, Mike19_MToppins@UNIPAC.COM31_Wed, 24 May 2000 16:05:27 -0600431_iso-8859-1 So the "old" one will still be available as a "base" utility???
-----Original Message----- From: Jim Ruddy [mailto:jaruddy@US.IBM.COM] Sent: Wednesday, May 24, 2000 3:45 PM To: DB2-L@RYCI.COM Subject: Re: Priced Utility Features V7
We don't have a "new" LOAD utility - we have been enhancing the utilities significantly over the last several releases. We believe we are now fully competitive. [...]
15460 49 27_Re: Priced Utility Features0_25_Don.Alden@I-STRUCTURE.COM31_Wed, 24 May 2000 16:03:50 -0600512_iso-8859-1 For all of you that are thinking of saving money by migrating to ORACLE, as Jim mentioned, they charge for ALL service calls. And as I mentioned in an earlier reply, ORACLE is 4 to 5 times more expensive to purchase than DB2 for OS390.
Just in case your management is threatening to migrate from DB2 you might let them know that ORACLE (DOES NOT) use => COMPRESSION. This fact alone will TRIPLE your DASD costs if your company is thinking about jumping to "BIG RED" to save money. [...]
15510 40 30_Re: Priced Utility Features V79_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 24 May 2000 17:01:59 -0500729_- No.
On Wed, 24 May 2000 16:05:27 -0600, Toppins, Mike wrote:
>So the "old" one will still be available as a "base" utility??? > >-----Original Message----- >From: Jim Ruddy [mailto:jaruddy@US.IBM.COM] >Sent: Wednesday, May 24, 2000 3:45 PM >To: DB2-L@RYCI.COM >Subject: Re: Priced Utility Features V7 > > >We don't have a "new" LOAD utility - we have been enhancing the utilities >significantly over the last several releases. We believe we are now fully >competitive. > >Jim Ruddy >IBM DB2 Utility Development > >================================================ >To change your subscription options or to cancel your subscription visit the >DB2-L webpage at http://www.ryci.com/db2-l. [...]
15551 49 30_Re: Priced Utility Features V79_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 24 May 2000 17:03:22 -0500676_- Why would you want something that EVERYONE complained was too slow?
On Wed, 24 May 2000 17:01:59 -0500, Jim Ruddy wrote:
>No. > >On Wed, 24 May 2000 16:05:27 -0600, Toppins, Mike >wrote: > >>So the "old" one will still be available as a "base" utility??? >> >>-----Original Message----- >>From: Jim Ruddy [mailto:jaruddy@US.IBM.COM] >>Sent: Wednesday, May 24, 2000 3:45 PM >>To: DB2-L@RYCI.COM >>Subject: Re: Priced Utility Features V7 >> >> >>We don't have a "new" LOAD utility - we have been enhancing the utilities >>significantly over the last several releases. We believe we are now fully >>competitive. >> [...]
15601 69 30_Re: Priced Utility Features V713_Toppins, Mike19_MToppins@UNIPAC.COM31_Wed, 24 May 2000 16:16:02 -0600419_iso-8859-1 1) Because there is already so many jobs in place in production already. 2) It works. 3) It's part of the product as currently delivered. 4) ...
-----Original Message----- From: Jim Ruddy [mailto:jaruddy@US.IBM.COM] Sent: Wednesday, May 24, 2000 4:03 PM To: DB2-L@RYCI.COM Subject: Re: Priced Utility Features V7
Why would you want something that EVERYONE complained was too slow? [...]
15671 13 34_Re: X'00E40322' in an online reorg9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 24 May 2000 18:04:02 -0500348_- Could be that your mapping table index is not large enough.
Jim Ruddy IBM DB2 Utility Development
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15685 80 68_Re: Priced Utility Features V7 - Who would want the old u tilities ?15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Thu, 25 May 2000 09:32:02 +1000409_iso-8859-1 Well, no disrespect Jim, but I don't recall ever complaining to IBM that their LOAD utility was too slow.
At Macquarie Bank we ZERO 3rd party utilities (We have RC/Migrator but that is not strictly a utility). We have looked at them from time to time, but they are not cost effective for our purposes as adding a full set of 3rd party utilities would be SEVERAL TIMES the price of DB2. [...]
15766 15 43_Generate DDL in Control Center doesn't work7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Wed, 24 May 2000 19:42:34 -0500417_- Hi,
I am trying to generate DDL for a database using UDB Control Center. However, when I click on the button 'Generate' nothing happens.
What am I doing wrong?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15782 40 15_Re: Replication12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Thu, 25 May 2000 13:06:36 +1200515_us-ascii Geoff,
We've got DProp/R here and, while a bit complicated, it seems to do the trick. Actually, we're trying to get rid of it because it's a bit too complicated to run and because (for us, anyway) is uses about 7-8 times the CPU than is used to query our MIS-type DB. We're looking at rebinding the query packages with UR and using WLM to kill any nasty queries, then route people back to the real OLTP for their queries. Saves DProp/R Capture, Apply, a DB2 subsystem and a whole lotta cycles. [...]
15823 151 36_Re: Double Byte Character Set (DBCS)11_John Matear27_John.Matear@BANKWEST.COM.AU31_Thu, 25 May 2000 09:33:13 +0800489_us-ascii Tony, Thanks for that information. Am I correct in assuming that the only way to enable DBCS is to set MIXED DATA = YES in DSNHDECP.
If we only had the one DB2 subsystem this would be fine but we currently have multiple subsystems using the same DSNHDECP. We would not want all of these subsystems to have DBCS enabled. What would be the best approach for this? Separate DSNHDECP for the DBCS enabled subsystem? We currently only have one DSNHDECP for all subsystems. [...]
15975 62 30_Re: DB2 v6.1 upgrade on AIX...12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 24 May 2000 18:30:10 -0700609_us-ascii just follow the readme instructions and it works just fine. I upgraded the EEE version. Make sure you've got the latest version (6.1) of the Control Center on first, cause the 5.2 version won't work with 6.1 on the server. Realize that you're going to upgrade ALL the instances on the AIX box. I thought I could just upgrade one instance, but had an AIX "learning experience' --- "Whiting, George" wrote: > Is v5.2 the most current AIX? > > > -----Original Message----- > > From: Ragam, Sai J [SMTP:Sai.Ragam@BNSF.COM] > > Sent: Wednesday, May 24, 2000 10:26 AM [...]
16038 75 19_Re: DB2 table names14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 25 May 2000 11:44:09 +1000407_iso-8859-1 Jaydeep,
1) Read the SQL Ref Manual section on Identifiers/SQL Identifiers/Ordinary identifiers (Sect 3.3.1.1 in OS390 V6) "An ordinary identifier is a letter followed by zero or more characters, each of which is a letter, a digit, or the underscore character."
2) Which version of DB2 are you using? At OS390 V6, you have to use a delimited identifier to create such a table. [...]
16114 48 34_Re: X'00E40322' in an online reorg23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 25 May 2000 05:55:52 +0100466_iso-8859-1 Jim I thought that .. but the indexes are sized with very large Pri and Sec QTYs. (and it went over pretty quickly at the start). You have made me think of one thing though which I will go away and test.
Anybody else have this before?
regards
Leslie
-----Original Message----- From: Jim Ruddy [mailto:jaruddy@US.IBM.COM] Sent: Thursday, May 25, 2000 12:04 AM To: DB2-L@RYCI.COM Subject: Re: X'00E40322' in an online reorg [...]
16163 198 51_Re: Help ! Perfomance Problem with SUM(*) in db2 v523_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 25 May 2000 06:04:34 +0100518_iso-8859-1 Monica
..please do not be ashamed. If I had a pound for every time I used to assume something was correct I would be a rich man now.
Any trainees that I have to educate these days get given some magical words at the start which have stood me in good stead for the whole of my life - "trust nobody". Not to be take quite 100% but when you are faced with a problem (performance of other) then it pays to cover all the ground with your own eyes from the top to the bottom, then you can make [...]
16362 91 36_Re: RES: DB2 Log records recovery !!11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Thu, 25 May 2000 14:25:11 +0800571_iso-8859-1 Please send me a copy too. e-mail address : rolandchua@singaporeexchange.com Thanks
Roland
Walter De Assis Guimaraes @RYCI.COM> on 12/05/2000 08:21:49 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: RES: DB2 Log records recovery !!
Ed.
I am interested too. Please send it to walter.guimaraes@unibanco.com.br [...]
16454 27 27_Re: Priced Utility Features14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 25 May 2000 08:50:14 +0200350_us-ascii Hi JIm, I read your post and i can say that :
I Know three italian big companies that are migrate from S/390-DB2 to SUN/HP host-like (and
ORACLE as dbms) and I know many others who are evaluating this kind of migration.
What you say it'll be nice IF DB2 price will be reduced since you haven't any utility any more [...]
16482 59 27_Re: Priced Utility Features14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 25 May 2000 09:23:49 +0200392_us-ascii And what's next ? Have we to pay for every SELECT we'll do (as 'enhancement' of new
mega-multi-super-tera-furlong-Cindy-optimizer) ? Exasperating what it's going to happen I can
image this....in DB2 V 10 or 12.
And I'm not so sure that a migration from DB2 to ORACLE is so expensive, or do you think that all managers who decided this are all drunk ? :-))) [...]
16542 59 27_Re: Priced Utility Features23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 25 May 2000 08:41:47 +0100496_iso-8859-1 Can I put my penny worth in?
I think we need to all wait until the exact details come out of what is and what is not in the product. I agree that IBM need to tread easily with V7 and what is and what is not in the product .. but my view is that they have realized that companies "do" buy third party products .. why .. speed .. functionality ... etc .. now if they deliver these things and you can dump your 5Million pound contract with Company A or B or C .. then you may [...]
16602 101 30_Re: Priced Utility Features V70_18_mebert@AMADEUS.NET31_Thu, 25 May 2000 09:54:02 +0100555_us-ascii Remember that for the people handing out the big bucks the only competitive argument is the discount off the list price. And certainly Oracle doesn't cost 4-5 times what DB2 costs - otherwise there wouldn't be so many shops moving to Oracle/Unix - managers aren't that stupid. While I do agree that DB2 is probably the best choice if you want performance and stability (that's DB2 on OS/390 of course), thinking that this is enough can drive you out of business pretty quickly in today's world. See OS/2 vs. Windows, or Apple vs. Microsoft. [...]
16704 20 34_Re: X'00E40322' in an online reorg14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 25 May 2000 09:54:04 +0200485_us-ascii May be that the volume where you created mapping index is out of space. Have you any
00D70014 or 00D70025 (or 00D7xxxx ) error to indicate vsam acces method failure (in SYSLOG or in DB2 address space)?
Regards Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16725 45 32_Are IDENTITY columns of any use?14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 25 May 2000 19:06:22 +1000345_iso-8859-1 Hi all,
It has been some time since the use of IDENTITY columns was last aired. I am wondering if anyone has had positive experiences (or expectations) in their use. My impression is that , apart from some uses to row placement and setting partition boundaries, the poor implementation means they have no usefull purpose. [...]
16771 57 34_Re: X'00E40322' in an online reorg23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 25 May 2000 10:42:21 +0100288_iso-8859-1 Max nope none of those .. I thought it may be dasd / vsam related .. but we are SMSd here and thinsg grow easily without worry.
and I also had loads of on-line reorgs running at the same time .. no problem.
I have one things I must try and will report back. [...]
16829 26 0_10_Leo Robles25_roblesl@CELLULARONEPR.COM31_Thu, 25 May 2000 08:04:33 -0400
16856 76 30_Re: DB2 V6 on AIX weirdness...10_Leo Pedron19_lpedron@BOSCOVS.COM31_Thu, 25 May 2000 08:37:58 -0400573_iso-8859-1 SQL1611W is normal to see when it is issued and there aren't any applications currently connected to the database.
I'm going to assume that you were running a DB2MOVE export to draw data out of your database. This will produce a list of the tables and the number of rows exported on the screen where you started it. Also in the directory that you are exporting the data to will have two files you should look at. One is called export.out and one is called db2move.lst. The export.out file contains a listing of all the tables exported and the number [...]
16933 74 27_Re: Priced Utility Features14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Thu, 25 May 2000 09:05:46 -0400523_us-ascii WOW - take it form someone who did not get to attend IDUG last week - This thread has generated more list traffic then we had in all of last week ;-)
We are all mature adults, and given the full details at the time of making our decisions to move on to the next level, some can choose Oracle (if they must) and some that will benefit can go the (possibly) more expensive route of V7 - but others like us (small shops with limited budgets) may choose to stand and fight. V6 could be the last version me [...]
17008 183 36_Re: Double Byte Character Set (DBCS)19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 25 May 2000 08:06:05 -0500645_ISO-8859-1 John, DSNHDECP is assembled into SDSNEXIT. Ask around, I think you'll find a separate SDSNEXIT used for each DB2 subsystem.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, [...]
17192 105 47_Re: Repost: IBM Software Group Launches New Ads14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Thu, 25 May 2000 09:27:09 -0400634_us-ascii Ahhhh - a possible new forum for those concerned about the V7 pricing issue ;-)
Bill G.
Morrill, John wrote:
> Greetings! > > Below is a posting from Mike Swift's DB2 Interested Parties mailing > list. .... > ================================================= > > Dear DB2 Interested Parties, > > A comprehensive ad campaign was launched this week by DB2's division > within IBM, the IBM Software Group (see below), which aims to > ... > specifically focused on IBM's data management solutions (DB2). > .... > Feedback? Let me know what you think about this IBM software group > advertising campaign [...]
17298 74 15_Re: Replication10_Mike Paris14_MPARIS@TUC.COM31_Thu, 25 May 2000 08:30:22 -0500418_US-ASCII Raymond.
What kind of info are you looking for on the AIX side?
We have 4 AIX production machines moving data back and forth to two OS390 subsystems for the past 2 years.
You can contact me offline if you like.
Michael Paris
Senior Database Analyst IBM Certified Solutions Expert DB2 UDB Database Administration IBM Certified Advanced Technical Expert Data Replication [...]
17373 77 36_Re: Are IDENTITY columns of any use?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 25 May 2000 09:41:24 -0400439_us-ascii >> there is no means of determining the value placed in a just-inserted row, >>unless there are already unique values in the row
Yes, You could get the value just inserted. I remember Jim Teng was mentioning something about it.
-----Original Message----- From: James Campbell [SMTP:James.Campbell@HANCORP.COM.AU] Sent: Thursday, May 25, 2000 5:06 AM To: DB2-L@RYCI.COM Subject: Are IDENTITY columns of any use? [...]
17451 80 30_Re: DB2 v6.1 upgrade on AIX...11_Steve Mazer17_smazer@FMTUSA.COM31_Thu, 25 May 2000 09:27:18 -0400622_us-ascii George, Who said you had to upgrade ALL instances on the AIX machine? Version 6 gets installed in /usr/lpp/db2_06_01 while Version 5 is in /usr/lpp/db2_05_00. We have instances of DB2 UDB EEE at different levels (5 and 6) on the same set of nodes.
Regards, Steve Mazer Fourth Millennium Technologies
At 06:30 PM 5/24/00 -0700, you wrote: >just follow the readme instructions and it works just >fine. I upgraded the EEE version. Make sure you've >got the latest version (6.1) of the Control Center on >first, cause the 5.2 version won't work with 6.1 on >the server. Realize that you're [...]
17532 225 36_Re: Double Byte Character Set (DBCS)11_Pedro Cunha24_pedro.cunha@CAIXA.GOV.BR31_Thu, 25 May 2000 10:42:42 -0300337_iso-8859-1 Hello,
I would suggest having a separate dataset containing the DSNHDECP with MIXED DATA = YES and concatenating it before the SDSNEXIT common to all DB2s, but only in the affected DB2 subsistem. We have in our site only one SDSNEXIT for all DB2 subsistems and have different names for every ZPARM for each one of them.
17758 122 16_Re: SQLCODE +10116_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Thu, 25 May 2000 06:54:27 -0700355_iso-8859-1 I've haven't seen a +101, but I have seen DSNT413I. As far as I can recall, it's always been a result of the SQLCA being overlaid in the program, like from an array that's gone beyond it's bounds.
Tony Provenzola Nike Database Services BEST Consulting * Phone: (503) 532-0772 * Fax: (503) 532-2618 * Email: Tony.Provenzola@nike.com [...]
17881 361 94_Repost: "IBM's eBusiness Database -- DB2 Universal Database" (IDC Research Report, April 2000)13_Morrill, John12_JohnM@VP.NET31_Thu, 25 May 2000 07:59:37 -0600690_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties
Carl Olofson, Research Director, Application Development and Deployment, IDC Research has recently published a report on DB2 UDB for UNIX, Windows, OS/2 Version 6. Below are some highlights from the paper. I can send the .pdf file of the report to you if you wish (238 Kbytes). [...]
18243 30 43_FOCUS DB2 v6 Precompile fails, was OK in v512_Ron Carlisle33_Ron.Carlisle@COUNTRYCOMPANIES.COM31_Thu, 25 May 2000 08:51:27 -0500672_iso-8859-1 The Information Builders, Inc. FOCUS DB2 and SQL/DS Read/Write Interface version 7.09 precompile fails under DB2 v6, because source code includes the SQL statement “COMMIT WORK RELEASE”. This is understandable, since the syntax for COMMIT does not mention “RELEASE” as an allowable suffix.
However, FOCUS version 7.08 source code also contains “COMMIT WORK RELEASE” which must have precompiled and bound under DB2 v5 SUCCESSFULLY, since it is currently running (survived the migration to DB2 v6) and “COMMIT WORK RELEASE” exists in sysibm.syspackstmt.stmt. DB2 v5 SQL Reference regarding COMMIT syntax is the same as v6. It would appear that DB2 v6 [...]
18274 84 36_Re: Are IDENTITY columns of any use?0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 25 May 2000 09:11:20 -0500442_us-ascii James:
One of your points has been addressed by an APAR PQ36328 . I was just reviewing the Technical Update document that discusses features in the May Refresh. A new function IDENTITY_VAL_LOCAL() has been added to retrieve the value of the identity column just inserted into a table.
You can find the book "DB2 UDB Server for OS/390, Version 6 Technical Update (SC24-6108)" on the Web http://www.ibm.com/redbooks [...]
18359 23 36_Re: Are IDENTITY columns of any use?0_14_amreed@AEP.COM31_Thu, 25 May 2000 10:09:23 -0400382_us-ascii The IDENTITY_VAL_LOCAL() function returns the most recently assigned value for an identity column that was populated by a singel row insert.
e.g. SET :HV = IDENTITY_VAL_LOCAL(). The result is DECIMAL(31,0).
This information is available in an IBM redpiece titled DB2 UDB server for OS/390 V6 Technical Update.
I hope this helps, Alan Reed DBA AEP [...]
18383 49 17_DB2 AIX Questions22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 25 May 2000 07:44:09 -0700448_- Hello List,
I am a newbie where DB2 AIX is concerned and had a developer ask me the following two questions that I have no clue about. Any insight, help, answers or directions to reference materials would be appreciated.
Question 1 : Is there a limit (and if so What is it) of the number of connections to DB2 on AIX. In other words, what is the limit of the number of processes that are communicating with DB2 simultaneously. [...]
18433 81 21_Re: DB2 AIX Questions10_Leo Pedron19_lpedron@BOSCOVS.COM31_Thu, 25 May 2000 11:20:23 -0400514_iso-8859-1 There is a limit to the number of connections that you can have to DB2 and that is set with the max_coordagents. The maximum number of coordagents that can be communicating with DB2 at once is set with maxcagents. For example, if max_coordagents is set for 600 and maxcagent is set for 400, then 400 DB2 can be servicing up to 400 connections at once, and any connections beyond 400 would wait for other to finish before they could execute, but up to 600 connections could be made to the instance. [...]
18515 109 30_Re: Priced Utility Features V711_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US31_Thu, 25 May 2000 10:18:37 -0500393_- I would like to know whether the IBM copy and recover utilities would also be priced out as separate "enhanced" utilities in V7. My inpression is that there will be no "basic set" of utilities. You either buy the enhanced utilities or nothing at all. And will the IBM utilities be priced out separately as individual utilities or will we have to obtain a "suite" of enhanced utilities? [...]
18625 16 12_SQL activity13_Tomassi, Aldo20_Aldo_Tomassi@BMC.COM31_Thu, 25 May 2000 10:29:48 -0500409_ISO-8859-1 I need to reconstruct all SELECT statements executed on a DB2 subsystem on certain tables, possibly avoiding a subsystem block. Any suggestion ? Thanks Aldo
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18642 120 30_Re: DB2 V6 on AIX weirdness...10_Mike Wiles14_mwiles@UCG.COM31_Thu, 25 May 2000 11:36:36 -0400409_iso-8859-1 Thanks for the response Leo!
Actually, I had done a "db2move export" from an NT v5.2 database. I recreated the tablespaces and tables in AIX, then did a "db2move import". This is what I cancelled, and what started the madness. The 14th table of the 50 that I was moving was rather big, and took much longer than I thought it would (17 hours at that point,) so I killed it. Big mistake! [...]
18763 36 16_Re: SQL activity20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 25 May 2000 11:39:26 -0400320_us-ascii Tough. For static SQLs you could use IFCID 60 and 65 (SELECT INTO & OPEN) for all plans that might hit that table and then filter out later. For dynamic SQL, only choice is initiate IFCID 63 and filter later.
That could be huge data to filter through. I wish there could have better way to do this. [...]
18800 26 16_Re: SQL activity9_Rob Crane22_racrane@CONCENTRIC.NET31_Thu, 25 May 2000 10:08:13 -0600539_us-ascii Detector from Computer Associates Apptune from BMC
--------------------------------- "Tomassi, Aldo" wrote: > > I need to reconstruct all SELECT statements executed on a DB2 subsystem on > certain tables, possibly avoiding a subsystem block. > Any suggestion ? > Thanks > Aldo > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
18827 147 30_Re: Priced Utility Features V718_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Thu, 25 May 2000 11:56:34 -0400505_iso-8859-1 Tony: I agree with you on this. They (IBM) need to get their act together. But as a former employee who use to bleed 'IBM Blue' for 20+ years I can tell ya they are real good at shotting themselves in both feet. Without even having to aim... (my opinion and no one elses). I think there will be alot of discussion on this but if/when the time comes for us to go to V7 we will look alot more carefully into what its going to cost us. No more taking it on face-value if you will. We use 3rd [...]
18975 105 21_Unique vs Primary Key23_Donald W. Woodruff, Jr.30_dwoodruf@CI.NEWPORT-NEWS.VA.US31_Thu, 25 May 2000 11:57:15 -0400547_iso-8859-1 Hello all:
First, please excuse me if this is a simple question.
Is there any difference between Unique keys and Primary Keys in a table definition?
We are running DB2 for OS/390 v5.1.
This is my understanding of a Unique key (from my reading and testing):
Using a Unique key in a table definition is the same as a Primary Key definition. Meaning, we can have Foreign Keys that relate to our Unique key(s) acting as the parent. Having this capability allows a table to have multiple parent keys. [...]
19081 138 30_Re: Priced Utility Features V720_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Thu, 25 May 2000 10:57:31 -0500540_iso-8859-1 All, Do you really believe that IBM is going to abandon its customer base and cause many of them to migrate to Oracle. Most of us that currently use BMC or CA(Platinum) utilities will in all likelihood be paying less dollars to the almighty software gods even if the IBM utilities are separate products. For the smaller shops out there, I'll bet that IBM provides alternate pricing to keep those of you on the DB2 platform with utilities. Keep your heads, the sky is not falling. Bill Johnson DBA Allstate Insurance Company [...]
19220 25 36_Online Reorg/Image Copy by Partition0_20_bjnigh@HOUSEHOLD.COM31_Thu, 25 May 2000 09:31:37 -0700373_us-ascii I have an application which will insert 1 million rows and delete another 1 million rows from a table each day. The application is critical and will need to perform as efficiently as possible. The table will hold at most 7 million rows. I had to partition the table due to the 4GB VSAM limit. The table is partitioned by account number and has 32 partitions. [...]
19246 123 46_Re: Priced Utility Features and Tiered Pricing12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 25 May 2000 09:39:13 -0700564_us-ascii Max- You may be able to do this... A couple of years ago, I installed an IBM component called the "multi user access license charge" (MULCH - had nothing to do with Cindy, but that would be an interesting enhancement) to use with their Batch Pipes product which essesentially tracked MVS software usage via SMF data. You paid IBM at the end of the month, based on how many megabytes of data was pumped through the Pipes product. For small applications, on large machines, this had the effect of reducing your costs. But once the genie was out of the [...]
19370 53 40_Re: Online Reorg/Image Copy by Partition15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 25 May 2000 11:47:45 -0500401_iso-8859-1 That would depend on how often you are reorganizing your data. How often do you do it now? I would assume that it is quite often since such a large percentage of your rows are changed every day. If you are reorganizing once a week or so then don't do another image copy. That would be redundant. If quick recovery is an issue then consider incremental image copies between the reorgs. [...]
19424 44 27_Re: Priced Utility Features9_Jim Ruddy18_jaruddy@US.IBM.COM31_Thu, 25 May 2000 11:46:53 -0500329_- I knew that the discussion would be lively when our executives decided that the utilities would be packaged and priced separately and that we wouldn't have the details finalized when we announced V7 - that the customers would have to wait until we announce general availability.
Beyond the shock are some concerns: [...]
19469 26 36_Northern Oregon User's Group meeting12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 25 May 2000 10:16:03 -0700429_us-ascii NODE, The Northern Oregon RDBMS User's Group next meeting will be held on June 5, in Portland. Topics include WEB-enabling DB2. It's also one of the few things that's still free! Go to http://www.geocities.com/db2ug for details. If you'd like to get on the mailing list (and you're not on it if you haven't already gotten a personal invitation) drop me a note offline of the db2-l list. See you there. Tim Malamphy [...]
19496 53 25_Re: Unique vs Primary Key24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 25 May 2000 10:15:28 -0700351_- Please don't take this wrong, but you're a little off base. The primary key is used to identify a column or set of columns which uniquely identify a row in a DB2 table. It requires a unique index to be defined for it, and referential integrity rules can be established to relate other tables to that table based on it's primary key definition. [...]
19550 64 25_Re: Unique vs Primary Key14_Backes,Michael26_BackeM@MAIL.OA.STATE.MO.US31_Thu, 25 May 2000 12:50:24 -0500573_iso-8859-1 i believe you are mixing two different things. i do not know of any unique key syntax that exists.
you can have primary and foreign keys. period. a primary key on a column or columns then 'forces' you to have a 'unique' index on the key columns. thus in effect making the primary key column(s) unique.(hence the confusion i believe), but it is the index with the unique(ie. create unique type 2 index) that enforces it, The primary key designation simply forces you to have the unique index. because in theory you can have a table that has a primary [...]
19615 82 25_Re: Unique vs Primary Key19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Thu, 25 May 2000 13:56:28 EDT373_us-ascii Hi,
Just like to add that during data modelling, you could have entities that are identified by more than one key, all of which are unique, and are known as candidate keys. This is especially true when you have keys that are composed of multiple attributes. Depending on your business needs you will decide on one of these keys to be your Primary key. [...]
19698 42 16_Re: SQL activity13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Thu, 25 May 2000 13:09:12 -0500551_us-ascii Compuwares's DBA-Xpert has a batch job that extracts data from SYSIBM.SYSSTMT and SYSIBM.SYSPACKSTMT . It massages the data and load the column impact table. This table can then be accessed from screens within DBA X-pert, but the screens are slow. My programmers use QMF queries against the table. It has information on everywhere a column for a table is used: SELECT, UPDATE, DELETE, INSERT, WHERE clause, GROUP BY clause and ORDER BY clause. This is a very fast why to find out what is happening to a column or a table in your system. [...]
19741 68 27_Re: Priced Utility Features12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 25 May 2000 21:11:00 +0200571_x-user-defined Hi,
As management always says: "You must save, never mind how much it costs" ;))
Isaac Yassin
Don.Alden@I-STRUCTURE.COM wrote: > > For all of you that are thinking of saving money by migrating to ORACLE, as > Jim > mentioned, they charge for ALL service calls. And as I mentioned in an > earlier > reply, ORACLE is 4 to 5 times more expensive to purchase than DB2 for OS390. > > Just in case your management is threatening to migrate from DB2 you might > let them > know that ORACLE (DOES NOT) use => COMPRESSION. This fact alone [...]
19810 104 27_Re: Priced Utility Features12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 25 May 2000 21:12:04 +0200537_x-user-defined Hi,
Can it be that the "MS" in DBMS stands for MicroSoft ??? ;))
Isaac Yassin
Rohn.Solecki@MTS.MB.CA wrote: > > , snicker, chuckle, > > Jim, boy did your response hit a nerve with some people on the list > > I guess it is a matter of definitions. When we buy DB2 are we buying a > database or a Database Management System (DBMS). I guess most of us > believed the former IBM position, as stated in the extract below that > "DB/2" is a DBMS. But now you are telling us that as of V7 all [...]
19915 45 27_Re: Priced Utility Features14_Frank Fillmore26_frank_fillmore@HOTMAIL.COM29_Thu, 25 May 2000 14:17:38 EDT471_- I asked the "will the base price go down if you charge separately for the utilities" question during the panel discussion at IDUG and detected a definite chill in the response. Even so, I feel that the following warrants a reponse.
>2. You won't migrate beyond V6 because the cost will be higher. Red >herring. >V5 cost more than V4 and V6 cost more than V5. If you thought that V7 would >cost less than V6 then you don't understand business. [...]
19961 76 25_Re: Unique vs Primary Key11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 25 May 2000 13:58:34 CDT336_- Donnie:
Contrary to other opinions you have received so far, I see that you do have a point. While it is true that Primary Key is a logical concept and Unique Index is a physical concept, in DB2 they are tied together by requiring that a PK must have a unique index supporting it (otherwise the definition is incomplete). [...]
20038 34 17_Great Opportunity13_Burquest, Jon26_john.burquest@NEONSOFT.COM31_Thu, 25 May 2000 13:09:23 -0600452_iso-8859-1 Hello all,
I have a critical need right now for two Senior DB/2 developers to work on a new product for NEON in our Denver headquarters(see www.neonsoft.com) The right candidates will have strong DB/2 development skills and will have done modeling(ERwin) and stored procedures work. It would be great if they knew C/C++ and Unix as well. Messaging experience(IBM's MQ Series or other proprietary queuing systems) would be great. [...]
20073 60 25_Re: Unique vs Primary Key19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 25 May 2000 15:04:41 -0500360_ISO-8859-1 Hi Donnie, Boy, your simple question really stirred the pot. First things first. Why do you find a need for multiple unique keys (UKs) each participating in a referential constraint in a single table? Wouldn't that violate 3rd normal form? See DB2 UDB/OS390 V6 SQL REF., bookmanager ref. 6.32. A foreign key can be set up on either a PK or UK. [...]
20134 47 25_Re: Unique vs Primary Key23_Donald W. Woodruff, Jr.30_dwoodruf@CI.NEWPORT-NEWS.VA.US31_Thu, 25 May 2000 16:25:35 -0400581_iso-8859-1 To all who responded:
I appreciate the responses, I apologize if my first message was some what vague and did not completely explain the point I was trying to get across.
Suresh, thanks for the response as well as understanding my point.
Basically, I could not see any difference between a Primary Key and a Unique key ("Unique-constraint" as defined in a "CREATE TABLE" statement) as of DB2 v5 for OS390. Granted you can only have one primary key in a table which is the basis of the Relational Model, but if a unique key can take on the same [...]
20182 84 47_Re: FOCUS DB2 v6 Precompile fails, was OK in v512_Michael Deer20_Michael.Deer@UAL.COM31_Thu, 25 May 2000 14:00:38 -0500489_- Ron - We hit this problem as well. You need to remove 'RELEASE' from 'hlq.EDALIB.DATA(DB2PARMS)'. This affects both FOCUS and EDA.
-Mike ---------------------------------------- Michael Deer, JD, MBA Engineer - Computer Systems United Airlines (847) 700-7065
---------- From: DB2-L(a)RYCI.COM Sent: Thursday, May 25, 2000 8:59 AM To: DB2-L(a)RYCI.COM Cc: Ron.Carlisle(a)COUNTRYCOMPANIES.COM Subject: FOCUS DB2 v6 Precompile fails, was OK in v5 [...]
20267 33 34_Restoring a db2look generated DDL.16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM31_Thu, 25 May 2000 13:33:33 -0700286_iso-8859-1 Hello all, This is probably a dumb question with an obvious answer, but I cannot seem to find it anywhere. I have a DDL file generated by the 'db2look' command that I'm trying to restore into another system. I'm not entirely sure how to make the database parse the DDL. [...]
20301 59 38_Re: Restoring a db2look generated DDL.11_Jakobs, Jef18_JJakobs@HARTIS.COM31_Thu, 25 May 2000 15:44:48 -0500378_iso-8859-1 Try
db2 -tvf database.ddl > output.txt
This will define the semicolon as command separator, and will turn verbose on, so you can see what happened.
The f tells db2 to take input from a file (for example database.ddl)
Be sure to connect to a database, and be sure to disconnect using "terminate". "Quit" will not end the connection... [...]
20361 54 46_Re: Priced Utility Features and Tiered Pricing11_Jon Nolting18_nolting@AMDAHL.COM31_Thu, 25 May 2000 13:42:10 -0700605_us-ascii Amdahl has introduced Multiple Server Feature to help customers try and manage software costs in just such a situation. With MSF, you could upgrade your physical processor to accomodate the new workload. However, you would run the particular domain(s) for this workload in a new MSF server on the physically upgraded machine. We have worked with many 3rd party ISVs who will only charge for their software based on the MSF server the software is used in. In this case, however, IBM is less restrained in that they charge for their software based on the entire physical machine regardless of [...]
20416 114 25_Re: Unique vs Primary Key13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Thu, 25 May 2000 16:53:51 -0400380_us-ascii A few minor points. Not sure if they're applicable in your case.
In the "pristine" relational model, Primary Keys are required to be unique and non-Null. In DB2 for OS/390 V5, it is possible to create a Unique Where Not Null index. This would allow you to Insert rows where one or more of the columns are NULL, and may wreak havoc with your DBMS-enforced RI. [...]
20531 170 13_Sybase to DB223_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 25 May 2000 17:21:39 -0400731_iso-8859-1 Greetings !!!!!
We will be moving over some data from Sybase to DB2 fairly soon. Are there any gotchas to watch for ? Whats the best way/format to get data out of Sybase, which could be easily loaded into DB2 without much ado.
TIA
Sanjay
> -----Original Message----- > From: Lockwood Lyon [SMTP:Lockwood_Lyon@AMWAY.COM] > Sent: Thursday, May 25, 2000 4:54 PM > To: DB2-L@RYCI.COM > Subject: Re: Unique vs Primary Key > > A few minor points. Not sure if they're applicable in your case. > > In the "pristine" relational model, Primary Keys are required to be unique > [...]
20702 640 19_Re: Sort Pool Usage10_STEVE HOWE15_SHOWE@BCBSM.COM31_Thu, 25 May 2000 17:44:58 -0400321_iso-8859-1 > Joel, > The vpsize is 9000. I have included the STATS from Omegamon. Any > comments would be greatly appreciated. > > Virtual Buffer Pool Size= 9000 Hiperpool Size = 5000
VPOOL Buffers Allocated = 9000 HPOOL Buffers Allocated = 5000
VPOOL Buffers in Use = 7183 HPOOL Buffers Backed = 5000 [...]
21343 64 27_Re: Priced Utility Features12_Michael Deer20_Michael.Deer@UAL.COM31_Thu, 25 May 2000 15:37:43 -0500607_- re: the utility 'discussion'
I am in the rather unique position of being both an attorney and a DB2 systems programmer (go figure!). I am now convinced, and this is merely my opinion, that this new 'business model' for IBM utilities is very much related to the current direction the Microsoft antitrust case is headed. At a very abstract level, there is a strong similarity between 1) the Microsoft's alleged anti-competitive behavior in its including 'products' as 'part of the operating system' to squash the competition, and 2) what would likely happen to the DB2 3rd party tools market if [...]
21408 31 44_Moving the data between identical databases.16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM31_Thu, 25 May 2000 15:12:16 -0700459_iso-8859-1 Hello All, One more quick question about data replication into a test database.
I have two database with identical create definitions running on separate systems. It would, of course, be possible to use the EXPORT command to take the data from each table, then LOAD it into the DB on the other system, but is there any way to do a global EXPORT to create a dump of the entire databases contents to place into an identical db elsewhere? [...]
21440 56 48_Re: Moving the data between identical databases.10_Mike Wiles14_mwiles@UCG.COM31_Thu, 25 May 2000 18:23:54 -0400374_iso-8859-1 Assuming that the databases were on the same platform, you could: do a backup of the source redirected restore on the target drop the replication control tables that come out of the restore (they are for the source, not the target) run a script recreating the replication control tables on the target with the correct values (as dpropr will create for you.) [...]
21497 191 17_Re: Sybase to DB212_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM31_Thu, 25 May 2000 15:36:09 -0700332_iso-8859-1 Sanjay: In general, bcp the data out from Sybase in character format (not native). Ftp the file to the host. Load the file(s) into db2 table(s) with the LOAD util using external formats where necessary. Pay attention to any fields that might present problems (e.g., timestamps, binaries). Should work pretty smooth. [...]
21689 231 36_Re: Double Byte Character Set (DBCS)11_John Matear27_John.Matear@BANKWEST.COM.AU31_Fri, 26 May 2000 08:12:41 +0800550_us-ascii Hello Rick, No need to ask around. We have one SDSNEXIT that contains DSNHDECP and a zparm for each subsystem.
John Matear CBS Integrated Solutions Ltd
---------------------------------------- Message History ----------------------------------------
From: "DAVIS, RICK (SBCSI)" on 25-05-2000 09:06 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: John Matear/SDG/SS/BankWest)
Subject: Re: Double Byte Character Set (DBCS) [...]
21921 30 27_Re: Priced Utility Features12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Thu, 25 May 2000 19:12:52 -0500559_iso-8859-1 This is getting too Jesuitical. I understand the analysis, but it is far too deep to match the realities. The next claim will be this is part of a right-wing conspiracy to help Microsoft!
IBM may believe they have a chargeable feature. I do not, but they my well. How many places have simply assumed that they needed 3rd party utilities without actually trying IBM's? Will this get them to actually try IBM against the competition? If they do then IBM in Version 7 will win more than they will loose. Perhaps it is just good marketing? [...]
21952 337 21_Re: DB2 AIX Questions11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Fri, 26 May 2000 10:44:55 +1000502_iso-8859-1 Marty,
in addition to Leo's answer, if you were looking for "real-life experiences" with a large number of concurrent connections to DB2 AIX: we have been running up to 1200 concurrent connections without any problems - once we installed the necessary memory (4 GB in our case) and kept the number of triggers invoked by these connections down to a minimum. Mind you, most of our connections are normally asleep, typically only 20 or 30 are actually running SQL at any one time. [...]
22290 95 34_Re: WLM Stored procedures DSNTPSMP18_Michael Arlebrandt28_micke_arlebrandt@HOTMAIL.COM30_Fri, 26 May 2000 07:42:15 CEST503_- Thanks Jim and Dan,
I have been able to run Stored Procedure Builder and DSNTPSMP after adding STEPLIB for DSNLOAD, SYS1.LE370.SCEERUN and SYS1.CPP.SCBCCMP.
These libraries including the TSO command lib are included in the LINKLIST also.
Now the TSO ALLOCATE command works fine but I still have problem with the DELETE command (RC=-3), I have tried to STEPLIB SYS1.CMDLIB where the DELETE command is located, also included in the LINKLIST but still the DELETE command fails. [...]
22386 21 23_Question Load utility..20_Baskaran Subramaniam27_subramaniam.baskaran@DB.COM31_Fri, 26 May 2000 11:52:06 +0530373_us-ascii Hello List Users..
We are using DB2 load utility to load a table in Partioned Tablespace with RESUME (YES) & ENFORCE(YES).. The load file has duplicate keys... because of which the duplicate records are getting discarded. My requirement is that the table has to be loaded with one of these records and the other duplicate key records being discarded.. [...]
22408 45 27_Re: Question Load utility..14_Backes,Michael26_BackeM@MAIL.OA.STATE.MO.US31_Fri, 26 May 2000 01:30:04 -0500294_iso-8859-1 NOT SURE WHETHER OR NOT THERE IS A WAY IN THE DB2 LOAD UTILITY, A VERY EASY WAY IF YOU HAVE SYNCSORT IS A SIMPLE SORT OF YOUR INPUT FILE WITH A SUM FIELDS = NONE ON YOUR KEY FIELDS BEFORE YOU TRY TO LOAD IT. BASICALLY GETTING RID OF YOUR DUPLICATES BEFORE YOU TRY TO LOAD THEM. [...]
22454 108 27_Re: Priced Utility Features14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 26 May 2000 09:08:30 +0200332_us-ascii You can find this kind of managers in some Klingon planet or in Tatooine. Not in the Earth,
maybe outside the solar system.
If I have had such managers in my old companies I'd be the richest data admin in Italy.
They always said 'You MUST save at the MINIMUM cost' (I'm included in the cost....). [...]
22563 37 21_test....please ignore14_Popy A. Dimoka24_dimokap@INTERAMERICAN.GR31_Fri, 26 May 2000 10:57:38 +030019_iso-8859-7
22601 107 27_Re: Priced Utility Features14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 26 May 2000 10:03:05 +0200425_us-ascii Hi, Jim, very nice post...
1) & 2) Customers want a good, reliable and at resonable price product. I think that a product have to cost less if you cannot provided some 'historical' features like utilities. While you're saying that we have to pay more, more and more (plus more) every new DB2 version and that we have no choice. THIS is a real customer care. Congratulations, ORACLE will be verrry happy. [...]
22709 58 27_DB2 UDB to OS/390 Migration14_Popy A. Dimoka24_dimokap@INTERAMERICAN.GR31_Fri, 26 May 2000 11:07:36 +0300237_iso-8859-7 Hello list!
We are going to migrate an application from DB2 UDB V6 for NT to the mainframe,DB2 for OS/390 ver 5.Any ideas,books,references etc would be highly appreciated.
Thanks in advance,
Popy A. Dimoka
22768 57 8_Net.data7_revadee18_revadeev@SCB.CO.TH31_Fri, 26 May 2000 15:31:33 +0700250_windows-874 Dear all,
Now, my application is use Net.data (version 1.0.12) to select report data (BLOB datatype) from database (DB2) to show on web. But I don't know have any tools else can use like Net.data.
Thanks, Revadee Vichitchep.
22826 22 24_SYSLGRNX deletes on DROP28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Fri, 26 May 2000 03:26:45 PDT428_- As an update to the prior discussion, I've looked at the DB2 V1 R1 design docs and the oldest code I can access, V2 R1. Both use the phrase "cleanup utility logging on DROP" which is kind of vague but implies to me that they thought both SYSCOPY and SYSLGRNG would be cleaned up on the DROP, and that's not the way it works. I'm getting the feeling now that this is "working as always" rather than "working as designed". [...]
22849 23 29_Fw: Re: Unique vs Primary Key12_Kent Collins15_kcollins@WF.NET31_Fri, 26 May 2000 06:29:42 -0500245_iso-8859-1 Fritz, There are limitations which exist for Primary Keys that do not for Unique Indexes.( Nulls for example). I would define a Primary Key on a table only if that table will be defined as a Parent, meaning RI will be defined.
22873 56 19_Re: Sort Pool Usage14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 26 May 2000 08:15:30 -0400585_ISO-8859-1 Steve, Interesting data. What period was this for? If it's for a day (24hrs) it's less than meaningful for diagnosing a problem. We need to look at problem 'periods', not long intervals that probably include most periods of good performance.
Normally, the HP allocation should start at 2x the VP, and tune up/down from there - and you may have done this.... Not sure what the indicated HP Hit% of 100% really means in this report. The 1.9% read-to-write ratio is of just a tick since it should be 2.0%, probably due to a rounding error someplace. While the 1.9% [...]
22930 38 98_Central PA DB2 Users Group Classes by Martin Hubel - June 27th & June 28th - The DB2 I/O Workshops10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Fri, 26 May 2000 08:29:10 -0400410_us-ascii Greetings everyone!
The Central PA DB2 Users Group will be hosting Martin Hubel & his DB2 I/O Workshop series. The classes are tentatively scheduled for: Tuesday, June 27th - The DB2 I/O Workshop: Part 1: Physical I/O Wednesday, June 28th - The DB2 I/O Workshop: Part 2: Logical I/O
The classes will be held at the Camp Hill Corporate Center, Building 300 & will be $150 per class. [...]
22969 54 27_Re: Question Load utility..19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 26 May 2000 08:12:08 -0500598_ISO-8859-1 Baskar, Consider this: which dup record do you wish to load? The first encountered? Second? . . . Doesn't the fact that you have dups indicate a data integrity issue? HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately [...]
23024 52 38_Problems running db2profc on SQLj code12_Bill Littman24_blittman@TOMOTHERAPY.COM31_Fri, 26 May 2000 08:12:13 -0500289_iso-8859-1 I am a DB2 & SQLj newbie. I am trying to get a test app running but I am having difficulty. The test app has a single line of SQLj, and I am pretty sure it is fine.
I execute the following line: sqlj -url=jdbc:db2:tomodb DB2Test.sqlj which returns without an error. [...]
23077 89 27_Re: Question Load utility..12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 26 May 2000 06:45:39 PDT523_- Baskar,
DB2 always removes the dup row(s) from the load file due to the reason given by Rick. All dups in the load file are rejected and there isn't anyway to avoid that. As Rick mentioned, how is DB2 to know which you want and which you Don't want?? When the load is done, go to the discards file and remove the ones you don't want, then load the discard file into the table. Your dup rows SHOULD mostly be together so finding them is fairly easy. Since you are doing a RESUME YES, some of the rows might be [...]
23167 159 46_Re: Priced Utility Features and Tiered Pricing16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Fri, 26 May 2000 06:47:14 -0700532_iso-8859-1 Regarding tiered pricing. At one time I worked for a County health department that bought time on a State machine. We got our own license for Software AG's ADABAS, because the State didn't use ADABAS. When the machine was upgraded, our cost for ADABAS licensing and support went up, even though our use of it didn't change, and there was no upgrade to ADABAS (repeat, there were NO upgrades to ADABAS to make this work). The justification was that the licensing was based on the machine, not the use of the product. [...]
23327 608 91_Repost: I Know You're Out There! (Winter Corp Announces: Database Scalability Program 2000)13_Morrill, John12_JohnM@VP.NET31_Fri, 26 May 2000 08:03:25 -0600610_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Stakeholders,
HELP! I need your help. As per my note to you last month below, the Winter Corporation's Database Scalability Program 2000 is soliciting completed surveys about database systems with over 100GB of data. [...]
23936 66 27_Re: Priced Utility Features11_David Price22_dprice@UBIQUITY.COM.AU31_Fri, 26 May 2000 09:17:58 -0500609_- Jim, With regard to your point 2 (below) that successive versions are always more expensive, and that customers should or do accept this as a fact...
There are a number of examples where IBM unreasonably increased the price of a new version beyond the worth of any additional benefits to most customers. Customers simply did not upgrade. Result: IBM embarassment, a price drop on the version after and IBM supporting direct migration to bypass the poorly priced version. IMS V2 for example only benefited extremely large users (read big banks) with its lifting of some limits and the rolling in [...]
24003 95 27_FW: Priced Utility Features13_Brendan Friel18_b.friel@PECORP.COM31_Fri, 26 May 2000 09:41:22 -0500450_iso-8859-1 I'm definitely starting to get a feeling that the DB2 vs Oracle war is getting close to being over and the bad guys are going to win. From an employment/contracting view, in a lot of areas of the US DB2 is dead on all platforms.
Oracle is booming.
The utility pricing issue just hands an additional weapon to the Oracle/UNIX forces. How 'good' a product is can become largely irrelevant when you lose the marketing war. [...]
24099 23 27_Re: Priced Utility Features13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 26 May 2000 10:58:32 -0400334_iso-8859-1 Hello Brendan, You're certainly welcome to your observations and opinions, and while I'm no longer in the consulting side of our business, from the DB2 tools perspective, DB2 is far from dead.
Our DB2 products continue to sell better every year.
Last I read, the number of DB2 licenses is still growing. [...]
24123 50 27_Re: Priced Utility Features15_David A. Zelmer25_david.zelmer@CITICORP.COM31_Fri, 26 May 2000 10:03:10 -0500217_us-ascii Max,
Including "rich" with data admins is an oxymoron. Sort of like military intelligence or tax cuts!
Why do you suppose we drink beer? It is what we can afford!
Have a good day,
24174 14 14_DB2 5.1 TCP/IP20_Cable, George (CORP)29_George.Cable@CORPORATE.GE.COM31_Fri, 26 May 2000 11:05:30 -0400507_- Just starting with DB2 5.1 TCP/IP, we have an issue with authorization ids and passwords being passed. What are your experiences with PassTickets (RACF or ACF2)? What are your experiences with DCE? What are your experiences with internal CDB hard coded passwords?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
24189 40 30_DB2 Connect Deployment Options13_Tierney, Mark20_mtierney@FIRSTAM.COM31_Fri, 26 May 2000 10:26:57 -0500594_- Greetings All....
We are in the process of opening up our DB2 for OS/390 (V5) environment to outside requesters/platforms. In the various information sources about DB2 Connect EE (mostly web) there seems to be some differences in the doc. On the DB2 Product Family: DB2Connect page it says you can use: Intra, Extra, Public Internets to get to DB2 via DB2 Connect. However if you look at the EE page it just says LAN based applications.(?) My confusion is heightened a little bit by posts on the list that indicate that DB2Connect and the WebServer can be co-located allowing Web [...]
24230 24 28_Applying DB2 ESO maintenance12_Mike O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV31_Fri, 26 May 2000 11:44:10 -0400357_US-ASCII We are new at DB2, and are faced with applying our first maintenance cycle. Does anyone know of an easy way to apply the ESO maintenance tapes? What are the pitfalls? From what I've seen so far, this is a very complex and time consuming process.
Any tips or hints on how to make the maintenance go smoothly will be greatly appreciated. [...]
24255 53 25_Re: Unique vs Primary Key13_OConner, John26_John.OConner@COURTS.WA.GOV31_Fri, 26 May 2000 08:48:52 -0700574_iso-8859-1 I think there are two reasons for creating indexes: 1) to improve performance and 2) to enforce business rules (uniqueness). It may be a good idea to include business rules in the table definition where possible. You don't want someone to drop a "business rule" index, thinking it's not being used because it's not referenced in any of the explains. Putting these "rules" in the table definition will coerce the existence of the corresponding indexes. You won't put rows that violate the business rules into your table without changing the table definition. [...]
24309 57 32_DB2 V6 POSTPONED REVOVER PROBLEM17_Richard Cotterill20_rcotteri@PCUG.ORG.AU31_Sat, 27 May 2000 01:55:40 +1000343_us-ascii Hi, We are using DB2 V6 and have a Tablespace stuck in Postponed Recover status. Issue -RECOVER POSTPONED or restarting DB2 does not remove it. DB2 nolonger recognises that the tablespace is in this status during restart.
We have been told by IBM that we will need to COLD START DB2 to remove the status or run a USERMOD. [...]
24367 204 36_Re: Double Byte Character Set (DBCS)16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Fri, 26 May 2000 08:48:57 -0700408_iso-8859-1 Yes, only way to enable DBCS is to set MIXED DATA = YES in DSNHDECP.
I didn't deal with the systems side of it, but I talked to the person who did. She said, "We also only use one copy of DSNHDECP. I had to create a separate library that had a copy of DSNHDECP in it with MIXED DATA = YES. I then had a steplib in my started tasks with that library in front of the standard DSNHDECP." [...]
24572 94 27_Re: Priced Utility Features12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 26 May 2000 20:02:12 +0200380_x-user-defined Hi, Just one small note - we pay less for V5 then for V4 (should be V$). All the rest will have to wait as we decide now about the next move. We have enough ORACLE and DB2 to give us all the info. we need to make a decision, we'll wait for more info. about V7 pricing (we use only IBM utilities now, so it means having to check how the price/performance goes) [...]
24667 28 28_Information Engineering (IE)19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 26 May 2000 12:38:24 -0500593_ISO-8859-1 Hi all, Some help please. We use the IE option for data modeling in ERwin 3.5.2. Is there a single source document or book that describes IE? Has IE ever been adopted officially as an ANSI standard?
Considering V7 Utilities, hehe Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please [...]
24696 216 17_Re: Sybase to DB214_subrata mondal25_subratamondal@HOTMAIL.COM29_Fri, 26 May 2000 18:42:02 GMT613_- Sanjay.,
Check up in the sybase Bin directory on your client. you have a file namely bcp.exe you can bcp the data in character format. It is an ASCII file. Once you have this you can load onto Db2 I guess. check the status too...
Good luck Subrata Wash DC
>From: "Jain, Sanjay (Exchange)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Sybase to DB2 >Date: Thu, 25 May 2000 17:21:39 -0400 > >Greetings !!!!! > > >We will be moving over some data from Sybase to DB2 fairly soon. Are there >any gotchas to watch for [...]
24913 17 33_group buffer pool for workfile db10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 26 May 2000 15:06:45 -0400364_us-ascii Hi all
Is there a great need, if any at all, for a Group buffer pool for the workfile database.
Tom
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
24931 22 16_ASCII In DB2/39016_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Fri, 26 May 2000 15:08:12 -0400428_iso-8859-1 Hey Folks.. We're running a product called Business Objects. The product inserts rows into a DB2 table, but does so in ASCII. When we try to return rows through the product, Business Objects get's confused and can't make the conversion in a readable format on the client screen. Is there a simple process by which we can convert the incoming ASCII to EBCIDIC? I'm hoping this will resolve the problem. THanks... [...]
24954 53 20_Re: ASCII In DB2/39023_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 26 May 2000 20:03:40 +0100292_iso-8859-1 Er ... Michael you can create ASCII tables in DB2 .. or is this what your saying you have ?
I work in a SAP envrionment that is nearly 100% ASCII .. but the DB2 Catalog is EBCIDIC (I do beleive that V6 or V7 will allow ASCII catalogs).
Leslie Pendlebury-Bowe UK [...]
25008 48 37_Re: group buffer pool for workfile db23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 26 May 2000 20:07:57 +0100470_iso-8859-1 Only if you have Sysplex query parallelism - I do believe (ready to be shot down in flames)... ie where one db2 can use another db2's sortworks etc.
we do not have it switched on here....but I think there is no reason why you cannot do that.
Leslie Pendlebury-Bowe
-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: Friday, May 26, 2000 8:07 PM To: DB2-L@RYCI.COM Subject: group buffer pool for workfile db [...]
25057 37 37_Re: group buffer pool for workfile db29_Vanderbeck, Raymond K(O95918)35_Raymond.Vanderbeck@PINNACLEWEST.COM31_Fri, 26 May 2000 12:05:51 -0700483_iso-8859-1 No, because each member in the group has its own workfile. Also in IBM Redbook "DB2 for MVS/ESA Version 4 Data Sharing Implementation, chapter 10, page 199, it says under Tuning Group Buffer Pools, "Separate DB2 workfiles cannot be shared across members. You do not need an associated GBP".
-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: Friday, May 26, 2000 12:07 PM To: DB2-L@RYCI.COM Subject: group buffer pool for workfile db [...]
25095 62 37_Re: group buffer pool for workfile db23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 26 May 2000 20:14:44 +0100624_iso-8859-1 ahhhh but do you need them for sysplex query parallelism???????????????
Leslie
-----Original Message----- From: Vanderbeck, Raymond K(O95918) [mailto:Raymond.Vanderbeck@PINNACLEWEST.COM] Sent: Friday, May 26, 2000 8:06 PM To: DB2-L@RYCI.COM Subject: Re: group buffer pool for workfile db
No, because each member in the group has its own workfile. Also in IBM Redbook "DB2 for MVS/ESA Version 4 Data Sharing Implementation, chapter 10, page 199, it says under Tuning Group Buffer Pools, "Separate DB2 workfiles cannot be shared across members. You do not need an associated GBP". [...]
25158 37 37_Re: group buffer pool for workfile db11_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 26 May 2000 12:38:46 PDT661_- By definition the workfile database does not use a group bufferpool.
Rick Creech
>From: Tom Taylor >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: group buffer pool for workfile db >Date: Fri, 26 May 2000 15:06:45 -0400 > >Hi all > >Is there a great need, if any at all, for a Group buffer pool for the >workfile >database. > >Tom > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can >be reached at DB2-L-REQUEST@RYCI.COM. [...]
25196 33 23_AST - Refresh=Immediate17_Patricia Candella21_pcandella@METLIFE.COM31_Fri, 26 May 2000 15:49:23 -0400506_us-ascii List, UDB EEE - V6 / UNIX
I have just started working on a UDB - EEE project, and the customers wanted to explore Summary tables in an effort to speed up performance on their ad-hoc queries. The database "fact tables" are spread over 4 nodes; the dimension tables are all on 1 node (which will be replicated over the other nodes eventually). The data in the database is read-only; data is loaded into the database on a monthly basis using the auto loader utility with the insert-mode. [...]
25230 33 37_DB2PM scope group reports - heeellllp23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 26 May 2000 20:55:35 +0100314_iso-8859-1 I am having a problem getting Db2PM to report to me stats over a pre-defined interval for my group bufferpools.
It is being given Stats records from my SMF logs for both members, sorted as required, yet I only get GBP0 reported in the SCOPE group report.
has anybody else had this .. [...]
25264 53 27_Re: AST - Refresh=Immediate11_Steve Mazer17_smazer@FMTUSA.COM31_Fri, 26 May 2000 15:47:25 -0400601_us-ascii No. The AST refreshing is only triggered by DML: Inserts, Updates, and Deletes. You could load the fact table data into staging tables and then Insert/Select into the real fact tables. That would cause the rows to be processed into the ASTs.
Regards, Steve Mazer Fourth Millennium Technologies
At 03:49 PM 5/26/00 -0400, you wrote: >List, >UDB EEE - V6 / UNIX > >I have just started working on a UDB - EEE project, and the customers wanted to >explore Summary tables in an effort to speed up performance on their ad-hoc >queries. The database "fact tables" are spread over [...]
25318 50 37_Re: group buffer pool for workfile db17_Linda F. Claussen18_lindafc@NETINS.NET31_Fri, 26 May 2000 15:26:06 -0500466_ISO-8859-1 Tom,
You should keep work files in a separate buffer pool that is not backed by a group buffer pool.
To support sysplex parallelism you should put work files on shared DASD that is accessible from all members that can process parallel queries. Use the same buffer pool number for all members of the data sharing group and make sure that VPXPSEQT is >0 . DB2 assumes at run time that all work files are in the same numbered buffer pool. [...]
25369 41 52_DB2 Connect Licensing - 'Concurrent User' definition15_Belfield, Al G.15_AGBELFI@TWA.COM31_Fri, 26 May 2000 15:40:15 -0500426_iso-8859-1 What it the definition of 'Concurrent User' for DB2 Connect V7 licensing?
The planned architecture is to have 500 PC's with 'thin' clients connecting to 5 applications servers. These application servers will have DB2 Connect EE installed, and will each open 10 connections thru to DB2 on the S/390 system, while each server will have 20 'active' application transactions executing at any point in time. [...]
25411 89 27_Re: AST - Refresh=Immediate22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Fri, 26 May 2000 16:49:20 -0400409_- I don't know about LOAD
Another option is IMPORT. Since an IMPORT does its work by issuing SQL inserts and ASTs are populated by DML activity, then I would expect the rows processed by the IMPORT command to be populated into the AST. I would also expect that because refresh=immediate is specified that only news rows will be used to update the ASTs. I have not done this so you should test it. [...]
25501 69 56_Re: DB2 Connect Licensing - 'Concurrent User' definition14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 26 May 2000 16:57:37 -0400354_iso-8859-1 The definition I use for concurrent users is: How many users will be simultaneously using the gateway. That means you license to what your high - water mark will be. So you may have 500 pc's but only 100 will ever be active at the same time. So I would buy 100. But, I haven't looked at licensing lately and it may have changed. HTH Phil [...]
25571 94 56_Re: DB2 Connect Licensing - 'Concurrent User' definition13_OConner, John26_John.OConner@COURTS.WA.GOV31_Fri, 26 May 2000 14:16:08 -0700421_iso-8859-1 I'm sure there's a "technically correct" answer to this question, but when we asked our DB2 Connect sales rep this same question, the answer seemed to be somewhat negotiable. I believe that our rep would have required us to purchase only 50 licenses under your scenario (at any single point in time, DB2 on OS/390 is only going to see 5x10 connections). Your rep may interpret your situation differently. [...]
25666 85 37_Re: group buffer pool for workfile db23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Sat, 27 May 2000 17:47:07 +0100363_iso-8859-1 Linda hi .. yes you have refreshed my memory .. it is the vsam share options that are altered at install time or switch time to allow for sysplex query parallelism ..
all the best
Leslie
-----Original Message----- From: Linda F. Claussen To: DB2-L@RYCI.COM Sent: 5/26/00 9:26 PM Subject: Re: group buffer pool for workfile db [...]
25752 44 64_DB2 V7.1 Beta connect problems, anybody else testing this thing?16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM31_Sat, 27 May 2000 13:47:55 -0700504_iso-8859-1 Hello All!
I'm not sure if there are others out there running the beta code for DB2 V7.1, but if there are, I want to see if anybody else has run into this problem.
After a perfectly successful install, I can connect to all the databases as the instance user just fine. However, if I setup another user in the SYSADM group, which should give them full permissions over the instance (At least, it did in V6.1) I cannot connect to any databases. Here's the error I'm getting: [...]
25797 77 33_Managing the Logical Unit of Work10_Wang.James24_Wang.James@AAA-CALIF.COM31_Sun, 28 May 2000 01:25:11 -0700329_us-ascii Can anyone explain how the logical unit of work will be managed in following configuration:
MS Transaction Server <-> MQSeries <-> CICS <-> DB2 |--> SQL Server
James Wang Sr. Systems Programmer Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com
25875 83 38_partition on the month of the db2 date15_MAHSOUN, KHALID29_kmahsoun@SAUDIAIRLINES.COM.SA31_Sun, 28 May 2000 12:28:48 +0300211_- Hi I am Sorry about my last question I was in a harry what I meant is
I want to partition on the month value of a DB2 date column to make it 12 partition without including the year value
Thanks .
25959 37 42_Re: partition on the month of the db2 date12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Sun, 28 May 2000 20:11:15 +0200362_x-user-defined Hi, You'll need a separate column based on month only. Make it char(2).
Isaac Yassin
> "MAHSOUN, KHALID" wrote: > > Hi > > I am Sorry about my last question I was in a harry what I meant is > > I want to partition on the month value of a DB2 date column to make it 12 > partition without including the year value > > Thanks .
25997 52 31_Re: ESS/Shark DASD expectations15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 27 May 2000 14:13:03 -0500516_us-ascii Time to ramble on about ESS, DASD in general. Hit the ol' delete key if you don't wish to read.
Shark is "better" than other DASD vendors BEST/latest products in only 1 respect; MVS IOS code has been rewritten to take advantage of parallel UCBs/volumes (2 I/Os for the same MVS volume are NO longer queued within MVS, that queueing, if any, is now moved to the controller). The only thing you need to make parallel access volumes (PAV) work is to know the secret IBM DASD channel command codes. [...]
26050 32 42_Re: partition on the month of the db2 date13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Mon, 29 May 2000 08:56:41 +0530488_us-ascii I am facing a problem . I am trying to read the log records via IFI calls . The DB2 Admin guide says that you can read the log records by buffering it . This is done by starting trace IFI126 . I am able to start the traces properly in an opx buffer . All the code is in assembly. Now I use the post ECB method for telling my program that the buffer is full . Now after I run the program and during the active state of the program I execute inserts etc on a particular table [...]