1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 2000, week 1
2 58 43_Re: DB2 PM saving data for later processing23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Fri, 1 Dec 2000 06:54:51 -0000425_iso-8859-1 Tom
you are correct .. but you could use SMF and then process the data through DB2PM batch?
or am I way of the mark here?
Leslie Pendlebury-Bowe DB2 DBA OS390 SAP DB2 Certified
-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: Tuesday, November 28, 2000 2:36 PM To: DB2-L@RYCI.COM Subject: DB2 PM saving data for later processing [...]
61 82 46_Re: Group bufferpool and CA/Platinum DB2 tools23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Fri, 1 Dec 2000 06:59:16 -0000332_iso-8859-1 Richard
never thought this .. but good point .. it is a waste.
However, we use all our CA tools from one member .. we see no reason to use them from the other member ..
but the fortunate position is that we are an SAP site , which means 100% datasharing and hence we have GBPs for everything .. [...]
144 48 37_Re: Unload with DSNTIAUL under DB2 V516_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Fri, 1 Dec 2000 13:37:30 +0530648_- It is same as any other select statement and the whole underlying concept is exactly same......................DB2 knows as the pages in BP are of 3 types Inuse(Still Locked), Updated(Mentioned By You) and Available .
HTH Regards Sanjeev
> -----Original Message----- > From: heiko.schmaelzle@SI-BW.DE [SMTP:heiko.schmaelzle@SI-BW.DE] > Sent: Thursday, November 30, 2000 7:32 PM > To: DB2-L@RYCI.COM > Subject: Unload with DSNTIAUL under DB2 V5 > > Hi List! > > Which rows will be unloaded by this utility if there are still changed > rows of > the table in the bufferpool (the application program already said commit). > Are > [...]
193 24 13_Claim counter10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 1 Dec 2000 09:18:47 +0100338_us-ascii Hi listers.
I read some times ago that there's a claim counter used by utilities in drain process, but I cannot remember where this
counter is located (you know, the old age & lost neurons...).
Can you help me to remember where I can find this counter..?
Thanks in advance (from my neurons too). [...]
218 41 30_Re: DB2 vs. FoxPro performance15_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE30_Fri, 1 Dec 2000 02:34:30 -0600384_- Hi Mike....
Have you considered using nested table expressions ??
(goes like:
SELECT XX, YY, ZZ FROM ( SELECT A.A AS XX ,B.B AS YY ,C.C AS ZZ FROM A FULL OUTER JOIN B ON... ) AS INTERMED_RES
WHERE XX = '...'
The idea behind this that you do not have to physically store the intermediate data, but rather SELECT from it as a "virtual result". [...]
260 79 37_Re: List PreFetch/Sequential prefetch16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Fri, 1 Dec 2000 15:19:03 +0530554_- Hi Elsie, DB2 optimizer is the best to decide whether to kick sequential prefetch or random access but the things which are in our hand is to give the best information to optimizer to make it kick the right access method.DB2 optimizer will not do any kind of prefetch (if ideally the random access should be used) unless the catalog stats gives it wrong info.Same is the other way.Random access costs more I/O i.e 1 page per I/O is read but in case of sequential prefetch 32 pages/ I/O (for sqls) can be read.list prefetch is better when we can't [...]
340 57 17_Re: Claim counter16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Fri, 1 Dec 2000 16:32:17 +0530543_- Hi Max, If i can recall correctly, it is located in the hearder page of the tablespace.Not sure about location, offset, how much bytes kept.One more thing is that it is not only used by the utilities but as soon as the claims are released the claim counters are decremented. There are different claim counters kept depending on the kind of claim acquired i.e write, read with isolation or CS/RR. I think Diagnosis Guide will be able to tell us more.I do not have Diagnosis Guide with me right now so if you can have a look and share it [...]
398 32 39_Re: What Does DB2 Reorg pass to DFSORT?17_William R. Miller32_william.miller@DRESDNER-BANK.COM30_Fri, 1 Dec 2000 05:21:59 -0600552_- Hi all,
What does Reorg pass to DFSort?
It is my understanding that Reorg calculates the number of rows based upon the number of pages containing data. With fixed length rows, reorg gets it right. With varchar columns things can go wrong. DB2 estimates the number of rows, because all it has is the number of pages and the record length. This it passes on to sort using the filesz parameter. If you have a very good compression factor, then DB2 can - and here it does - get it wrong. What happens is that DFSort thinks it is going [...]
431 54 37_Re: List PreFetch/Sequential prefetch13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Fri, 1 Dec 2000 06:54:26 -0500616_iso-8859-1 Elsie, List-prefetch does not sort the index entries in cluster order. Rather it sorts them in RID order -- the order the data is actually stored. Cluster order is the order the pages SHOULD be stored.
Let me try to paraphrase an excellent analogy Bonnie Baker makes in her presentations (see www.bonniebaker.com -- Yes, her web site is finally back in business!) to explain list pre-fetch. It really is different from sequential prefetch. Bonnie, of course, tells the story very entertainingly and I won't attempt to capture that here. The story goes that Bonnie's Aunt Louise hates to go to [...]
486 52 38_Re: clustered versus Unclustered index0_24_db46@DAIMLERCHRYSLER.COM30_Fri, 1 Dec 2000 07:40:23 -0500402_us-ascii Basically, DB2 does not sort the data in the index order specified. As one can easily guess, there can be only one clustering index on any table.
The advantages of a clustering index is basically speed in accessing the data by that index.
The only disadvantage that I can think of is that at re-org time, DB2 will physically sort the data and that will take some more time. [...]
539 179 38_Re: Rejected posting to DB2-L@RYCI.COM14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE30_Fri, 1 Dec 2000 13:41:35 +0100575_us-ascii Right, here goes again, this time somewhat shorter ....
"L-Soft list server at RYCI.COM (1.8d)" schrieb:
> Your message cannot be distributed to the DB2-L list because it exceeds the > maximum message size of 250 lines. This limit has been set by the list owner > and does not necessarily apply to the other lists hosted at RYCI.COM. If you > have any question, please contact the list owner, who can be reached at > DB2-L-request@RYCI.COM. > > Hi Isaac, > > we're still alive and kicking, so to speak. Anyway, we're doing our best, but > as they [...]
719 118 39_Re: What Does DB2 Reorg pass to DFSORT?13_Lockwood Lyon19_Lockwool@MEIJER.COM30_Fri, 1 Dec 2000 07:57:06 -0500613_ISO-8859-7 All,
Thanks for your many (!) responses to this issue. Here's a summary of stuff so far. Sorry if I've not noted exactly which respondee(s) provided which insight(s).
Clearly, part of the problem is knowing "exactly what does Reorg do?". For example, it's not obvious whether Reorg really needs to decompress rows to pass to DFSORT; it may instead simply pass the index key column(s) from the index (not compressed, of course) with the still-compressed row concatenated on the end. After all, the actual sort is on the index key (for clustering), not on the row itself. The rows are [...]
838 76 37_Re: List PreFetch/Sequential prefetch15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Dec 2000 07:06:13 -0600361_iso-8859-1 Dave,
"List-prefetch does not sort the index entries in cluster order. Rather it sorts them in RID order --" That is an important distinction when the index involved in list prefetch is not the clustering index. However, if the index is the clustering index then I would presume that RID order and clustering order would be the same (?). [...]
915 35 28_Re: IMS and Stored Procedure11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Fri, 1 Dec 2000 08:32:34 -0500415_iso-8859-1 We are just now looking at this. There is doc in the DB2 Application Programming and SQL Guide. Look for ODBA. There are two sample COBOL programs shipped with DB2 (DSN8EC1, DSN8EC2) that should help get you started.
-----Original Message----- From: Jacob Ganzel [mailto:jacobg@SEMECH.CO.IL] Sent: Thursday, November 30, 2000 2:05 AM Subject: IMS and Stored Procedure [...]
951 59 30_Knowledge Management and DB2 !27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Fri, 1 Dec 2000 19:08:28 +0530522_- Hi List,
This might be somewhat offbeat but still let me explain the stuff.
1) We are looking at setting up a Knowledge Management site for our organization. Basically, this KM site needs to be a browser based software which interacts with Lotus Notes, Microsoft Office and RDBMS like DB2 , Oracle, Informix,etc . It needs to be personalizable to each employees needs in terms of getting people skillsets, information within the organization and outside, settign up project spaces or virtual places . [...]
1011 40 37_Re: List PreFetch/Sequential prefetch13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Fri, 1 Dec 2000 08:38:51 -0500374_iso-8859-1 Hi Linda, It's probably a poor choice of wording on my part.
If you have a clustering index that is poorly clustered, rid order is not cluster order.
Probably what I should have said is that for an index with poor clusterratio, whether it's a clustering index or not, the RIDs are not in cluster order and need to be sorted in data page order. [...]
1052 57 37_Re: List PreFetch/Sequential prefetch15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 1 Dec 2000 07:44:02 -0600412_iso-8859-1 Ah, thanks very much for clarifying that point. Now it makes sense. I learn so much from monitoring this list.
Linda
-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Friday, December 01, 2000 7:39 AM To: DB2-L@RYCI.COM Subject: Re: List PreFetch/Sequential prefetch
Hi Linda, It's probably a poor choice of wording on my part. [...]
1110 107 34_Re: Knowledge Management and DB2 !9_Cam White20_cwhite@REVEALNET.COM30_Fri, 1 Dec 2000 08:50:06 -0500646_iso-8859-1 A far cheaper, customizable alternative for DB2 Knowledge Management for OS/390 would be to consider RevealNet's Knowledge Base for DB2:
* 1,700 topics on DB2 design, development and administration * current through v6 * Includes Instant Messages for DB2 (a consolidated list of error messages) * Updated 2x per year * Contributors include Gabrielle Wiorkowski, Craig Mullins, Willie Favero * Customizable - add your own notes, docs, listserv threads, etc. to any topic or error message * IBM Redbook content and pre-supplied drilldowns to BookManager docs * Software can be easily configured for shared access on a server [...]
1218 67 37_Re: List PreFetch/Sequential prefetch11_rick creech18_ykcirc@HOTMAIL.COM30_Fri, 1 Dec 2000 08:08:21 -0600651_- Hi,
I thought I would add a few comments based on my own observations over the years. Sometimes you might want to look at DB2 performance tuning from 2 different perspectives(in general): 1. online/transaction processing/record-at-a-time processing. 2. batch/decision-support processing/some non-typical online processing. If I am tuning for (1), for the optimal case I am trying to achieve random I/O and a minimum of I/O. This often means there will be no prefetch. Therefore, prefetch is sometimes a red flag that points out sql that could use more tuning. Also, I am trying to eliminate sorts wherever possible. Sorts can especially [...]
1286 19 34_Re: Knowledge Management and DB2 !14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 1 Dec 2000 10:35:35 -0500423_ISO-8859-1 Deepak, It seems to me that the underlying engine is less important - than where and how are you going to get the data and "knowledge" that you want...
Regards, Joel
===============================================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.
1306 51 24_Finding a row with a RID15_Stovall, Martin16_MStovall@USG.COM30_Fri, 1 Dec 2000 10:30:27 -0600233_iso-8859-1 I have a RID of '008811030F', the manual says that the RID made up of part page # and part is the row id on the page; this tablespace Is partitioned; how do I determine which is the partition #, the page # and the row id??
1358 40 11_Re: compare14_David, Osborne27_Osborne_David@COMPUWARE.COM30_Fri, 1 Dec 2000 11:32:14 -0500323_iso-8859-1 Jeff, This can be done with our DBA-Xpert product via the Compare facility. In addition, the tool has capabilities that support all other administrative functions that a DB2 DBA utilizes on a regular basis. All of this is supplied in a single tool. If you need more information you can contact me directly. [...]
1399 65 35_Re: jdbc - App driver vs Net driver14_Holman, Vivian27_Vivian_Holman@COMPUWARE.COM30_Fri, 1 Dec 2000 11:51:19 -0500334_iso-8859-1 I hit a similar problem, and in my case I had forgotten to define the data source in the DB2 client configuration assistant. The net driver worked fine because I had the full connect string specified, but the app driver didn't work until I had defined the data source locally on the machine that was running the code. [...]
1465 51 28_Re: Finding a row with a RID11_Joseph Link26_joe.link@FIRSTDATACORP.COM30_Fri, 1 Dec 2000 10:54:58 -0600380_us-ascii Look at pages 295-296 of the DB2 UDB for OS/390 V6 Diagnosis Guide and Reference. The size of the RID and the placement of the partition number depend on the DSSSIZE of the tablespace, the number of partitions and the page size. Assuming that this tablespace has a DSSSIZE of 4, and 4 KB pages, it looks like your RID is for partition 9, page 8811030 and row ID 0F. [...]
1517 31 24_Hardware Upgrade and DB212_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Fri, 1 Dec 2000 12:14:43 -0500579_iso-8859-1 Hello,
We are upgrading our hardware, going from 3 cpus to 1 cpu. Are there any zparm or other changes that need to be made or does the optimizer automagically "know" that the CPU configuration is different? Also, the new machine has hardware compression. Anything we need to change before DB2 will use the compression, or does DB2 try a HW compression instruction and if it fails revert to SW compression? And while I'm on a roll.....we upgraded our DASD from 3390s to a raid device. Does DB2 need any zparm (or other changes) to know about the new dasd? [...]
1549 60 28_Re: Hardware Upgrade and DB216_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Fri, 1 Dec 2000 13:04:13 -0500504_iso-8859-1 Robert, You don't need to touch ZPARM. You will want to consider use of DEGREE(ANY) on binds. The optimizer will know about the hardware change automatically. DB2 will try hardware compression if you specify COMPRESS(YES) on tablespaces. If hardware assist is not available you will get a message saying so. As for the RAID, no changes but beware of 'RAID 5 Write Penalty' if your DASD is RAID-5. RAID-5 can suffer significant elapsed time increases on writes unless it is highly cached. [...]
1610 41 28_Re: Hardware Upgrade and DB214_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 1 Dec 2000 13:24:55 -0500460_ISO-8859-1 Going from 3 processors to 1, or from a processor with 3 cpu engines to a processor with 1 cpu engine? If it's 1 cpu engine, you may be in for some nasty surprises regarding overall system performance and throughput. Regarding RAID, you will find that a cache miss will give worse performance than the 3390...... so hope you have cache to the max. Don't let anyone tell you that dataset placement doesn't matter on RAID, because it still does. [...]
1652 20 15_CA - RC Compare10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM30_Fri, 1 Dec 2000 13:25:40 -0500342_us-ascii A few weeks back I posted a question to the list asking for information related to RC Compare and Admin Portfolio. CA and Wendy's disagreed as to whether Wendy's owned the product. I am happy to report that Scott Jessee of CA stepped in and resolved the issue, and I would like to publicly thank him for his help! Thanks Scott! [...]
1673 41 26_Running the Repair Utility0_29_paul.packham@POSTOFFICE.CO.UK30_Fri, 1 Dec 2000 18:42:44 +0000353_us-ascii Hi,
I running the Repair Utility in a batch job at the moment. This is necessary because I have just done an DFDSS offline system copy from one of our SAP DB2s to another. The repair that I'm running looks like this : REPAIR LOCATE TABLESPACE A000XAAX.TNOTEED PAGE 0 VERIFY OFFSET X'28' DATA 'EPD1' REPLACE OFFSET X'28' DATA 'EPC1' [...]
1715 19 30_Implicit Tablespace Definition16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU30_Fri, 1 Dec 2000 14:13:58 -0500343_iso-8859-1 Hey Folks... We have a situation where certain developers will be creating their objects in our development LPAR. They will be creating tables without specifying a tablespace. Is there a way to increase the default PRIQTY & SECQTY, so they or myself has to get involved with that?
Michael Dempsey UNC Health Care System [...]
1735 78 30_Re: Running the Repair Utility20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 1 Dec 2000 14:21:17 -0500320_us-ascii Paul
I can see that you are trying to change the DB2 subsystem name after restoring datasets. But that is not required at all. In other words there is no need to change subsystem name in the header what needs to be changed are the following-
1. REPAIR LEVELID 2. OBID translation (if needed) [...]
1814 40 14_I/O contention12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US30_Fri, 1 Dec 2000 14:32:03 -0500583_US-ASCII We have 2 batch applications which run concurrently in our DB2 subsystem and are I/O bound. We have been asked to improve the batch run times without changing the existing applications. One app accesses most its data in sequential order, while the other accesses the data in a random sequence. We have isolated the applications into their own BPs and while we have seen some hit ratio improvement, we have not seen a corresponding improvement in the overall runtimes of the batch cycle. We are currently at version 5 of DB2 and have massive BPs (virtual over 1 gig and [...]
1855 16 34_Re: Implicit Tablespace Definition0_26_truman.g.brown@VERIZON.COM30_Fri, 1 Dec 2000 14:10:47 -0500437_us-ascii I think what you're saying (?) is that they intend to use the default database. This isn't a good idea - I would make them use explicit database and tablespace definitions.
George
================================================ 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.
1872 60 18_Re: I/O contention14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 1 Dec 2000 14:58:00 -0500360_ISO-8859-1 Shark should help your I/O problem substantially.... how much depends on the amount of IOQ time that is part of your 20-30 Ms response. It would help your determination if you have the elapsed time components of the response times..... before/after you move to Shark.
DO NOT totally buy the "dataset placement does not matter scenario". [...]
1933 80 18_Re: I/O contention20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 1 Dec 2000 15:03:21 -0500562_us-ascii Mark
Unfortunately you were asked not to consider what is most important to consider, i.e. to change the application. However, even without changing application design, you could help improve performance some times.
I don't know how your application is but consider the following scenarios -
- Application which was doing tons of random I/O was correct simply by using a sorted input (sorted in the clustering order of driver table cursor). No change in the application but one extra DFSORT step for sorting the input dataset. [...]
2014 20 43_DB2-L MAINTENANCE (ISP CHANGE THIS WEEKEND)14_Charles Golson22_RYC_INC@COMPUSERVE.COM30_Fri, 1 Dec 2000 15:11:16 -0500442_ISO-8859-1 The list is changing its internet service provider this weekend beginning at 5:00 EST today.
We expect the list to be back in service Saturday 12/2/2000, by 8:00 am EST.
Thanks.
===============================================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.
2035 54 34_Re: Implicit Tablespace Definition0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 1 Dec 2000 14:13:47 -0600481_us-ascii I agree with Truman, don't do it. We have a similar setup to what you describe for one of our apps. The developers can create their own tables, in development DB2 subsystem only.
We have them setup with a personal Database, stogroup, vcat (all based on their userid) in our development DB2 subsystem (on OS390). DBA provides/maintains standard (current production definition which includes the TS) DDL (actually a DBA Expert 'Mod') that any developer can use. [...]
2090 20 30_Re: Running the Repair Utility0_29_paul.packham@POSTOFFICE.CO.UK30_Fri, 1 Dec 2000 20:13:40 +0000497_us-ascii Pillay,
Thanks for your reply. In our case I think we do need to change the system id and the vcat in the header page because we have ISV products which throw out errors if they find a mismatch.
Regards, Paul Packham The Post Office
================================================ 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.
2111 74 18_Re: I/O contention19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 1 Dec 2000 14:15:26 -0600472_ISO-8859-1 Mark, Given you're not Shark / PAV now, this is usually a dataset placement problem -- too many "hot" datasets on the same volume! Or too many "hot" datasets on volumes behind a single controller. Monitor the I/O subsystem with a very small interval, say 5 or 1 min(s)., and you'll find the problem. It'll be either high IOSQ or device busy. Find the datasets with the highest hits and move a few around to new volumes preferably on different controllers. [...]
2186 75 18_Re: I/O contention12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US30_Fri, 1 Dec 2000 15:34:30 -0500335_US-ASCII Joel -
Thanks for the reply. We are planning on doing a before/after benchmark.
Is there anyway to "place" datasets on shark? It was my understanding that although we might define things on different "volumes", these "volumes" were only logical - not physical - so they could reside anywhere on the device. [...]
2262 21 18_Re: I/O contention0_26_truman.g.brown@VERIZON.COM30_Fri, 1 Dec 2000 15:41:31 -0500365_us-ascii Mark,
Several good suggestions have already been made. I'd like to add: check the HPSEQ value on the hiperpool that's backing up your random activity VBP. You may improve hiperpool hits substantially by lowering this value if it's too high and there's any concurrent sequential activity.
EX: VBP VPSEQT=70, make corresponding HPSEQT=40. [...]
2284 109 18_Re: I/O contention12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US30_Fri, 1 Dec 2000 16:08:15 -0500401_US-ASCII Could you expand on the techniques you mention below for converting to "c" type or "n" type hybrid joins.
Thanks! >>> venkat_pillay@ML.COM 12/01 3:03 PM >>> Mark
Unfortunately you were asked not to consider what is most important to consider, i.e. to change the application. However, even without changing application design, you could help improve performance some times. [...]
2394 29 59_Logical Page List (LPL) Error While Inserting Into an Index9_Don Alden25_Don.Alden@I-STRUCTURE.COM30_Fri, 1 Dec 2000 14:02:50 -0700506_iso-8859-1 Fellow Listers,
We have an application that is "cratering" an index while trying to INSERT a duplicate row. DB2 returns the customary -803 abend. Instead of the usuall Rollback we get an error message "DSNB250E - A Page Range was added to the Logical Page List" and the Index is then put into LPL status. When another application tries to access the table it gets a -904 (resource unavailble) so we either Recover the index or Start the Database/Tablespace to remove the LPL status. [...]
2424 24 22_Subtracting timestamps0_26_Bill.Huguenard@WATKINS.COM30_Fri, 1 Dec 2000 16:07:00 -0500521_- When calculating the difference between two timestamps in COBOL as in the following example, how should the resulting host variable be defined?
EXEC SQL SELECT TIMESTAMP(:WS-CALC-END-TS) - TIMESTAMP(:WS-CALC-START-TS) INTO :WS-CALC-DIFF-COMP FROM WMDATDTE END-EXEC.
We have tried to define WS-CALC-DIFF-COMP as S9(14)V9(6) COMP-3 and received a precompile error stating that the host variable was undefined or unusable. We are running V5 DB2 on MVS/OS390. Please reply to Bill.Huguenard@Watkins.com. [...]
2449 60 26_Re: Subtracting timestamps0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 1 Dec 2000 15:31:22 -0600453_us-ascii I was just looking at my chart
DB2 Timestamp = COBOL Pic X(26) DB2 Date = COBOL Pic X(10) DB2 Time = COBOL Pix X(8)
Note: that assues you are using ISO default date display format "yyyy-mm-dd" and timestamp format '1999-11-18-00:00:00.000000'
Bill.Huguenard@WATKINS.COM@RYCI.COM> on 2000/12/01 03:07:00 PM
Please respond to DB2 Data Base Discussion List [...]
2510 51 26_Re: Subtracting timestamps14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Fri, 1 Dec 2000 16:48:46 -0500711_iso-8859-1 The result should be pic s9(20)v9(6). The result is of the form YYYYMMDDHHMMSS.ssssss.
Manas.
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Bill.Huguenard@WATKINS.COM > Sent: Friday, December 01, 2000 4:07 PM > To: DB2-L@RYCI.COM > Subject: Subtracting timestamps > > > When calculating the difference between two timestamps in COBOL as in the > following example, how should the resulting host variable be defined? > > EXEC SQL > SELECT TIMESTAMP(:WS-CALC-END-TS) - > TIMESTAMP(:WS-CALC-START-TS) > INTO :WS-CALC-DIFF-COMP > FROM WMDATDTE > END-EXEC. > > We have tried to define WS-CALC-DIFF-COMP as S9(14)V9(6) COMP-3 > [...]
2562 57 26_Re: Subtracting timestamps19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Fri, 1 Dec 2000 17:10:11 EST840_us-ascii Bill,
Have you defined your two input host variables as PIC X(26) ??
I tried the same thing under SPUFI and your output field seems to be correctly defined.
SELECT TIMESTAMP('9999-12-31-00.00.01.000000') - TIMESTAMP('0001-01-01-00.00.01.000000') FROM DDC2ACTC.T0547_ZERO_PRK_MCI ; ---------+---------+---------+---------+---------+---------+-------
---------+---------+---------+---------+---------+---------+------- 99981130000000.000000 DSNE610I NUMBER OF ROWS DISPLAYED IS 1
Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: , on 12/01/2000 4:07 PM: When calculating the difference between two timestamps in COBOL as in the following example, how should the resulting host variable be defined? [...]
2620 49 26_Re: Subtracting timestamps19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Fri, 1 Dec 2000 17:12:43 EST577_us-ascii Bill,
Another thing to look for is whether the variables are in a copybook. In which case, if you are using a COBOL COPY the precompiler will not see it. Change the COPY to 'EXEC SQL INCLUDE END-EXEC'.
Just another thought.
Ciao,
Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: , on 12/01/2000 4:07 PM: When calculating the difference between two timestamps in COBOL as in the following example, how should the resulting host variable be defined? [...]
2670 21 48_Allocating CPU time in a DB2/Connect Environment14_Gill, Joseph G19_joseph.gill@EDS.COM30_Fri, 1 Dec 2000 17:20:38 -0500386_iso-8859-1 Is the field QWHUCPU in the DB2 101 record a good field to use to capture the CPU used by users coming in via DB2/Connect?
Is it accurate enough to allocate resource utilization among various users? (Assuming a monoplex with no sharing).
Does this field capture the amount of CPU time required to process a given request, in all of the DB2 address spaces? [...]
2692 93 8_Packages10_Alan Smith25_alancsmith@BTINTERNET.COM30_Sat, 2 Dec 2000 11:08:33 +0000322_US-ASCII The best way from a housekeeping point of view is not to use versions. However, you need to keep old DBRMs in case of backout, copy up of load module and package need to be synchronised exactly, and I think you will get contention when binding the new package if someone is running against the existing one. [...]
2786 78 52_Re: Does an elephant fly? No? Prove it. - Conclusion19_Alekos Papadopoulos13_apapad@NBG.GR30_Sat, 2 Dec 2000 13:51:20 +0200503_ISO-8859-7 Thank you all for the nice suggestions. With your help I have a way out of the problem: A summary of the solution follows: ALTER TABLE ADD COLUMN does not ivalidate the the plan unless the column is of type DATE, TIME or TIMESTAMP as Ranjay Sinha and Sanjeev told. If a package is not rebound then there is not even a warning in its execution as Mohammad Khan said (that's why I didn't get any warnings after the ALTER, not even after a REORG on the table as Colin correctly suggested). [...]
2865 58 34_Re: Knowledge Management and DB2 !27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Sat, 2 Dec 2000 02:53:09 -0500638_- Joel,
The data will typically be coming from disparate sources , ie both structured and unstructured information. The structured information could be from RDBMS such as Oracle, DB2,etc while the unstructured information could be MS Office such as MS-Word Docs, Reports and Email from MS Outlook.
Again , the idea is that knowledge should be intelligently mined to get pertinent information rather than some related information. We understand that Lotus and IBM have come out with Raven and Intelligent Miner and Discover and other vendors like Plumtree and Hummingbird are also in the market, what we would like is a [...]
2924 14 18_Re: I/O contention0_26_truman.g.brown@VERIZON.COM30_Fri, 1 Dec 2000 15:45:42 -0500339_us-ascii Your SMS people should be able to map logical volumes to physical volumes.
George
================================================ 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.
2939 23 26_update of partitioning key10_Alan Smith25_alancsmith@BTINTERNET.COM30_Sat, 2 Dec 2000 11:08:36 +0000528_US-ASCII In a partitioned tablespace, if you update a row so that its key changes and it needs to be moved from one partition to another, the source and destination partitions and those inbetween as well as index parts and NPIs are drained. Can anyone tell me why this happens - surely all DB2 has to do is do a delete followed by an insert. Is this going to be corrected? - I don't want to disable partition-key updating at subsystem level, and I can see us hitting this problem as we partition more and more tablespaces. [...]
2963 32 8_Question15_Enrique Escobar17_enesc@HOTMAIL.COM30_Fri, 1 Dec 2000 22:38:28 -0000489_- Hi guys,
I know this is a DB2 list, but recently I have been working with Oracle too. I wonder if somebody knows a way to send an e-mail (or knows a list of users like this one) depending on a specific condition whitin a script.
The situation is the following : When we execute the Load, sometimes we generate a file containing all the rejected records from this load. What I need to do is send an e-mail (with the file attached) notifying that this file was created. [...]
2996 15 40_DB2-L MAINTENANCE - ISP CHANGE COMPLETED14_Charles Golson22_RYC_INC@COMPUSERVE.COM30_Sat, 2 Dec 2000 14:27:51 -0500333_ISO-8859-1 The internet service provider change is completed and the list is back in service.
===============================================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.
3012 66 18_Re: I/O contention12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM30_Sat, 2 Dec 2000 14:06:51 -0600487_- Mark:
This is just an advise. If you are on os/390 v2.4 or later you should be able to use the news RMF Monitor III Reports. Now it allows you to generate Dataset level reporting and then you would be able to find out what datasets has high activity and maybe just placing some of them in differents volumes you may balance you I/O Workload. Take a glance at the website www9.s390.ibm.com/rmf. There are many presentations with plenty of information about RMF monitor III. [...]
3079 51 45_Time to Schedule User Group Speakers for 200113_Willie Favero21_wfavero@ATTGLOBAL.NET30_Fri, 1 Dec 2000 21:30:03 -0600702_iso-8859-1 Hi all,
I am posting this for our group at BMC that schedules speakers for user groups.
Willie Favero
---------------------------------------------------------------------------
As the new year is almost over, BMC realizes you are already making plans for your user group meetings for the year 2001. BMC would like to offer it’s services by providing educational and technical presentations at your meetings. BMC has long been involved in many user group meetings and our presentations have been well received. We have several top notched presenters such as Craig Mullins and Willie Favero just waiting to help educate your users. We have many presentations [...]
3131 22 63_Anyone using MetaMatrix to integrate UDB and other data sources17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM30_Sat, 2 Dec 2000 18:00:36 -0500326_iso-8859-1 Looking to find out if anyone out there is using MetaMatrix (Content Integration Platform and Global Data Dictionary) to integrate data from DB2 UDB (UNIX) and other data sources (Sybase, DB2 OS/390, etc.). Also would be interested to know if anyone looked at MetaMatrix and decided on some other alternative. [...]
3154 21 18_Re: I/O contention14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Sat, 2 Dec 2000 22:34:07 -0500514_ISO-8859-1 Message text written by DB2 Data Base Discussion List >Your SMS people should be able to map logical volumes to physical volumes<
If you're really on a RAID box, there is no physical mapping since data is striped across multiple disks.
Regards, Joel
===============================================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.
3176 41 18_Re: I/O contention14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Sat, 2 Dec 2000 22:43:18 -0500375_ISO-8859-1 Mark, You only care about the "logical" volume placement, since this is where any contention will occur. Being a RAID device, you no control over where the data gets striped internally...
Regards, Joel
Message text written by DB2 Data Base Discussion List > Joel -
Thanks for the reply. We are planning on doing a before/after benchmark. [...]
3218 17 34_Drivers to Access DB2/400 database20_Yasas Mallawarachchi14_yasas@SLIIT.LK30_Sun, 3 Dec 2000 12:21:59 +0600371_iso-8859-1 Hi All, Are there any other driver other than Client Access to access DB2/400 database from an NT machine
Yasas
================================================ 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.
3236 40 12_Online Reorg12_Higgins John25_HigginsJohn@JOHNDEERE.COM30_Sun, 3 Dec 2000 14:56:26 -0600565_iso-8859-1 Hello, All.
We have been running online reorgs (SHRLEVEL CHANGE) for several months with no problems.
Friday afternoon, we had 61abends due to sqlcode -904's on one tablespace in about 12 minutes while the tablespace (single table tablespace) was being reorg'ed.
I suspect that we had some other job (probably read-only) that was blocking the reorg from entering the UTUT state during the switch phase. Because reorg must drain all classes, read-only jobs block reorg unless they commit. This is true even if they read with UR. [...]
3277 75 41_Calling the DB2 LOAD utility via DSNUTILS0_31_Ross_Mallett@SEARCHSOFTWARE.COM30_Mon, 4 Dec 2000 09:29:19 +1000574_us-ascii I'm hoping that someone here can help me. I'm trying to call the DB2 LOAD utility via DSNUTILS: EXEC SQL CALL SYSPROC.DSNUTILS ( :utility_id, :restart, :ustmt, :retcode, :utility_name, :recdsn, :recdevt, :recspace, :discdsn, :discdevt, :discspace, :pnchdsn, :pnchcdevt, :pnchspace, :copydsn1, :copydevt1, :copyspace1, :copydsn2, :copydevt2, :copyspace2, :rcpydsn1, :rcpydevt1, :rcpyspace1, :rcpydsn2, :rcpydevt2, :rcpyspace2, :workdsn1, :workdevt1, :workspace1, :workdsn2, :workdevt2, :workspace2, :mapdsn, :mapcdevt, :mapspace, :errdsn, :errdevt, :errspace); [...]
3353 82 12_Re: Question14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Mon, 4 Dec 2000 14:10:35 +1100456_iso-8859-1 Some snips about two Oracle lists: 1) "To subscribe to the list, send a message to: " 2) "All commands to ListGuru should be sent to:
ListGuru@fatcity.com
Commands go in the message BODY, not the Subject: line. If you want a list of all possible commands, put 'HELP' in the message body and you will be returned a complete list of ListGuru commands." (You'll want to subscribe to ORACLE-L) [...]
3436 16 96_Per-Erik Svennberg/P001890/Nordbanken =?iso-8859-1?q?=E4r?= inte =?iso-8859-1?q?p=E5?= kontoret.15_Pelle Svennberg24_per-erik.svennberg@NB.SE28_Mon, 4 Dec 2000 07:05:44 GMT318_iso-8859-1 Jag är borta från kontoret från 2000-12-04 till 2000-12-11.
===============================================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.
3453 23 45_Minimum bandwidth requirement for replication18_Yosia Widi Nugroho20_yosia@CENTRIN.NET.ID30_Mon, 4 Dec 2000 14:39:06 +0700564_- Dear guys,
Does anyone know about the minimum bandwidth requirement for DB2 replication? We will implement the data replication via VSAT. FYI, the amount of data that will be replicated is about 100KByte.
Need your advice soon. Thanks.
regards, Yosia.
Cheers, Yosia W. Nugroho
================================================ 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.
3477 70 16_Re: Online Reorg16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Mon, 4 Dec 2000 02:53:47 -0500632_- Do you find any indication of this in the MSTR address space.Probably you will find out what is the reason for resource unavailable corresponding to that utility job.
Hope this helps
Regards Sanjeev
> -----Original Message----- > From: Higgins John [SMTP:HigginsJohn@JOHNDEERE.COM] > Sent: Monday, December 04, 2000 2:26 AM > To: DB2-L@RYCI.COM > Subject: Online Reorg > > Hello, All. > > We have been running online reorgs (SHRLEVEL CHANGE) for several months > with > no problems. > > Friday afternoon, we had 61abends due to sqlcode -904's on one tablespace > in about 12 minutes while the tablespace [...]
3548 54 34_Re: Implicit Tablespace Definition25_Sinha, Ranjay Kumar (CTS)24_SRanjay@CAL.CTS-CORP.COM30_Mon, 4 Dec 2000 13:15:49 +0530475_- Hi Michel, When ever a "create Table " command is issued without specifying the the tablespace name DB2 generates the tablespace name (depending upon the table name) in the default database(DSNDB04) using the default STOrage group (SYSDEFLT). Db2 uses the default values for space allocation and other table space attributes. After the tablespace creation with dafault value (12 for priqty , 4 for secqty) u can increase the PRIQTY and SECQTY by "ALTER TABLESPACE " . [...]
3603 122 30_Re: Running the Repair Utility0_18_mebert@AMADEUS.NET30_Mon, 4 Dec 2000 09:45:50 +0100355_us-ascii Before actually starting the Utility, DB2 has to parse all the input statements and put them into SYSUTILX (for restartability with the RESTART parm). I have noticed that this can take quite a long time with high CPU usage. It is probably better to split the input into 100-200 separate DSNUTILB invocations, with 50-100 statements at most. [...]
3726 62 63_Re: Logical Page List (LPL) Error While Inserting Into an Index16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Mon, 4 Dec 2000 04:07:05 -0500454_- Hi Don, I am not sure if insert only put in your pageset in LPL but there could be a possiblility that someone had run the LOAD with Enforce No and after the tablespace was put into check pending status the start with access force was issues and at the 1st insert tablespace might have gone into LPL.As you said "instead of rollback" , rollback is not issued when -803 is issued.Did u find this message in the MSTR address space ? Hope this helps [...]
3789 68 26_UDB/NT Migration 5.2 > 7.112_Paul Pennock35_PAUL.PENNOCK@FRIENDSPROVIDENT.CO.UK30_Mon, 4 Dec 2000 09:28:04 +0000623_ISO-8859-1 --- Received from FPU.PENNOP 7981891 04-12-00 09:14
-> IN=DB2-L@RYCI.COM
Hi all,
I'm planning to upgrade our UDB System from version 5.2 to 7.1 we don't use stored procedures, replication or any of the other bells and whistles available but :
as well as the software upgrade we will be upgrading to Windows 2000 from NT and we're also upograding the hardware from a compaq 5500 to an 8500. In addition to this my network guys are trying to sell me the benefits of SAN storage technology - although I have my doubts about the performance benefit. The current server configuration [...]
3858 20 26_update of partitioning key11_Hans Selman26_hans.selman@NL.ABNAMRO.COM30_Mon, 4 Dec 2000 12:15:18 +0100464_us-ascii Alan
We did have a similar problem with an update of a partitioning key and locking out a lot of our partitions. Please check UQ47208 for solving this problem.
Hans Selman ABN AMRO Bank NV Netherland
================================================ 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.
3879 92 18_Re: I/O contention12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US30_Mon, 4 Dec 2000 07:40:33 -0500632_US-ASCII Thanks for the information. I will request the report!
Mark Anzmann Database Administration DHRIS Program Andersen Consulting Team
>>> harbry_a@HOTMAIL.COM 12/02 3:06 PM >>> Mark:
This is just an advise. If you are on os/390 v2.4 or later you should be able to use the news RMF Monitor III Reports. Now it allows you to generate Dataset level reporting and then you would be able to find out what datasets has high activity and maybe just placing some of them in differents volumes you may balance you I/O Workload. Take a glance at the website www9.s390.ibm.com/rmf. There are many presentations [...]
3972 28 41_Datasharing and False Contention - 1 LPAR16_Ouellette, Lee R21_OUELLETTELR@AETNA.COM30_Mon, 4 Dec 2000 08:26:45 -0500550_iso-8859-1 We have experienced a strange situation which I'm wondering whether others have encountered previously.
We are in a 5-way datasharing environment, and when the DBA runs a Load job, encounters a lengthy increase in runtime (what had previously been able to Load in just under 30 minutes runs up to 5 hours). Via an online monitor, we've seen 98-99% false contention with no known other access from the other LPARs (in fact, the Load job is running off-hours, on the weekend - with the DBA controlling submission of other jobs). [...]
4001 79 16_Re: Online Reorg16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Mon, 4 Dec 2000 08:32:17 -0500396_iso-8859-1 John, We have had a similar situation. It was caused by applications with too few COMMITs. The way we found them was to use our scheduler to submit jobs which had: TSO TIME DSN SYSTEM(ssid) -DISPLAY DATABASE(dbname) SPACE(tsname) CLAIMERS LIMIT(*) every minute. We directed the output of each job to a dataset rather than to the console so that the output was easier to decipher. [...]
4081 55 52_Re: Does an elephant fly? No? Prove it. - Conclusion13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Mon, 4 Dec 2000 08:15:55 -0600470_- Just one more comment about the issue. The fears of your management about getting into a big resource consuming project are unfounded. This is not an all or nothing change i.e. programs can be changed individually. In my opinion the logical course would be that whenever a programmer is working on program this change ("SELECT *" to "SELECT column-list") should also be done. You'd move towards a better environment without anybody even noticing it. HTH Mohammad [...]
4137 48 45_Re: Datasharing and False Contention - 1 LPAR20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Mon, 4 Dec 2000 09:20:14 -0500319_us-ascii I suggest, you report this to IBM because if what you are saying is correct i.e. Non GBP dependent tablespace (load from 1 LPAR and no other access), then there should not be any CF movements and hence no false contention.
However, you could double check on your own by starting CF related traces. [...]
4186 49 45_Re: Datasharing and False Contention - 1 LPAR11_rick creech18_ykcirc@HOTMAIL.COM30_Mon, 4 Dec 2000 08:31:19 -0600658_- Hi, Just out of curiosity what is the current size of your lock structure? Thanks.
Rick Creech
>From: "Ouellette, Lee R" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Datasharing and False Contention - 1 LPAR >Date: Mon, 4 Dec 2000 08:26:45 -0500 > >We have experienced a strange situation which I'm wondering whether others >have encountered previously. > >We are in a 5-way datasharing environment, and when the DBA runs a Load >job, encounters a lengthy increase in runtime (what had previously been >able to Load in just under 30 minutes runs up to 5 hours). [...]
4236 161 18_Re: I/O contention20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Mon, 4 Dec 2000 09:41:05 -0500479_iso-8859-1 Hi Mark
Usually updating the catalog is most effective way to convert your nested loop joins to Hybrid but it is widely believed to be dangerous.
I have a little different opinion on this issue. I believe, if application folks are not ready to change their stuff or some kind of politics is involved, I would tweak with access path (in order to get better performance without application change) and keep good documentation on this catalog changes. [...]
4398 22 31_Subtracting timestamps/solution0_26_Bill.Huguenard@WATKINS.COM30_Mon, 4 Dec 2000 09:45:00 -0500377_- FYI: Last week I had posted a question regarding how to define a host variable in COBOL to receive the result from a query that subtracted one timestamp from another. The SQL Reference indicates that the host variable should be DECIMAL(20,6), translated to PIC S9(14)v9(6) COMP-3. We received a precompile error stating that the host variable was undefined or unusable. [...]
4421 28 52_Re: Does an elephant fly? No? Prove it. - Conclusion13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Mon, 4 Dec 2000 10:30:59 -0500585_iso-8859-1 Mohammad, That's an excellent observation. -- or at least one with which I wholeheartedly agree.
On the last few projects for applications I supported, we had a list of changes like that which were less than urgent, but which needed to be implemented eventually.
Programmers had the responsibility of checking the list whenever a program was opened for other changes. The "While-you're-in-there" list worked out very well and when the list of programs still unchanged for an item got small enough, project managers usually assigned the change explicitly. [...]
4450 103 30_Re: UDB/NT Migration 5.2 > 7.10_22_Rohn.Solecki@MTS.MB.CA30_Mon, 4 Dec 2000 09:59:43 -0600553_us-ascii Just the obvious advice. Keep your life simple, do one change at a time and wait for it to stabilize before stating the next change.
If you change more than one thing at a time and run into problems, ie performance problems, then you've set yourself up for the 'vendor finger pointing game'. You know, ". . . the problem couldn't possibly be with our stuff, it's got to be the other guy . . .". On the otherhand, having the new hardware come with Win2K installed is probably a good idea, because then you can let Compaq worry about [...]
4554 13 20_Predictive Governor?11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Mon, 4 Dec 2000 10:15:55 -0600330_us-ascii Is anyone using the Predictive Governor and be willing to share their settings?
================================================ 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.
4568 57 33_DB2 OS/390 V6.1 DSNZPARM ARCHRETN16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM30_Mon, 4 Dec 2000 11:26:28 -0500304_iso-8859-1 We just upgraded to V6.1. We have a value of "ARCHRETN=14" in our DSNZPARM, the same as V5.1. Has anyone else noticed that the primary archive log is only being retained for two (2) days and the secondary archive log is being retained forever? Any ideas as to why this is happening? TIA. [...]
4626 25 16_Re: Online Reorg9_Jim Ruddy18_jaruddy@US.IBM.COM30_Mon, 4 Dec 2000 11:19:39 -0600604_- Another alternative is to set the "UR CHECK FREQ" on panel DSNTIPB.
"Specify the number of checkpoint cycles to complete before DB2 issues a warning message to the console and instrumentation for an uncommitted unit of recovery (UR).
Accept the default to disable this option. This option does not affect performance. If you use this option, specify a value that is based on how often a checkpoint occurs in your system and how much time you can allow for a restart or shutdown. For example, if your site's checkpoint interval is 5 minutes and the standard limit for issuing COMMITs [...]
4652 66 41_Re: parallelism on UNIX - DB2 UDB EE (E?)16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT30_Mon, 4 Dec 2000 18:28:48 +0100455_us-ascii Tim,
thanks a bunch for your reply - unbelievable, I finally understood why I was getting so mixed up with all those EEEEEEEs!
I'm copying my colleague in on this, do you think I or him could pester you offline regarding this matter? (the parallelism, not the E's, of course ;-)
ciao!
Aurora Emanuela Dell'Anno Systems Programmer Sistemi Informativi S.p.A. e-mail: aurora.dellanno@sistinf.it tel. +39 335 7429486 [...]
4719 13 39_Re: What Does DB2 Reorg pass to DFSORT?9_Jim Ruddy18_jaruddy@US.IBM.COM30_Mon, 4 Dec 2000 11:34:17 -0600321_- What is the PMR number for this problem?
Jim Ruddy IBM DB2 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.
4733 15 11_DB2 Connect16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV30_Mon, 4 Dec 2000 10:46:41 -0700442_- We're examining using DB2 Connect and a question has come up.
Has anybody heard if a flavor of DB2 Connect can run on an S390 platform or am I "forced" to use NT or the other PC type flavors?
================================================ 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.
4749 14 15_Re: DB2 Connect15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM30_Mon, 4 Dec 2000 11:45:44 -0600367_us-ascii You can use DDF on the mainframe to talk to other DB2's. DB2 CDonnect is from PC to Mainframe. Thats what I am told.
================================================ 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.
4764 21 11_DB2 INDEXES13_Speaks, Joann23_P1023G2@BUPERS.NAVY.MIL30_Mon, 4 Dec 2000 12:51:37 -0500529_iso-8859-1
Hello!
I 'm currently working with DB2 V5 in an OS390 environment and we use TYPE 2 indexes. I need to know is it advantages to create an index on a new table with aproximately 50 to 100 rows? Your immediate feedback will be appreciated .
Thanks Joann S.
================================================ 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.
4786 36 15_Re: DB2 INDEXES13_Toppins, Mike19_MToppins@UNIPAC.COM30_Mon, 4 Dec 2000 11:03:29 -0700534_iso-8859-1 Any access against it should do a tablespace scan because there are so few rows.
-----Original Message----- From: Speaks, Joann [mailto:P1023G2@BUPERS.NAVY.MIL] Sent: Monday, December 04, 2000 10:52 AM To: DB2-L@RYCI.COM Subject: DB2 INDEXES
Hello!
I 'm currently working with DB2 V5 in an OS390 environment and we use TYPE 2 indexes. I need to know is it advantages to create an index on a new table with aproximately 50 to 100 rows? Your immediate feedback will be appreciated . [...]
4823 88 37_Re: DB2 OS/390 V6.1 DSNZPARM ARCHRETN50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Mon, 4 Dec 2000 13:06:51 -0500667_iso-8859-1 Is your catalog parameter = yes?
Are you using GDG's ?
If so check out the retention time on the GDG entry.
-----Original Message----- From: Brookman, Gerald [mailto:gerald.brookman@US.ORIGIN-IT.COM] Sent: Monday, December 04, 2000 11:26 AM To: DB2-L@RYCI.COM Subject: DB2 OS/390 V6.1 DSNZPARM ARCHRETN
We just upgraded to V6.1. We have a value of "ARCHRETN=14" in our DSNZPARM, the same as V5.1. Has anyone else noticed that the primary archive log is only being retained for two (2) days and the secondary archive log is being retained forever? Any ideas as to why this is happening? TIA. [...]
4912 55 15_Re: DB2 INDEXES20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Mon, 4 Dec 2000 13:12:17 -0500631_us-ascii Not always. If in any access path , this small table is involved in a nested loop join as an outer table then creating an index could be needed for performance. Although the scenario is rare but possible.
> -----Original Message----- > From: Toppins, Mike [SMTP:MToppins@UNIPAC.COM] > Sent: Monday, December 04, 2000 1:03 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 INDEXES > > Any access against it should do a tablespace scan because there are so few > rows. > > -----Original Message----- > From: Speaks, Joann [mailto:P1023G2@BUPERS.NAVY.MIL] > Sent: Monday, December 04, 2000 10:52 AM > To: DB2-L@RYCI.COM [...]
4968 51 15_Re: DB2 INDEXES19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 4 Dec 2000 12:14:45 -0600634_ISO-8859-1 Joann, Although no index would be preferred, you'll probably need a index to ensure uniqueness, e.g.. enforce a primary or unique key.
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, [...]
5020 68 15_Re: DB2 INDEXES14_Scott Trometer22_scott.trometer@RCI.COM30_Mon, 4 Dec 2000 13:14:10 -0500458_iso-8859-1 You might want the index to enforce uniqueness
-----Original Message----- From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] Sent: Monday, December 04, 2000 1:12 PM To: DB2-L@RYCI.COM Subject: Re: DB2 INDEXES
Not always. If in any access path , this small table is involved in a nested loop join as an outer table then creating an index could be needed for performance. Although the scenario is rare but possible. [...]
5089 12 15_Re: DB2 Connect11_John Wallin24_john.wallin@ZURICHUS.COM30_Mon, 4 Dec 2000 12:10:50 -0600300_us-ascii You can use TSO on the mainframe to talk to db2's
================================================ 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.
5102 111 31_Date fields defined as not null12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Mon, 4 Dec 2000 13:20:15 -0500521_iso-8859-1 Hi Listers, I've been given some files to load into a UDB/EEEv7.1/AIX database ... these files are used to load into DB2/OS390 databases ... my question is: These files have DATE columns defined as NOT NULL .... and some of the records have a '?' in the column when there hasn't been a date entered into the field .... how can I code a load script to accept '?' as a valid value ??? ... when I try to load the file, anytime a '?' is attempted to be inserted into a DATE field, it tells me it's an invalid [...]
5214 21 27_Encrypt columnData on Table11_Tom Marcano23_marcano_db2@HOTMAIL.COM30_Mon, 4 Dec 2000 18:21:57 -0000263_- Hello all,
I'd like to know if anyone has any easy way to encrypt the data on the DB2 table, That is all about to protect our CREDIT CARD data. Please let me know if you have any idea, I need to look at the UDF to see if I can do something with it. [...]
5236 32 11_DB2 Connect16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV30_Mon, 4 Dec 2000 11:44:47 -0700417_- From the couple of responses I've had I believe I wasn't clear enough in my original query.
My original query is as follows: ------------------ We're examining using DB2 Connect and a question has come up.
Has anybody heard if a flavor of DB2 Connect can run on an S390 platform or am I "forced" to use NT or the other PC type flavors? ---------------- I will be running an a TCP/IP environment. [...]
5269 30 32_Total Cost of Ownership question11_Robert Jans21_Jans.Robert@AMSTR.COM30_Mon, 4 Dec 2000 11:39:00 -0700360_- Hi, Listers!
Quick question, does anyone know where I can find a white paper type article on TCO for MS SQL Server. I have Richard Yevich's excellent DB2 UDB article and am looking for a similar thing for SQL Server. We have a rather large app that's being developed in SQL Server and we're looking to move it to DB2 UDB both on the NT platform. [...]
5300 100 15_Re: DB2 INDEXES12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Mon, 4 Dec 2000 20:49:54 +0200424_iso-8859-1 Hi, And if rows are long you may have more than 1 or 2 pages....
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Scott Trometer" Newsgroups: bit.listserv.db2-l To: Sent: Monday, December 04, 2000 8:14 PM Subject: Re: DB2 INDEXES [...]
5401 32 44_Converting SQL Server Triggers to DB2-OS/39023_DePratti, Roland A H07A25_Roland.DePratti@CIGNA.COM30_Mon, 4 Dec 2000 13:47:02 -0500422_us-ascii Hi Everyone,
I am supporting a SQL Server app that for various reasons is porting to the OS/390 environment. It currently uses Triggers on certain tables to update the last update operator. The obtain the value from system parameter available in SQL server. Is there a similar technique in DB2 Triggers? Are there system variables available to a trigger that can be used to update a column like this? [...]
5434 62 15_Re: DB2 Connect15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Mon, 4 Dec 2000 12:55:10 -0600288_iso-8859-1 A colleague of mine thinks that there might be the possibility of running DB2Connect on an OS/390 version of Linux. He says that he is reciting from damaged memory but he thinks that he read that somewhere. It may be very new though so I don't know if it is even out yet. [...]
5497 59 18_Global Temp Tables11_Lorenz, Don15_dlorenz@KCC.COM30_Mon, 4 Dec 2000 12:40:16 -0600583_iso-8859-1 Howdy,
We are trying to clarify some confusion at our site with global temp tables (we have both OS390 V5 and V6 installed (on different machines and in totally separate environments). We have a vendor claiming that "some relational databases do not support "True temp tables' in a form that allows the structure of the table to be determined at run time. That includes V5.1 of DB2 for OS390. However, V6.1 of DB2 for OS390 does support "True temp tables' of this type." Since Global Temp tables were implemented with OS390 for DB2 V5 and we don't know of any [...]
5557 65 15_AW: DB2 Connect16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE30_Mon, 4 Dec 2000 20:00:49 +0100600_iso-8859-1 This can be done via ODBC, but you anODBC-Driver for your NT-client which is a part of DB2-connect (afaik).
Roland
> -----Ursprüngliche Nachricht----- > Von: Duane Lee - ATCX [SMTP:DLee@MAIL.MARICOPA.GOV] > Gesendet am: Montag, 4. Dezember 2000 19:45 > An: DB2-L@RYCI.COM > Betreff: DB2 Connect > > From the couple of responses I've had I believe I wasn't clear enough in > my > original query. > > My original query is as follows: > ------------------ > We're examining using DB2 Connect and a question has come up. > > Has anybody heard if a flavor of DB2 Connect can [...]
5623 44 31_Re: Encrypt columnData on Table0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 4 Dec 2000 13:23:32 -0600413_us-ascii Although I agree encryption is probably the better choice, another alternative is using RACF (or what ever table access control software you use at your site). We create a base view (and the table) which has a very restricted access. Client 'data owner' has to approve individual access requests to the data. A second view, without the password field, has the general DB acess for that application. [...]
5668 64 36_Re: Total Cost of Ownership question14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Mon, 4 Dec 2000 13:30:51 -0600639_iso-8859-1 Robert and all,
A TCO Paper, on DB2 versus MS SQL Server, similar to the other white papers we are doing, will be available by the end of this week. It's location will be posted on here at that time.
Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@ylassoc.com
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Robert Jans > Sent: Monday, December 04, 2000 12:39 PM > To: DB2-L@RYCI.COM > Subject: Total Cost of Ownership question > > > Hi, Listers! > > Quick question, does anyone know where I can find a white paper [...]
5733 79 58_Database Comparisons - Interesting InformationWeek Article11_John Wynton21_jwynton@THEMISINC.COM30_Mon, 4 Dec 2000 14:29:26 -0500506_windows-1252 Folks:
You may be interested in the following database article in InformationWeek. I've included a link to the on-line version:
http://www.informationweek.com/815/database.htm
DB2 appears to do well.
Regards,
John Wynton Senior Account Manager Themis, Inc. Specialists in DB2, CICS & MQSeries Education 1-800-756-3000; 908-233-8900 (Int'l) http://www.themisinc.com
5813 127 22_Re: Global Temp Tables12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Mon, 4 Dec 2000 21:39:42 +0200437_iso-8859-1 Hi, DB2 V5.1 CREATED TEMPORARY TABLES (CTT): Not logged by DB2. Used for temporary processing. While processing, the data are kept in memory (DSNDB07). No data are kept after processing completion. Indexes can not be defined on a CTT. Table structure remains defined in DB2 catalog. One table definition can service many concurrent users - each has his/hers own copy of the data although the table structure is the same. [...]
5941 28 15_Re: DB2 Connect13_McHugh, Gerry21_MchughG@DIVINVEST.COM30_Mon, 4 Dec 2000 13:38:08 -0600586_iso-8859-1 You are correct.
-----Original Message----- From: Daniel Sullivan [mailto:daniel.sullivan@ZURICHUS.COM] Sent: Monday, December 04, 2000 12:46 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect
You can use DDF on the mainframe to talk to other DB2's. DB2 CDonnect is from PC to Mainframe. Thats what I am told.
================================================ 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. [...]
5970 18 34_Basic SQL statement with timestamp10_Lee Mandel16_DBMSUser@AOL.COM28_Mon, 4 Dec 2000 14:42:04 EST464_US-ASCII Hello List, Lets say I had a table with three columns and one of the columns is a timestamp. How would the sql statement look like to fetch only the entry with the highest timestamp (the most current)? Thanks, 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.
5989 170 22_Re: Global Temp Tables14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Mon, 4 Dec 2000 13:48:35 -0600667_iso-8859-1 To add more to Isaac's response:
SAVEPOINTS - work with Declared Temp Tables - are not supported with Global Temp Tables
DML - full DML with Declared Temp Tables - INSERT only with Global Temp Tables
Both of these are very important features.
Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@ylassoc.com
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Isaac Yassin > Sent: Monday, December 04, 2000 1:40 PM > To: DB2-L@RYCI.COM > Subject: Re: Global Temp Tables > > > Hi, > DB2 V5.1 > CREATED TEMPORARY TABLES (CTT): > Not logged by DB2. [...]
6160 13 35_Re: Date fields defined as not null7_Db2 fan16_askdb2@YAHOO.COM30_Mon, 4 Dec 2000 13:44:45 -0600408_- It is normally loaded with the lowest date '0001-01-01' when not defined with NULL. Applications shd take cognizance of this fictitious date representation. Db2 fan
================================================ 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.
6174 91 15_Re: DB2 Connect22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM30_Mon, 4 Dec 2000 14:45:55 -0500331_iso-8859-1 DB2 Connect does not execute on the OS/390 platform.
I believe Linda is correct in that DB2 Connect is being ported to Linux for S/390. Linux for S/390 is in its own LPAR. It will not execute as an OS/390 address space like Unix System Services does. DB2 for Linux/390 is not GA. I don't when it will be GA. [...]
6266 124 15_Re: DB2 INDEXES0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 4 Dec 2000 13:49:56 -0600497_us-ascii As well as uniqueness, Relation integrity depends in Relational contrainsts based on Primary keys.
Isaac Yassin @RYCI.COM> on 2000/12/04 12:49:54 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: DB2 INDEXES
Hi, And if rows are long you may have more than 1 or 2 pages.... [...]
6391 50 38_Re: Basic SQL statement with timestamp15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Mon, 4 Dec 2000 13:52:05 -0600500_iso-8859-1 timestamp_table is composed of three columns, col1, col2, timestampcol.
select max(timestampcol) from timestamp_table
If this table gets very large you might have big problems with sorting because one would be required to get the maximum value of timestamp. You might consider putting a clustering index on the table in timestamp order. (Zero PCTFREE or FREEPAGE then because inserts would always to to the end of the table.) You know your app better than I do, though. [...]
6442 90 15_Re: DB2 Connect24_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Mon, 4 Dec 2000 14:59:10 -0800614_us-ascii Linda, That is correct. DB2 Connect will run on Linux for zSeries (nee S/390). It is important to understand that Linux on this platform won't be like OS/390 Open Edition (which became Unix Systems Services). Those were just APIs imbedded in the OS/390 operating system. Linux will run natively on the zSeries iron. I think three different Linux vendors are currently engaged in porting their products. You will also be able to run DB2 Universal Database for Linux, Unix, and Windows on Linux for zSeries. This gives big iron customers an alternative when they need functionality which has not found [...]
6533 67 22_Db2 Connect for OS/39014_Philip Gunning24_Philip.Gunning@QUEST.COM30_Mon, 4 Dec 2000 11:28:12 -0800471_- Duane, There is no support for DB2 Connect for OS/390 yet, But if you are running Linux on OS/390 then you might be able to run DB2 Connect on Linux on OS/390. Other than that, you are limited to the supported platforms, NT, UNIX, Linux. HTH - Phil
Phil Gunning Quest Software Certified Solutions Expert -- DB2 UDB Certified Advanced Technical Expert -- DB2 DRDA Certified Solutions Expert -- Application Development Unix, NT, OS/2 Assoc List Owner DB2-L
6601 15 31_Re: Encrypt columnData on Table7_DB2 fan16_askdb2@YAHOO.COM30_Mon, 4 Dec 2000 14:08:25 -0600306_- You can alternatively use EDITPROC exit to encode and decode a column. The proc will get applied at the row level. There is a sample at the SDSNSAMP lib. Look at the member DSN8EA1. You can use similar exits. This sample tries to encode and decode salary column in one of the sample tables. DB2 fan [...]
6617 118 22_Re: Global Temp Tables0_24_db46@DAIMLERCHRYSLER.COM30_Mon, 4 Dec 2000 15:14:08 -0500369_us-ascii I guess it comes down to what is meant by 'true' temporary tables.
I would think that Sybase has more 'true' temporary tables because they can be created on the fly (without having to enter them into systables) and that indexes can be created on them (used quite often in Sybase stored procedures) and updates and selective deletes can be on them. [...]
6736 34 26_Re: Db2 Connect for OS/39014_Dean Montevago18_DMonteva@VNSNY.ORG30_Mon, 4 Dec 2000 15:13:49 -0500545_- Hi, If they are at V6 of DB2 is it true they don't need DB2 Connect at all ? Also, NEON systems has a DB2 Connect type product that runs on the 390.
> -----Original Message----- > From: Philip Gunning [SMTP:Philip.Gunning@QUEST.COM] > Sent: Monday, December 04, 2000 2:28 PM > To: DB2-L@RYCI.COM > Subject: Db2 Connect for OS/390 > > Duane, There is no support for DB2 Connect for OS/390 yet, But if you are > running Linux on OS/390 then you might be able to run DB2 Connect on Linux > on OS/390. Other than that, you are limited [...]
6771 61 12_Schema Names10_Iris Wilde16_wildei@TDBANK.CA30_Mon, 4 Dec 2000 15:16:53 -0500410_iso-8859-1 Hi All: We're hot into a debate about naming conventions for schemas and were wondering what the rest of the world has come up with. Some proponents want to go with existing collection names (simplicity, ease of administration) while others want to come up with a new convention (flexibility, authorization control). Any insights and/or experience would be most appreciated. Thanks in advance. [...]
6833 124 48_Re: Converting SQL Server Triggers to DB2-OS/39012_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Mon, 4 Dec 2000 14:21:12 -0600547_us-ascii Hello Roland.
See Table 40 in the DB2 UDB for OS/390 SQL Reference manual. (I've appended it below) I've found it helpful in regard to what system values are available to your triggers. However, what would be really nice (and I beat this drum every chance I get) would be for IBM to enable "Set" with "Sub-Select" capability in "Before" triggers. This way, you could retrieve a value stored somewhere in the DB, into your row as it's being inserted. (Currently, in v6.1 you can only do this in a "Before" trigger with a UDF.) [...]
6958 41 38_Re: Basic SQL statement with timestamp10_Mike Wiles14_mwiles@UCG.COM30_Mon, 4 Dec 2000 15:26:11 -0500365_windows-1252 Hi Lee...
I'm not sure if this is the best way to do it, but if you want the entire row corresponding to the highest timestamp, you'll need to do this...
select * from t1 where timestampcol = (select max(timestampcol) from t1)
I do this all the time, and I'm looking for a better way, so I'd be curious about other solutions. [...]
7000 18 14_UDB for AS/4009_Rob Crane22_racrane@CONCENTRIC.NET30_Mon, 4 Dec 2000 13:47:50 -0700388_us-ascii What methods of connection have you used with DB2 UDB for AS/400? Any comments on preferred method or gateway?
Thanks,
-Rob
================================================ 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.
7019 62 38_Re: Basic SQL statement with timestamp13_Neil Courtney19_NCOURTN@CLEAR.CO.NZ30_Tue, 5 Dec 2000 10:12:54 +1300410_iso-8859-1 Hi Mike,
if you add a descending index on the timestampcol, this will work just fine. The subselect will then get the max(timestampcol) value with a single access to the descending index.
Cheers, Neil
-----Original Message----- From: Mike Wiles [mailto:mwiles@UCG.COM] Sent: Tuesday, 5 December 2000 09:26 To: DB2-L@RYCI.COM Subject: Re: Basic SQL statement with timestamp [...]
7082 29 47_Anybody using Java Stored Procedures with MSCS?17_Kevin Gottfredsen23_kgottfredsen@HUMANA.COM30_Mon, 4 Dec 2000 15:11:16 -0600578_- We're having a problem with Java SPs since migrating an instance to a MSCS clustered instance.
We can build the SPs fine with the Stored Procedure Builder, but when we attempt to call them we get a SQL4304N error with a reason code of "1" (Java class could not be found in the CLASSPATH). If I copy the jar files from the MSCS disk resource to the UDB install drive (eg. from H:\Db2profs\function\jar\ to D:\Sqllib\function\jar\), the SPs work fine. I tried adding H:\Db2profs\function to my CLASSPATH environment variable, but get the same error. [...]
7112 12 35_Re: Date fields defined as not null13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Mon, 4 Dec 2000 15:19:34 -0600336_- I am assuming you are using the IBM load utility? Have you checked out the Nullif parameter?
================================================ 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.
7125 74 38_Re: Basic SQL statement with timestamp14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU30_Tue, 5 Dec 2000 08:32:32 +1100678_iso-8859-1 **************************************************************** IMPORTANT
The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...]
7200 65 16_Re: Online Reorg12_Higgins John25_HigginsJohn@JOHNDEERE.COM30_Mon, 4 Dec 2000 16:57:49 -0600533_us-ascii Jim,
We already had "UR CHECK FREQ" set to 1.
The checkpoints frequency is set to 100,000.
The checkpoint interval averages 7.6 minutes. I don't know how fast checkpoints were occurring during the problem interval.
Question: If the online-reorg switch phase was delayed by a long-running, non-committing, read-only job (which specifies "FOR FETCH ONLY WITH UR" in its SQL), would the system detect that job as a long-running unit of recovery? I thought not; please correct me if I am wrong. [...]
7266 44 28_DB2 Training on the Internet24_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Mon, 4 Dec 2000 18:09:25 -0800439_us-ascii We have just about completed our Distance Learning website which will enable The Fillmore Group to deliver DB2 courses and related topics training over the Internet. We will have real-time, full-motion audio/video streaming from our classroom in Baltimore, USA. Students will be able to ask questions via chat, e-mail, and fax. Lab exercises will be conducted via client/server and telnet access to our servers in Baltimore. [...]
7311 39 15_Re: DB2 Connect13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Mon, 4 Dec 2000 18:47:59 -0500363_iso-8859-1 Hi Duane, I still don't understand.
You say >In a three tier environment I have a client (1), communication server (2), >and host(3). Can I replace the communication server (tier 2) by running DB2 >Connect EE (or whatever it may be called) on my host?
What is your client(1)? How many clients? Why do you want DB2 Connect on OS/390? [...]
7351 79 16_Re: Schema Names14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 5 Dec 2000 11:59:44 +1100524_iso-8859-1 I support keeping the schema name the same as the matching collection's name. This doesn't ease administration (because schemas are managed with a different set of grants from those used for collections); or enhance authorization control (for the same reason). It just means there is one less set of naming conventions floating around waiting to trip some unsuspecting person at 3am. Apart from using a schema to test updates to UDFs and SPs, I cannot see a requirement that requires having different names. [...]
7431 39 25_Re: Timestamp Differences11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM30_Mon, 4 Dec 2000 21:28:53 -0500422_us-ascii Bill, I'd suggest you use the TIMESTAMPDIFF function to find the difference between two timestamps. The function in DB2 UDB provides for the difference in seconds, minutes, hours, or other time intervals. Here is a sample sql statement:
select timestampdiff(4,cast(stop_time-start_time) as char(22))) as elap_mins, timestampdiff(2,cast(stop_time-start_time) as char(22))) as elap_secs from yourtable; [...]
7471 13 8_Re: -4078_Lo, Mary17_mary.lo@TGSLC.ORG30_Mon, 4 Dec 2000 20:45:52 -0600361_iso-8859-1 I found my problem. Since it's BEFORE trigger, I need to use New_table identifier for SET statement. Thanks.
================================================ 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.
7485 37 15_Re: DB2 Connect0_31_Ross_Mallett@SEARCHSOFTWARE.COM30_Tue, 5 Dec 2000 15:14:51 +1000430_us-ascii If I understand matters correctly, you need some transport software on your client or on a middle tier gateway. Either that or you write some pretty powerful client/middleware software yourself. I don't think you can write SQL and have it go directly over TCP/IP to DB2 OS/390. And I don't believe there's a flavor of DB2 connect that resides on any host. I believe the transport must be on the client or a gateway. [...]
7523 40 8_Re: -4070_31_Ross_Mallett@SEARCHSOFTWARE.COM30_Tue, 5 Dec 2000 15:49:32 +1000307_us-ascii Hi.
I'm was wondering if you could elaborate on your message for me.
I've currently got a problem with a trigger which is giving me a -407 error. None of the fields on an INSERT in the trigger appear to be NULL -- and none are when I do a SELECT on them -- but I get this error. [...]
7564 83 8_AW: -40712_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 5 Dec 2000 08:39:49 +0100658_iso-8859-1 Hi Ross,
SQLCODE -407 (SQLSTATE 23502) means that the statement cannot insert a null value into a column that is defined as NOT NULL.
HTH. With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Compentence Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- [...]
7648 157 12_Re: AW: -40717_Massimo Biancucci19_mbiancucci@DEBIS.IT30_Tue, 5 Dec 2000 09:17:14 +0100391_us-ascii
From the manual:
-407 AN UPDATE OR INSERT VALUE IS NULL, BUT THE OBJECT COLUMN column-name CANNOT CONTAIN NULL VALUES
Explanation: One of the following conditions occurred:
- A null insert or update value was specified for a column defined as NOT NULL.
- No insert value was provided for a column that does not have a default value. [...]
7806 87 15_Re: DB2 Connect15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Tue, 5 Dec 2000 09:24:49 +0100598_iso-8859-1 >-----Original Message----- >From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] >Sent: Monday, December 04, 2000 12:45 PM >To: DB2-L@RYCI.COM >Subject: DB2 Connect > > >From the couple of responses I've had I believe I wasn't clear enough in my >original query. > >My original query is as follows: >------------------ >We're examining using DB2 Connect and a question has come up. > >Has anybody heard if a flavor of DB2 Connect can run on an S390 platform or am I "forced" to use NT or the other PC type flavors? As far as I am aware DB2 connect is supposed to connect clients [...]
7894 64 38_Re: Basic SQL statement with timestamp10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Tue, 5 Dec 2000 04:05:55 -0600312_- Lee,
At the risk of stating the obvious, this kind of query usually requires a correlation of the Subselect to obtain the desired result.
e.g.
select * from t1 taba where col1 = 'a' and col2 = 'b' and col3 = (select max(col3) from t1 tabb where col1 = taba.col1 and col2 = taba.col2) [...]
7959 110 38_Re: Basic SQL statement with timestamp17_Massimo Biancucci19_mbiancucci@DEBIS.IT30_Tue, 5 Dec 2000 11:45:10 +0100280_us-ascii If u want to seek a particular row for a known value of col1 and col2;
select col3 from table where col1 = "a" and col2 = "b" and col3 = ( select max(col3) from table where col1 = "a" and col2 = "b");
if you want to open a general cursor on the table: [...]
8070 36 15_Re: DB2 Connect13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Tue, 5 Dec 2000 07:40:11 -0600529_- Duane You strike a cord with me here. Why should I have to have a "seperate" Server just to run DB2 Connect ? Why can't they have that same functionality on S/390 ? May be as an add on to the core DB2 product. I'd really like to get away from the hassels of running another server just to run DB2 Connect. Even the Linux/390 that some people talked about is really another server, merely running on the same hardware. I wish IBM gives its official response. Mr. Katsnelson ? or Mr. Miller ? I'm full of why's ... Mohammad [...]
8107 14 45_Re: Datasharing and False Contention - 1 LPAR15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Tue, 5 Dec 2000 07:43:40 -0600404_- Some other questions:
- Are there other users using the other partitions? - What is your pseudo close interval? - Do you use selective partition locking?
================================================ 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.
8122 146 31_Re: Date fields defined as NULL12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Tue, 5 Dec 2000 08:50:23 -0500555_iso-8859-1 Shauna Thanx for replying, I made a mistake on my initial question ... the database column is definitely nullable ... the input file has '? ' in date fields that are to be considered null values. The NULLIF parameter would be a great idea to have the load utility translate the input value as null ... but, I can't find where I can use this parameter with UDB/AIX... if I were in an OS/390 environment I think that would work... The input files I'm using are currently being used to load a Sybase IQ database, and in their load statement, [...]
8269 14 3_CDB13_Davis, Ronald17_DavisRo@CONED.COM30_Tue, 5 Dec 2000 09:21:36 -0500316_- To: Jennifer Moody -
You kept her word. Thanks for the Tee-shirt.
================================================ 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.
8284 31 7_Re: CDB20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Tue, 5 Dec 2000 09:25:14 -0500551_us-ascii Same here.
Thanks for sending me T-shirt
> -----Original Message----- > From: Davis, Ronald [SMTP:DavisRo@CONED.COM] > Sent: Tuesday, December 05, 2000 9:22 AM > To: DB2-L@RYCI.COM > Subject: CDB > > To: Jennifer Moody - > > You kept her word. Thanks for the Tee-shirt. > > ================================================ > 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. [...]
8316 17 7_Re: CDB10_Max Scarpa16_mscarpa@CESVE.IT30_Tue, 5 Dec 2000 15:42:07 +0100417_us-ascii Thanks Jennifer for champagne, caviar and Cyndy Crawford visit. It's better than one tshirt.
Max Scarpa
PS Sorry list owners, I'll never do it again....
================================================ 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.
8334 22 35_Alter PRI and SEC Quantity of Parts11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM30_Tue, 5 Dec 2000 08:45:40 -0600358_us-ascii Hi everyone,
I thought that if you wanted to alter the primary and secondary quantity of a part in a tablespace (OS/390 V6) that you could just stop the part of tablespace and do the alter. I was just trying to do some alter and it appears that is asking me to stop the whole space before I do the alter. Anyone experience this? [...]
8357 140 38_Re: Basic SQL statement with timestamp10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Tue, 5 Dec 2000 08:43:16 -0600394_- Not just a particular row for known values. Consider the following:
SELECT DBNAME, TSNAME, DSNUM, SHRLEVEL, ICDATE, ICTIME FROM SYSIBM.SYSCOPY A WHERE DBNAME LIKE 'ABC%' AND ICTYPE = 'F' AND ICBACKUP = ' ' AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY WHERE ICTYPE = 'F' AND DBNAME = A.DBNAME AND TSNAME = A.TSNAME AND DSNUM = A.DSNUM) ORDER BY DBNAME, TSNAME, DSNUM [...]
8498 50 7_Re: CDB11_Larry Cable19_Larry.Cable@NWA.COM30_Tue, 5 Dec 2000 08:42:56 -0600631_iso-8859-1 Thanks for the T-shirt Jennifer. It's nice to deal with a marketing rep who keeps their promise.
LarryC ----- Original Message ----- From: "Pillay, Venkat (PCA)" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, December 05, 2000 8:25 AM Subject: Re: CDB
> Same here. > > Thanks for sending me T-shirt > > > > -----Original Message----- > > From: Davis, Ronald [SMTP:DavisRo@CONED.COM] > > Sent: Tuesday, December 05, 2000 9:22 AM > > To: DB2-L@RYCI.COM > > Subject: CDB > > > > To: Jennifer Moody - > > > > You kept her word. Thanks for the Tee-shirt. [...]
8549 18 9_MERGECOPY10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Tue, 5 Dec 2000 09:00:56 -0600449_- Hello Listpeople,
I read somewhere that MERGECOPY cannot merge Image Copies copied with different SHRLEVELs. Can someone please confirm, refute, or comment upon this?
Thanks
John Hardy
================================================ 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.
8568 15 39_Re: Alter PRI and SEC Quantity of Parts15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Tue, 5 Dec 2000 09:06:20 -0600419_- Hello Trace
As far as I know, you don't have to stop a tablespace nor an index to alter the priqty and secqty.
But if you stop the space, did you say AT(COMMIT)?
================================================ 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.
8584 58 15_Re: DB2 Connect11_Matt Kelley18_mgk333@HOTMAIL.COM30_Tue, 5 Dec 2000 09:12:28 -0600535_- It seems that people are shooting for having code only on the workstation (which requires at least the DB2 runtime client) and on the mainframe (which requires "at least" DB2), and they don't want to run a separate, dedicated gateway. If this is the important consideration, then IBM provides the option to run DB2 Connect Personal Edition on each workstation, with no requirement for a gateway. The only difference between this scenario and having a DB2 Connect gateway running on OS/390 is where the DRDA requester code runs. [...]
8643 17 39_Re: Alter PRI and SEC Quantity of Parts10_Max Scarpa16_mscarpa@CESVE.IT30_Tue, 5 Dec 2000 16:21:16 +0100412_us-ascii It's from V5 (after applying some PTFs) that I don't stop any tablespace/index to alter space.
Is it a new 'features' of version 6 ? :-)
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.
8661 52 25_Re: Timestamp Differences9_Bob Lewis23_BLewis@MICROGENERAL.COM30_Tue, 5 Dec 2000 07:17:05 -0800625_iso-8859-1 Be careful of TIMESTAMPDIFF....it returns an integer value that is an ESTIMATE of the difference between two timestamps. (Per Graeme Birchall DB2 UDB V7 Cookbook....)
-----Original Message----- From: Scott Hayes [mailto:faster.databases@DATABASE-GUYS.COM] Sent: Monday, December 04, 2000 8:29 PM To: DB2-L@RYCI.COM Subject: Re: Timestamp Differences
Bill, I'd suggest you use the TIMESTAMPDIFF function to find the difference between two timestamps. The function in DB2 UDB provides for the difference in seconds, minutes, hours, or other time intervals. Here is a sample sql statement: [...]
8714 18 13_CURRENT SQLID0_27_Bud.Greenman@ONONDAGA.NY.US30_Tue, 5 Dec 2000 11:18:25 -0500506_- Help! I am trying to set up an ad-hoc report writer that came with a new client-server system. The report writer is a CA product called 'my Eureka' (previously 'IQ/Objects'). We are on DB2 v6.1 & OS390 2.8. I installed db2connect 6.1. When the user tries to generate a report & logs on to the db2 server (mainframe) the message is returned that the table .Tablename. is not found. I need to change the current sqlid to the authid for the database and maintain that on the pc. Any Ideas? TIA [...]
8733 58 15_Re: DB2 Connect13_McHugh, Gerry21_MchughG@DIVINVEST.COM30_Tue, 5 Dec 2000 10:20:54 -0600405_iso-8859-1 I think the point is being missed on some of these e-mails. The POINT is, you need a gateway for a distributed app. Neon, Intersolv, StarSql, DB2 Connect, whatever. You need a gateway on the client (originating - DRDA application requestor) side. Putting the gateway on the mainframe ain't gonna do you much good on the client side. And if don't have a client, you don't need the gateway. [...]
8792 49 59_Logical Page List (LPL) Error While Inserting Into an Index12_Chris Munson18_cmunson@US.IBM.COM30_Tue, 5 Dec 2000 09:03:42 -0800380_us-ascii Don, An LPL entry occurs as a result of some sort of 'logical' error condition and not as a result of some erroneous action on behalf of a user. The reasons vary but in the DSNB250E message you will see a CSECT name. This gives a general idea and can sometimes pinpoint the reason for the LPL. You can use this information to search for any known problems or APARs. [...]
8842 14 13_Re: MERGECOPY9_Jim Ruddy18_jaruddy@US.IBM.COM30_Tue, 5 Dec 2000 11:32:38 -0600403_- MERGECOPY will merge copies of differing SHRLEVELs. The SHRLEVEL of the last incremental will be used for the merged copy.
Jim Ruddy IBM DB2 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.
8857 13 16_Re: Online Reorg9_Jim Ruddy18_jaruddy@US.IBM.COM30_Tue, 5 Dec 2000 11:33:32 -0600305_- Any UR will be detected.
Jim Ruddy IBM DB2 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.
8871 44 41_DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Tue, 5 Dec 2000 12:20:09 -0600426_iso-8859-1 We are on DB2 v6.1 OS390 V2.6.
Trying "DECLARED GLOBAL TEMPORARY TABLE.." for the first time. Inside the program I get a -904 on the declare statement...
Running the same SQL through SPUFI also gives -904...the statement and the error message is below...
DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_EVENT (TEMP_OFFICE_CODE CHAR(02), TEMP_COUNTY_CODE CHAR(02), TEMP_COUNT INT) CCSID EBCDIC [...]
8916 79 45_Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM30_Tue, 5 Dec 2000 10:25:56 -0800521_iso-8859-1 Do you have a User Temporary Tablespace?
I ran into that problem the first time I was trying to use global temp tables. You must have a User Temporary Tablspace and the user the application is bound as must have USE permissions on that space.
-D
----------------------------------------------------------------------- Dylan C. Vanderhoof Internal Software Developer Semaphore Corporation http://www.semaphore.com/ perl -e "print(pack('h38','c6c616279616e604c6c616279616e6e2e65647'))" [...]
8996 24 42_DB2 Stored Procedures Builder - how much $16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Tue, 5 Dec 2000 13:47:47 -0500299_iso-8859-1 What is the price of DB2 Stored Procedures Builder? Our intent is to have a small number (perhaps 10) of developers working on Stored Procedures. The SP will run on DB2/390 V5, V6, V7. The developers will be using NT 4.0 Workstation (no SP development will take place on ?IX boxes). [...]
9021 96 45_Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Tue, 5 Dec 2000 12:57:21 -0600466_iso-8859-1 Appreciate your response. Where might I get more documentation on this? What should the name for a User Temporary Tablespace be and are there any special DDL requirements. I am guessing from my error message that the database name should be TEMP.
-----Original Message----- From: Dylan Vanderhoof [mailto:DylanV@SEMAPHORE.COM] Sent: Tuesday, December 05, 2000 12:26 PM To: DB2-L@RYCI.COM Subject: Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB [...]
9118 50 45_Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 5 Dec 2000 13:55:29 -0500508_iso-8859-1 Hi Tonmoy, I agree that the information on the need for the TEMP database and how to create it is well hidden.
In the SQL Ref. on Declare global temporary table, you can read: ---------------------------- PUBLIC implicitly has the following privileges without GRANT authority for # declared temporary tables:
# The CREATETAB privilege to define a declared temporary table in the # database that is defined AS TEMP, which is the database for declared # temporary tables. [...]
9169 102 15_Re: DB2 Connect12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 5 Dec 2000 11:08:26 -0800539_us-ascii Mohammad, I'm not with IBM. But here's my understanding of how it works.
DB2 Connect is essentially a collection of communication drivers and protocols allowing connection from a PC to a HOST. That host can be AIX, NT, AS/400 or OS/390. DB2 Connect manages (amongst other things, but in a simplified view) the connection and the ODBC drivers from your PC to the HOST. And this is true, regardless of whether you're connecting to AIX, OS/390, AS/400, or NT UDBs. I've done all of these exactly the same way from my PC. [...]
9272 30 41_S04E RC0C0A0DD2 / Global Temporary Tables10_Mark Labby16_mlabby@PHEAA.ORG30_Tue, 5 Dec 2000 14:10:09 -0500595_us-ascii I was just wondering if anyone has seen a pattern of various S04E Abends after starting to implement the TEMP database and tablespaces in DB2 v6 for OS/390...
I created the database and tablespace about 3 weeks ago in our production and test regions. As far as I know, we have exactly 2 applications actually coded to declare a Global Temporary Table and those applications have had no problems. However, since I have created the TEMP databases, we have had 5 production S04E abends with at least 2 reason codes that have mentioned the DECLARE GLOBAL TEMPORARY TABLE in the [...]
9303 18 4_Help10_Elsie Tama24_elsie.m.tama@VERIZON.COM30_Tue, 5 Dec 2000 14:11:50 -0500405_us-ascii What impact will be if I read from a table that have unsorted data, and multiple primary Keys.? Any ideas will be appreciated.
Thanks,
Elsie
================================================ 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.
9322 42 17_Re: CURRENT SQLID12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 5 Dec 2000 11:16:45 -0800561_us-ascii At the risk of stating the obvious, how about "set current sqlid = "...
--- Bud.Greenman@ONONDAGA.NY.US wrote: > Help! I am trying to set up an ad-hoc report writer > that came with a new > client-server system. The report writer is a CA > product called 'my Eureka' > (previously 'IQ/Objects'). We are on DB2 v6.1 & > OS390 2.8. I installed > db2connect 6.1. When the user tries to generate a > report & logs on to the db2 > server (mainframe) the message is returned that the > table .Tablename. > is not found. I need to [...]
9365 21 17_Re: CURRENT SQLID7_DB2 fan16_askdb2@YAHOO.COM30_Tue, 5 Dec 2000 13:22:50 -0600563_- Usually, ODBC applications will connect to the database with a USERID. Then depending on how the application is written, that userid may need a Synonym. example. Let us say the ODBC apps is trying to connect to the database with userid ODBCUSR. Then all the tables that are referenced by the Application must be thru a Synonym ODBCUSR.TBL1,.... This is because the application will not generally fully qualify the object names. you will have to read the install cover letter / documentation for the specific installation setups. Regards, DB2 fan.......... [...]
9387 42 8_Re: Help16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Tue, 5 Dec 2000 14:19:52 -0500455_iso-8859-1 Elsie, A table can have only one primary key. If by read, you mean FETCH, there is no guarantee on the order the rows are returned unless the cursor has an ORDER BY. Same for the results set generated by SELECT.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Elsie Tama [mailto:elsie.m.tama@VERIZON.COM] Sent: Tuesday, December 05, 2000 2:12 PM To: DB2-L@RYCI.COM Subject: Help [...]
9430 87 17_Re: CURRENT SQLID10_Rob Wright17_rwright@LIC.CO.NZ30_Wed, 6 Dec 2000 08:45:25 +1200585_us-ascii I'm using the V7 client, but I think the V6 client has the same simple way to do this ..... :-)
Go to client configuration assistant Choose the ODBC driver you want to reference the report writer tables from Select the PROPERTIES option You should get a screen with DATABASE PROPERTIES CLI/ODBC Select the SETTINGS tab You should get a screen saying something like 'The data source is not connected .... Would you like to connect?' .... assuming you are not connected to the data source Select NO (you don't have to be) Your screen will now have CLI/ODBC SETTINGS [...]
9518 34 71_attempting to install fixpacks on UDB NT 6.1 but problem with win logon13_Lynne Flatley17_LFlatley@NEFN.COM30_Tue, 5 Dec 2000 15:08:45 -0500364_us-ascii In attempting to upgrade a UDB V6.1 NT system I receive the following error DB2 is currently running and lock by the following process(es): Winlogon.exe (PID=36) Click no to exit setup (Recommend) Click yes to shutdown these process........
If I click yes it brings down the NT box. Even with Administrator authority I can't stop WINLOGON.EXE [...]
9553 10 17_Re: CURRENT SQLID0_27_Bud.Greenman@ONONDAGA.NY.US30_Tue, 5 Dec 2000 15:11:10 -0500287_- THANKS! That's just what I was looking for.
================================================ 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.
9564 53 75_Re: attempting to install fixpacks on UDB NT 6.1 but problem with win logon13_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Tue, 5 Dec 2000 15:13:14 -0500500_iso-8859-1 Lynne, You might have tried this, but you can go into NT Services and stop all the DB2 related services. Then, you should be able to get a clean install without this error. This suggestion is really just a possible workaround to your problem, though. Good luck.
-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Tuesday, December 05, 2000 3:09 PM To: DB2-L@RYCI.COM Subject: attempting to install fixpacks on UDB NT 6.1 but problem with win logon [...]
9618 81 75_Re: attempting to install fixpacks on UDB NT 6.1 but problem with win logon13_Lynne Flatley17_LFlatley@NEFN.COM30_Tue, 5 Dec 2000 15:25:46 -0500650_us-ascii Thank you, Jim but unfortunately, that's part of my procedure before I attempt to apply the fixpack...I should have mentioned that.
Lynne A. Flatley New England Financial (617) 578-4079 (work) (781) 718-0919 (cell) lflatley@nefn.com
> -----Original Message----- > From: Fletcher, Jim [SMTP:jim.fletcher@BSIS.COM] > Sent: Tuesday, December 05, 2000 3:13 PM > To: DB2-L@RYCI.COM > Subject: Re: attempting to install fixpacks on UDB NT 6.1 but problem > with win logon > > Lynne, > You might have tried this, but you can go into NT Services and stop all > the > DB2 related services. Then, you should be able [...]
9700 58 46_Re: DB2 Stored Procedures Builder - how much $12_Susan Lawson22_lawson_susan@YAHOO.COM30_Tue, 5 Dec 2000 12:40:45 -0800663_us-ascii Eric,
Stored Procedure Builder is a free download product. www6.software.ibm.com/dl/sql/sqlproc-p
Regards,
Susan Lawson www.ylassoc.com
--- "Pearson, Eric L," wrote: > What is the price of DB2 Stored Procedures Builder? > Our intent is to have a small number (perhaps 10) of > developers working on > Stored Procedures. > The SP will run on DB2/390 V5, V6, V7. The > developers will be using NT 4.0 > Workstation > (no SP development will take place on ?IX boxes). > > > > regards, > > eric pearson > NS ITO Database Support > > ================================================ > To change your [...]
9759 157 45_Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB12_Susan Lawson22_lawson_susan@YAHOO.COM30_Tue, 5 Dec 2000 13:05:41 -0800361_us-ascii Tonmoy,
There is a little bit of documentation in SG24-6108-00 redbook - DB2 UDB Server for OS/390 V6 Technical Update book. You will need a TEMP database and several segmented tablespaces within it in order to create DECLARED temps. Refer to page 95 of this manual for more information.
Regards,
Susan Lawson www.ylassoc.com [...]
9917 97 75_Re: attempting to install fixpacks on UDB NT 6.1 but problem with win logon10_Park, Stan17_SPark@STATE.NM.US30_Tue, 5 Dec 2000 13:38:51 -0700437_iso-8859-1 I have had this problem with New Version Installs (not fixpacks) in the past and what I now do is logon to NT with the "db2admin" id and do the install. Then shutdown and logon to NT with my id.
-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Tuesday, December 05, 2000 1:26 PM To: DB2-L@RYCI.COM Subject: Re: attempting to install fixpacks on UDB NT 6.1 but problem with win logon [...]
10015 80 8_Re: Help10_Elsie Tama24_elsie.m.tama@VERIZON.COM30_Tue, 5 Dec 2000 15:47:04 -0500856_us-ascii YES PLEASE, I MEARNT UNCLUSTERING. ON THE SECOND QUESTION, I ALSO MEARNT INDEXES.
THANKS,
ELSIE
---------------------- Forwarded by ELSIE M. TAMA/EMPL/VA/Bell-Atl on 12/05/2000 03:45 PM ---------------------------
"Jeff A L'Italien" on 12/05/2000 02:54:59 PM
To: elsie.m.tama@VERIZON.COM
cc: (bcc: ELSIE M. TAMA/EMPL/VA/Bell-Atl)
Subject: Re: Help
Elsie,
I'd like to give you some help on this, but I'm unclear on both of your points. I'm not sure what you mean by the table having "unsorted" data. What is telling you that the data in the table is unsorted? Or.....are you referring to "unclustered"? Secondly, by your statement "multiple primary keys", are you [...]
10096 135 45_Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB0_22_BILL_GALLAGHER@PHL.COM30_Tue, 5 Dec 2000 16:05:08 -0500432_us-ascii Informational APAR PQ32670 has documentation on using DECLARE GLOBAL TEMPORARY TABLE, as well as creating a TEMP database and tablespace.
Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083
Tonmoy Dasgupta cc: Sent by: DB2 Data Base Subject: Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB Discussion List [...]
10232 111 8_Re: Help16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Tue, 5 Dec 2000 16:04:15 -0500492_iso-8859-1 Elsie, When you select or fetch there is no guarantee what order the data will appear unless you use ORDER BY.
When you use ORDER BY, you avoid a sort if the ORDER BY columns are the leading columns of a clustering index.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Elsie Tama [mailto:elsie.m.tama@VERIZON.COM] Sent: Tuesday, December 05, 2000 3:47 PM To: DB2-L@RYCI.COM Subject: Re: Help [...]
10344 42 75_Re: attempting to install fixpacks on UDB NT 6.1 but problem with win logon18_Gert van der Kooij15_geko@WANADOO.NL30_Tue, 5 Dec 2000 22:17:07 +0100489_iso-8859-1 Hi, You need to check all monitoring tools also. If you can't get it to work you can do the following:
- stop all DB2 related services and change the startuptype to manually; - rename the SQLLIB to - reboot your server, you will get a error message from the process which locks the db2 process - rename the directory to SQLLIB - install the fix - change the services startuptype back to the original type - reboot your server [...]
10387 32 40_Looking for a (DBA) opening in Singapore12_sudheer garg20_sud_garg@HOTMAIL.COM30_Tue, 5 Dec 2000 21:18:39 -0000460_- Hi Folks,
My friend in US is looking for an opening in Singapore. He is a senior DB2 DBA with 9 years of experience, with experience in supporting/carrying out several projects in different fields. He has been working in US as a DBA for more than 4 years. He has carried out presentations in several tech conferences. He also has experience in IBM's latest technologies such as Webspehere, Java, JDBC, Java servlets and the related architecture. [...]
10420 25 48_Allocating CPU time in a DB2/Connect Environment14_Gill, Joseph G19_joseph.gill@EDS.COM30_Tue, 5 Dec 2000 16:35:49 -0500425_iso-8859-1 Is the field QWHUCPU in the DB2 101 record a good field to use to capture the CPU used by users coming in via DB2/Connect? If not, what is a more accurate field?
Is it accurate enough to allocate resource utilization among various users? (Assuming a monoplex with no sharing).
Does this field capture the amount of CPU time required to process a given request, in all of the DB2 address spaces? [...]
10446 63 75_Re: attempting to install fixpacks on UDB NT 6.1 but problem with win logon11_Jakobs, Jef18_JJakobs@HARTIC.COM30_Tue, 5 Dec 2000 15:35:02 -0600309_iso-8859-1 Lynne,
It depends a lot on how your NT box has been setup.
For example on one Compaq machine I've had to not only stop all db2 related services, but also some Compaq related ones.
DB2 seemed to think it was up and running when in fact only some Compaq services were up... [...]
10510 20 19_DB2 Control Center.14_Mohammed Ahmed22_Mohammed.Ahmed@UAL.COM30_Tue, 5 Dec 2000 15:31:08 -0600549_- Hi Listers,
Successfully Logging into DB2 Control Center. When I double click the Tables folder. I get the following message.
"[IBM][CLI Driver][DB2] SQL0440N No function by the name "PROCEDURE" having compatible arguments was found in the function path. SQLSTATE=42884"
Ansar
================================================ 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.
10531 80 15_Re: DB2 Connect13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Tue, 5 Dec 2000 15:39:24 -0600438_iso-8859-1 I also am waiting for that glorious day when there is a DB2 Connect 'gateway' on OS/390 (perhaps on Unix System Services?).
Sure, Gerry, you will always need some 'client' code on the end user workstations (whether thin or fat), but the 'gateway' itself COULD reside on the host and eliminate the need for the irritating middle hop on NT, UNIX, OS/2 etc, and the subsequent administration and support requirements. [...]
10612 29 23_Re: DB2 Control Center.13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Tue, 5 Dec 2000 16:28:33 -0600439_US-ASCII Ansar, Is DB2 Connect installed ? You need DB2 Connect to reach host databases. Kurt
>>> Mohammed.Ahmed@UAL.COM 12/05/00 03:31PM >>> Hi Listers,
Successfully Logging into DB2 Control Center. When I double click the Tables folder. I get the following message.
"[IBM][CLI Driver][DB2] SQL0440N No function by the name "PROCEDURE" having compatible arguments was found in the function path. SQLSTATE=42884" [...]
10642 64 15_Re: DB2 Connect15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 6 Dec 2000 09:50:00 +1100542_- Hi Dave (and others?),
I'm not a 'DB2 on platforms other than OS/390' guru, but I do have some experience. The way I've always looked at it is that with DB2 for OS/390 you get the connectivity bit thrown in for free (well, not free, but you know what I mean). That bit is called DDF. With DB2 on non-OS/390 platforms, the DBMS bit has been stripped out from the DDF bit and each can be purchased separately, depending on your requirements. No prize for guessing that, in this scenario, the DBMS bit is DB2 for NT, AIX, etc. and [...]
10707 83 46_Re: DB2 Stored Procedures Builder - how much $12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 5 Dec 2000 15:06:10 -0800568_us-ascii You can download it, but you don't have to if you have DB2 Connect v7. It comes as a free part of DB2 connect v7 PE (its in the tools section). So when you install DB2 connect v7, its easy to add SPB in the install as well.
V6 of DB2 connect doesn't support OS/390 access by SPB so you need DB2 connect v7 (unless you're going to use one of the many brand-x products). --- Susan Lawson wrote: > Eric, > > Stored Procedure Builder is a free download product. > www6.software.ibm.com/dl/sql/sqlproc-p > > Regards, > > Susan [...]
10791 50 8_Re: Help15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 6 Dec 2000 10:13:44 +1100530_- Elsie,
Several of the people on this list have given you good advice on this and other questions you've posted. It seems to me, from the kind of questions you're asking, that you're starting to get seriously into DB2 - which is a good thing - but don't have much experience with it. I would suggest you pester your employer to send you on a 2-3 day DB2 DBA course of some sort. That would give you a good grounding in all aspects of DB2 design issues (which seem to be where most of your questions are coming from). [...]
10842 117 46_Re: DB2 Stored Procedures Builder - how much $12_Susan Lawson22_lawson_susan@YAHOO.COM30_Tue, 5 Dec 2000 15:35:23 -0800505_us-ascii We are using V6 DB2 Connect with SPB Preview 2, which was the version released to work with OS/390. This is working just fine.
--- Myron Miller wrote: > You can download it, but you don't have to if you > have > DB2 Connect v7. It comes as a free part of DB2 > connect v7 PE (its in the tools section). So when > you > install DB2 connect v7, its easy to add SPB in the > install as well. > > V6 of DB2 connect doesn't support OS/390 access by > SPB > so you [...]
10960 217 31_Re: Date fields defined as NULL11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Wed, 6 Dec 2000 10:30:34 +1100530_- Randy,
I assume you are using filetype ASC for the load. Have a look at the LOAD section in the command reference, it has several examples how to load nulls. By default, the utility expects a value of Y for null indicators, but you can override this with the "modified by nullindchar=?" clause. I have never tried this combination myself, but as far as I can see, it should work. Of course, this assumes that you are using actual null indicators (similar to NULLIF on OS/390), not just '?' in the date field itself. [...]
11178 88 15_Re: DB2 Connect13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Tue, 5 Dec 2000 17:40:17 -0600409_iso-8859-1 Hi Raymond, I think you nailed it when you said "...or on a central gateway somewhere." What I'd like to see is that somewhere be OS/390.
Someone please correct me (IBM?) here if I'm understanding this wrong:
DDF is expecting DRDA. DB2 Connect gateway 'does' that. Currently this function must reside on a network node between the client and the host (or for PE on the client!). [...]
11267 112 15_Re: DB2 Connect11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Tue, 5 Dec 2000 15:51:18 -0800475_iso-8859-1 We have a UNIX address space running on our 0S/390. I ask my MVS guy to try to install DB2 connect EE UNIX version on it. He said the DB2CCEE UNIX is a different UNIX than the OS/390 UNIX. To bad because I could have had it up sooner, as it was I had to wait for the lan/wan guys to find a UNIX server and install it. I hear that os/390 r10 will have a the ability to run a NT address space. If so we may be able to install EE there. Might be able to get rid [...]
11380 60 15_Re: DB2 Connect15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 6 Dec 2000 11:00:56 +1100521_- Hmmm... I think I see what you're getting at. Make the 'gateway' that your local PC connects to (to find DB2 Connect) OS/390. I think you're getting into a PC/network area I know little about. When you connect to ssid (on the DB2 Connect server) how does DB2 PE know where that server is? Is that down to Comms Manager? (can't remember it's new name. Comms Server?) If there's another layer that can find DB2 Connect on OS/390 instead of on the traditional gateway, then I guess you're in. Comms guys, step on up. [...]
11441 57 15_Re: DB2 Connect0_15_leon@CA.IBM.COM30_Wed, 6 Dec 2000 10:05:51 +1000497_us-ascii Duane, DB2 Connect is specifically designed to connect PC, UNIX and web applications to DB2 for OS/390, DB2 for VSE and VM and DB2/400 database servers. We offer 2 types of DB2 Connect products: 1. direct connectivity from desktop applications is accomplished by installing DB2 Connect Personal Edition on the PC where the application is running 2. application/web server support is provided by installing DB2 Connect Enterprise Edition server on some sort of an intermediate server [...]
11499 106 15_Re: DB2 Connect0_15_leon@CA.IBM.COM30_Wed, 6 Dec 2000 10:51:08 +1000372_us-ascii Mohammad, I think I am "they" so maybe I can shed some light on this. I want to say right up front that what I will be describing is strictly technical implementation (i.e. not pricing) for a very specific applications i.e. typical 2-tier or "fat client" client-server applications. I am not going to get in to 3-tier applications or web-based applications. [...]
11606 140 45_Re: DECLARE GLOBAL TEMPORARY: -904 ON TEMP DB14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 6 Dec 2000 10:20:55 +1100311_iso-8859-1 The name of the TEMP database can be anything you like. There can be only one TEMP database in each system. (It is this 'one database' restriction that causes the writers to use the word "the", rather than a restriction on the name.) In a sysplex, each system has to have its own TEMP database. [...]
11747 24 9_IFCID 1987_DB2 fan16_askdb2@YAHOO.COM30_Tue, 5 Dec 2000 21:49:17 -0600580_- Hi, I am trying to find the average page residency time for a Bpool that is primarily used for random access objects. I am planning to use the Storeclock value in the standard header/correlation following the IFCID info. Basically what I wd do is to subtract the RELPAGE storeclock value from the corresponding GETPAGE store clock. Is that an accuarate estimate?. Is there a better way of doing this?. Is there any REXX based routine to convert STCK to timestamp eqvt other than using STCKCONV?. If using STCK is the only option, is there any any special conventions to be [...]
11772 158 15_Re: DB2 Connect14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 6 Dec 2000 15:03:47 +1100393_iso-8859-1 It's not just that OS/390 Unix Services (or whatever they call it nowadays) is a different UNIX, it's that programs are compiled to run under a particular instruction set - which is not S/390. To try and run a UNIX (hardware platform unspecified) under UNIX Services has as much chance of working as expecting a stranger to talk in Xhosa. (If your e-address ended in .za ....) [...]
11931 51 13_Re: IFCID 19815_Sydney Brereton21_sbrereton@MMAL.COM.AU30_Wed, 6 Dec 2000 14:50:33 +1030408_US-ASCII Hi, I used SAS to do the data manipulation of GTF records from IFCID 198 records. The SAS data format I used was "INPUT @3 TSTAMP TODSTAMP8", this allowed me to find the first and last trace record time and derive the trace period (in the event that GTF wrapped the trace data set). You should be able to do the subtraction to get the page residency. Just my opinion and all that. Cheers, Syd. [...]
11983 25 7_Re: CDB14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 5 Dec 2000 23:16:02 -0600434_iso-8859-1 Jennifer,
Just received the advertising post card. CDB used reference to www.ryci.com in an advertising way without our permission, as well as quotes from subscribers to the private, non-public list server in violation of several US statutes. RYC will be contacting CDB on this issue.
Thank you, Richard Yevich +======+======+======+ Richard_Yevich@ryci.com http://www.ryci.com -- RYC Knowledge Database [...]
12009 36 16_ADB/2 Software !27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Wed, 6 Dec 2000 13:52:27 +0530317_iso-8859-1 Hi List,
Has anyone ever heard of ADB/2 Software. We need to receive some training on this tool but are unable to locate any resource or website which can help us on this.
The only information I received about ADB on the net, is for the Apple Data Bus architecture and the ADB mouse !!! [...]
12046 53 52_Using stored procedures with JDBC (DB2 v5 on OS/390)15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Wed, 6 Dec 2000 09:42:44 +0100595_iso-8859-1 Hello all,
In my shop we have various Intranet applications whom are connecting to DB2 on OS/390 via an NT-machine using DB2 connect EE. Those JAVA applications use dynamic SQL with JDBC, DB2 Connect EE, and SNA. We don't like having dynamic SQL on a production database. Therefore we want to implement stored procedures. We are on DB2v5, and so far the manuals and literature on stored procedures for DB2v5 do not say anything of a JAVA application being able to call a stored procedure via JDBC. Does anyone have experience with this, and even more does someone have an [...]
12100 68 21_CAF & USS Performance30_CHRISTOPHER.KELLER@Vereinte.de30_CHRISTOPHER.KELLER@VEREINTE.DE30_Wed, 6 Dec 2000 09:46:00 +0100490_iso-8859-1 --- Received from BG1.KELLERC 6785-2761 06-12-00 09.46
-> DB2-L@RYCI.COM
Hello, we will be implementing a CLI Application in UNIX System Services which will attach to DB2 via CAF.
My knowledge of CAF is not extensive, I am aware of the differences between the TSO, CAF and RRSAF attachments and in the past we've used CAF in an ISPF application used by tens of users. We are talking here though about a client-server application with hundreds of users. [...]
12169 53 20_Re: ADB/2 Software !10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 6 Dec 2000 03:03:51 -0600580_- Just a wild guess, but I think you may have Access for DB2 by Princeton Softech.
On Wed, 6 Dec 2000 13:52:27 +0530, Thakral, Deepak Kumar (CTS) wrote:
>Hi List, > >Has anyone ever heard of ADB/2 Software. We need to receive some training on >this tool but are unable to locate any resource or website which can help us >on this. > >The only information I received about ADB on the net, is for the Apple Data >Bus architecture and the ADB mouse !!! > >Will be grateful for any information you might be having about this tool [...]
12223 28 31_JDBC & SQLJ - request for infos10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 6 Dec 2000 10:22:53 +0100338_us-ascii We installed JDBC in a small test LPAR and it works, but we would like to know where we can find infos to evaluate the
performance of JDBC application vs SQLJ application as in theory it'd be better to use static SQLJ instead of dynamic
JDBC . We need this informations to develop a new marketing application. [...]
12252 94 56_Re: Using stored procedures with JDBC (DB2 v5 on OS/390)11_Manish Lall25_Manish.Lall@IN.EFUNDS.COM30_Wed, 6 Dec 2000 15:02:57 +0530583_us-ascii Hello Jaap,
You can call the stored procedure through java with the configuration you have mentioned(NT, JDBC,DB2 connect ...) But while binding the packages use the collection id " NULLID", because whenever you use java on NT,DB2 Connect for calling stored procedure on DB2 OS/390 it looks for the packages under this collection id .. atleast in our case we were forced to bind under this collection id and then it worked without any problem.( You can also experiment by binding the packages using any other collection id and checkout whether it works or not ) [...]
12347 60 35_Re: JDBC & SQLJ - request for infos11_Manish Lall25_Manish.Lall@IN.EFUNDS.COM30_Wed, 6 Dec 2000 15:20:57 +0530540_us-ascii Hello Max ,
You can visit
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DSNJV0G2/CCONTENTS this book talks a lot about JDBC and SQLJ , and can be of some help .
Thanks, Manish Lall
Max Scarpa @RYCI.COM> on 12/06/2000 02:52:53 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: JDBC & SQLJ - request for infos [...]
12408 53 13_Re: MERGECOPY16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Wed, 6 Dec 2000 11:27:28 +0530537_- Hi Jim, I am not able to get your second sentence i.e "The SHRLEVEL of the last incremental will be used for the merged copy". I have a feeling that Mergecopy works on IC datasets only and it doesn't require any kind of hold on corresponding tablespace. Do you mean to say if mergecopy is run on the IC datasets which are the output of imagecopy with different shrlevel then DB2 will find out if shrlevel change or reference was used for the last IC(where from ?) and then it will combine the all IC datasets.(Why ??) I also feel [...]
12462 50 39_Re: Alter PRI and SEC Quantity of Parts16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Wed, 6 Dec 2000 12:07:27 +0530587_- Hi Trace, It is not neccessary to stop the part or tablespace. The only thing is the change will be in effect after the reorg.What is the exact message you are getting while trying to alter the tablespace ?.
Regards Sanjeev
> -----Original Message----- > From: Trace Jones [SMTP:Trace_R_Jones@RELIANTENERGY.COM] > Sent: Tuesday, December 05, 2000 8:16 PM > To: DB2-L@RYCI.COM > Subject: Alter PRI and SEC Quantity of Parts > > Hi everyone, > > > I thought that if you wanted to alter the primary and secondary quantity > of > a part in a tablespace (OS/390 V6) that [...]
12513 84 38_Re: Basic SQL statement with timestamp16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Wed, 6 Dec 2000 01:47:31 -0500471_- Hi John, If we consider col1 and col2 as the primary key of the table T1 then is there any difference between the query given by you and query written below i.e
select col1,col2,max(col3) from T1 where col1 = 'a' and col2 = 'b' group by col1,col2
The only difference i can find is because in both the cases the result will be single row and your query can be coded in the application as a singleton select and my query can't be(because of GROUP BY). [...]
12598 62 13_Re: MERGECOPY0_18_mebert@AMADEUS.NET30_Wed, 6 Dec 2000 12:01:28 +0100579_us-ascii Hi Sanjeev,
it makes sense if you think about it. An IC can be SHRLEVEL REF (no write access during the copy process) or SHRLEVEL CHANGE (writes allowed). An incremental IC contains all changed pages since the last IC (that's all pages changed since the start of the previous IC if that was a SHRLEVEL CHANGE IC, and all pages changed since the end of the IC for a SHRLEVEL REF IC). This means that merging consecutive ICs will always be consistent, and that the last (incremental) IC determines the SHRLEVEL. MERGECOPY will get the SHRLEVEL, as well as all [...]
12661 34 16_pklist(collid.*)10_Ozgur Ozen13_oozen@YKB.COM30_Wed, 6 Dec 2000 12:53:54 +0200631_us-ascii Hi all,
what would be the performance consequences of binding plans with pklist(collid1.*,collid2.*,collid3.* ... colid10.*) with nearly 10.000 packages in each collection.
Does it use matching index access to the package table for a package in a collection ?
Manaul says; The order in which you specify packages in a package list can affect run-time performance. Searching for the specific package involves searching the DB2 directory, which can be costly. When you use collection-id.* with PKLIST keyword, you should specify first the collections in which DB2 is most likely to find a package. [...]
12696 74 20_Re: pklist(collid.*)12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Wed, 6 Dec 2000 11:12:02 -0000473_iso-8859-1 I believe DB2 uses hashing to locate a package within a collection, so there is very little overhead in having lots of packages in a collection, but each collection is scanned in turn, so the order and number of collections in the plan can be important.
Colin Allen Abbey National
-----Original Message----- From: Ozgur Ozen [mailto:oozen@YKB.COM] Sent: Wednesday 06 December 2000 10:54 AM To: DB2-L@RYCI.COM Subject: [DB2-L] pklist(collid.*) [...]
12771 159 38_Re: Basic SQL statement with timestamp10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 6 Dec 2000 06:03:00 -0600366_- Hello Sanjeev,
I agree that the query:
select col1,col2,max(col3) from T1 where col1 = 'a' and col2 = 'b' group by col1,col2
should produce the same result as (for instance):
select col1, col2, col3 from T1 taba where col1 = 'a' and col2 = 'b' and col3 = (select max(col3) from T1 tabb where col1 = taba.col1 and col2 = taba.col2) [...]
12931 23 20_Re: pklist(collid.*)15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Wed, 6 Dec 2000 06:48:15 -0600341_- Hi
The PKLIST-entries are search sequentially. For each collidn.*-entry DB2 accessed the SPT01 using a full matching index acces, because it knows location and collid from the PKLIST-entry, name and contoken of the package from the call to DSNHLI and those four make up the unique index.
One thing has to be considered: [...]
12955 33 22_Varchar vs compression12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Wed, 6 Dec 2000 12:58:18 -0000563_iso-8859-1 Just an idle thought, but if I am going to create a new table with compression on, is there any point in using VARCHAR for some of the columns inside it?
Colin Allen Abbey National
Important:
Internet communications are not necessarily secure and may be intercepted or changed after they are sent. The Abbey National Group does not accept liability for any such changes. If you wish to confirm the origin or content of this communication, please contact the sender using an alternative means of communication. [...]
12989 221 30_DB2 v7.1 for NT internal error19_Margaritis Dimitris20_margardi@NOVABANK.GR30_Wed, 6 Dec 2000 14:51:30 +0200417_iso-8859-7 Hi all
I get the error you can see below in mydatabase log Environment: DB2 v7.1 for NT Database is replicated to another NT machine Is there any idea?
Thanks in advance
Dimitris Margaritis NOVABANK S.A. ----------------------------- System Engineer
182, Sygrou Av., 176 71 Athens, Greece Phone: + 301 9557146 Fax: + 301 9530658 Email: margardi@novabank.gr [...]
13211 90 26_Re: Varchar vs compression15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Wed, 6 Dec 2000 14:08:52 +0100347_iso-8859-1 Colin,
To give a quick answer; NO. To compress the VARCHAR attribute is maximised and then compressed. The Varchar has some extra BITS inside, this gives extra overhead you don't want to have. However the depends question might be if you want to compress or not.
Kind Regards,
Jaap Slot, DB2 DBA, Rabobank ICT [...]
13302 48 52_Re: Allocating CPU time in a DB2/Connect Environment20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 6 Dec 2000 08:13:26 -0500625_us-ascii Gill
The QWHUCPU field is not a very accurate field for accounting purposes (or 101 type SMF records). Look for QWACAJST field for accounting data-section to get in-db2 time for any accounting record, regardless of DB2 Connect or not.
-Venkat Pillay
> -----Original Message----- > From: Gill, Joseph G [SMTP:joseph.gill@EDS.COM] > Sent: Tuesday, December 05, 2000 4:36 PM > To: DB2-L@RYCI.COM > Subject: Allocating CPU time in a DB2/Connect Environment > > Is the field QWHUCPU in the DB2 101 record a good field to use to capture > the CPU used by users coming in via DB2/Connect? If not, [...]
13351 95 26_AW: Varchar vs compression12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 6 Dec 2000 14:14:31 +0100356_iso-8859-1 Colin,
For DB2 for OS/390 the COMPRESS YES option works on the tablespace level. Not on a table level.
Just an idea: create the table inside a tablespace, load the data, runstats the tablespace and then run the DB2 DSN1COMP service aid utility. As a result you will see the percentage of savings if you choose compression ON. [...]
13447 54 13_Re: IFCID 19820_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 6 Dec 2000 08:20:48 -0500326_us-ascii I think, what you are trying will not give you the desired result. Because the RELPAGE is done as soon as page is no longer needed by the application but the page could still stays in the bufferpool for much much longer time. Hence (RELPAGE time - GETPAGE time) is not the page residency time in the bufferpool. [...]
13502 15 26_Re: Varchar vs compression15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Wed, 6 Dec 2000 07:23:09 -0600447_- Colin
One advantage you have with VARCHAR, you can enlarge it using the new ALTER statement: ALTER TABLE table ALTER COLUMN columnname SET DATA TYPE VARCHAR (m), where m is greater than old value.
================================================ 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.
13518 21 26_Re: Varchar vs compression13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 6 Dec 2000 08:28:36 -0500381_iso-8859-1 Hi Colin, Others have already commented on the compress vs varchar efficiencies.
Some applications might still have a need for Varchar. For instance, say your app. needed to know the exact length of an item of data. A Varchar column is the best way to do this.
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com [...]
13540 64 26_Re: Varchar vs compression20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 6 Dec 2000 08:31:06 -0500400_us-ascii Although, if you are using compression then VARCHAR does not provide much benefit as compared to a CHAR column. Still there are few points to consider for using VARCHAR.
1. Now you could alter the size of VARCHAR using ALTER statement thereby making your maintenance easier. 2. VARCHAR can be much longer than 255 hence a better choice again from future maintenance perspective. [...]
13605 80 39_Re: Alter PRI and SEC Quantity of Parts20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 6 Dec 2000 08:34:17 -0500380_us-ascii In recent days, there has been marked changes in the way we change PRIQTY and SECQTY for our tablespace/indexspace.
1. There is no need to stop the tablespace for altering PRIQTY & SECQTY. 2. The change in the SECQTY is effective for the immediate extents taken. In other words DB2 will look at the Catalog and extend the linear vsam based on the new SECQTY. [...]
13686 18 55_Converting V5 Stored Procedures to V6 Stored Procedures11_Paul Turpin22_pault704@EARTHLINK.NET30_Wed, 6 Dec 2000 07:32:33 -0600502_- I know when you upgrade DB2 from V5 to V6 the process does the necessary conversion automatically, taking the information in SYSIBM.SYSPROCEDURES and propagating it to the new V6 stored procedure tables (SYSPARMS, SYSROUTINEAUTH, SYSROUTINES).
My question is, if you receive V5 stored procedure statements from a vendor and need to put them into a V6 system, does anyone know of a utility to convert the statements from V5 format (INSERT statements) to the V6 format (CREATE statements). [...]
13705 26 27_DB2 VSE 18 CHAR RESTRICTION17_Rabindra Senapati21_rsenapati@HOTMAIL.COM30_Wed, 6 Dec 2000 07:53:52 -0600353_- Hello Group,
We are using DB2 VSE V7.1. Does any one knows How to over come the 18 charcter restriction for dbspace,tablename and column name.
Do the same thing holds good for DB2 MVS or OS/390. Please let me know more information about MVS and OS/390 side. Is there any patch or fix to over come that limitation either VSE or MVS? [...]
13732 24 31_Re: DB2 VSE 18 CHAR RESTRICTION13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 6 Dec 2000 09:22:06 -0500394_iso-8859-1 Hi Rabi, Sorry I can't speak for VSE, but for OS/390, this restriction is puportedly being lifted in the next release beyond v7. This is the news we got at the DB2 Tech Conference in October in Las Vegas.
This is a massive effort I believe, and will affect many components and other tools. I don't expect you'll see an APAR delivering this bug, er I mean, feature early. [...]
13757 189 38_Re: Basic SQL statement with timestamp0_24_John_McComb@VANGUARD.COM30_Wed, 6 Dec 2000 09:22:51 -0500331_us-ascii Maybe I'm missing something, but Lee's original request appears to be asking for the row with the highest timestamp on the table, not the higest timestamp for each value of col1 and col2. In that case the query would be simply:
select col1, col2, col3 from T1 taba where col3 = (select max(col3) from T1 tabb) [...]
13947 47 31_Re: DB2 VSE 18 CHAR RESTRICTION16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Dec 2000 09:22:47 -0500674_iso-8859-1 Wonderful. Now SQL will be able to use COBOL-like BY-THE-SHORES-OF-GITCHEE-GOOMIE-BY-THE-SHINING-GREAT-SEA-WATERS names. This must be a conspiracy by the keyboard salesweasels.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Wednesday, December 06, 2000 9:22 AM To: DB2-L@RYCI.COM Subject: Re: DB2 VSE 18 CHAR RESTRICTION
Hi Rabi, Sorry I can't speak for VSE, but for OS/390, this restriction is puportedly being lifted in the next release beyond v7. This is the news we got at the DB2 Tech Conference in October in Las Vegas. [...]
13995 22 27_DB2 cannot identify to IRLM12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Wed, 6 Dec 2000 08:36:08 -0600471_iso-8859-1 I am in the process of installing DB2 on our PROD lpar for the first time. We currently have 2 DB2 subsystems on a different lpar, DB2 v 5.1 put level 9901. When I attempt to bring up DB2P on the PROD lpar, the following message is received: DSNT379I Cannot identify to IRLM. Invalid Ssname. I have looked in IEFSSN10 and it looks correct, and I have checked my zparms, and they look correct as well. Anyone have any suggestions on where to look next???? [...]
14018 28 41_What happened to http://www.ryci.com/ ???10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 6 Dec 2000 15:29:04 +0100343_us-ascii I tried to connect to db2-l via www.ryci.com/db2-l, as usual, but I received a http 404 error.
I connected to main page www.ryci.com and I found that now it's 'The heart of America' for DB2 (it seems a cupid's
network member...).
Is there a new address for db2-l ? Or was the access from internet disabled ? [...]
14047 67 13_Re: IFCID 19814_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Wed, 6 Dec 2000 09:33:08 -0500603_ISO-8859-1 This will not provide residency time since you have no way of knowing when a page is deleted from the pool (falls off an LRU queue). The Buffer Pool Tool provides an "approximation" of page residency time, and V7 (due in January) has a utility that shows page references.
Residency time is interesting from a statistical analysis viewpoint, but of little value in a real world. For any particular object, some number of pages may have long times because they are re-referenced, while other pages have short times. The important metric remains the I/O rate, and the goal of tuning [...]
14115 12 31_Re: DB2 cannot identify to IRLM12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Wed, 6 Dec 2000 09:42:11 -0500318_us-ascii there is a parm in the irlm startup that must match the ssid entry.
================================================ 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.
14128 46 31_Re: DB2 cannot identify to IRLM16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Dec 2000 09:39:39 -0500451_iso-8859-1 Was the JCL cloned from somewhere else? If so, do you have IRLMSID= in ZPARM equal to IRLMNM= in the IRLM JCL? is IRLMNM=in the JCL = the member you defined in IEFSSN10?
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Vernon, John [mailto:John.Vernon@TRS.STATE.TX.US] Sent: Wednesday, December 06, 2000 9:36 AM To: DB2-L@RYCI.COM Subject: DB2 cannot identify to IRLM [...]
14175 52 45_Re: What happened to http://www.ryci.com/ ???16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Dec 2000 09:41:44 -0500510_iso-8859-1 Max, When I specify www.yci.com/db2-l I get DB2 Database Discussion List
Is someone maybe playing games with your DNS?
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: Wednesday, December 06, 2000 9:29 AM To: DB2-L@RYCI.COM Subject: What happened to http://www.ryci.com/ ???
I tried to connect to db2-l via www.ryci.com/db2-l, as usual, but I received a http 404 error. [...]
14228 204 38_Re: Basic SQL statement with timestamp10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 6 Dec 2000 08:48:07 -0600575_- No, you're not missing anything. This was the correct solution suggested by Mike Wiles way back before I stuck my oar in. Anyway, I think we've done this one to death now.
On Wed, 6 Dec 2000 09:22:51 -0500, John_McComb@VANGUARD.COM wrote:
>Maybe I'm missing something, but Lee's original request appears to be asking for >the row with the highest timestamp on the table, not the higest timestamp for >each value of col1 and col2. In that case the query would be simply: > >select col1, col2, col3 > from T1 taba > where col3 = > (select max(col3) > from [...]
14433 49 45_Re: What happened to http://www.ryci.com/ ???0_22_The-Thanh.Luong@AGF.BE30_Wed, 6 Dec 2000 16:09:56 +0100474_- Max, Have you tried http://jupiter.ryci.com ? There are links from that site. Regards,
LUONG The-Thanh
-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: Wednesday, 06 December, 2000 3:29 PM To: DB2-L@RYCI.COM Subject: What happened to http://www.ryci.com/ ???
I tried to connect to db2-l via www.ryci.com/db2-l, as usual, but I received a http 404 error. [...]
14483 49 33_Re: What Happened to www.ryci.com14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Wed, 6 Dec 2000 07:15:52 -0800147_- I believe they are having some technical problems with the site and I have alerted them. -Phil
Phil Gunning Assoc List Owner DB2-l
14533 74 45_Re: What happened to http://www.ryci.com/ ???0_23_Sheila_White@AMSINC.COM30_Wed, 6 Dec 2000 10:05:52 -0500501_us-ascii I get the same thing as Max. I note that the Heart of American DB2 page is hosted by RYC Inc.
"Pearson, Eric L," on 12/06/2000 09:41:44 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Sheila White/AMS/AMSINC)
Subject: Re: What happened to http://www.ryci.com/ ???
Max, When I specify www.yci.com/db2-l I get DB2 Database Discussion List [...]
14608 21 45_Re: What happened to http://www.ryci.com/ ???10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 6 Dec 2000 16:31:22 +0100507_us-ascii Many & many thanks folks (expecially to LUONG The-Thanh), now I'm able to reach db2-l via
jupiter.ryci.com/db2-l/
I'm not able to reach the list via www.ryci.com/db2-l as usual, anyway.
Thanks again. You won a tshirt.
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.
14630 42 45_Re: What happened to http://www.ryci.com/ ???15_Lankester, Andy22_Andy_Lankester@BMC.COM30_Wed, 6 Dec 2000 09:48:41 -0600354_iso-8859-1 Looks a bit like the 'DROP DATABASE XYZ' 'OHHH NOOO I am on the production system' syndrome. Possibly they loaded the Heart of America stuff into the main rather than a subordinate directory.
Incidentally if you _DO_ do an accidental DROP then call the OS/390 operators and get them to cancel you FORCE ASAP - could save your job! [...]
14673 74 31_Re: DB2 VSE 18 CHAR RESTRICTION13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 6 Dec 2000 11:00:40 -0500354_us-ascii Yes! We're all going to get very comfortable with the substr function when querying the catalog (ugh) on OS/390...just like we do now on NT and UNIX...where DB2 already supports table names up to 128 characters in length...
Lynne A. Flatley New England Financial (617) 578-4079 (work) (781) 718-0919 (cell) lflatley@nefn.com [...]
14748 55 33_Cannot Connect from Apache to DB219_Margaritis Dimitris20_margardi@NOVABANK.GR30_Wed, 6 Dec 2000 18:16:56 +0200717_iso-8859-7 I tried to connect from IBM Apache to DB2 database on a AIX 4.3.3 machine and i got the following error Is there any ideas?
Thanx
DB2B0028I Do Rollback due to error occured. @@@@@@@@@@@@@@ AR_OPEN return @@@@@@@@@@@@@ *** Wed Dec 6 14:02:28 2000
DB2B0000I Open connection to DB2 Database @@@Info get_ConnectInfo(names[0])=USER,params[0]=isis @@@ Info get_Connectinfo(doctab=ISIS.ISIS_DOCAR, doctab_blob=ISIS.ISIS_DOCAR_BLO B, idxtab=ISIS.ISIS_IDXAR) DEF_PAGE=32000 DB2B0001E Cannot connect to DB2 Database. Process denied 8198131 DB2B0028I Do Rollback due to error occured. DB2B0002I DB2 Database isis has been connected. DB2B0035E Could not get user identification from database [...]
14804 37 37_DB2 Environment Performance Checklist9_Don Alden25_Don.Alden@I-STRUCTURE.COM30_Wed, 6 Dec 2000 09:20:32 -0700380_iso-8859-1 Fellow Listers,
I am in the process of developing a DB2 Performance and Tuning project for our DB2 customers. I am including all major components of DB2 including Applications, Systems and Distributed tuning oppurtunities in this project. The main reason for this project is to investigate and formulate performance improvement plans for our DB2 customers. [...]
14842 60 26_Re: Db2 Connect for OS/39012_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 6 Dec 2000 08:56:07 -0800539_us-ascii True, Neon systems has a product that runs on the OS/390 but this product STILL requires some code that has to run on the client PC.
Regardless of how you call it. You need some type of code on the pc. --- Dean Montevago wrote: > Hi, > If they are at V6 of DB2 is it true they don't need > DB2 Connect at all ? > Also, NEON systems has a DB2 Connect type product > that runs on the 390. > > > -----Original Message----- > > From: Philip Gunning > [SMTP:Philip.Gunning@QUEST.COM] > > Sent: Monday, [...]
14903 20 31_Re: DB2 VSE 18 CHAR RESTRICTION14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Wed, 6 Dec 2000 11:29:40 -0600481_iso-8859-1 As I recall from IBM Tech for OS/390: 20 man-year effort, requiring a complete restructuring of the Catalog (I think UNICODE was even mentioned), among about 100 other items...
Some version after V7.
Richard Yevich
================================================ 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.
14924 53 31_Re: DB2 cannot identify to IRLM50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Wed, 6 Dec 2000 12:43:09 -0500583_iso-8859-1 From the zparm ::
IRLMPRC=DBP2IRLM, IRLMSID=IRLP,
The irlmprc should be the same as the started subsystem for the irlm
Also the IRLM start up proc ::
DB2.SDXRRESL <-- DB2 irlm library
and check the parameter in the start up proc
LIB='DB2.SDXRRESL', <-- DB2 irlm library IRLMNM=IRLP, <-- should match the zparm parameter
-----Original Message----- From: Vernon, John [mailto:John.Vernon@TRS.STATE.TX.US] Sent: Wednesday, December 06, 2000 9:36 AM To: DB2-L@RYCI.COM Subject: DB2 cannot identify to IRLM [...]
14978 36 11_DB2 Connect16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV30_Wed, 6 Dec 2000 10:43:50 -0700401_- Thanks to all those that responded to my message/query.
What I was trying to see was if there was a version of DB2 Connect that runs on S390 that I could use in place of the middle tier. The responses indicate my best option in this regard would be to use Linux/S390. We will investigate this but I don't know if we will choose to go that route or if we will go with an NT middle piece. [...]
15015 57 31_Re: DB2 CONNECT ENTERPRISE HELP0_15_leon@CA.IBM.COM30_Wed, 6 Dec 2000 12:45:31 -0500367_us-ascii DB2 Connect Enterprise Edition comes with a manual called "DB2 Connect Enterprise Edition Quick Beginnings". This manual has step-by-step instructions that you need to follow. These instructions are very good and easy to follow. If for some reason you have not received a printed copy of this book, then you will find a soft copy on the DB2 Connect CD. [...]
15073 66 41_Re: DB2 Environment Performance Checklist9_Cam White20_cwhite@REVEALNET.COM30_Wed, 6 Dec 2000 13:30:49 -0500687_iso-8859-1 Don,
You will find a wealth of performance & tuning insights in the Knowledge Base for DB2. Much of the information is organized in checklist format. For product information and downloading a trial version, visit http://www.revealnet.com/Products/DB2/db2adm.htm
Best wishes,
Cam White
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Don Alden > Sent: Wednesday, December 06, 2000 11:21 AM > To: DB2-L@RYCI.COM > Subject: DB2 Environment Performance Checklist > > > Fellow Listers, > > I am in the process of developing a DB2 Performance and Tuning project > for our DB2 customers. I am [...]
15140 13 13_Re: IFCID 19817_Venkat Srinivasan16_askdb2@YAHOO.COM30_Wed, 6 Dec 2000 12:31:01 -0600377_- Joel, Not meaning to infringe on your secrets, but could you please explain how to find the approximate page resident time?.. DB2 fan
================================================ 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.
15154 78 27_DB2 VSE 18 CHAR RESTRICTION16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT30_Wed, 6 Dec 2000 18:04:19 +0100417_us-ascii Rabi,
sorry to inform you that there is no change to the 18-bytes limit for column names on DB2 Server for VSE and VM.
ciao.
Aurora Emanuela Dell'Anno Systems Programmer Sistemi Informativi S.p.A. e-mail: aurora.dellanno@sistinf.it tel. +39 335 7429486
no trees were killed in the sending of this message. however - a large number of electrons were seriously inconvenienced. [...]
15233 147 15_Re: DB2 Connect0_15_leon@CA.IBM.COM30_Wed, 6 Dec 2000 13:57:14 -0500370_us-ascii You will not be able to run Windows NT or UNIX binaries on S/390. What UNIX services and Windows NT subsystems on S/390 allow you to do is simplify porting your source code to S/390. DB2 Connect, as most products out there, is distributed in binary form specific to a particular hardware and OS. The version we have for S/390 hardware is for Linux/390 OS. [...]
15381 124 15_Re: DB2 Connect0_15_leon@CA.IBM.COM30_Wed, 6 Dec 2000 14:05:48 -0500540_us-ascii Dave, we've spend a lot of effort evaluating what you are proposing. Without getting in to too many details I can tell you that what we are doing with DB2 Connect on the S/390 platform is very closely aligned and is in step with what IBM as a whole is doing with S/390. By now there should be no doubt that IBM is positioning Linux/390 as the UNIX for the S/390 hardware. That is where DB2 Connect and many other products in the IBM portfolio run. You will continue to see IBM and other vendors deliver more and more products [...]
15506 22 52_DB2 OS/390 Version 5 or 6 and OS/390 R10 maintenance16_Jerry Bustamante20_ggbusta@LANDSEND.COM30_Wed, 6 Dec 2000 13:14:03 -0600401_us-ascii Does anyone know if there is any DB2 OS/390 maintenance required to run under OS/390 R10?
Thank you,
:-)
Jerry Bustamente
================================================ 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.
15529 59 15_Re: DB2 Connect22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM30_Wed, 6 Dec 2000 14:45:12 -0500453_iso-8859-1 CAE was the DB2 Connect V5 terminology for what is now called the Run-Time Client in DB2 Connect V6.1 and greater. Two names for the same function.
Mike Piontkowski TP&S Technical Maintenance Voice: +1 302.886.4612 Fax: +1 302.886.4749
-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: Wednesday, December 06, 2000 12:44 To: DB2-L@RYCI.COM Subject: [DB2-L] DB2 Connect [...]
15589 73 31_Re: DB2 cannot identify to IRLM12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Wed, 6 Dec 2000 15:03:10 -0600499_iso-8859-1 Yep, the jcl was cloned, and I did not identify the new IRLM in the IEFSSN10 member (I had defined the new DB2 subsystem, but not the IRLM subsys).
Many thanks to all on the list (Tony Clark, Eric Pearson, Robert Knight, Jeff Frazier), I really appreciated the help!!!!!
john
-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Wednesday, December 06, 2000 8:40 AM To: DB2-L@RYCI.COM Subject: Re: DB2 cannot identify to IRLM [...]
15663 75 38_Re: Basic SQL statement with timestamp10_Mike Wiles14_mwiles@UCG.COM30_Wed, 6 Dec 2000 17:38:31 -0500439_iso-8859-1 Hi Guys,
I don't want to beat this to death, but I was curious if there is a difference between:
select col1, col2, col3 from T1 taba where col3 = (select max(col3) from T1 tabb)
and
select col1, col2, col3 from T1 where col3 = (select max(col3) from T1)
(Please note that I have lifted this form John McComb's example below and corrupted it in the second example, removing the aliases.) [...]
15739 13 12_Re: DDF Help14_William Poston21_william.poston@DB.COM30_Wed, 6 Dec 2000 16:56:21 -0600377_us-ascii For those of you using DDF heavily to communicate between two DB2 subsystems what do you have your RUSIZES and VPACING set to?
================================================ 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.
15753 241 34_Re: DB2 v7.1 for NT internal error11_Bruce Allen17_ballen@SPOTON.COM30_Thu, 7 Dec 2000 10:09:22 +1100586_iso-8859-1 Hi, Did you change the size of the log files? We saw DB2 get confused over calculating which log files was required for a given LSN (command db2flsn) after changing the log file size, but while capture still had processing of the log file to complete.
HTH, Bruce
> -----Original Message----- > From: Margaritis Dimitris [SMTP:margardi@NOVABANK.GR] > Sent: Wednesday, 6 December 2000 23:52 > To: DB2-L@RYCI.COM > Subject: DB2 v7.1 for NT internal error > > Hi all > > > I get the error you can see below in mydatabase log > Environment: > DB2 v7.1 for NT > [...]
15995 74 64_Re: Using stored procedures with JDBC & added question on SQL-J.12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Thu, 7 Dec 2000 10:05:04 +1100544_- Jaap, Has any thought been given to Java using SQL-J. I know it's a DB2 V6 thing, but I was under the impression you could also get on V5 via APAR(s).
Dear List, As an aside has anybody out there, used it (SQL-J), under any type of volume; and would you care to comment on your experiences? We have an Unix based application that is using MQ-Series to chat to DB2 (ie: pass message to mainframe program and pass back results) It was done this way for 2 reasons the scalability of processing the MQ queues, and because Dynamic SQL [...]
16070 47 29_Re: AIX Memory per Connection11_Bruce Allen17_ballen@SPOTON.COM30_Thu, 7 Dec 2000 10:38:46 +1100347_- Hi Scott, There is a freeware/shareware called 'the monitor' which separates file cache from other memory (replacement for top). Also, there is a tool called svmon. It is a detail tool (per task/process) for memory usage, and it appears that it will tell you private memory used. (However, it is too long since I used it to say much more). [...]
16118 66 29_Re: AIX Memory per Connection14_Scott Saunders20_ssaunders@SIEBEL.COM30_Wed, 6 Dec 2000 15:33:56 -0800646_iso-8859-1 Thanks, Bruce.
Would you know where the shareware could be found?
Scott Saunders
-----Original Message----- From: Bruce Allen [mailto:ballen@SPOTON.COM] Sent: Wednesday, December 06, 2000 3:39 PM To: DB2-L@RYCI.COM Subject: Re: AIX Memory per Connection
Hi Scott, There is a freeware/shareware called 'the monitor' which separates file cache from other memory (replacement for top). Also, there is a tool called svmon. It is a detail tool (per task/process) for memory usage, and it appears that it will tell you private memory used. (However, it is too long since I used it to say much more). [...]
16185 42 15_Re: DB2 Connect13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Wed, 6 Dec 2000 18:47:45 -0600618_- On Wed, 6 Dec 2000 10:51:08 +1000, leon@CA.IBM.COM wrote:
Thanks for a very lucid explanation of the available soluntions but ...
>2. install DB2 Run-Time Client and a DB2 Connect Enterprise Edition Server > >A very important point here is that no matter which approach you take with >DB2 or with any other client-server database you will have to install some >client enabling software on the CLIENT machine i.e. machine where the >application (a piece of code that makes SQL calls through one of the >supported APIs) is running. In other words, installing software on server >alone will never be [...]
16228 46 26_Re: Varchar vs compression14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 7 Dec 2000 11:55:32 +1100373_iso-8859-1 On what do you base this assertion? (EG do you have a statement from IBM, have you manually decompressed a row, etc) My understanding has always been that what is compressed is what would be stored if the row was not compressed.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...]
16275 96 29_Re: AIX Memory per Connection11_Bruce Allen17_ballen@SPOTON.COM30_Thu, 7 Dec 2000 14:18:44 +1100760_- Hi Scott,
You could try http://www.ibm.com/servers/aix/download and from there go to Public Domain Software Library for AIX at UCLA. I believe it is also at Freeware and Shareware Archive for AIX at Groupe Bull
The program you want is monitor.
Regards, Bruce
> -----Original Message----- > From: Scott Saunders [SMTP:ssaunders@SIEBEL.COM] > Sent: Thursday, 7 December 2000 10:34 > To: DB2-L@RYCI.COM > Subject: Re: AIX Memory per Connection > > Thanks, Bruce. > > Would you know where the shareware could be found? > > Scott Saunders > > -----Original Message----- > From: Bruce Allen [mailto:ballen@SPOTON.COM] > Sent: Wednesday, [...]
16372 24 12_Value Clause11_David Nance16_DWNance@FHSC.COM30_Wed, 6 Dec 2000 17:10:58 -0500449_US-ASCII Does anyone know how to get spaces or rather a character string back when a column is a date? example: VALUE(D_END_DATE, ' ') I have tried a few variations on the above theme. The field is normally null. I would like to be able to have the sql insert a character string. The only way I have been able to pull it off is using a case expression, just thought the value clause might be a little easier for processing and readability. TIA [...]
16397 38 16_Re: Value Clause18_Martinson, Barbara25_Barbara_Martinson@BMC.COM30_Wed, 6 Dec 2000 22:06:09 -0600648_iso-8859-1 CHAR(CURRENT DATE) CHAR(CURRENT DATE,JIS), CHAR(CURRENT DATE,EUR), etc.
-----Original Message----- From: David Nance [mailto:DWNance@FHSC.COM] Sent: Wednesday, December 06, 2000 4:11 PM To: DB2-L@RYCI.COM Subject: Value Clause
Does anyone know how to get spaces or rather a character string back when a column is a date? example: VALUE(D_END_DATE, ' ') I have tried a few variations on the above theme. The field is normally null. I would like to be able to have the sql insert a character string. The only way I have been able to pull it off is using a case expression, just thought the value clause might be [...]
16436 57 16_Re: Value Clause16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Thu, 7 Dec 2000 09:44:47 +0530378_- Hi Dave, If i understood your question correctly then you want date column to be returned as spaces where its value is null. You can use
Value(CHAR(DATE), --any character string you want--) If you want to insert the character string in the date data type then it should exactly match the date time format and its reasonable value.Otherwise you will get -180/-181. [...]
16494 141 22_Re: Global Temp Tables11_Lorenz, Don15_dlorenz@KCC.COM30_Wed, 6 Dec 2000 14:02:37 -0600668_iso-8859-1 Thanks to Dean, Richard and Isaac for their helpful responses about the Global Temp tables!
-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [mailto:db46@DAIMLERCHRYSLER.COM] Sent: Monday, December 04, 2000 2:14 PM To: DB2-L@RYCI.COM Subject: Re: Global Temp Tables
I guess it comes down to what is meant by 'true' temporary tables.
I would think that Sybase has more 'true' temporary tables because they can be created on the fly (without having to enter them into systables) and that indexes can be created on them (used quite often in Sybase stored procedures) and updates and selective deletes can be on them. [...]
16636 24 19_Replication - CLOBs16_Minnie, Louwrens17_lminnie@FNB.CO.ZA30_Thu, 7 Dec 2000 07:48:37 +0200318_iso-8859-1 We are trying to replicate a DB2 UDB V5.2 database from one NT server to another. Everything works OK, accept, if the table contains columns defined as a CLOB.
Question, is there any limit on the size of the CLOB column, if so, what is it? Or is there a special way of replicating these tables? [...]
16661 105 45_Re: Calling the DB2 LOAD utility via DSNUTILS23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 7 Dec 2000 06:09:17 -0000839_iso-8859-1 sounds to me that the stored proc * associated load are out os sync .. just a wild guess on my part.
sorry I cannot help further
Les
-----Original Message----- From: Ross_Mallett@SEARCHSOFTWARE.COM [mailto:Ross_Mallett@SEARCHSOFTWARE.COM] Sent: Sunday, December 03, 2000 11:29 PM To: DB2-L@RYCI.COM Subject: Calling the DB2 LOAD utility via DSNUTILS
I'm hoping that someone here can help me. I'm trying to call the DB2 LOAD utility via DSNUTILS: EXEC SQL CALL SYSPROC.DSNUTILS ( :utility_id, :restart, :ustmt, :retcode, :utility_name, :recdsn, :recdevt, :recspace, :discdsn, :discdevt, :discspace, :pnchdsn, :pnchcdevt, :pnchspace, :copydsn1, :copydevt1, :copyspace1, :copydsn2, :copydevt2, :copyspace2, :rcpydsn1, :rcpydevt1, :rcpyspace1, :rcpydsn2, :rcpydevt2, :rcpyspace2, :workdsn1, [...]
16767 158 39_Re: What Does DB2 Reorg pass to DFSORT?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 7 Dec 2000 06:19:29 -0000308_iso-8859-7 Lyon
I have come to this discussion late, for that my applogies.
About two years ago I went through the exact same pains as you. Where did I get - nowhere. I use a subset of parms on reorg now with dynamic sort and they seem to work for our show and we are heavy VARCHAR users. [...]
16926 197 38_Re: Basic SQL statement with timestamp16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Wed, 6 Dec 2000 23:36:50 -0500363_iso-8859-1 Hi John, It really helped me. I just could not visualize some situations. Thanks a lot for the informations and corrections.I am also agreed with Mike that the access path could be different and co-related query, i could only take correctly if i recall the RDBMS book of C.J.Date. Mathematical explaination is always better from my point of view. [...]
17124 82 34_Re: DB2 v7.1 for NT internal error19_Margaritis Dimitris20_margardi@NOVABANK.GR30_Thu, 7 Dec 2000 09:50:49 +0200456_iso-8859-1 Hi, Thanks for your answer. Yes in this database the I change the log size. What is the appropiate function in order to solve this problem. Do you need that I have to initialize the replication with a cold start of capture?
Regards Dimitris
-----Original Message----- From: Bruce Allen [mailto:ballen@SPOTON.COM] Sent: Thursday, December 07, 2000 1:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2 v7.1 for NT internal error [...]
17207 102 26_Re: Varchar vs compression15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Thu, 7 Dec 2000 10:27:15 +0100444_iso-8859-1 James,
James, I recalled it from (maybe bad) memory. As I remember I heard this some years ago at an IBM Tech Conference. An IBM employee told it to me and at that time it sounded right to me. It's a valid argument for compression strategics not using VARCHAR. As I remember your assertion does count for CHAR but not for VARCHAR. Maybe an IBM-er out there could tell us what really happens with VARCHAR and compression. [...]
17310 28 34_IBM DB2 Database UTILITY Questions0_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 7 Dec 2000 09:33:37 +0000375_us-ascii Hi,
I have two questions on the IBM DB2 OS/390 Utilities which are puzzling us at the moment. The reason behind the questions are because we are benchmarking the IBM utilities against another vendors products. We have been running ISV products in our shop for as long as I can remember so our experience in running the IBM utilities is somewhat limited. [...]
17339 68 38_Re: IBM DB2 Database UTILITY Questions15_Lankester, Andy22_Andy_Lankester@BMC.COM30_Wed, 6 Dec 2000 21:21:58 -0600487_iso-8859-1 Paul,
a) because it has to do locking since it is going through the buffer pools. ISV products read the disk directly b) AFAIK because what concurrent copy does is a DFDSS dump/restore which I think causes the consolidation
Incidentally beware doing concurrent copy of large numbers of spaces - it produces one humungous output file and if you subsequently need to do a recover of a single space it may have to read large amounts of data to do the restore. [...]
17408 18 38_Re: IBM DB2 Database UTILITY Questions0_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 7 Dec 2000 11:28:17 +0000347_us-ascii Andy,
Thank you very much for your response.
Regards, Paul Packham The Post Office
================================================ 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.
17427 197 38_Re: Basic SQL statement with timestamp10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Thu, 7 Dec 2000 06:44:41 -0600355_- Hello Mike,
Your two queries are functionally identical. The only difference between them is that your first query is using labels. A label is used to qualify a column name in a query in order to resolve an ambiguous references (please do not confuse this use of the word 'label' with 'column labels', which are a different thing entirely). [...]
17625 54 16_Re: Value Clause0_24_db46@DAIMLERCHRYSLER.COM30_Thu, 7 Dec 2000 07:49:04 -0500717_us-ascii You might try the CASE statemetn
CASE WHEN D_END_DATE IS NULL THEN ' ' ELSE CHAR (D_END_DATE) END
Dean
David Nance @RYCI.COM> on 12/06/2000 05:10:58 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Value Clause
Does anyone know how to get spaces or rather a character string back when a column is a date? example: VALUE(D_END_DATE, ' ') I have tried a few variations on the above theme. The field is normally null. I would like to be able to have the sql insert a character [...]
17680 50 16_Re: Value Clause0_24_db46@DAIMLERCHRYSLER.COM30_Thu, 7 Dec 2000 07:50:47 -0500703_us-ascii You might also try VALUE (CHAR (D_END_DATE), ' ')
Dean
David Nance @RYCI.COM> on 12/06/2000 05:10:58 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Value Clause
Does anyone know how to get spaces or rather a character string back when a column is a date? example: VALUE(D_END_DATE, ' ') I have tried a few variations on the above theme. The field is normally null. I would like to be able to have the sql insert a character string. The only way I have been able to [...]
17731 44 65_Offtopic Mail - Related to Performance of applications using VSAM16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Thu, 7 Dec 2000 10:35:13 +0530522_- Hi All, First of all sorry to post the offtopic mail to the list and this is regarding the problem of one of our client's applications cycle which are using VSAM as the data storage. There are approx. 30 programs (Online -CICS) executed in one cycle and we are finding that at some point of time the application is having very high response time contributed to the whole cycle.We got some clue that it is because of the heavy I/O on the VSAM, i have no idea how VSAM access is from the I/O point of view as i found [...]
17776 63 23_Re: Replication - CLOBs16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Thu, 7 Dec 2000 08:07:18 -0500427_- Few restrictions and requirements for replicating the large objects : 1) Capture program will detect the change in large objects data when the table is defined with DATA CAPTURE CHANGES, 2)Target table should be read only. 3) Before images are not supported as it does the direct copying, 4)The primary key for the source table and the subscription-set definition must match. 5) DB2 connect 5.2 or later should be used. [...]
17840 30 69_Re: Offtopic Mail - Related to Performance of applications using VSAM13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Thu, 7 Dec 2000 08:11:45 -0500346_iso-8859-1 Hello Sanjeev, I believe Strobe from Compuware would help you pinpoint that kind of performance problem pretty readily.
I believe Mainview from BMC would help you track that down from a different perspective. Candle's Omegamon CICS or MVS might do the trick also. I know CA has monitors but I have no experience with them. [...]
17871 122 45_Re: Calling the DB2 LOAD utility via DSNUTILS11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Thu, 7 Dec 2000 08:18:48 -0500300_iso-8859-1 It was not mentioned so I will ask, Is this a WLM stored procedure environment ? This is a requirement for DSNUTILS. You may also want to review the link edit for dsnutils (v5=DSNTIJSP). Also check that a correct row is in SYSPROCEDURES (this was put in by V5 catmaint job DSNTIJUT). [...]
17994 31 69_Re: Offtopic Mail - Related to Performance of applications using VSAM10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 7 Dec 2000 14:42:14 +0100498_us-ascii Hi Sanjeev.
I used STROBE to monitor DL/I & VSAM files some years ago, it was quite good.
Regards
Max Scarpa
PS Take a look at:
http://www.share.org/proceedings/sh95/share00s.htm
There are some presentation covering VSAM. I think I've some small articles about VSAM/CICS performance, if needed let me know.
PPS Check if DASD features (DFW, cache RD/FW etc are enabled, if there is enough cache, if there are enough buffer....) [...]
18026 68 16_Re: Value Clause11_David Nance16_DWNance@FHSC.COM30_Thu, 7 Dec 2000 08:41:41 -0500459_US-ASCII Sanjeev,Dean, Barbara, Thanks for the help. Your suggestions worked, I kept trying to put the char function in the wrong place within the query. Thanks again.
Dave Nance First Health Services, Corp. (804)527-6841
>>> db46@DAIMLERCHRYSLER.COM 12/07/00 07:50AM >>> You might also try VALUE (CHAR (D_END_DATE), ' ')
Dean
David Nance @RYCI.COM> on 12/06/2000 05:10:58 PM [...]
18095 73 69_Re: Offtopic Mail - Related to Performance of applications using VSAM11_David Nance16_DWNance@FHSC.COM30_Thu, 7 Dec 2000 08:43:47 -0500612_US-ASCII Sanjeev, Strobe is a pretty good product. Its main usage would be for batch processes, but can be used for online processes as well.
Dave Nance First Health Services, Corp. (804)527-6841
>>> SSanjeev@CAL.CTS-CORP.COM 12/07/00 12:05AM >>> Hi All, First of all sorry to post the offtopic mail to the list and this is regarding the problem of one of our client's applications cycle which are using VSAM as the data storage. There are approx. 30 programs (Online -CICS) executed in one cycle and we are finding that at some point of time the application is having very high response time [...]
18169 141 29_Re: AIX Memory per Connection15_Jackson Reavill18_damcon2@US.IBM.COM30_Thu, 7 Dec 2000 09:01:27 -0500372_us-ascii Hi all,
Along the same lines... Is there a base amount of memory that is known to be used by any given DB2 connection to an AIX box? Where anything such as functions, triggers, etc. would be in addition to this base amount. This would at least allow someone to be able to calculate a minimum amount of memory needed for a given number of connections. [...]
18311 42 35_Strange Deadlock Warning & DSNT375I32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR30_Thu, 7 Dec 2000 16:14:12 +0200634_- Hello List,
I have the following DSNT375I. As you see in the second part of the message, PLAN, CORR. ID, CONN. ID and LUW ID are all *. Do you have any comments for that?
DSNT375I +PDD1 PLAN=OPGCO WITH 262 CORRELATION-ID=POOLWI080005 CONNECTION-ID=PBA3CICS LUW-ID=NETB.DDFPDD1.B50D2B77530C=28456 THREAD-INFO=PBA3CICS:*:*:* IS DEADLOCKED WITH PLAN=* WITH CORRELATION-ID=* CONNECTION-ID=* LUW-ID=* THREAD-INFO=*:*:*:* ON MEMBER PDD1 . DSNT501I +PDD1 DSNILMCL RESOURCE UNAVAILABLE 263 CORRELATION-ID=POOLWI080005 CONNECTION-ID=PBA3CICS LUW-ID=* REASON 00C90088 TYPE 00000302 NAME DPGMK01 .SMKPFONS.X'000003' [...]
18354 100 17_Re: CURRENT SQLID13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Thu, 7 Dec 2000 08:10:52 -0600586_- Be careful when you do this if your client is using multiple client server applications. This is a global variable and sets it to this secondary authid for ALL applications using this data source.
On Wed, 6 Dec 2000 08:45:25 +1200, Rob Wright wrote:
>I'm using the V7 client, but I think the V6 client has the same simple way to do >this ..... :-) > > Go to client configuration assistant > Choose the ODBC driver you want to reference the report writer tables from > Select the PROPERTIES option > You should get a screen with DATABASE [...]
18455 138 26_Re: Varchar vs compression14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Thu, 7 Dec 2000 08:24:31 -0600375_iso-8859-1 Jaap,
According to all documentation I have, on the compression algorithm used by IBM, there is no concept of VARCHAR expansion prior to compression. What I think you are refering to is when a VARCHAR is selected from a compressed row in certain situations, it gets expanded to full length in the thread work area depending on how the column was used. [...]
18594 35 16_DB2 setup on AIX10_Adrian Roe25_adrian.roe@TELEWEST.CO.UK30_Thu, 7 Dec 2000 14:21:26 -0000403_iso-8859-1 Hi All,
Would anyone be able to help with suggested standards for installing DB2 V7 on AIX ie. any good URL's to look at for standards documents, suggested disk layouts/file system setup, O/S config, modifications to the out of the box config, pitfalls to avoid and so on.
We are primarily a SQL Server and Oracle shop and are new to DB2 so our knowledge is a bit sketchy. [...]
18630 132 45_Re: Calling the DB2 LOAD utility via DSNUTILS8_Kurian B23_Bejoy_Kurian@MAY-CO.COM30_Thu, 7 Dec 2000 08:31:07 -0600443_us-ascii Are you running Store procedure address space under WLM? To run DSNUTILS you need wlm managed address space. I hope the load libs need to be authorized. Thanks
From: "Pendlebury-Bowe, Leslie" @RYCI.COM> on 12/07/2000 12:09 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
18763 79 23_Varchar Column Question12_Bruce Fuller17_BFuller@EBSCO.COM30_Thu, 7 Dec 2000 08:26:30 -0600395_- Esteemed List:
I have a question concerning a varchar column. Below you will find a restart table that has been created at our shop. We (tech support) have a few problems with the table, the main problem we see is in the varchar column. As all of you know a restart table should only have one row per page. You can either do that with columns or with the use of row level locking. [...]
18843 65 12_Online Reorg10_Alan Smith25_alancsmith@BTINTERNET.COM30_Mon, 4 Dec 2000 19:59:22 +0000384_US-ASCII I'm not sure how you can find the culprit in this particular case (SMF?), but there are I think a few other things to consider:
A job will hold locks across a commit if it is using a cursor declared WITH HOLD.
I think tablespace-level locks are held across a commit if the plan/package is bound with RELEASE(DEALLOCATE) - reusable threads may be an issue. [...]
18909 115 27_Re: Varchar Column Question12_Bob LaCerais28_Bob_LaCerais@TAX.STATE.NY.US30_Thu, 7 Dec 2000 09:45:51 -0500414_us-ascii We're also a DB2 for OS/390 Version 5 shop.
We enforce one row per page by specifying 'MAXROWS 1' in the CREATE TABLESPACE statement.
Bruce Fuller cc: Sent by: DB2 Subject: Varchar Column Question Data Base Discussion List
12/07/00 09:26 AM Please respond to DB2 Data Base Discussion List [...]
19025 77 16_Re: Online Reorg16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 7 Dec 2000 09:41:49 -0500597_iso-8859-1 John,
We have had a similar situation. When we added the PARM STATSLVL(SUBPROCESS) to the EXEC statement, we found that the time in the subprocess INTERVAL = DRAIN WRITERS was high. It together with the last log apply and the SWITCH was exceeding IRLMRWT.
To find the culprit, we created a job which did a -DISPLAY DATABASE(dbname) SPACE(whatever) CLAIMERS and had the scheduler run it once a minute during the reorg window. To simplify making sense of the output we directed all the output to a DISP=MOD dataset and preceded each -DISPLAY with a TIME (TSO command). [...]
19103 100 27_Re: Varchar Column Question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 7 Dec 2000 09:50:21 -0500669_iso-8859-1 Why one row per page? Does some task which uses this table have deficient COMMIT logic?
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Bruce Fuller [mailto:BFuller@EBSCO.COM] Sent: Thursday, December 07, 2000 9:27 AM To: DB2-L@RYCI.COM Subject: Varchar Column Question
Esteemed List:
I have a question concerning a varchar column. Below you will find a restart table that has been created at our shop. We (tech support) have a few problems with the table, the main problem we see is in the varchar column. As all of you know a restart table should only have one row per [...]
19204 23 69_Re: Offtopic Mail - Related to Performance of applications using VSAM13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM30_Thu, 7 Dec 2000 09:06:35 -0600554_us-ascii Sanjeev -
Landmark markets The Monitor for CICS (TMON) and also has TMON for DB2, MVS, and MQ Series as well. We use TMONCICS and TMONDB2 in a heavy CICS-VSAM shop and are satisfied with its abilities. You can trial/buy each piece separately and add on as needed.
HTH,
Kathy
================================================ 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.
19228 24 39_recovering data from the DB2 VSAM files18_Sripathi Dantuluri18_sripathi@INAME.COM30_Thu, 7 Dec 2000 08:56:05 -0600320_- Hi,
I did a platinum load replace with resume no. I didn't specified space-defn parameter. The reloaded data row count is lower than the old data recount. Before the load, the table is storing data in four vsam files. The load utilised only the first 2 files, but the remaining 2 files are still existing. [...]
19253 78 20_Re: DB2 setup on AIX15_Stacey L Waters23_waterss1@NATIONWIDE.COM30_Thu, 7 Dec 2000 09:18:32 -0600482_us-ascii I would suggest reading the UDB Quick Beginnings for UNIX book...it is pretty good. Another book that helped me when I was getting started with UDB was A Complete Guide to DB2 Universal Database by Don Chamberlin.
The install is pretty good. The one item I usually change after install is the size of the IBMDEFAULTBP buffer pool. The one thing that you will want to remember is that you start and stop an instance in UDB and a database resides in an instance. [...]
19332 25 27_DB2 V7.1 18 char Limitation17_Rabindra Senapati21_rsenapati@HOTMAIL.COM30_Thu, 7 Dec 2000 09:21:12 -0600308_- Hello Group,
I could found DB2 UDB NT V7.1 also has the limitation of 18 Characters in Primary and Foreign Key names of course may be Unique Index names. Here we over come table name and column name limitations but holds good for other objects too. If there is any solution please let me know. [...]
19358 38 31_Re: DB2 V7.1 18 char Limitation14_Scott Trometer22_scott.trometer@RCI.COM30_Thu, 7 Dec 2000 10:25:51 -0500513_iso-8859-1 -----Original Message----- From: Rabindra Senapati [mailto:rsenapati@HOTMAIL.COM] Sent: Thursday, December 07, 2000 10:21 AM To: DB2-L@RYCI.COM Subject: DB2 V7.1 18 char Limitation
Hello Group,
I could found DB2 UDB NT V7.1 also has the limitation of 18 Characters in Primary and Foreign Key names of course may be Unique Index names. Here we over come table name and column name limitations but holds good for other objects too. If there is any solution please let me know. [...]
19397 109 43_Re: recovering data from the DB2 VSAM files15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 7 Dec 2000 09:27:57 -0600346_iso-8859-1 Check out DFSMS/MVS V1R5 Using Data Sets SC26-4922-04.
I have never seen this done but here is some information that might be of help.
2.1.2.3 Linear Data Sets © Copyright IBM Corp. 1979, 1999 Topic lines 1 to 14 of 14
A linear data set is a VSAM data set with a control interval size of 4096 [...]
19507 94 27_Re: Varchar Column Question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 7 Dec 2000 10:29:38 -0500593_us-ascii Are you on data-sharing? If not, then row-level locking may save you I/O as well as lock contentions. Don't totally eliminate this option.
> -----Original Message----- > From: Bruce Fuller [SMTP:BFuller@EBSCO.COM] > Sent: Thursday, December 07, 2000 9:27 AM > To: DB2-L@RYCI.COM > Subject: Varchar Column Question > > Esteemed List: > > I have a question concerning a varchar column. Below you will find > a restart table that has been created at our shop. We (tech support) > have a few problems with the table, the main problem we see is in the > varchar column. As all [...]
19602 24 26_non-corr-subquery and join15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Thu, 7 Dec 2000 09:48:27 -0600466_- Hi listers
I have the following SQL:
SELECT some columns FROM INTB0096 WHERE predicates AND SAM_BEL_ID IN (SELECT SAM_BEL_ID FROM INTB0095 WHERE predicates)
The optimizer decides to do a nested loop join with INTB0096 as outer and INTB0095 as inner. Now the predicates for INTB0096 are so bad, that it would be better to do first the IN-subselect and with this list access INTB0096. How can I afford that. Any hints are very appreciated. [...]
19627 59 65_Offtopic Mail - Related to Performance of applications using VSAM14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Thu, 7 Dec 2000 10:55:41 -0500614_ISO-8859-1 Try the basics... poor dataset placement. An RMF report looking at only your DB2 volumes during the period when you are having he performance problem, should show you where the problems are.... then determine which datasets are on that (or those) volumes. Regards, Joel
Message text written by DB2 Data Base Discussion List > First of all sorry to post the offtopic mail to the list and this is regarding the problem of one of our client's applications cycle which are using VSAM as the data storage. There are approx. 30 programs (Online -CICS) executed in one cycle and we [...]
19687 78 31_Re: DB2 V7.1 18 char Limitation14_Scott Trometer22_scott.trometer@RCI.COM30_Thu, 7 Dec 2000 10:56:57 -0500407_iso-8859-1 Being an MFer (mainframer), I'm not sure what reason would constitute a 'real' need for long object names.
Databases - Can't think of any that can't be addressed in eight Tablespaces - Nope. Tables - Can't think of any that can't be addressed in eight, let alone 18. Indexes - Same, especially so (DB2 index commands only allow 8 anyway) Columns - OK, but that's why 18 are available [...]
19766 49 43_Re: recovering data from the DB2 VSAM files15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 7 Dec 2000 10:00:06 -0600330_iso-8859-1 First, I would do a listcat on the data set of interest to see if the load reset the VSAM high-used RBA. If it did, I'm afraid you will have a tough time getting the data back. Is there an image copy prior to the load replace ?
If you do a DSN1PRT of the fourth data set, do you see your data still there ? [...]
19816 88 35_Strange Deadlock Warning & DSNT375I12_Susan Lawson22_lawson_susan@YAHOO.COM30_Thu, 7 Dec 2000 08:17:50 -0800638_us-ascii Cuneyt,
Are you V6? We have recently ran into a simliar problem with Version 6 that produced a very similar error message. It is a known bug and can be fixed with PQ37572/UQ44218.
Your problem looks/sounds similar - I hope this helps.
Regards, Susan Lawson www.ylassoc.com
> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@RYCI.COM]On Behalf Of > Cuneyt Goksu (Garanti Teknoloji) > Sent: Thursday, December 07, 2000 8:14 AM > To: DB2-L@RYCI.COM > Subject: Strange Deadlock Warning & DSNT375I > > > Hello List, > > I have the following DSNT375I. As you see in the [...]
19905 60 49_How to cancel jobs submitted thru Control Center?13_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Thu, 7 Dec 2000 11:06:05 -0500517_iso-8859-1 Hi, On UDB 6.1 NT, I have had some jobs(scripts) submitted thru the Script Center on a client hang up on the server. I was able to walk over to the server and run the jobs manually ok, but the jobs still show up in the Journal as running jobs. I forced the associated connection with these jobs ok, but the jobs still show up as running. Any ideas on how to get the jobs out of the system, back door methods or whatever? DB2 is in use so I don't want to shut DB2 down unless absolutely necessary. The [...]
19966 56 30_Re: non-corr-subquery and join20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 7 Dec 2000 11:14:05 -0500338_us-ascii There are certain rules when DB2 converts a non-correlated subquery into a join. Most often that is a good access path but if you like to disable it you could code your query as follows and be sure that DB2 will not convert it to join. But you should double check by running the SQL both ways to make sure, which is better. [...]
20023 17 27_Re: Reccommendations needed11_Jeff Kalman15_jkalman@CSC.COM30_Thu, 7 Dec 2000 11:30:18 -0500396_us-ascii Hi all, I would like some reccommendations on a good book/reference for learning DB2 UDB version 7 on the MS Windows NT platform.
TIA Jeff
================================================ 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.
20041 15 43_Re: recovering data from the DB2 VSAM files18_Sripathi Dantuluri18_sripathi@INAME.COM30_Thu, 7 Dec 2000 10:39:04 -0600370_- The load didn't touched the fourth dataset at all. Can you please give me some details about DSN1PRT.
Thanks, Sripathi.
================================================ 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.
20057 13 24_GA date for V7 on OS/3900_22_Rohn.Solecki@MTS.MB.CA30_Thu, 7 Dec 2000 10:45:49 -0600360_us-ascii What is the general acceptance date for V7 on OS/390. Last I heard it was supposed to be sometime around now.
================================================ 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.
20071 28 122_IFI (instrumentation facility interface) returns an error -- usin g NT Version 7 control center accessing DB2 V6 on OS/39012_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Thu, 7 Dec 2000 10:48:51 -0600635_iso-8859-1 Using the Control Center to access data on the mainframe works great except for displaying the bufferpools and threads, it returns the following error: IFI Command Execution failed: IFI Return code:0. IFI Reason code: 0 IFI excess bytes: 0
I have the following traces running on the mainframe DSNW127I % CURRENT TRACE ACTIVITY IS -, TNO TYPE CLASS DEST QUAL, 01 GLOBAL 01,02,03 RES NO, 02 STAT 01,03,04,05 SMF NO, 03 AUDIT 01,02,07 SMF NO, 04 ACCTG 01,02,03 SMF NO, *********END OF DISPLAY TRACE SUMMARY DATA*********, DSN9022I % DSNWVCM1 '-DIS TRACE' NORMAL COMPLETION, Anyone experience this error or have any [...]
20100 22 9_Linux/3900_15_leon@CA.IBM.COM30_Thu, 7 Dec 2000 11:53:13 -0500354_us-ascii Given that there has been a fair bit of discussion about Linux/390 in this list in the last couple of days I thought it would be appropriate to post a link to this latest news story about a major victory for Linux/390 at Telia (Swedish telecom company). Here is the link http://www.zdnet.com/zdnn/stories/news/0%2C4586%2C2662146%2C00.html. [...]
20123 59 27_Re: Reccommendations needed14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 7 Dec 2000 16:43:28 -0000475_iso-8859-1 If you are already a DBA on another platform, the this link is just for you... http://www-4.ibm.com/software/data/db2/selfstudy/
Regards, Marcus
-----Original Message----- From: Jeff Kalman [mailto:jkalman@CSC.COM] Sent: 07 December 2000 16:30 To: DB2-L@RYCI.COM Subject: Re: Reccommendations needed
Hi all, I would like some reccommendations on a good book/reference for learning DB2 UDB version 7 on the MS Windows NT platform. [...]
20183 107 39_FW: Strange Deadlock Warning & DSNT375I32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR30_Thu, 7 Dec 2000 19:05:09 +0200543_- We are V5.
Cuneyt GOKSU Garanti Teknoloji Tel : 0090-212-4783210 mailto:Cuneytg@garanti.com.tr Visit : http://www.kultur.gov.tr
-----Original Message----- From: Susan Lawson [mailto:lawson_susan@YAHOO.COM] Sent: Thursday, December 07, 2000 6:18 PM To: DB2-L@RYCI.COM Subject: Strange Deadlock Warning & DSNT375I
Cuneyt,
Are you V6? We have recently ran into a simliar problem with Version 6 that produced a very similar error message. It is a known bug and can be fixed with PQ37572/UQ44218. [...]
20291 44 27_Re: Reccommendations needed22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM30_Thu, 7 Dec 2000 12:07:35 -0500481_iso-8859-1 DB2 Universal Database V7.1 for UNIX, Linux, Windows and OS/2 DBA Certification by Baklarz and Wong
Prentice Hall: ISBN: 0-13-091366-9 IBM Order Number: SC09-4255-00
Mike Piontkowski TP&S Technical Maintenance Voice: +1 302.886.4612 Fax: +1 302.886.4749
-----Original Message----- From: Jeff Kalman [mailto:jkalman@CSC.COM] Sent: Thursday, December 07, 2000 11:30 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Reccommendations needed [...]
20336 52 38_Re: IBM DB2 Database UTILITY Questions13_Zessin, Peter25_Peter.Zessin@ATCOITEK.COM30_Thu, 7 Dec 2000 10:08:09 -0700628_- a) appears to be a bug introduced with V6. We noticed this as well and received a fix from IBM which corrects the performance; With the fix, the shareleve change copy consumes the same amount of CPU as a sharlevel reference copy.
Regards, Peter Zessin
> -----Original Message----- > From: paul.packham@POSTOFFICE.CO.UK [SMTP:paul.packham@POSTOFFICE.CO.UK] > Sent: 07 December, 2000 2:34 AM > To: DB2-L@RYCI.COM > Subject: IBM DB2 Database UTILITY Questions > > Hi, > > I have two questions on the IBM DB2 OS/390 Utilities which are puzzling us > at > the moment. The reason behind the questions are because [...]
20389 52 38_Re: IBM DB2 Database UTILITY Questions15_Hernandez, Hugo22_Hugo_Hernandez@BMC.COM30_Thu, 7 Dec 2000 11:24:01 -0600708_iso-8859-1 Paul:
My opinion is :
a) DB2 has to resolve more locking. b) The consolidation maybe is caused by a DFDSS dump/restore
-----Original Message----- From: paul.packham@POSTOFFICE.CO.UK [mailto:paul.packham@POSTOFFICE.CO.UK] Sent: Thursday, December 07, 2000 3:34 AM To: DB2-L@RYCI.COM Subject: IBM DB2 Database UTILITY Questions
Hi,
I have two questions on the IBM DB2 OS/390 Utilities which are puzzling us at the moment. The reason behind the questions are because we are benchmarking the IBM utilities against another vendors products. We have been running ISV products in our shop for as long as I can remember so our experience in running the IBM [...]
20442 13 26_Re: Varchar vs compression9_Jim Ruddy18_jaruddy@US.IBM.COM30_Thu, 7 Dec 2000 11:32:25 -0600344_- VARCHAR columns are NOT expanded before the row is compressed.
Jim Ruddy IBM DB2 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.
20456 154 15_Re: DB2 Connect0_15_leon@CA.IBM.COM30_Thu, 7 Dec 2000 12:46:31 -0500350_us-ascii >My question is if this run time client can communicate with DB2 Connect EE on an NT box >why can't it communicate with an address space on OS/390 ? Now this address >space can be the application requester for the DB2 application server. Or >maybe being in the same OS image it won't need to use DDF and create allied >threads instead. [...]
20611 52 23_Mad MAX goes again ....12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Dec 2000 19:49:10 +0200327_windows-1255 Hi, If we are at it, take a look at the following query :
SELECT A.K_NUMBER FROM MyTable A WHERE A.K_NUMBER = (SELECT MAX(B.K_NUMBER) FROM MyTable B WHERE A.YEAR=B.YEAR) GROUP BY A.K_NUMBER ;
On a big table (with indexes) it takes on 9672-R45 : 3 MIN 51.43 SEC CPU time
A small twist to: [...]
20664 38 11_AVG broken?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 7 Dec 2000 12:48:08 -0500669_iso-8859-1 We received SQLCODE -802 on statement: SELECT CAR_AAR_CODE, MAX(TARE_WEIGHT), AVG(TARE_WEIGHT), COUNT(*) FROM DCMITMS.TCARFILE WHERE TARE_WEIGHT> 0 AND CAR_AAR_CODE = 'C113' GROUP BY CAR_AAR_CODE; resulting in: DSNT408I SQLCODE = -802, ERROR: EXCEPTION ERROR FIXED POINT OVERFLOW HAS OCCURRED DURING ADDITION OPERATION ON INTEGER DATA, POSITION The MAX for rows specifying this predicate is 146000 and the number of qualifying rows is 39194. I would understand the -802 on a SUM since the SUM would truly be larger than 2,147,483,648 (TARE_WEIGHT is an INTEGER). However, it makes no sense for AVG. The true AVG is about 100,000. This is well below the [...]
20703 168 69_Re: Offtopic Mail - Related to Performance of applications using VSAM15_Hernandez, Hugo22_Hugo_Hernandez@BMC.COM30_Thu, 7 Dec 2000 11:52:35 -0600581_iso-8859-1 Hello Sanjeev,
I hope this is valid because is made through the list.
There are some application monitors in the market that can help you. The one that I know is called InTune and as you asked is a multipurpose application monitor that can give to you information related to DB2, CICS, VSAM, sequential files, MVS delays, ADABAS, NATURAL. Is a very simple to use product that tells you quickly where do you have an opportunity to reduce delays, waits. It tells you how many times you use an SQL, a VSAM file, a sequential file, and the most important [...]
20872 71 15_Re: AVG broken?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 7 Dec 2000 12:02:27 -0600389_iso-8859-1 Hi, Eric,
I ran into a problem using AVG a while ago. I don't remember what the exact error was but I seem to remember to remember that it had to do with overflow. Here is the remedy that I used.
SELECT AVG (DECIMAL(FLOAT(COLA))) FROM TABA
Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin [...]
20944 238 31_Re: Date fields defined as NULL12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Thu, 7 Dec 2000 13:08:52 -0500381_iso-8859-1 Ulrich, Yes, I'm using ASC for the load. ... and your assumption is the same one I had when I was initially confronted with this situation. I've tried it again.. set the nullindchar=? and it just won't load... this is the error when '? ' is in a nullable date field: SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007 [...]
21183 22 25_DB2 Connect Compatibility14_David Beaudoin27_beaudoin@FIRSTINVESTORS.COM30_Thu, 7 Dec 2000 13:07:03 -0500470_iso-8859-1 Is it possible (advisable?) to install DB2 Connect (Enterprise) Version 7.1 on a server currently running UDB 6.1 EE? Or does DB2 Connect Version 6.1 have to be installed with UDB 6.1?
I have been hearing conflicting opinions that it is OK to do this, as Connect and UDB are completely separate installs, and also that this is *NOT* OK, because Connect uses some of the UDB code base, if UDB is installed, so the release numbers must be the same. [...]
21206 84 15_Re: AVG broken?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 7 Dec 2000 12:16:27 -0600480_iso-8859-1 ".... seem to remember to remember that..."
Ooooops! I stuttered.
Linda
-----Original Message----- From: Billings, Linda Sent: Thursday, December 07, 2000 12:02 PM To: 'DB2 Data Base Discussion List' Subject: RE: AVG broken?
Hi, Eric,
I ran into a problem using AVG a while ago. I don't remember what the exact error was but I seem to remember to remember that it had to do with overflow. Here is the remedy that I used. [...]
21291 15 24_Read this article on Db214_subrata mondal25_subratamondal@HOTMAIL.COM30_Thu, 7 Dec 2000 18:16:54 -0000
21307 50 26_Re: Varchar vs compression12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Dec 2000 20:35:37 +0200547_windows-1255 Hi, I guess that the confusion is due to VARCHAR being expanded when used in an index. Combine that with the DSNZPARM parameter RETVLCFK (Return Variable Length Char From Key) to get a fully obscured... ;)) RETVLCFK=YES ==> you get the VC field from index but the length is the maximum length and not the actual one. You than use it in the program and if you forget to calculate the new length before updating it you'll get it at max length in the data as well. RETVLCFK=NO ==> you get the VC field from the data with the actual [...]
21358 111 38_Re: Basic SQL statement with timestamp12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Dec 2000 20:39:01 +0200580_iso-8859-1 Hi, Both are non-correlated. In order for a query to be correlated you need a reference from the outer into the inner. Take a look at the example I've sent few minutes ago under "Mad MAX goes again"
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Mike Wiles" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, December 07, 2000 12:38 AM Subject: Re: Basic SQL statement with timestamp [...]
21470 95 15_Re: AVG broken?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 7 Dec 2000 13:35:24 -0500616_iso-8859-1 Linda, THANKS!!!
I have opened an ETR with IBM to determine whether this (undocumented) extra step really should be reuired.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Thursday, December 07, 2000 1:02 PM To: DB2-L@RYCI.COM Subject: Re: AVG broken?
Hi, Eric,
I ran into a problem using AVG a while ago. I don't remember what the exact error was but I seem to remember to remember that it had to do with overflow. Here is the remedy that I used. [...]
21566 187 22_Re: Global Temp Tables12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Dec 2000 20:43:11 +0200490_iso-8859-1 Hi, Nearly forgot - you can do a "mass delete" on DTT (e.g. "delete from table" - however no "where" clause is allowed.).
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Lorenz, Don" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, December 06, 2000 10:02 PM Subject: Re: Global Temp Tables [...]
21754 192 39_Re: What Does DB2 Reorg pass to DFSORT?12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Dec 2000 20:45:41 +0200531_iso-8859-7 Hi, We needed up using a REXX to generate the OLR jobs and add sortwork cards with the correct (more or less) size .
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Pendlebury-Bowe, Leslie" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, December 07, 2000 8:19 AM Subject: Re: What Does DB2 Reorg pass to DFSORT? [...]
21947 14 35_Re: Excel to DB2 Connect for OS/39014_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM30_Thu, 7 Dec 2000 12:49:10 -0600396_iso-8859-1 I'm trying to use MS Excel to get a data on OS/390 via DB2 Connect. Has anyone done this? If so, how did you get it to work? I can't connect. -
================================================ 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.
21962 34 12_SQLCODE -87912_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Dec 2000 21:02:31 +0200325_windows-1255 Hi, I tried to create a new function on a new V6 and what usually works fine gives me the following reply -
SQLCODE = -879, ERROR: CREATE OR ALTER STATEMENT FOR USR1.TOCHAR1 CANNOT DEFINE A COLUMN, DISTINCT TYPE, FUNCTION OR STORED PROCEDURE PARAMETER AS MIXED OR GRAPHIC WITH ENCODING SCHEME EBCDIC [...]
21997 17 38_Change password prompt for DB2 Connect21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US30_Thu, 7 Dec 2000 14:03:00 -0500404_iso-8859-1 Hi all,
Is there any way to call the password change option in the Client Configuration Assistant from a client application, i.e. VB.
Jim
================================================ 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.
22015 48 35_Re: Excel to DB2 Connect for OS/39012_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 7 Dec 2000 21:07:18 +0200375_iso-8859-1 Hi, Assuming you have DB2 CONNECT installed and working properly. You choose "data > get external data > create new DB query" on that window on the bottom line you scroll to "ODBC()" and choose it, then on "open" you choose the DB2 ssid from the odbc list. After that you'll get a logon panel to your MF, give the userid and password of MF and there you are. [...]
22064 35 43_Re: recovering data from the DB2 VSAM files15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 7 Dec 2000 13:08:30 -0600517_iso-8859-1 Sripathi,
The use of DSN1PRNT is documented in the DB2 Utility Guide and Reference. I think you'll find much better information there than I could provide you.
Michael
-----Original Message----- From: Sripathi Dantuluri [mailto:sripathi@INAME.COM] Sent: Thursday, December 07, 2000 10:39 AM To: DB2-L@RYCI.COM Subject: Re: recovering data from the DB2 VSAM files
The load didn't touched the fourth dataset at all. Can you please give me some details about DSN1PRT. [...]
22100 173 15_Re: DB2 Connect13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Thu, 7 Dec 2000 13:11:22 -0600379_iso-8859-1 Leon,
I very much appreciate your input. Judging from the number of messages for this thread, it seems many others are being helped by your comments as well (and many myths may be dispelled)!
I have one more question for you: Does PE have the sysplex functionality (that supports WLM and datasharing) that EE does? I don't see any doc regarding it. [...]
22274 99 53_Re: How to cancel jobs submitted thru Control Center?0_22_BILL_GALLAGHER@PHL.COM30_Thu, 7 Dec 2000 13:56:55 -0500481_iso-8859-1 Jim,
We experienced similar problems some time ago on AIX. The problem, according to IBM, was that the Journal files were corrupted. The solution was to delete the Journal files and let the system recreate them when you reschedule the scripts. Unfortunately, I cannot find my notes on our particular incident, so I don't have the exact details of which files need to be deleted, although I think that the db2jobht.prf and db2jobsm.prf files were among them. [...]
22374 120 31_Re: Date fields defined as NULL0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 7 Dec 2000 13:28:53 -0600550_iso-8859-1 Sure, SQLCODE = -180 (ie SQL0180N) says that you are trying to insert something that DB2 does not recoginze as a date into a date field. As someone pointed out yesterday, Valid date range is 0001-01-01 to 9999-12-31 is described in SQLCode -181 in the Messages and Codes manual.
So for null fields, as Ulrich points out, set the null indicator to true, and do NOT insert "?" into the date value. If the null flag is set to true, then the value in the field is irrelevant, so try using one of the extreme ends of the valid date [...]
22495 56 69_Re: Offtopic Mail - Related to Performance of applications using VSAM10_Rob Wright17_rwright@LIC.CO.NZ30_Fri, 8 Dec 2000 08:39:51 +1200312_us-ascii Hi Sanjeev
Before you go out and buy a tool for monitoring your CICS, there are a few CICS statistics you could look at that will give you an indication of whether the problem is related to I/O or whether it is a CICS internal problem. The following items are related to internal CICS-VSAM: [...]
22552 35 28_SV: GA date for V7 on OS/39025_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE30_Thu, 7 Dec 2000 20:59:14 +0100658_iso-8859-1 Last thing I heard was end of first quarter 2001, that is March 31.
> -----Ursprungligt meddelande----- > Från: Rohn.Solecki@MTS.MB.CA [SMTP:Rohn.Solecki@MTS.MB.CA] > Skickat: den 7 december 2000 17:46 > Till: DB2-L@RYCI.COM > Ämne: GA date for V7 on OS/390 > > What is the general acceptance date for V7 on OS/390. Last I heard it was > supposed to be sometime around now. > > ================================================ > 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. [...]
22588 63 35_Re: Excel to DB2 Connect for OS/39014_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM30_Thu, 7 Dec 2000 14:12:01 -0600415_iso-8859-1 Thanks, My problem is that I have to put my UID and PASSWORD into the DB2CLI.INI dataset on my PC. I'm not happy about this because of obvious reasons. I don't get a logon panel. Anything else I should try?
-----Original Message----- From: Isaac Yassin [mailto:yassin@NETVISION.NET.IL] Sent: Thursday, December 07, 2000 1:07 PM To: DB2-L@RYCI.COM Subject: Re: Excel to DB2 Connect for OS/390 [...]
22652 51 29_Re: DB2 Connect Compatibility12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 7 Dec 2000 12:27:16 -0800567_us-ascii David, A) DB2 connect shares the code base with UDB so you cannot or should not install different versions and expect things to work correctly. B) Why do you need to install DB2 Connect? If you have UDB EE, you have the DB2 connect part already there. All you have to do is connect it up to whatever server you want. As the saying goes, been there and done that. --- David Beaudoin wrote: > Is it possible (advisable?) to install DB2 Connect > (Enterprise) > Version 7.1 on a server currently running UDB 6.1 > EE? Or does [...]
22704 54 46_Change password prompt for DB2 Connect (Reply)13_Scott Goodell22_scott.goodell@WCOM.COM30_Thu, 7 Dec 2000 14:49:50 -0600637_us-ascii Not sure exactly what you are looking for but you can change the password using the Call Level Interface (CLI) Connect call. I was able to get this to work using JAVA so I suspect VB would work as well, although I don't know anything about VB.
Scott
|--------+---------------------------> | | "Brown, James R. | | | - DIT" | | | | | | | | | 12/07/00 01:03 PM| | | Please respond to| | | DB2 Data Base | | | Discussion List | | | | |--------+---------------------------> >----------------------------------------------------------------------------| | | | To: [...]
22759 97 30_Re: DB2 Connect - Cancel Query10_STEVE HOWE15_showe@BCBSM.COM30_Thu, 7 Dec 2000 16:33:25 -0500548_iso-8859-1 We have two DB2 Connect EE Gateways in place. Both are on AIX (same version), both using DB2 Connect 5.2 Fix Pack 11 and both connecting to the same DB2 5.1 subsystems via SNA. The one difference between these 2 environments is one is using COMM Server 4 and the other is on COMM Server 5. Users use a number of front end products such as COGNOS, ACCESS. Users connect to one of these Servers via DNS entries that assign on a rotating basis. One problem our users are having is trying to cancel a query from their workstation. When [...]
22857 21 13_regarding LOB17_ravi kumar hassan18_ravibh@HOTMAIL.COM30_Thu, 7 Dec 2000 15:51:04 -0600400_- Hi Folks,
In our shop we installed DB2 V6 for OS/390. in that i am getting confused with LOB. can somebody explain me about this like where it can be used? how it can be used?? what is the use of LOB????
Thanks KUMAR _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com [...]
22879 77 39_Re: Strange Deadlock Warning & DSNT375I10_Rob Wright17_rwright@LIC.CO.NZ30_Fri, 8 Dec 2000 11:11:54 +1200478_us-ascii From the (V6) message description:
"....
An asterisk (*) can appear for PLANID2, ID5, ID6, ID7, and ID9 if the blocking request was released by the requester or was timed out between the detection of the deadlock and reporting the deadlock."
Rob
"Cuneyt Goksu (Garanti Teknoloji)" on 12/08/2000 02:14:12 AM
Please respond to DB2 Data Base Discussion List [...]
22957 27 34_strange db2look problem - V6.1 AIX14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Thu, 7 Dec 2000 17:21:37 -0500476_iso-8859-1 I have a database called DB2TEST and a few tables created by user DB2TEST in V6.1/AIX. I then execute the following:
db2look -d DB2TEST -u DB2TEST -e
This does not generate the ddl. I then add -x option to the end and now I get the GRANTs generated but again not the DDL. I have also tried using the -t option with a specific table name and get the same result. However in our V5.x boxes the command works fine and produces the ddls as expected. [...]
22985 79 12_XML extender23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 7 Dec 2000 17:14:46 -0500632_- Hello listers
We are interested in storing XML documents in DB2. We are already using LOBs. My question is:-
Are there any sites using XML extender support ? Does anyone have any idea when XML extender support would be available for DB2/OS390 ?
TIA
Sanjay Jain
> -----Original Message----- > From: STEVE HOWE [SMTP:showe@BCBSM.COM] > Sent: Thursday, December 07, 2000 4:33 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect - Cancel Query > > We have two DB2 Connect EE Gateways in place. Both are on AIX (same > version), both using DB2 Connect 5.2 Fix Pack 11 and [...]
23065 50 15_Re: AVG broken?14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 8 Dec 2000 09:30:48 +1100413_iso-8859-1 and what is AVG if not SUM(...)/COUNT(*)
Which is why the V6 SQL Reference says (about AVG) "The argument values must be of any built-in numeric data type, and their sum must be within the range of the data type of the result."
So, no, AVG is not broken.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...]
23116 96 16_Re: XML extender23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 7 Dec 2000 17:31:54 -0500579_- I found out-----> XML extender would be available in ver 7 of db2/os390. But I still want to know if some one is using it on UDB on smaller platform and what has been your experience ?
Sanjay Jain
> -----Original Message----- > From: Jain, Sanjay (Exchange) [SMTP:sanjayjain@BEAR.COM] > Sent: Thursday, December 07, 2000 5:15 PM > To: DB2-L@RYCI.COM > Subject: XML extender > > Hello listers > > We are interested in storing XML documents in DB2. We are already using > LOBs. My question is:- > > Are there any sites using XML extender support ? Does anyone [...]
23213 95 16_Re: XML extender13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Thu, 7 Dec 2000 16:41:38 -0600551_iso-8859-1 Hi,
XML Extenders is in V7.1 on the OS390 (and elsewhere).
I just finished a pilot on the NT UDB V7.1 environment, but found them to be too buggy at this stage to use in a real application. Support was a big issue as well.
Our pilot had about 2 tables and had to produce pretty standard/simple XML documents. We spent about 6 weeks or so before giving up. Since we did wanted to use them, our plan was to use UDB/NT until the OS390 environment was XMl extender enabled and then switch ... but that did not happen. [...]
23309 41 38_Re: strange db2look problem - V6.1 AIX13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 7 Dec 2000 16:46:36 -0600574_US-ASCII Hello Manas, Try db2look -d dbname -u tbcreator -e -p -o outputfilename -i userid -w password HTH Kurt >>> manas.dasgupta@PFSFHQ.COM 12/07/00 04:21PM >>> I have a database called DB2TEST and a few tables created by user DB2TEST in V6.1/AIX. I then execute the following:
db2look -d DB2TEST -u DB2TEST -e
This does not generate the ddl. I then add -x option to the end and now I get the GRANTs generated but again not the DDL. I have also tried using the -t option with a specific table name and get the same result. However in our V5.x boxes the [...]
23351 47 29_Re: DB2 Connect Compatibility0_15_leon@CA.IBM.COM30_Thu, 7 Dec 2000 17:50:43 -0500379_us-ascii While DB2 Connect and DB2 UDB database server are 2 separate products they are build from the source code that is shared between these 2 products. When you install DB2 Connect you place some of the same files on the disk as you would if you installed DB2 UDB. What this means is that if you have both products installed on a machine they must be at the same level. [...]
23399 136 13_Re: Linux/39012_Hylton Tom P20_Tom.P.Hylton@IRS.GOV30_Thu, 7 Dec 2000 17:52:12 -0500394_iso-8859-1 I don't think anyone is questioning IBM's commitment to L/390, rather I think the criticism is being solely brought into play on IBM's LACK of commitment for UnixSystemServices AKA USS AKA OpenEdition AKA ad nauseum. USS is a piece of OS390 that has been literally forced onto customer boxes by these same folks, going so far as to make it impossible to run OS/390 without USS. [...]
23536 34 19_DB2 OS/390 V4 to V614_Dale E. Miller15_dmiller@UGI.COM30_Thu, 7 Dec 2000 17:54:20 -0500572_us-ascii I am in the process of installing DB2 V6 on OS/390 (V2.8). We are bypassing V5, going from V4 to V6 directly using another subsystem. My question is this: Can I install the new V6 subsystem; define all the structures, install our 3rd party products, copy all the data from the V4 subsys to the V6 subsys and then do a 'rename' of the underlying datasets from the V6 subsystem back to the 'old' dataset names of the V4 subsystem? Or are their internal identifiers for subsystem names in the datasets themselves? (I seem to recall seeing something about this, [...]
23571 69 69_Re: Offtopic Mail - Related to Performance of applications using VSAM15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK30_Thu, 7 Dec 2000 23:00:12 -0000558_iso-8859-1 We had a similar problem one time which was due to the VSAM file being closed and re-opened many times during the program. Once this was sorted out (it was done in a buried subroutine) everything worked really well. I agree with the other guys though, it was Strobe that found it! HTH Keith ----- Original Message ----- From: "S, Sanjeev (CTS)" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, December 07, 2000 5:05 AM Subject: Offtopic Mail - Related to Performance of applications using VSAM [...]
23641 100 13_Re: IFCID 1980_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Thu, 7 Dec 2000 16:02:25 -0600521_us-ascii One thing that I have used to get an (indirect) idea about residency time is the IFCID 6 records instead of the IFCID 198 records. What I do is look at the time period between two reads of the same block (by looking at the IFCID 6 records that designate the same block). By looking at a sampling of these records during prime time, I can tell if my bufferpool(s) are too small (the rereads come very quickly) or possibly too big (there are no rereads or the rereads are very few and are many minutes apart. [...]
23742 20 34_Finding the fix pack level UDB/Sun14_Scott Saunders20_ssaunders@SIEBEL.COM30_Thu, 7 Dec 2000 15:34:42 -0800319_iso-8859-1 Good afternoon! What is the easiest way to determine what fix pack level is on a DB2 (V5.2) instance on a Sun Solaris server? I can run db2level and guess that the code release, "SQL05020", is db2 5.2. What does level identifier, "020A0103", or the informational tokens mean?
TIA, Scott Saunders [...]
23763 111 29_Re: AIX Memory per Connection11_Bruce Allen17_ballen@SPOTON.COM30_Fri, 8 Dec 2000 11:13:48 +1100345_- Hi Scott, I looked up the archives. Try svmon -G for a one line display: inuse-pers is persistent memory (file cache) and inuse-work for programs. I think you may need root access for svmon.
A book I found to be an excellent source of information on AIX performance tools was Accelerating AIX by Rudy Chukran (ISBN 0-201-63382-5). [...]
23875 100 34_Re: DB2 v7.1 for NT internal error11_Bruce Allen17_ballen@SPOTON.COM30_Fri, 8 Dec 2000 11:16:39 +1100573_- Hi, We did a cold start as the database was small. Sorry.
Regards, Bruce Allen
> -----Original Message----- > From: Margaritis Dimitris [SMTP:margardi@NOVABANK.GR] > Sent: Thursday, 7 December 2000 18:51 > To: DB2-L@RYCI.COM > Subject: Re: DB2 v7.1 for NT internal error > > Hi, > Thanks for your answer. > Yes in this database the I change the log size. > What is the appropiate function in order to solve this problem. > Do you need that I have to initialize the replication with a cold start > of capture? > > Regards > Dimitris > > > -----Original [...]
23976 141 29_Re: AIX Memory per Connection11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Fri, 8 Dec 2000 11:10:20 +1100588_- Jay,
we have found that DB2 uses around 2.3 MB per connection in our AIX environment (no triggers, no functions, etc).
Cheers, Ulrich
> -----Original Message----- > From: Jackson Reavill [SMTP:damcon2@US.IBM.COM] > Sent: Friday, December 08, 2000 1:01 AM > To: DB2-L@RYCI.COM > Subject: Re: AIX Memory per Connection > > Hi all, > > Along the same lines... Is there a base amount of memory that is known to > be used by any given DB2 connection to an AIX box? Where anything such as > functions, triggers, etc. would be in addition to this base amount. This > [...]
24118 94 17_Re: regarding LOB14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 8 Dec 2000 11:48:47 +1100307_iso-8859-1 Kumar,
A LOB is a column that can be longer than the normal maximum length of a column - up to 2 Gb in size. It can be manipulated (by INSERT, SELECT and UPDATE) just like any other column - although the host variables used need to be correctly defined (see Appl Prog and SQL Guide). [...]
24213 84 43_Re: recovering data from the DB2 VSAM files14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 8 Dec 2000 12:21:37 +1100518_iso-8859-1 Sripathi,
Some ideas:
Option 1) Does your unload utility have a facility to unload from image copies? Do you have a pre-load image copy with the required data?
Option 2) 1) stop the tablespace and make a DSN1COPY of it (first two clusters only) 2) recover the tablespace to before the load (you do have image copies and logs, don't you) 3) unload the required data 4) restore your DSN1COPY using RESET 5) rebuild indexes if necessary. Did I mention that this would take some time? [...]
24298 94 31_Re: DB2 V7.1 18 char Limitation14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 8 Dec 2000 12:21:56 +1100332_iso-8859-1 Scott
I think the real need is that the SQL standard is moving to support of long names. Consequently, various application providers are writing code assuming that the RDBMS can support them. So if IBM wants to sell DB2 .... (You may notice that the DBINFO structure passes various names in 128 byte fields.) [...]
24393 23 25_Re: CAF & USS Performance12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 7 Dec 2000 20:52:45 -0600527_- Here's my opinion. Stored procedures are generally a better structure than using multiple users in one address space. Even with stored procedures we call the structure TP-light. Unless you code the facilities for separation of users, security, accounting, controls, ... then you don't have them.
Is this a single application that will run one or two users at a time? Or is this trying to replace a more complex structure with many applications and tens or hundreds of concurrent users. Those needs are different. [...]
24417 15 27_Re: DB2 for OS390 Version 612_Roger Miller19_millerrl@US.IBM.COM30_Thu, 7 Dec 2000 21:00:26 -0600263_- I've seen the confusion as well. There are multiple uses for the fields, so we can distinguish having the refresh code for example. There is no separate release for V6.2, just V6 and V7 (and V3 for a very short while, V4 for a while, V5 for a bit longer). [...]
24433 53 23_Re: Replication - CLOBs14_Michael Finnis28_MFinnis@PRINCETONSOFTECH.COM30_Thu, 7 Dec 2000 22:06:39 -0500388_ISO-8859-1 Hi Minnie,
From the outset, I work for the vendor Princeton Softech. Our company has a suite of tools, the Relational Tools for Servers, which will provide the functionality (and more) you seek in migrating CLOB's from one DB2 system to another.
You may care to look at: http://www.princetonsoftech.com/products and look at "Move for Servers" in particular. [...]
24487 160 31_Re: Date fields defined as NULL11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Fri, 8 Dec 2000 14:04:07 +1100320_- Randy,
you need to include the "NULL INDICATORS" clause. I had always assumed that the positions you identify for your null indicators had to be different from all your actual data, but it looks like you can "overlay" null indicators, so assuming your ninth field is the problem date, the clause would be: [...]
24648 14 28_Re: GA date for V7 on OS/39012_Roger Miller19_millerrl@US.IBM.COM30_Thu, 7 Dec 2000 21:30:45 -0600469_- There has not been an announcement for general availability on V7 yet. We're thinking probably the end of March, but it becomes official when it's official. Until then, anything can change.
Roger Miller, DB2 for OS/390
================================================ 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.
24663 42 15_Re: DB2 Connect13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Thu, 7 Dec 2000 22:22:10 -0600290_- Leon Your point about the price is well taken but I've some technical questions. I do wonder about the effect that use based pricing might have on this discussion. BTW my knowledge of DB2 Connect ( both EE & PE ) is very limited so please excuse me if I end up showing my ignorance. [...]
24706 46 13_Re: IFCID 19814_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Thu, 7 Dec 2000 23:44:04 -0500520_ISO-8859-1 Larry, While high re-reads might indicate the pool is too small, no re-reads or many minutes apart does not imply the pool is too large. The access could be quite random and not hit the same page frequently, or a page could be read in, and be hit very heavily and stay in the pool... thus no re-reads. Suppose a page is re-read by some type of prefetch... you would never know it since the 6 record only has the info for the first page. Then you would need to match with a 7 record to even know how many [...]
24753 34 19_rounding the values13_Morrill, John12_JohnM@VP.NET30_Thu, 7 Dec 2000 22:17:56 -0700526_- -----Original Message----- From: Puppala.Veeravenkateswararao@in.efunds.com [mailto:Puppala.Veeravenkateswararao@in.efunds.com] Sent: Tuesday, December 05, 2000 11:29 PM To: DB2-L-request@RYCI.COM Subject: Re: You are now subscribed to the DB2-L list
HI
I woud like to know , How we can round the values after decimal places of an Interger Rather than handling programatically , I would like to know is there any specific option in SQL while manipulating DB2 database on MVS environment . [...]
24788 16 48_meaning of VDWQT=0 & CASTOUT CLASS THRESHOLD=0 ?7_Soo Lee19_goingga@HANMAIL.NET30_Thu, 7 Dec 2000 23:47:23 -0600455_- I have some questions. What is the exact meaning of VDWQT=0 & CASTOUT CLASS THRESHOLD=0 ?
Which is right, VDWQT=0 makes I/O more frequently or VDWQT=0 makes I/O less frequently ?
please, help me...
================================================ 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.