1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2007, week 5
2 151 34_Antwort: Re: [DB2-L] V8 phase time11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Jun 2007 07:22:03 +0200645_iso-8859-1 SAP users *always* have a different approach....VARCHAR(1) anyone ???
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert
Chris Hoelscher Gesendet von: DB2 Data Base Discussion List 28.06.2007 19:22 Bitte antworten an DB2 Database Discussion list at IDUG [...]
154 148 29_Antwort: Re: [DB2-L] z/OS DB211_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Jun 2007 07:25:17 +0200483_iso-8859-1 My firm also offer a tool "SQL PerformanceExpert" that offers helpful tips (also with reasons!) about how to improve your SQL
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert [...]
303 460 33_Re: Antwort: Re: [DB2-L] z/OS DB213_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 29 Jun 2007 08:37:08 +0100512_iso-8859-1 Oh, now look. If we're gonna go down the product plug route I can think of at least one bit of 'APPlication TUNing softwarE' that BMC has. Of course it would be beneath me to name the product...
It's Friday; let the games begin!
Raymond
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: 29 June 2007 06:25 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Antwort: Re: [DB2-L] z/OS DB2 [...]
764 139 37_Re: V7 to V8 upgrade...Cost estimates11_Horn Stefan30_stefan.horn@BRITISH-ENERGY.COM31_Fri, 29 Jun 2007 08:52:53 +0100357_us-ascii Hi guys,
I agree with the 1 year ish time scales, we have a fairly small and stable DB2 set up
I.e. prod is 2-way data-sharing, with approx 500,000 trans pre day in 24/7 environment
We began planning in march 2005, and went live NFM in Feb 2006, then probably took another couple of months to fully get the benefits of v8 [...]
904 54 17_Re: V8 phase time13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 29 Jun 2007 09:02:45 +0100619_us-ascii Steve,
I'm not contradicting the suggestions made so far, rather adding a consideration. Or two.
How long you spend in each phase is really down to your comfort level. I know of sites that have key business processing quarterly, so they stayed at CM mode for a full quarter's processing before moving forward. Conversely, in some conservative sites, their main processing cycle might be annual, so they sit tight at the same level until that annual process is complete. The logic, flawed or otherwise, being if you can get through your most critical processes OK then you're probably OK for [...]
959 216 45_Migrating from DB2 z/OS to DB2 UDB on Windows18_Maniar, Saquib TCS27_saquib.maniar@IMPDIRECT.COM31_Fri, 29 Jun 2007 10:05:06 +0200513_US-ASCII
Hello list,
We're currently planning migration of mainframe database on db2 v8.2 nfm to db2 9 on windows. We fear that there could be an impact of the storage considerations of the datatypes when migrated from mainframe to windows. Although the basic datatypes are same across the platforms, the storage mechanism used by the two platforms are obviously not identical, and hence there could be an impact in the storage for the same data for the same datatype. [...]
1176 58 85_SQL to compare current and (-1) version of Accesst statistics stored in he PLAN table14_Richard Atkins16_rratkp@YAHOO.COM31_Fri, 29 Jun 2007 01:50:22 -0700371_ascii Dear listers,
Am not sure if this has been addressed here before ...
Is anbody aware of an SQL that would let me compare the current ACCESSPATH of a TABLE (corelating to the most recent BINDTIME) with the (-1 version of the BINDTIME) that is stored in the PLAN_TABLE for a given package/program that has the same collection ,version and queryno. [...]
1235 42 17_Re: V8 phase time14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Fri, 29 Jun 2007 10:51:27 +0200415_iso-8859-1 > But when switching from ENFM to NFM to work backwards from Prod > to Test. The idea being to try to stop people developing NFM- > dependent code in Test before your Prod environment can run it.
Exactly; that's the only reason (IMHO) for the existence of ENFM. Migrating from ENFM to NFM is nothing more than switching a flag. Nothing has to be installed or converted anymore at that point. [...]
1278 179 102_Antwort: [DB2-L] SQL to compare current and (-1) version of Accesst statistics stored in he PLAN table11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Jun 2007 10:53:04 +0200392_iso-8859-1 Yes I amt....we, and a bunch of other vendors, happily sell software that does this. An SQL or two cannot even begin to address the complexity of your request...
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...]
1458 47 12_Re: z/OS DB214_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Fri, 29 Jun 2007 10:59:32 +0200423_iso-8859-1 > If we're gonna go down the product plug route ...
Good idea ;-) Here's mine: There are several good training centers, often independent from IBM, offering courses where you learn (1) how to write correct, readable, and performant SQL; (2) how to tune SQL for use on DB2 for z/OS; (3) understand performance aspects of DB2; (4) how to administer a DB2 system for best performance (5) and lots more. [...]
1506 35 45_Migrating from DB2 z/OS to DB2 UDB on Windows13_Saquib Maniar27_saquib.maniar@IMPDIRECT.COM31_Fri, 29 Jun 2007 04:07:59 -0500501_ISO-8859-1 Hello list,
We’re currently planning migration of mainframe database on db2 v8.2 nfm to db2 9 on windows. We fear that there could be an impact of the storage considerations of the datatypes when migrated from mainframe to windows. Although the basic datatypes are same across the platforms, the storage mechanism used by the two platforms are obviously not identical, and hence there could be an impact in the storage for the same data for the same datatype. [...]
1542 455 24_Re: DBM1 storage problem13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 29 Jun 2007 10:22:13 +0100369_US-ASCII First, this looks very much like a DB2 Version 7 report. Casting my eye over the numbers they appear to behave as Version 7 numbers as well.
Second, taking 648MB from 1815MB gives over 1GB. So I suppose that DOES explain the 18MB per thread leading to a max thread count of 52. (Note: I haven't taken into account things like Storage Cushion etc.) [...]
1998 170 62_Antwort: [DB2-L] Migrating from DB2 z/OS to DB2 UDB on Windows11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Jun 2007 11:31:01 +0200537_iso-8859-1 its a bit old (Oct 2006) and its only z/OS V8 to LUW V8 to Iseries 5.3 but it will give you at least a good idea.....
http://www.ibm.com/developerworks/db2/library/techarticle/0206sqlref/0206sqlref.html
then scroll on down to CREATE TABLE and check out the various notes about colunm type and size...
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...]
2169 272 67_IDUG 2007 - Europe Registration and Advance Programme Now Available19_Cuneyt Goksu (.NET)19_cuneytgoksu@USA.NET31_Fri, 29 Jun 2007 13:11:20 +0300548_ISO-8859-1 IDUG Europe 2007
Register now for the leading user-driven technical event for DB2 professionals.
IDUG 2007 - Europe 5-9 November 2007 Athens, Greece w3.IDUG.org/2007Europe
Register today for IDUG 2007 - Europe! Visit our convenient online registration page or click here to download a print-friendly version of our registration form.
You can also download a copy of the Advance Programme, and get a preview of all the educational and networking opportunities available this year. [...]
2442 52 24_Re: DBM1 storage problem10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 29 Jun 2007 13:09:42 +0200421_US-ASCII This value :
31 BIT EXTENDED HIGH PRIVATE (MB) 1725.89
remember me this other value:
31 BIT EXTENDED HIGH PRIVATE (MB) 1620.47
with 61 MB of storage available for DB2 below 2 Gb left, just before a DB2 crash due to an out-of-db2 condition (a PDS-E problem).
Just an idea
Max Scarpa
---------------------------------------------------------------------------------
2495 36 17_Re: V8 phase time14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 29 Jun 2007 22:18:29 +1000455_US-ASCII We went straight through ENFM to NFM, but then did not run NG - leaving the default DSNHDECP with NEWFUN=NO. This will stop static SQL exploiting NFM features. Once everyone is in production, we'll run NG to set NEWFUN=YES.
Yes, I know this allows NFM dynamic SQL (at least I think it does), but the skill set required to write dynamic SQL in a program usually includes the ability to understand the instruction "don't use NFM code". [...]
2532 449 89_Re: SQL to compare current and (-1) version of Accesst statistics stored in he PLAN table12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Fri, 29 Jun 2007 07:33:41 -0700611_US-ASCII Richard:
Path Checker from IBM and Path Check from HLS Technologies, Inc. both provide this function. In addition both products have a feature that will do the same function but without doing a bind. This allows you to compare and contrast what will happen with what has happened. The products are designed to run in a production environment without the impact of an actual bind. I suggest that you ask your IBM representatives if you have an ESSO agreement in place. If so you may have rights to the IBM product without other payments. The same functionality exists in the [...]
2982 68 17_Re: V8 phase time13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 29 Jun 2007 13:37:39 +0100291_us-ascii 'Usually' is the key word there. Just be prepared for SPUFI, QMF, etc. users to get on the blower asking about -4700. But then, you get to walk around there with that most useful of persuasive devices, the cricket bat. As Teddy once said, 'Speak softly but carry a big stick'. [...]
3051 128 24_Re: DBM1 storage problem3_Les21_db2dba@BTINTERNET.COM31_Fri, 29 Jun 2007 13:42:07 +0100466_windows-1250 Couple extra questions,
1. have you tracked and kept historical 225 info in your warehouse so you can graph the data? Always helps to see what is happening
2. Do you have storage contraction on?
Also can you clarify Martin's observations, this is V7? You mention v8.
If V8 I have my own personal observations I can put forward, if V7 .. Then I would like at the info apars mentioned and ensure thread contraction is on. [...]
3180 362 71_Re: IDUG 2007 - Europe Registration and Advance Programme Now Available35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 29 Jun 2007 08:42:42 -0400608_iso-8859-1 IDUG Europe 2007Where do speakers register, and where do vendor exhibition staff register?
Thanks, Joel
Joel Goldstein Responsive Systems Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts Group Buffer Pool performance too! www.responsivesystems.com tel. (732) 972-1261 fax.(732) 972-9416 ----- Original Message ----- From: Cuneyt Goksu (.NET) Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, June 29, 2007 6:11 AM Subject: [DB2-L] IDUG 2007 - Europe Registration and Advance Programme Now Available [...]
3543 144 24_Re: DBM1 storage problem11_Jacek Surma18_framedb2@GMAIL.COM31_Fri, 29 Jun 2007 15:20:13 +0200552_ISO-8859-1 Yes, Martin is right. This report is for DB2 v7, but 2 months ago we migrated from v7 to v8 and there is the same problem with storage. Jacek
2007/6/29, Les : > Couple extra questions, > > 1. have you tracked and kept historical 225 info in your warehouse so you > can graph the data? Always helps to see what is happening > > 2. Do you have storage contraction on? > > Also can you clarify Martin's observations, this is V7? You mention v8. > > If V8 I have my own personal observations I can put [...]
3688 154 12_Re: z/OS DB214_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Fri, 29 Jun 2007 08:53:09 -0500306_us-ascii You probably are out of luck here. You can't beat the fools, they are simply too smart ! When you stop them from doing a select from a table without a where clause, they will come up with a cartesian product. Try to catch what you can with your monitoring process and work from there. Khalid [...]
3843 49 24_Help.. help... help.....19_Suresh Chimalakonda29_chimalakonda.suresh@GMAIL.COM31_Fri, 29 Jun 2007 10:32:43 -0400388_ISO-8859-1 Any help, I would greatly appreciate it. My problem is some thing like this: I have a table which has a column AMT with attribute decimal (17,2).
A view is being created on this table and in the create view query the AMT is being summed up. Now DB2 has assigned attribute DECIMAL(27,2) to the view. This is creating all kinds of problems for us in the programming. [...]
3893 118 17_Re: V8 phase time8_duam lee20_duam_lee@HOTMAIL.COM31_Fri, 29 Jun 2007 14:34:57 +0000649_Windows-1252 Thanks in advance. I have two questions. 1.Please explain what is ebcdic to unicode round trip conversion when migration to V8 starts.
2. In compatible mode i could not understand the meta data from sql is converted back to EBCDIC.
Duam
> Date: Fri, 29 Jun 2007 22:18:29 +1000> From: jacampbell@ACSLINK.NET.AU> Subject: Re: [DB2-L] V8 phase time> To: DB2-L@WWW.IDUGDB2-L.ORG> > We went straight through ENFM to NFM, but then did not run NG - leaving the default > DSNHDECP with NEWFUN=NO. This will stop static SQL exploiting NFM features. Once > everyone is in production, we'll run NG to set [...]
4012 56 28_Re: Help.. help... help.....19_Suresh Chimalakonda29_chimalakonda.suresh@GMAIL.COM31_Fri, 29 Jun 2007 10:51:18 -0400508_ISO-8859-1 > > Any help, I would greatly appreciate it. My problem is some thing like > this: I have a table which has a column AMT with attribute decimal (17,2). > > A view is being created on this table and in the create view query the AMT > is being summed up. Now DB2 has assigned attribute DECIMAL(27,2) to the > view. This is creating all kinds of problems for us in the programming. > > Can anyone please let me know if there is a way we can control the column > attribute the db2 assigns to the [...]
4069 155 28_Re: Help.. help... help.....37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Fri, 29 Jun 2007 16:55:37 +0200596_iso-8859-2 it seems to me that CREATE VIEW POKXX AS SELECT DEC(SUM(OBRAT),17,2) AS SUMM FROM SPDEVE.SPTCO WHERE CISUCET < 123456; can be created
regards, dusan
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Suresh Chimalakonda Sent: Friday, June 29, 2007 4:51 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Help.. help... help.....
Any help, I would greatly appreciate it. My problem is some thing like this: I have a table which has a column AMT with attribute decimal (17,2). [...]
4225 148 28_Re: Help.. help... help.....13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Fri, 29 Jun 2007 10:55:48 -0400550_us-ascii Hi Suresh.
Can you post the DDL for the original table and the DDL for the Create View?
Dave
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Suresh Chimalakonda Sent: Friday, June 29, 2007 10:33 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Help.. help... help.....
Any help, I would greatly appreciate it. My problem is some thing like this: I have a table which has a column AMT with attribute decimal (17,2). [...]
4374 47 50_IMS/DB2 question (logging vs ROLLBACK on IMS log).13_Brendan Friel28_Brendan_Friel@NOTES.NTRS.COM31_Fri, 29 Jun 2007 10:08:10 -0500394_US-ASCII In a situation where a mainframe DB2/IMS stored proc is being called from Java, it looks like the IMS log data is always saved,even from a failed transaction). This is independent of any commit/rollback logic on DB2 or Java. The log is being used as a datastore for application data. (Please limit replies regarding the cost/benefit of this approach. It has been there for ever.) [...]
4422 11 42_Re: SV: -302 under ver 8 running EASTRIEVE10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Fri, 29 Jun 2007 10:13:16 -0500537_- Thanks for posting the solution, we just now ran into this issue
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
4434 166 46_[zOS 1.6 db2 v7] - MS Access as an application11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Fri, 29 Jun 2007 11:38:23 -0400378_us-ascii One of our directors is recommending we use MS-Access for updating/inserting/deleting DB2 data residing on zOS as an alternative to building CICS screens. MS-Access will connect via ODBC through our Oracle gateway to get to the DB2 table.
I've been asked if this is acceptable. My gut feel is it's not, but I need to present the hard facts. [...]
4601 53 32_Application Status "UOW Waiting"0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Fri, 29 Jun 2007 11:49:57 -0400353_US-ASCII A DB2 v8.2 LUW fp14 question:
Periodically, we have a transaction that ends up "sitting" in DB2 in a "UOW Waiting" state that is holding a number of locks on some tables in one of our production databases. Other transactions come in and end up in a "Lock-Wait" state, waiting for locks that are being held by the first transaction. [...]
4655 94 36_Re: Application Status "UOW Waiting"14_Sahgal, Vineet24_Vineet.Sahgal@TURNER.COM31_Fri, 29 Jun 2007 12:02:30 -0400381_US-ASCII This is a very common problem especially if you are coming through a connection pool environment or even in a direct connection application.
The first thing is to look at the type of locks that the application thread is holding. Depending on whether it is a Next-share lock or Exclusive lock, the solution is different depending on the application environment [...]
4750 36 24_Application inventory DB10_Art McEwen24_art.mcewen@MOH.GOV.ON.CA31_Fri, 29 Jun 2007 11:05:57 -0500438_- Hi,
We're looking at our options for purchasing or building an application inventory product to feed our Change Management and service desk processess, of course the data it would have to manage would include hardware/software network, ownership, client base etc..
It's a classic buy or build situation, anybody here sucessfully built one? I'd be interested in seeing the data model and DB design used to support it. [...]
4787 162 28_Re: Help.. help... help.....19_Suresh Chimalakonda29_chimalakonda.suresh@GMAIL.COM31_Fri, 29 Jun 2007 12:24:13 -0400408_ISO-8859-1 I am not if I can post original one but it is some thing like this.
Table
col1 char(1) col2 char(1) col3 char(1) col4 decimal(17,2)
view
create view ( vcol1, vcol4) as ( select col1, sum(col4) where col3 = x group by col1)
The attribute being assigned to vcol4 is DECIMAL(27,2).
We are having problems in cobol and ezt with the (27,2) thing. [...]
4950 72 54_Re: IMS/DB2 question (logging vs ROLLBACK on IMS log).14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Fri, 29 Jun 2007 11:13:58 -0500367_- You are correct logging information is saved by IMS for every IMS Insert Delete or Update. There is a diffrence if the transactions aborts and Rollback occurs ... Even more logging takes place in the roll back case. Logging for the original work and Logging for the roll back.
This is no diffrent that what is done by DB2 atleast at a conceptual level. [...]
5023 141 28_Re: Help.. help... help.....9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 29 Jun 2007 12:01:39 -0500451_windows-1250 If you decide to go decimal 31, and you are prepared for it because DB2 is already running that way.
The compile-time option for PL/1 is LIMITS(FIXEDDEC(31)); the default is 15.
COBOL option is ARITH(EXTEND) changes the max decimal from 18 to 31. And it requires a fairly current compiler.
YMMV - and once you change the max decimal field to 31, there are different rules for intermediate results in COBOL also. [...]
5165 47 28_Re: Help.. help... help.....11_Hunter Cobb25_hunter@TRAINERSFRIEND.COM31_Fri, 29 Jun 2007 11:10:08 -0600603_ISO-8859-1 You might consider using the CAST function:
CREATE VIEW TESTVIEW2 (VC1, VC2) AS SELECT C1, CAST(SUM(C3) AS DECIMAL(17,2)) FROM TESTTAB WHERE C2 LIKE 'H%' GROUP BY C1;
Hunter Cobb -------------------------------- Suresh Chimalakonda wrote: > Any help, I would greatly appreciate it. My problem is some thing like > this: I have a table which has a column AMT with attribute decimal > (17,2). > > A view is being created on this table and in the create view query the > AMT is being summed up. Now DB2 has assigned attribute DECIMAL(27,2) > to the view. This is creating all [...]
5213 167 89_Re: SQL to compare current and (-1) version of Accesst statistics stored in he PLAN table14_Richard Atkins16_rratkp@YAHOO.COM31_Fri, 29 Jun 2007 10:14:33 -0700296_ascii Gerald, Thanks for your reply. We do not have the tools that you mentioned so I stuck trying to write an SQL to do this. Frustrating aye at 8:15 pm on Friday ..but then ....c'est la vie
Hopefully someone has had this problem before and has an SQL to share
Cheers Richard [...]
5381 183 24_Re: DBM1 storage problem3_Les21_db2dba@BTINTERNET.COM31_Fri, 29 Jun 2007 18:25:41 +0100431_windows-1250 What about my other questions? Thanks Leslie
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jacek Surma Sent: 29 June 2007 14:20 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DBM1 storage problem
Yes, Martin is right. This report is for DB2 v7, but 2 months ago we migrated from v7 to v8 and there is the same problem with storage. Jacek [...]
5565 52 17_Re: V8 phase time14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Fri, 29 Jun 2007 20:33:23 +0200411_iso-8859-1 > 2. In compatible mode i could not understand the meta data from sql > is converted back to EBCDIC.
That's not the case. There is no way back once the catalog is in Unicode, since not all Unicode characters have a corresponding value in EBCDIC.
That explains why in Compatibility Mode, the "only" thing that is not yet v8 is the catalog conversion. Which allows going back to v7. [...]
5618 268 50_Re: [zOS 1.6 db2 v7] - MS Access as an application14_Flatley, Lynne31_Lynne.Flatley@LIBERTYMUTUAL.COM31_Fri, 29 Jun 2007 15:21:22 -0400382_us-ascii Hi Brian. I have not had experience with using MSAccess to update production DB2 data on the mainframe. Any company I have worked for in the past wouldn't allow this.
How many users would be doing these updates?
I believe you will have scalability issues and data integrity issues because MSAccess's locking/concurrency strategy is just not very robust. [...]
5887 264 50_Re: [zOS 1.6 db2 v7] - MS Access as an application14_Arnold, Mark S20_Mark.Arnold@BNSF.COM31_Fri, 29 Jun 2007 14:49:34 -0500510_US-ASCII Brian,
There are lots of potential "gotchas" with this approach... My biggest concerns would be security and data integrity - it's a lot easier to back-door changes in Access, where the users can see (and manipulate) the base data. You could write an application in Access that would add validation and not expose the tables, using Access security, VB forms & code, etc, but it would probably be as expensive to code that as the CICS screens, and add lots of complexity to the Access app. [...]
6152 169 89_Re: SQL to compare current and (-1) version of Accesst statistics stored in he PLAN table10_Nicola Nur17_nick_nur@YAHOO.CA31_Fri, 29 Jun 2007 16:10:30 -0400796_iso-8859-1 Richard I use an adaption of this SQL taken from Gabriella old book. Adapt it to your needs and run it before and after. Just play with it.
SELECT A.APPLNAME, A.PROGNAME,A.QUERYNO,A.QBLOCK_TYPE,A.ACCESSTYPE, A.ACCESSNAME, A.ACCESSCREATOR, A.MATCHCOLS,A.VERSION,A.BIND_TIME,A.PREFETCH, A.QBLOCKNO,A.PLANNO,A.MIXOPSEQ FROM xxxxxx.PLAN_TABLE A INNER JOIN (SELECT DISTINCT NAME, COLLID, VERSION, BINDTIME FROM SYSIBM.SYSPACKAGE A WHERE LOCATION = ' ' AND BINDTIME >= '2006-12-10-20.22.51.000000' AND BINDTIME <= '2007-06-22-00.00.00.000000' AND COLLID IN ('A COLLECTION') AND NOT EXISTS (SELECT 1 FROM SYSIBM.SYSPACKAGE WHERE LOCATION = ' ' AND NAME = A.NAME AND COLLID IN ('THE SAME A COLLECTION') AND PCTIMESTAMP >= A.PCTIMESTAMP AND (PCTIMESTAMP > A.PCTIMESTAMP OR BINDTIME [...]
6322 285 17_Re: V8 phase time14_Roy J Cornford23_roy_cornford@UK.IBM.COM31_Fri, 29 Jun 2007 21:52:20 +0100552_ISO-8859-1 I suspect the reference is to the parsing being done in UNICODE once in CM and subsequent conversion back to EBCDIC.
Regards, Roy
Roy Cornford
DB2 for z/OS Development
Hursley Park MP 135 Winchester SO21 2JN United Kingdom
+44 1962 816016
roy_cornford@uk.ibm.com
Peter Vanroose Sent by: DB2 Data Base Discussion List 29/06/2007 19:33 Please respond to p.vanroose@ieee.org [...]
6608 27 42_CA Unicenter Merge/Modify - DB2V7 for z/OS29_Hannis, James D (GE Comm Fin)19_James.Hannis@GE.COM31_Fri, 29 Jun 2007 16:52:24 -0400401_iso-8859-1 I'm attempting to use the COPY-IMAGE-COPY option of Merge/Modify with dynamic file allocation for the target output file. I've tried several variations - both with and without the COPYDDN statement - but all have failed with:
PMM0158E - 'COPYDDN' SYNTAX IS 'COPYDDN(ddname,ddname)' This Error has Occurred in CSECT - MMA@MERG
Has anyone on the List been able to do this? [...]
6636 482 108_Re: [SPAM] Re: [DB2-L] SQL to compare current and (-1) version of Accesst statistics stored in he PLAN table12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Fri, 29 Jun 2007 16:05:59 -0700521_us-ascii
From: Gerald Hodge [mailto:ghodge@hlstechnologies.com] Sent: Friday, June 29, 2007 12:49 PM To: 'DB2 Database Discussion list at IDUG' Subject: RE: [SPAM] Re: [DB2-L] SQL to compare current and (-1) version of Accesst statistics stored in he PLAN table
Richard:
Some things to look out for:
1.) A rebind should always match the sequence number for the SQL. If someone does a bind without an EXPLAIN you may have problems. [...]
7119 144 17_Re: V8 phase time12_Dash Sushant23_dash_dba@REDIFFMAIL.COM31_Fri, 29 Jun 2007 21:49:06 -0000526_iso-8859-1 Yes Roy, The conversion back from UNICODE to EBCDIC holds true in CM and ENFM mode. If i understood the question correctly then it is true that some of the characters in CM and ENFM mode when parsed by the SQL precompiler are converted to UNICODE and back to EBCDIC in DBRM. On Sat, 30 Jun 2007 Roy J Cornford wrote : >I suspect the reference is to the parsing being done in UNICODE once in CM >and subsequent conversion back to EBCDIC. > > > >Regards, >Roy > > > > >Roy Cornford > >DB2 for z/OS Development > [...]
7264 260 50_Re: [zOS 1.6 db2 v7] - MS Access as an application14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 30 Jun 2007 17:11:07 +1000448_ISO-8859-1 Through an Oracle gateway! Why? If you are going to use ODBC, get some drivers that can go direct to DB2 on zOS. If you need to go through a gateway, use DB2 Connect.
The concern I have with this is that, unless managed very carefully, it will, effectively, give end users update access to your production data. Even if it doesn't directly, it could undermine internal controls allowing a rogue employee to gain such access. [...]
7525 178 28_Re: Help.. help... help.....12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 30 Jun 2007 10:46:35 +0300430_us-ascii Hi,
On top of all the good replies you've got up to now -
remember that the SUM of many rows with DEC(17,2) may exceed the (17,2) allotted length, So - If you are 200% sure that it will never happen - got with create view casting it as DEC(17,2) Otherwise - go for 31 - which means all that Mike has already written. From past experience - go with 31 as with 17 you'll fall one day in the near future. [...]
7704 17 37_Re: V7 to V8 upgrade...Cost estimates14_Carol Goldberg19_puli@MINDSPRING.COM31_Sat, 30 Jun 2007 07:59:28 -0500362_- We are in the "planning" stage of going to version 8 , would any one care to elaborate on you test plans, I can have one developed but would like a sanity check to make sure we have a complete plan. We are not data sharing, and the other unusual is for distributed our installation uses Host Integration Server ( 2000). Any comments would be appreciated. [...]
7722 43 37_Re: V7 to V8 upgrade...Cost estimates13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Sat, 30 Jun 2007 09:36:05 -0500341_ISO-8859-1 Have you talked to your IBM person about our no-charge migration planning workshop? we have a team of people that will come to your shop and spend 4-6 hours reviewing your migration plan, giving a presentation with some hints and tips for a successful migration, and present a little on new features and functions in DB2 V8. [...]