> [...]
27866 43 50_Re: Modification Regarding Breaking the tablespace18_Rajesh Kumar Sinha24_rksinx@LOT.TATASTEEL.COM31_Mon, 14 May 2001 15:06:51 +0530402_us-ascii In case of following condition table cannot be renamed:-
Referenced in any existing view definitions or summary table definitions Referenced in any triggered SQL statements in existing triggers or be the subject table of an existing trigger Having any check constraints Parent or dependent table in any referential integrity constraints The scope of any existing reference column. [...]
27910 88 40_DB2 Connect - Large account installation12_Jacob Ganzel19_jacobg@SEMECH.CO.IL31_Mon, 14 May 2001 14:46:49 +0300384_x-user-defined Hello list.
What is the best way to install and maintain DB2 Connect Client code in a large account (1000+ workstations) without doing it on every workstation manually ?
Is there any software distribution package which can install, catalog and maintain from a central site?
I would appreciate receiving a reference large account dealing with. [...]
27999 83 39_DB2 Inactive thread - DB2 Connect users12_Jacob Ganzel19_jacobg@SEMECH.CO.IL31_Mon, 14 May 2001 14:48:02 +0300554_x-user-defined Hello list.
Does TYPE 2 INACTIVE THREAD support ( DB2 V6) disconnects DB2 Connect users?
Question comes from the need of reducing the number of concurrent DB2 Connect users by disconnecting long time IDLE users.
Is there other ways to do it?
Thanks Jacob.
--------------------------------------------------------------- Jacob Ganzel Database Products Mgr. SEMECH Software Marketing Ltd.
3b Netanyahu St., OR YEHUDA, ISRAEL 60376 Email: jacobg@semech.co.il Tel.: +972-3-5333144 Fax.: +972-3-5333132
28083 90 36_Re: Looking for help creating a view12_Bob LaCerais28_Bob_LaCerais@TAX.STATE.NY.US31_Mon, 14 May 2001 08:02:42 -0400236_us-ascii I've tried that. It fails with the error message noted below. I checked the SQL reference manual after getting this error message and found that 'a view definition cannot contain unions or references to remote objects'.
28174 43 39_Re: DB2 Version 7 Operational Utilities12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Mon, 14 May 2001 14:05:44 +0200333_us-ascii Hi Jim,
thanks for the info.
I just downloaded the utility guide for DB2 V7 from the web and looked at the UNLOAD chapter. I have one question: can the FROMCOPYDDN option be used to unload data from concurrent copies taken with the FILTERDDN option? (We're not on V7 yet, but plan to go later this year.) [...]
28218 63 16_Re: How to store11_David Nance16_DWNance@FHSC.COM31_Mon, 14 May 2001 08:07:42 -0400310_US-ASCII Duam, We have something similar. You might want to consider partitioning the table using the date as part of the key. Then again, you may want to think of rolling this seldom used data into another table. Then the six month transaction would have to be changed to incorporate this archive table. [...]
28282 13 25_Re: DB2 Stored Procedures11_Joan Keemle25_KeemleJoanT@JOHNDEERE.COM31_Mon, 14 May 2001 06:55:14 -0500398_- One idea I've heard mentioned is to write a Rexx stored procedure and dynamically allocate your file in Rexx. Then call the COBOL stored procedure. * Joan
================================================ 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.
28296 49 41_Disaster Recovery Data Sharing Questions.10_Lee Mandel16_DBMSUser@AOL.COM29_Mon, 14 May 2001 08:28:46 EDT497_US-ASCII The manual states one method to determine the ENDLRSN value to use for CRESTART is to find the lowest LRSN value listed in the DSN1213I message, for the data sharing group. The DSN1LOGP message DSN1213I do not have a data sharing group listed. Questions: 1 How do I determined the data sharing group? 2 Is there is way to limit the sysprint to print only the DSN1213I messages, or at least omit some messages? 3 Do anyone have a method to automate the creation of the Crestart card? [...]
28346 29 27_Re: Column Naming Standards13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 14 May 2001 08:36:52 -0400463_iso-8859-1 Hi Glenn,
I have been victim of such naming standards policies in my checkered past.
I never found them very helpful. Sure, standardization is desirable. But it seemed to me (as a DBA -- not a DA) and the developers I supported that the irrational application of absolute standards was more of a hindrance than a help. But that was probably just irrational rebellion against the iron-fisted data administrators, at least on my part. [...]
28376 81 27_Re: Column Naming Standards11_Moore, Tony15_TMoore@IKON.COM31_Mon, 14 May 2001 08:55:14 -0400578_iso-8859-1 Glenn, I'm using a similar standard... a column name can be created with a defined set of "prime words" and/or their defined abbreviations and a ending "class" word or abbreviation that describes the data (AMT, DATE, NBR, etc.). For both prime words and class words I allow either the full word or abbreviation. I keep these words/abbreviations in ISPF tables with a REXX that the programmers and project dba's can use to build column names. The class words are set in stone, but I do add prime words/abbreviations as needed. It seems to be working pretty good. [...]
28458 34 13_Siebel Survey14_Scott Trometer22_scott.trometer@RCI.COM31_Mon, 14 May 2001 07:56:27 -0500369_iso-8859-1 Listers,
It looks like our shop will be moving to a Siebel/UDB solution in the near future. There have been a number of discussions regarding the OS. Is anyone using Siebel on OS/390? Any comments, thoughts, concerns? How about Unix?
I am looking for very high-level info here...liked it, didn't like it, tough to install/administer, etc. [...]
28493 24 13_Cluster ratio15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Mon, 14 May 2001 08:15:34 -0500305_us-ascii Hi Listers
Is it possible to get in & around 100% cluster ratio for NPIs on table defined whose TS is partitioned . I am not getting it after (reorg + runstats). Few of them are between 66 and 70 %. Are these cluster ratios are good?
Any suggestion will certainly appreciated. [...]
28518 94 45_Re: Disaster Recovery Data Sharing Questions.9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Mon, 14 May 2001 14:17:48 +0100593_us-ascii
Lee, Im not quite sure I understand your question ('1'). (1) You've got to run DSN1LOGP against EACH member in the datasharing group - the DSN1213I message is only relevant to one particular member. Therefore you need to know the members in the datasharing group before you run DSN1LOGP (i.e. by doing a -DISPLAY GROUP command ). (2) I have not found a way to just get the DSN1213I message. By passing the DSN1LOGP, SYSPRINT output through REXX it is simple enough to extract, and write out, the DSN1213I message. (3) If you write a REXX program (as above) [...]
28613 80 27_Re: Column Naming Standards19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 14 May 2001 08:31:04 -0500599_iso-8859-1 Glenn, Some, hopefully, practical advice. Given the 18 char. limit. I try to avoid abbreviation of any table or column name. Plain English is always the best. I realize this may be impossible with some of the jillion char. long names generated by OO design tools. When it becomes necessary, there should be standard abbreviations across the enterprise. I then choose the word or words that have abbreviations that make the most sense (some abbreviations leave no clue what they stand for, ha). Once a word has been abbreviated it should always be abbreviated in that model and I try [...]
28694 27 39_Re: DB2 Version 7 Operational Utilities13_Jimmy Willett13_JRLBW@AOL.COM29_Mon, 14 May 2001 09:39:07 EDT57_US-ASCII where on web can you find the manuals???? thanks
28722 65 39_Re: DB2 Version 7 Operational Utilities12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Mon, 14 May 2001 15:58:10 +0200298_us-ascii Go to the IBM / DB2 homepage: http://www-4.ibm.com/software/data/db2/os390/index.html Click "library" on the left You will get a list of all DB2 related manuals.
Regards, Claude.
Jimmy Willett wrote:
> where on web can you find the manuals???? > thanks
28788 25 27_Re: Column Naming Standards14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Mon, 14 May 2001 08:54:51 -0500556_iso-8859-1 I would suggest that it is the responsibility of the Data Analyst to decide on the column names. If you think about it, there is no way (even without the 18 character limit) to fully describe the contents of the column, so the final name will always be a compromise. All you can reasonably do is give some hint as to its contents. What I would say however, is that columns (or attributes in the logical model) should be named consistently where they contain the same data. For example, do not call an account number ACCNUM in one table and [...]
28814 38 39_Re: DB2 Version 7 Operational Utilities12_Mark Granger22_the_grange@MBOX.COM.AU31_Mon, 14 May 2001 09:07:26 -0500542_us-ascii For DB2 V7 for OS/390 http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/DSNSHHA0
For All the IBM manuals http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/shelves
Mark Granger Independent Systems Integrators P/L Senior Technical Specialist - 2BDB2 Email: mgranger@isi.com.au Phone: +61 0416-012-262 (Australia) OR +1 617-306-7794 (USA)
----- Original Message ----- From: Jimmy Willett Date: Monday, May 14, 2001 8:39 am Subject: Re: DB2 Version 7 Operational Utilities [...]
28853 23 17_Re: Cluster ratio15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Mon, 14 May 2001 08:54:56 -0500621_- Mohammed
Data can only be clustered according to the clustering index, which is for partitioned tablespaces the partitioning index. So it is possible to get a 100% clusterratio for NPI, but it will be the exception, because there couldn't be hardly any difference in the definition of those indexes.
I also think, that the clusterratio is only important for clustering indexes, because the optimizer doesn't choose seq. pref. for non clustered indexes. If the work is done by using only the index (index only access) then the clusterratio doesn't matter, index entries are always stored in sequence. [...]
28877 41 17_Re: Cluster ratio20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Mon, 14 May 2001 15:22:04 +0100522_iso-8859-1 By definition NPIs are not clustering indexes and so cluster ratio is not relevant for them.
-----Original Message----- From: Mohammed Nayeem [mailto:Mohammed_Nayeem@MOMED.COM] Sent: 14 May 2001 14:16 To: DB2-L@RYCI.COM Subject: Cluster ratio
Hi Listers
Is it possible to get in & around 100% cluster ratio for NPIs on table defined whose TS is partitioned . I am not getting it after (reorg + runstats). Few of them are between 66 and 70 %. Are these cluster ratios are good? [...]
28919 53 27_Re: Column Naming Standards13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Mon, 14 May 2001 09:22:51 -0500541_us-ascii We use standard abbreviations always even when the whole word would fit. We have a standards committee made up of a DBA and a group of representative programmers. We started with a list of military abbreviations since we supply military as well as commerical products. We added new abbreviations when there was none already. All new abbreviations were approved by the committee. No programmers liked all the abbreviations, but they appreciated it when they moved to another application and all the abbreviations were the same. [...]
28973 111 37_Re: Regarding Breaking the tablespace14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Mon, 14 May 2001 07:28:15 -0700462_iso-8859-1 Sanjeev, I seem to recall that, at least for Version 6 of DB2, RENAME would fail if there are any views dependant upon the table. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.
-----Original Message----- From: S, Sanjeev (CTS) [mailto:SSanjeev@CAL.COGNIZANT.COM] Sent: Sunday, May 13, 2001 11:30 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Regarding Breaking the tablespace [...]
29085 130 20_Re: DB2 Questions...12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 14 May 2001 07:39:46 -0700563_us-ascii In addition to Raymond and Jim's reply, I'd like to add that a COMMIT statement will release all locks that your program has accumulated. It does, however, make your changes to the database permanent, so they would not "rollback" if your program abends later on. Tim --- "Bell, Raymond W" wrote: > Matias, > > I can't help with the 2nd or 3rd question, not being > familiar with identity > columns. As to the first, if you're asking if > there's a way to specify in > the SQL how long to wait for a lock the answer [...]
29216 102 27_Re: Column Naming Standards0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 14 May 2001 09:52:17 -0500559_us-ascii We use a standard originally defined by IBM (way back in the days of the dinosaurs, and please, no offense intended to people who where around when it was first published ... ) call the "OF Language". Basically it is a standard that defines a syntax for defining field names and as part of it we have a standard set of 3 (and some 2) character abbreviations, and end with a 1 char data type code (ie t=text, n=number, m=name, f=flag, c=code etc) that are !!!!!ALWAYS!!!!!! used to name columns and tables. You get a strong slap on the wrist [...]
29319 80 18_Re: Dropped Table!16_Machnik, Stanley19_MachnikS3@AETNA.COM31_Mon, 14 May 2001 11:08:02 -0400307_iso-8859-1 The Diagnosis manual is exactly what I need, thanks. I found (and highlighted!) all of the information I needed. Primarily, I was looking for the descriptions of all the values on the header.
As it turns out, we will be able to recreate the data manually. We were lucky on this time! [...]
29400 79 18_Re: Dropped Table!13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Mon, 14 May 2001 08:56:41 -0700325_iso-8859-1 OBID is present as a part of each 'record' in the table. As suggested below, do a DSN1PRINT with FORMAT option and search for PGSOBD. This will be a hex value identifying the OBID of the table this record is associated with. Convert it in decimal. We have V5 installed here and this is true at least till V5. [...]
29480 49 59_Diff in Partitioning implementation between OS/390 and UNIX11_Bikash Paul19_bikash_db@YAHOO.COM31_Mon, 14 May 2001 09:01:54 -0700599_us-ascii Hi listener, I am OS/390 person and Now got some added reponsibility to impletement partitioning on UDB running on HP-UX. Here is my query.
On OS/390, There is a tablespace called partitioned tablespace. - We decide the no of partition for the table and define a partitioned tablespace with same no of partition. - Create a table in the partitioned tablespace - Create a clustered index on the table. All the primary key columns OR only the leading columns could be used for partitioning. While defining the index, we can define range for each and every partition. If emp_no is [...]
29530 148 26_Hybrid vs Nested Loop Join12_Aedan Molony20_Aedan.Molony@PSIR.IE31_Mon, 14 May 2001 17:07:12 +0100506_iso-8859-1 Hi All, We currently have a program that opens a cursor like:-
SELECT MN1 . LINK_ID , MN1 . ORIG_ID , MN1 . ORIG_REF_NO , MN1 . DBT_NME , MN1 . AMT_TYPE , MN1 . TX_AMT, MN1 . FREQ_CDE , MN1 . UPR_LMT , MN1 . END_DATE , MN1 . RCVD_FIN_PYMT_DATE , DA1 . RET_UNIT_CDE , DA1 . RET_UNIT_AC_NO FROM DDD.VDDMN001 MN1 , DDD.VDDDA001 DA1 WHERE MN1 . END_DATE > '2001-05-13' AND MN1 . END_DATE <= '2001-05-14' AND DA1 . CANCLD_IND = 'N' AND MN1 . LINK_ID = DA1 . LINK_ID AND MN1 . LINK_ID > 0 [...]
29679 72 17_Re: Cluster ratio11_Bikash Paul19_bikash_db@YAHOO.COM31_Mon, 14 May 2001 09:07:36 -0700486_us-ascii Hi, You have probably defined Non-Partition clusted index. Good cluster ratio will improve performance always having efficient sequential prefetch method. Ideally data should be perfectly clustered and ratio should be 100%. You can achieve close to 100% by doing reorg. Howerver cluster ratio will fall while data is inserted, deleted from the table. We have some critical tables and do run reorg on them everynight to get good cluster ratio and hence better performance. [...]
29752 45 43_Re: DB2 Inactive thread - DB2 Connect users17_Miguel de Andrade29_miguel.andrade@BTINTERNET.COM31_Mon, 14 May 2001 10:55:21 -0500724_- You may consider : TCPKPALV (overrides inappropriate TCP/IP KeepAlive values) for TCP/IP connections.
Also, the installation manual - Tuning TCP/IP gives very good hints for tuning, and check zparm IDTHTOIN.
Best Regards, Miguel de Andrade
On Mon, 14 May 2001 14:48:02 +0300, Jacob Ganzel wrote:
>Hello list. > >Does TYPE 2 INACTIVE THREAD support ( DB2 V6) disconnects DB2 Connect users? > >Question comes from the need of reducing the number of concurrent DB2 >Connect users by >disconnecting long time IDLE users. > >Is there other ways to do it? > >Thanks Jacob. > >--------------------------------------------------------------- >Jacob Ganzel >Database Products [...]
29798 55 19_DB2 SQL Performance17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Mon, 14 May 2001 09:32:09 -0700554_us-ascii I have a performance question with a cobol batch job and DB2 V5.1 on OS/390.
We tested the job in our test environment with production data that was copied over with DSN1COPY.
The program selects 1 row from Table A using an IN-List Index scan on the first column of the index and an equal predicate for the second column. Table A has a 2 column index. Using the data returned a select is done on Table B (6 column index) using an equal predicate for the first column index and for a non-index column. Lastly Table C (2 column [...]
29854 102 30_Re: Hybrid vs Nested Loop Join34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Mon, 14 May 2001 12:45:59 -0400427_us-ascii Aedan
Since you haven't provided explain output, there are few information, which would be helpful to analyze the problem.
- Does both tables have clustered index on LINK_ID and how many columns apart from LINK_ID if they are composite ? - If you could provide explain output even better. - What is the cluster ration of the indexes ? - COLCARDF of all the columns involved in the WHERE predicate ? [...]
29957 104 17_Re: Cluster ratio34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Mon, 14 May 2001 12:55:40 -0400332_us-ascii The partition index must be a clustering index and there can only be one clustering index for a table. An NPI (non partitioned index) can never be defined as clustering index. This means that clusterratio of your Non partitioned Index is depended on how closely it matches with data pattern of the partitioning index. [...]
30062 23 39_Declared global temporary tables usage.15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 14 May 2001 12:56:46 -0400409_iso-8859-1 To all list users,
I would like to know what are different problems faced by using Declared temporary tables in DB2. Is there a fix for all that. Even after applying all these fixes available, do Declared temporary tables still create problems.
Also would like to know the maintenance level, if there one, which we can apply to remove all the declared temporary tables problems. [...]
30086 59 17_Re: Cluster ratio15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Mon, 14 May 2001 12:05:47 -0500508_iso-8859-1 I thought so too...but also keep wondering...even with nonclustering indexes the clusterratio is updated in an runstats...so could it have some influence on the optimizer ?...say we have two candidate nonclustering indices (indexes?) for the optimizer in a range scan... could the clusterratio have an influence?
-----Original Message----- From: Beighton-Dykes, Hugh [mailto:hugh.beighton-dykes@EDS.COM] Sent: Monday, May 14, 2001 9:22 AM To: DB2-L@RYCI.COM Subject: Re: Cluster ratio [...]
30146 95 23_Re: DB2 SQL Performance34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Mon, 14 May 2001 13:09:21 -0400439_us-ascii The simplest approach would be to convert this to a join (table A vs table B). Since you didn't mention the fullkeycardf & cardf for indexes & table, I assume that TABLE A has duplicate index & colcardf for first column for index on table B is very high.
Converting it to join will make optimizer choose the best access path for you instead of forcing nested loop kind of join programmatically (as you are doing now). [...]
30242 19 31_INDEXES IN TEMPORARY TABLES....34_=?iso-8859-1?Q?Mat=EDas_Salvador?=26_matias_salvador@UOL.COM.AR31_Mon, 14 May 2001 14:38:10 -0300446_iso-8859-1 Is there any way in DB2 to set indexes to Temporary Tables?
MATíAS SALVADOR JAVA Development Team Soluciones Integrales S.A. 590 Roca Av. 7° Floor Buenos Aires +54.011.4345.0537 int. 132
================================================ 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.
30262 17 25_Why is my index not used?15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Mon, 14 May 2001 12:52:13 -0500295_us-ascii I have created an index that contains all the columns in my where clause. I have run runstats, when I look at the activity in SAP it shows a completely different index being used and only matching one column of that index.
If anyone has an idea I'd like to hear it. Thanks. [...]
30280 77 35_Re: INDEXES IN TEMPORARY TABLES....16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Mon, 14 May 2001 13:58:52 -0400446_iso-8859-1 Yes,
If it is a declared temporary table and you are on os/390 version 6.1, then you can create indexes on the temporary tables.
Rick Creech
Matías Salvador cc: Sent by: DB2 Data bcc: Base Discussion Subject: INDEXES IN TEMPORARY TABLES.... List
05/14/01 02:08 PM Please respond to DB2 Data Base Discussion List [...]
30358 95 17_Re: Cluster ratio14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Mon, 14 May 2001 14:06:20 -0400391_iso-8859-1 Hi,
Can someone tell how is cluster ratio affected if there are ONLY inserts (frequent)to a table and of course selects (frequent), but NO deletes (well, probably once every 5 years by timestamp) and NO updates. This is for a history table for our application where we aim to keep the historical data for say, 5 years minimum (projected 50 million rows over 5 years). [...]
30454 37 20_db2 personal edition13_Jimmy Willett13_JRLBW@AOL.COM29_Mon, 14 May 2001 14:10:09 EDT371_US-ASCII I have just downloaded the v7.1 personal edition from IBM. I installed it and when I tried to create the sample database, it had authority problems. I am using Windows 98. I know that in Windows NT, the NT admin has to be set properly for 8 chars... Where do you set authority in Win98?? There is no administration folder in win98 like there is in win NT. Thanks
30492 136 45_Re: Disaster Recovery Data Sharing Questions.12_Tony Konczak22_TKonczak@CHECKFREE.COM31_Mon, 14 May 2001 14:07:26 -0400319_us-ascii
Lee, Try using DSNJU004 to print out the BSDS from each Data Sharing member. Get the ENDLRSN of the last log archived to disk for each Member and subtract 1 from lowest one. If you don't mirror your logs, all of your information is formatted neatly in the ACTIVE log section of the BSDS printout. [...]
30629 32 29_Re: Why is my index not used?14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Mon, 14 May 2001 13:20:03 -0500528_iso-8859-1 I'm sure you ran runstats. But what are the columns in your index and on which SAP table?
-----Original Message----- From: Daniel Sullivan [mailto:daniel.sullivan@ZURICHNA.COM] Sent: Monday, May 14, 2001 12:52 PM To: DB2-L@RYCI.COM Subject: Why is my index not used?
I have created an index that contains all the columns in my where clause. I have run runstats, when I look at the activity in SAP it shows a completely different index being used and only matching one column of that index. [...]
30662 78 63_Re: Diff in Partitioning implementation between OS/390 and UNIX15_Stacey L Waters23_WATERSS1@NATIONWIDE.COM31_Mon, 14 May 2001 13:34:39 -0500421_us-ascii UDB on NT/UNIX uses hashed based partitioning not range. In other words you do not specify a range values. UDB itself takes care of balancing the data between the partitions. A table is partitioned based on a subset of column(s) which is defined in the create table statement. The table is assigned to a tablespace at that point. The tablespace in turn controls across which nodes the table is partitioned. [...]
30741 142 29_Re: Why is my index not used?12_Troy Coleman19_Colematr@MEIJER.COM31_Mon, 14 May 2001 14:35:50 -0400391_US-ASCII When you prototype the SQL statement and do an explain are you using "?" for place holders?
Example:
The value for col1 = 'ABC' and for col2 = 'XYZ'
EXPLAIN ALL SET QUERYNO = 1 FOR Select col1, col2, col3 From tbl1 Where col1 = 'ABC' and col2 = ?
EXPLAIN ALL SET QUERYNO = 2 FOR Select col1, col2, col3 From tbl1 Where col1 = 'ABC' and col2 = 'XYZ' [...]
30884 12 29_Re: Why is my index not used?15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Mon, 14 May 2001 13:53:55 -0500289_us-ascii Yes I'm using the ? as a place holder.
================================================ 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.
30897 129 63_Re: Diff in Partitioning implementation between OS/390 and UNIX11_Bikash Paul19_bikash_db@YAHOO.COM31_Mon, 14 May 2001 12:03:44 -0700605_us-ascii Thanks stacey. I understand that range based partitioning is not possible. I have a requirement where data pertaining a region is kept in a separate table. We thought of replacing it using partitioning technique. Is there any way of restricting a partition to have predefined set of data. What i am looking at is, Using partitioning, We can acheive the followings 1) Introduce parallelism in batch and each stream will only look into a single partition 2) Restrict the access to a partition, whould improve the scan time while tablespace scan is being used 3) Keeping a partitions data into [...]
31027 12 29_Re: Why is my index not used?0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Mon, 14 May 2001 15:10:31 -0400320_us-ascii What about binding the plan after creation of the index and runstats?
================================================ 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.
31040 26 27_DB2 v7.2 Free Beta Download15_Kellie Wiginton16_kwig37@YAHOO.COM31_Mon, 14 May 2001 12:41:57 -0700567_us-ascii ================== DB2 for Linux and Windows v7.2 Free Beta Download
IBM has extended the record breaking performance and functionality of DB2 Universal Database with the announcement of Version 7.2. You can request a free 90 day trial copy of the BETA code by registering now.
http://www-4.ibm.com/software/data/db2/udb/downloads.html?open&l=327,t=grdb2,p=v7.2 ==================
__________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ [...]
31067 20 27_Books for DB2 Certification10_Raghu Kota21_raghukota@HOTMAIL.COM31_Mon, 14 May 2001 19:44:25 -0000542_- Hi Friends
What are best books for preparing DB2 version7.1 certification on os/390, How many papers are there??? Any Info???
TIA Raghu. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
================================================ 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.
31088 156 63_Re: Diff in Partitioning implementation between OS/390 and UNIX15_Stacey L Waters23_WATERSS1@NATIONWIDE.COM31_Mon, 14 May 2001 14:44:36 -0500411_us-ascii Bikash, I am interested in getting more information about each of the points listed in your email. If you can write me in more detail either through the listserv or directly I will try and help.
Thanks, Stacey
Bikash Paul @RYCI.COM> on 05/14/2001 02:03:44 PM
From: Bikash Paul @RYCI.COM on 05/14/2001 02:03 PM [...]
31245 19 32_DB2 Admin Client on Windows 200011_Judy Kibler21_judith.kibler@TRW.COM31_Mon, 14 May 2001 15:02:23 -0500449_us-ascii Hello Listers,
Has anyone had problems with the DB2 Administration Client software (v6) locking up on their Windows 2000 client PCs? Any known solution to the problem?
TIA, Judy Kibler
================================================ 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.
31265 52 31_Re: Books for DB2 Certification12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Mon, 14 May 2001 16:12:25 -0400658_us-ascii Someone in this list informed that a certification guide for OS/390 Db2 version 7.1 will be coming out next month(June 2001) Check out www.ibm.com/certify
Raghu Kota on 05/14/2001 03:44:25 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Amit Agarwal/FIS)
Subject: Books for DB2 Certification
Hi Friends
What are best books for preparing DB2 version7.1 certification on os/390, How many papers are there??? Any Info??? [...]
31318 39 24_Re: db2 personal edition21_Devineni, KishoreBabu29_KishoreBabu.Devineni@NIKE.COM31_Mon, 14 May 2001 13:58:36 -0700331_us-ascii You can download the LAB exercises(It is a PDF file) from IBM web site and there is a solution for this. As for as I remember any user ID can be used as SYSADMIN for Win'98... Create an instance INST1 Change the instance name in autoexec file Restart the machine and log on as INST1 Create sample data base in INST1. [...]
31358 32 29_Re: Why is my index not used?13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Mon, 14 May 2001 15:47:52 -0500456_- There are a lot of questions that come to my mind when I here similar stories.
1. Are you sure your where clause is indexable? (see Application & Programming Guide on Predicate Evaluation and Processing)
2. What is the cardinality of the columns in the index? High or low?
3. What is it that the optimizer likes about the other index? Compare the columns being used in each and where they are in the pecking order of the index. [...]
31391 13 25_Example of REPAIR LEVELID11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Mon, 14 May 2001 16:28:46 -0500339_us-ascii Does anyone have an example of using REPAIR to reset the LEVELID on a tablespace?... : )
================================================ 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.
31405 90 24_Re: db2 personal edition18_Gert van der Kooij15_geko@WANADOO.NL31_Mon, 14 May 2001 23:32:55 +0200610_iso-8859-1 Hi,
You probably need to run the db2logon command. ----- Original Message ----- From: Jimmy Willett Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Monday, May 14, 2001 8:10 PM Subject: db2 personal edition
I have just downloaded the v7.1 personal edition from IBM. I installed it and when I tried to create the sample database, it had authority problems. I am using Windows 98. I know that in Windows NT, the NT admin has to be set properly for 8 chars... Where do you set authority in Win98?? There is no administration folder in win98 like there is in win NT. Thanks
31496 38 29_Re: Example of REPAIR LEVELID13_Olson, Carlos14_COlson@QRS.COM31_Mon, 14 May 2001 15:47:12 -0700551_iso-8859-1 REPAIR LEVELID TABLESPACE databasename.tablespacename add PART 01 and repeat the line for each partition if this is a partitioned tablespace.
Carlos Olson Database Administrator QRS Corporation email: colson@qrs.com http://www.qrs.com
-----Original Message----- From: Jeff Faughn [mailto:Jeff_Faughn@MAY-CO.COM] Sent: Monday, May 14, 2001 2:29 PM To: DB2-L@RYCI.COM Subject: Example of REPAIR LEVELID
Does anyone have an example of using REPAIR to reset the LEVELID on a tablespace?... : ) [...]
31535 55 29_Re: Why is my index not used?12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Tue, 15 May 2001 08:46:04 +1000356_- ... and add to that
7) Can DB2 avoid a sort by using the first index rather than the new one.
... but as Shauna has said with out specific details it's very hard to say why.
Cheers, Nick Cianci DB2 DBA - CCRI Project 5th Floor (South) 484 StKilda Rd MELBOURNE 3004 * (+613) 9865-8354 (+61) 0408-64 06 01 * NCianci@CPTglobal.com [...]
31591 40 24_Re: db2 personal edition15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 15 May 2001 09:25:51 +1000480_- Jimmy,
I'm not going to be any help but I know how frustrating getting DB2 on Windoze to work can be. I managed to install DB2 V6.1 on W98 successfully and never had to manage any security settings. This is on my stand-alone laptop at home. The only time it prompted me for an ID was when I started using the Control Center (sp) and Command Center (sp). It seems any old damn thing will do, too. Maybe some more details might help someone else on the list help you. [...]
31632 52 27_Re: Column Naming Standards15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 15 May 2001 10:12:59 +1000615_- That wouln't be Eric by any chance, would it? 'Ho-ho-ho, he-he-he, Eric the half-a-bee'.
Sorry, again couldn't resist.
Raymond
> -----Original Message----- > From: Seibert, Dave [SMTP:Dave_Seibert@COMPUWARE.COM] > Sent: Monday, 14 May 2001 10:37 pm > To: DB2-L@RYCI.COM > Subject: Re: Column Naming Standards > > Hi Glenn, > > I have been victim of such naming standards policies in my checkered > past. > > I never found them very helpful. Sure, standardization is desirable. But > it > seemed to me (as a DBA -- not a DA) and the developers I supported that > the > irrational [...]
31685 111 24_Re: Buffer pool question10_Radha Rani24_radha_rani@ALTAVISTA.COM31_Mon, 14 May 2001 21:09:56 -0700482_- Sanjeev, It is my understanding that migration of pages to HP is not a 'continuous' process but a process 'triggered' when inventory of 'Free' buffers in virtual buffer pools goes below 128 (for bufferpools > 2500 pages). 128 buffers is not a huge number and it is very much possible that a GETPAGE request has to 'wait' because: 1. There are no 'free' buffers available AND 2. The ADMF task is still 'in the process' of transporting a buffer from virtual pool to hiperpool. [...]
31797 68 17_Re: Cluster ratio16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 15 May 2001 10:01:46 +0530447_- Abhijit,
If we look at the insert mechanism in DB2, we will come to know how the clustering destroys due to this. In brief, when a record is to be inserted, DB2 performs following actions: i) Decide the home page for the record on the basis of clustering index ii) If space is there in the home page or it is not locked, insert the record else look for the other pages(bit of story is there which varies as per the tablespace type). [...]
31866 15 47_Frank Yao/CACI/Prudential is out of the office.9_Frank Yao24_frank.yao@PRUDENTIAL.COM31_Tue, 15 May 2001 01:00:38 -0400412_us-ascii I will be out of the office from 05/12/2001 until 05/21/2001.
If this is an emergency, please contact Eileen Bennett at 716-6451 or Pat Kelly at 716-1559.
================================================ 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.