1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2004, week 5
2 149 29_Re: AW: Tuning of Dynamic SQL33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 29 Jul 2004 04:30:35 -0500510_- Myron
I found your reply very interesting. It was knew to me, that DB2 behaves like that in the 0 = 1 case. I did an explain and it works. But for the following statement it does not work:
SELECT * FROM SYSIBM.SYSDUMMY1 WHERE 1 > 2
Why I am so interested? A couple of months ago, I explained a very complex query (4-way join with some correlated subqueries) and got one row back in the plan_table with QBLOCK_TYPE "PRUNED". I couldn'd find any document, where PRUNED was explained. [...]
152 19 29_Re: AW: Tuning of Dynamic SQL33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 29 Jul 2004 04:59:15 -0500756_- Hi
Before anyone gets involved to deep, I found out by myself, why the complex query gets pruned. The reason for that is:
AND VPOS.PTBS_KENN = '......' AND ((VPOS.PTBS_KENN BETWEEN 'H80500' AND 'H80509') ....
Amazing, how smart the optimizer most of the time is.
--------------------------------------------------------------------------------- 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
172 34 20_DB2 UDB DBA position12_kent collins20_kent.collins@ATT.NET31_Thu, 29 Jul 2004 05:54:17 -0500615_US-ASCII An immediate opening for a DB2 DBA. The position is located in Dallas. Texas and the terms and brief of the duties is listed below. Interested parties should contact me at kent.collins@att.net or by phone at 972.507.4760.
Platform: Sun Solaris DB2: V8.1 Requirement: At least 3 years of working as a DBA on DB2/Unix platforms. DB2 Replication working knowledge required. Should be also to answer direct questions regarding the operation and setup of DB2 Replication Duties: 60% support new/existing development projects 40% production support Must be able to handle dynamic priorities. [...]
207 62 37_Re: PL/1 program using RRS attachment17_Jens Peter Hansen10_jph@PBS.DK31_Thu, 29 Jul 2004 13:16:44 +0200330_us-ascii Hi all
Thanks to Alex Vilens --- you lead os in the right direction
the problem was a kind of type mismatch on the first DSNRLI call ( 'IDENTIFY' ), so now we get the connection to DB2, and we can move on with the application.
Venlig hilsen / Best regards
Jens P. Hansen Host-DB2 [...]
270 20 61_Sept 2nd - Central PA DB2 User Group Event - RSVP to register50_Cathy Peck-IDUG Board Of Directors RUG Focal Point23_cathy.peck@HIGHMARK.COM31_Thu, 29 Jul 2004 09:24:02 -0400770_US-ASCII On September 2nd, we will be having the next FREE Central PA DB2 Users Group.
The agenda / directions can be found on the IDUG Calendar at: http://www.idug.org/calendar/calendar.asp?location=71.
Please RSVP to Cathy.Peck@Highmark.com to register. Hope to seeya in Sept! Seeya!
--------------------------------------------------------------------------------- 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
291 128 29_Re: AW: Tuning of Dynamic SQL13_Solecki, Rohn19_Rohn.Solecki@GWL.CA31_Thu, 29 Jul 2004 09:21:00 -0500363_iso-8859-1 Interesting. I searched on the IBM site and you got the PTF number right, there are 9 PTF's dealing with SQLPRUNING. The field that reports the PRUNED state is QBLOCK_TYPE in the PLAN_TABLE.
Rohn Solecki Software Developer Group Systems Support Services, Great-West Life Phone: (204) 946-4271 Fax: (204) 946-7064 Email: Rohn.Solecki@gwl.ca [...]
420 91 31_Reorg-problem on lob-tablespace14_Steurs Patrick21_Patrick.Steurs@NBB.BE31_Thu, 29 Jul 2004 16:44:46 +0200507_iso-8859-1 Hi,
We are investigating a reorg-problem on an z/os 1.4 & db2 v6.1 system.
The orgratio of a lob-tablespace should be close to 1 after a reorg / runstats lob-tablespace.
Testscenario : table xyz in a lob-tablespace
Parameter in db2-catalog Mai 2004 23 June 2004 24 June 2004 Units SPACE 4813 6355 6988 Mb CARDF 15 25164 25175 Records AVGSIZE 2070 197219 197192 Bytes per lob FREESPACE 4877568 1925968 1939200 Kb free space ORGRATIO 1.00 20.00 3.00 1.00 = perfect [...]
512 244 30_Re: IN list causes TB scan ???13_Terry Purcell18_tpurcel@US.IBM.COM31_Thu, 29 Jul 2004 09:46:51 -0500581_- Raquel,
Thankyou for your reply, but in the most humble way I would like to reassure you that my analysis is correct.
Let me try to reiterate what you are saying using another example. SELECT * FROM TELEPHONE_BOOK WHERE LASTNAME = 'PURCELL' OR FIRSTNAME = 'TERRY' If I have 2 indexes, one on LASTNAME, and the other on FIRSTNAME. You are saying that I can use matching index access on either index. This is not physically possible that any one index (given the two I have listed) can satisfy both predicates in the WHERE clause. The only possible access paths [...]
757 28 25_Questions about MERGECOPY14_Mark McCormack27_mamccormack@STATESTREET.COM31_Thu, 29 Jul 2004 11:02:07 -0400428_US-ASCII Do,
Terse answers to your questions:
1. Does MERGECOPY step have to be running right away after Incremental copy is finished? A. Mergecopy can run at any time.
2. Can I run a MERGECOPY job while data is updated, inserted or read? Are there any bad things? A. Mergecopy uses only copy files. It does not touch tablespaces / tables. The tables may be in use by other processes during mergecopy. [...]
786 27 25_Re: Tuning of Dynamic SQL33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 29 Jul 2004 17:56:16 +0200517_iso-8859-1 The ptf is UQ81203 and not UQ82103 (APAR PQ77454)
Roland
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Solecki, Rohn Sent: Thursday, July 29, 2004 4:21 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: AW: Tuning of Dynamic SQL
Interesting. I searched on the IBM site and you got the PTF number right, there are 9 PTF's dealing with SQLPRUNING. The field that reports the PRUNED state is QBLOCK_TYPE in the PLAN_TABLE. [...]
814 112 49_Re: SQL Stored procedures called by Triggers ....11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 29 Jul 2004 11:22:38 -0500545_- Raquel,
As Myron has pointed out a trigger can indeed call any type of SP, including SQL.
The specific issuw you have is the ability to pass back an error message back to the trigger. If you inded to use the DBINFO parm, STYLE DB2SQL IS required, which is not permitted on SQL SPs. But I think what you seem to be designing is a case where the triggerr will take different actions (or report different error messages) based on the error received. For this, SPs of any kind (even one with DB2SQL) are not going to help you - [...]
927 17 51_Re: IS THERE ANY OVERHEAD ASSOCIATED WITH A VARCHAR14_Ben Eisenstein22_beisenstein@THEOCC.COM31_Thu, 29 Jul 2004 14:33:52 -0500394_- There is a difference between the use of a NULL and no value. A NULL should be used when a value is not known. For example, if a birthdate is not known it should be set to NULL and not 01/01/0001 or some artificial value.
For a string there may be a legitimate use for an empty string as opposed to not known. (An empty string may compare to spaces, it can be concatenated, etc.) [...]
945 107 49_Re: SQL Stored procedures called by Triggers ....11_John Turman29_john.turman@TXDPS.STATE.TX.US31_Thu, 29 Jul 2004 15:26:36 -0500659_ISO-8859-1 Raquel,
Here is an example of a trigger calling an SQL Stored Procedure
CREATE TRIGGER TEST.DOBINS AFTER INSERT ON TEST.BRTHDATE REFERENCING NEW AS T FOR EACH ROW MODE DB2SQL BEGIN ATOMIC CALL TEST.DOBINS1A ('BRTHDATE', 'INS', T.DOB_IDN); END;
John
On Wed, 28 Jul 2004 18:01:31 -0700, Myron Miller wrote:
>I'm sure you're missing something. I don't have the manual right in front of >me. But we do this all the time. Over 99% of our SPs are SQL stored >procedures. And we have done calls to SPs from Triggers in several situations. > >I'm at the apartment so I don't [...]
1053 89 15_SQL for Dummies9_Bob Henry21_bhenry@SUNGARDSCT.COM31_Thu, 29 Jul 2004 17:08:29 -0400747_US-ASCII I have a very basic SQL question. Using SPUFI , the select statement is:
SELECT COLLID, NAME, SUBSTR(VERSION,1,30), TIMESTAMP, OWNER, CREATOR FROM SYSIBM.SYSPACKAGE ORDER BY COLLID, NAME, VERSION, TIMESTAMP;
The result table looks like:
---------+---------+---------+---------+---------+---------+---------+----------+---------+---------+---------+
COLLID NAME TIMESTAMP ---------+---------+---------+---------+---------+---------+---------+----------+---------+---------+---------+
ADS_CSRV_BATCH LSDBIO ADS_CSRV_001_BATCH 2001-09-24 ...
Notice that the "VERSION" column is not labeled in the output, I guess because of the SUBSTR. How can I assign a name of VERSION to that output column? [...]
1143 218 19_Re: SQL for Dummies22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Thu, 29 Jul 2004 16:09:36 -0500572_iso-8859-1
SELECT COLLID, NAME, SUBSTR(VERSION,1,30) AS VERSION, TIMESTAMP, OWNER, CREATOR FROM SYSIBM.SYSPACKAGE ORDER BY COLLID, NAME, VERSION, TIMESTAMP;
Venkatesh Mokshagundam Database Administrator Corporate Systems, Amarillo, TX 79102 Ph: 806-337-3374 Fax: 806-345-2736
-----Original Message----- From: Bob Henry [mailto:bhenry@SUNGARDSCT.COM] Sent: Thursday, July 29, 2004 4:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: SQL for Dummies
I have a very basic SQL question. Using SPUFI , the select statement is: [...]
1362 174 19_Re: SQL for Dummies0_30_Victor.A.BOND@ODOT.STATE.OR.US31_Thu, 29 Jul 2004 14:08:28 -0700595_- Bob,
TRY:
SELECT COLLID, NAME, SUBSTR(VERSION,1,30) AS VERSION, TIMESTAMP, OWNER, CREATOR FROM SYSIBM.SYSPACKAGE ORDER BY COLLID, NAME, VERSION, TIMESTAMP;
-----Original Message----- From: Bob Henry [mailto:bhenry@SUNGARDSCT.COM] Sent: Thursday, July 29, 2004 2:08 PM To: DB2-L@www.idugdb2-l.org Subject: SQL for Dummies
I have a very basic SQL question. Using SPUFI , the select statement is:
SELECT COLLID, NAME, SUBSTR(VERSION,1,30), TIMESTAMP, OWNER, CREATOR FROM SYSIBM.SYSPACKAGE ORDER BY COLLID, NAME, VERSION, TIMESTAMP; [...]
1537 28 22_DB2 Connect on windows12_Bob Jeandron21_bobjeandron@YAHOO.COM31_Thu, 29 Jul 2004 14:27:23 -0700410_us-ascii Is there anyone running > 500 concurrent users on DB2 Connect (V8.1) Windows Unlimited Edition to ZOS DB2 V7.1. We are trying to get an idea if, for example, a windows 2003 2.8 GHz 4GB WEB server will handle a large number of users. Note, not using connection concentrator at this time. Using ASP and need to set current packageset with Execute Immediate and have not found a way to do that yet. [...]
1566 56 61_Sept 1st - Pittsburgh DB2 User Group Event - RSVP to register50_Cathy Peck-IDUG Board Of Directors RUG Focal Point23_cathy.peck@HIGHMARK.COM31_Thu, 29 Jul 2004 17:20:53 -0400467_UTF-8
Greetings Pittsburgh DB2ers!
On September 1st, we will be having the next FREE Pittsburgh DB2 Users Group.
The agenda / directions can be found on the IDUG Calendar at: http://www.idug.org/calendar/calendar.asp?location=71. Or as always, you can visit our PA RUG Website at: http://www.db2parug.org to get the agenda / directions too. For those w/o internet access, feel free to review the agenda shown below. [...]
1623 171 19_Re: SQL for Dummies17_Duane Lee - EGOVX22_DLee@MAIL.MARICOPA.GOV31_Thu, 29 Jul 2004 16:03:01 -0700471_iso-8859-1 Do this to assign a name:
SELECT COLLID, NAME, SUBSTR(VERSION,1,30) AS COLNAME, TIMESTAMP, OWNER, CREATOR FROM SYSIBM.SYSPACKAGE ORDER BY COLLID, NAME, VERSION, TIMESTAMP;
-----Original Message----- From: Bob Henry [mailto:bhenry@SUNGARDSCT.COM] Sent: Thursday, July 29, 2004 2:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: SQL for Dummies
I have a very basic SQL question. Using SPUFI , the select statement is: [...]
1795 178 30_Re: IN list causes TB scan ???16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Thu, 29 Jul 2004 22:50:31 -0700461_us-ascii "..are saying that I can use matching index access on either index...."
Actually what I was saying was that because of the OR predicate (LASTNAME=' ' OR FIRSTNAME = ' '), DB2 would use either both the indexes (and go for MU processing) or none at all (or non-matching scan). In the original poster's mail, since an IN predicate obviated the use of multiple index scan (i.e. eliminated the use of both indexes), DB2 chose a tablespace scan. [...]
1974 237 33_Re: Loading identity columns ....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Thu, 29 Jul 2004 22:52:42 -0700588_us-ascii I should have mentioned that we are DB2 V.1 on OS/390. Unfortunately DB2 on OS/390 does not have any IDENTITYOVERRIDE clause in the LOAD statement...wish they had it.
Raquel.
--- "Amity, John" wrote:
> Raquel, > > You can use the by default option. Try the > following load syntax, then after the load you'll > just need to select the max column value and alter > the table's restart value to one higher. > > ### AIX Korn shell Function to load DB2/UDB table > with an identity column from a compressed export ### > > > loadTableId() [...]
2212 90 35_SQL Stored Procedure Conundrum ....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Thu, 29 Jul 2004 22:55:18 -0700357_us-ascii I am reasonably sure this is a DB2 bug but thought I would run it past the list, just in case... am trying out SQL Stored Procedures on DB2 PE 8.1.3. Guide has this to say:
"Each statement in an SQL procedure is an SQL statement. Therefore, after the execution of each statement, the values of SQLCODE and SQLSTATE are implicitly set." [...]
2303 197 35_FW: Reorg-problem on lob-tablespace14_Steurs Patrick21_Patrick.Steurs@NBB.BE31_Fri, 30 Jul 2004 09:50:25 +0200590_iso-8859-1 Sorry , the layout of the spreadsheet disappeared. Hope this one is better.
Hi,
We are investigating a reorg-problem on an z/os 1.4 & db2 v6.1 system.
The orgratio of a lob-tablespace should be close to 1 after a reorg / runstats lob-tablespace.
Testscenario : table xyz in a lob-tablespace
Parameter in db2-catalog Mai 2004 23 June 2004 24 June 2004 Units SPACE 4813 6355 6988 Mb CARDF 15 25164 25175 Records AVGSIZE 2070 197219 197192 Bytes per lob FREESPACE 4877568 1925968 1939200 Kb free space ORGRATIO 1.00 20.00 3.00 1.00 = perfect [...]
2501 69 14_Reorg question41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Fri, 30 Jul 2004 10:28:44 +0200785_iso-8859-1
Hi everyone out there,
I'm posting this on behalf of a colleague of mine:
hello experts outside,
we do a reorg and a new runstats because the value of overflow > 70. after that reorg the value isn't smaller. any ideas?
we talk about db2 v7.2 on an aix box
thanks in advance
Thomas Roedel
--------------------------------------------------------------------------------- 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 [...]
2571 31 28_Cursor Not In Prepared State15_sireesh chandra20_msireesh@HOTMAIL.COM31_Fri, 30 Jul 2004 08:35:10 +0000376_- All
We have been getting this error from BEA DB2 Driver in weblogic console when weblogic instance runs for longer than 3 or 4 days, or when more than 4 to 5 users work on the application.
java.sql.SQLException: [BEA][DB2 JDBC Driver][DB2]CURSOR C02 NOT IN PREPARED STATE java.sql.SQLException: [BEA][DB2 JDBC Driver][DB2]CURSOR C02 NOT IN PREPARED STATE [...]
2603 21 35_Using IFI 0306 to read archive logs9_John Krew21_john_krew@HOTMAIL.COM31_Fri, 30 Jul 2004 12:32:31 +0200352_windows-1255 Hi,
Can IFI 0306 be used to read archive logs on *tape*? What happens in this case? Does IFI simply obediently read the bootstrap dataset, get the dsname, dynamically allocate it and start to read, regardless of what medium it is stored on? Or does it discern that the archive is on tape and refuse to allocate it dynamically? [...]
2625 278 33_Re: Loading identity columns ....14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 30 Jul 2004 14:00:36 +0100310_iso-8859-1 Raquel,
But if you have a five column table and one of the columns (the identity column) is GENERATED BY DEFAULT, then you only have to code a LOAD statement to load the other four columns. DB2 will then fill in the identity value for you without you having to specify GENERATED ALWAYS. [...]
2904 197 18_AW: Reorg question41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Fri, 30 Jul 2004 15:13:44 +0200595_iso-8859-1 Robert,
it's data overflow, and yes, the colleague did use the statements mentioned below. He also used 'sharelevel change'.
Best regards
Ruediger Kurtz/Thomas Roedel
-----Ursprüngliche Nachricht----- Von: Smit [mailto:robert.erwin.smit@wxs.nl] Gesendet: Freitag, 30. Juli 2004 10:48 An: Kurtz, Rüdiger Betreff: Re: Reorg question
Kurtz/Thomas,
Is it index or data overflow?
Did you use these commands: db2 reorg table tabschema.tabname; db2 runstats on table tabschema.tabname with distribution and detailed indexes all; [...]
3102 380 23_cobol stored procedure.16_Proctor, William25_William.Proctor@TGSLC.ORG31_Fri, 30 Jul 2004 08:43:57 -0500383_us-ascii Thanks for all replies in advance.
We are trying to get a cobol stored procedure to work. It is running in OS/390 2.10 WLM address. We are on DB2 V7.1.
This is a real simple stored procedure being used to insure that everything is setup correctly. Obviously it's not. I am getting the following error when trying to execute the procedure. [...]
3483 132 27_Re: cobol stored procedure.12_michael bell21_mbell11a1@VERIZON.NET31_Fri, 30 Jul 2004 09:11:41 -0500311_Windows-1252 My first guess would be you don't have the LE runtime library in the WLM proc but there are several other possiblilities. The SG24-4693 redbook Getting Started with DB2 Stored Procedures: Give Them a Call through the Network is the best step by step intro to stored procedures that I know of. [...]
3616 429 27_AW: cobol stored procedure.33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 30 Jul 2004 16:21:04 +0200413_iso-8859-1 CEEPIPI
12 The routine did not contain a valid Language Environment entry prolog. Insure that the routine was compiled with a current Language Environment enabled compiler. The PreInit table was not updated. The routine_entry is set to the address of the loaded routine.
You can use my Cobol-Analyzer www.cbttape.org FILE#321 to detect the type of compiler you're using for MLCSP064 [...]
4046 18 51_Re: IS THERE ANY OVERHEAD ASSOCIATED WITH A VARCHAR12_Scott Fauque19_scott.fauque@CA.COM31_Fri, 30 Jul 2004 09:23:51 -0500422_- I didn't see this mentioned...
I have heard of defining 1 byte VARCHARs so that they could be made larger in the future using a v7 ALTER if the application design change...thus no outage. Pluses and minuses obviously. In v8 this is not an issue.
On Tue, 27 Jul 2004 17:46:19 -0400, Norma Mullin wrote: >Why would you want to define a 1 character field as a varchar field? [...]
4065 55 51_Re: IS THERE ANY OVERHEAD ASSOCIATED WITH A VARCHAR14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 30 Jul 2004 15:30:53 +0100344_iso-8859-1 Also, Java only understands variable characters so the cost of conversion from a CHAR column to a Java variable may well be more than the cost of storing a VARCHAR(1)
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
4121 65 57_Standards for Accessing DB2 through ODBC, OLE DB and JDBC12_Matt Harding18_MHarding@AFLAC.COM31_Fri, 30 Jul 2004 11:11:27 -0400466_- We are looking for same examples of the implementation of standards for the ODBC, OLE DB and JDBC when accessing DB2 on z/OS from the client/server side. What is of special interest is, how security issues (RACF, trusted connections, etc.) were handled.
Thanks
Matt Harding Database Analyst IBM Certified DB2 DBA for OS/390 DB Platform Services Information Technology Division Phone: (706) 596-7675 Fax: (706) 596-3072 Email: mharding@aflac.com [...]
4187 27 29_Re: Questions about MERGECOPY7_Do Park19_doparkdba@YAHOO.COM31_Fri, 30 Jul 2004 11:05:00 -0500484_- Thank you four update, Mark.
We're on DB2 V7.1 and Z/OS 1.2.
The Incremental Imagecopy and mergecopy job took 5 hours last night. In that job Incremental Imagecopy step took 30 minutes, and MERGECOPY step took 4 hours and 30 minutes. The Full imagecopy takes around 3 hours.
Do I need MERGECOPY step in this case? I'd like to take the MERGESTEP out from that job. What do you think about it? any other suggestion? I'd like to hear any opinion from anyone. [...]
4215 68 29_Re: Questions about MERGECOPY13_Solecki, Rohn19_Rohn.Solecki@GWL.CA31_Fri, 30 Jul 2004 11:34:08 -0500391_iso-8859-1 Are there other jobs, i.e. other IC jobs, that are waiting for this one to finish before they start? If yes, then putting the merge in a separate job is a good idea. Are you doing the incremental copy to tape, or is the full copy being merged to on tape (i.e. for largest IC's we used to go directly to tape)? If yes, then putting the merge in a separate job is a good idea. [...]
4284 59 26_Re: DB2 Connect on windows13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Fri, 30 Jul 2004 17:03:31 -0500494_iso-8859-1 Bob,
Before moving to Connect PE after buying Unlimited license, we were comfortably running between 1000 and 1900 concurrent users with V7.2 fp8 on a 2gb memory windows server. No connection pooling, no concentrator. How nice it is to be free of the hardware "hop" in the architecture. 1900 was an artificial ceiling we imposed based on average memory per connection statistics for our particular mix of applications (we did not want to reach 2000 with our 2gb memory). [...]