1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2005, week 5
2 34 20_Merging of Databases11_ali hasnain23_me_alihasnain@YAHOO.COM31_Fri, 28 Jan 2005 23:52:46 -0800492_us-ascii Hi;
I work in a bank which has 75 distributed databases of avg size of 2GB. I want to consolidate all of them in one.
Is there any good way that i can consolidate them fast.I've written consolidation programs but they take too much time.
From Ali Hasnain DBA-Bank Al Habib
__________________________________ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 [...]
37 119 31_Re: Help with writing query....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Sat, 29 Jan 2005 00:29:59 -0800639_us-ascii Oh Boy..that was tacky..I executed the query suggested by Colleen Clow without the WHERE clause (since no one else suggested anything for a couple of days) and the query updated ALL the rows in RABMAC.DEHTRO. Fortunately it was test environment.
Thanks Suresh.
--- "Vasu, Suresh {PBG}" wrote:
> It should be > UPDATE RABMAC.DEHTRO T1 > SET NED_CER = (SELECT T2.NED_CER > FROM RABMAC.QUOTATION T2 > WHERE > T1.ORD_RB = T2.ORD_RB AND > T1.ORD_ID =T2.ORD_ID AND > T1.COMP_ID =T2.COMP_ID > ) > WHERE EXISTS > (SELECT 1 > FROM RABMAC.QUOTATION T2 > WHERE > T1.ORD_RB = T2.ORD_RB AND > [...]
157 91 42_Re: Simple query taking forever to run....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Sat, 29 Jan 2005 00:31:44 -0800606_us-ascii Actually currently, the only value that YNAPMOC_ID has is 'EM' (COLCARD=1) and so, will not add any value, if added to the index.
I executed COUNT(DISTINCT of 4 columns) and it comes out to be 62044.
So, there indeed seems to be a high correlation.
Thanks, Raquel.
--- Walter Janißen wrote:
> Raquel > > First of all, I thought access path was using list > prefetch, because in > some cases list prefetch can switch to a tablespace > scan. So reading all > the pages with that big rows will last. > > Compression will give you [...]
249 55 22_Sub tasks in Reorg....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Sat, 29 Jan 2005 00:33:11 -0800703_us-ascii I have the following lines in my JCL. These lines apparently are supposed to limit the number of subtasks that DB2 creates for parallel index rebuild.
//SW01WK01 DD UNIT=SYSDA,SPACE=(CYL,(100,35),RLSE) //SW01WK02 DD UNIT=SYSDA,SPACE=(CYL,(100,35),RLSE) //SW01WK03 DD UNIT=SYSDA,SPACE=(CYL,(100,35),RLSE) //* //SW02WK01 DD UNIT=SYSDA,SPACE=(CYL,(100,35),RLSE) //SW02WK02 DD UNIT=SYSDA,SPACE=(CYL,(100,35),RLSE) //SW02WK03 DD UNIT=SYSDA,SPACE=(CYL,(100,35),RLSE)
Per the utility guide:
“REORG TABLESPACE determines the number of subtask pairs according to the following guidelines: The number of subtask pairs equals the number of sort work data set groups allocated. “ [...]
305 43 35_DB2 Command Center not working ....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Sat, 29 Jan 2005 00:34:32 -0800409_us-ascii I have DB2 PE 8.1 installed on XP. Through Command Center, I give following
commands:
1. CONNECT TO EMPDATA This works.
2. SELECT * FROM DB2ADMIN.EMP DB2ADMIN.EMP is a table in EMPDATA database. This command, however, fails with DBA2192 - Database connection failed.
When I issue the above commands through the DB2 Command Window (DB2 CLP), they work perfectly fine. [...]
349 45 25_Simple Rexx question ....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Sat, 29 Jan 2005 00:52:48 -0800404_us-ascii Ok, this will take a moment of Rexx experts’ time:
Following is my rexx:
/*REXX*/ ADDRESS ISPEXEC "VGET ZTEMPF" SAY 'ZTEMPF :' ZTEMPF "ALLOC FI(OUTFILE) DS('"ZTEMPF"') SHR REU" SAY 'RC AFTER ALLOC FILE :' RC X = SYSDSN("'"ZTEMPF"'") SAY 'OUTPUT OF SYSDSN :' X RETURN
This is the output:
ZTEMPF : SYS05029.T025218.RA000.TZSBK0.ISPCTL1.H01 RC AFTER ALLOC FILE : 0 [...]
395 57 29_Re: Simple Rexx question ....10_teldb2kals22_teldb2kals@TELSTRA.COM31_Sun, 30 Jan 2005 01:33:26 +1100466_utf-8 Hi Raquel,
SYSDSN function returns the status of only catalogued datasets. The ZTEMPF variable is for temporary (uncatalogued) datasets. Hence your output.
Regards, Kals.
Raquel Rodriguez Sent by: DB2 Data Base Discussion List 29/01/2005 21:52 Please respond to DB2 Database Discussion list at IDUG
To: DB2-L@WWW.IDUGDB2-L.ORG cc: Subject: [DB2-L] Simple Rexx question .... [...]
453 72 32_Re: synonym , i don't understand13_Jim Schaeffer29_jim.schaeffer@EPOSTOFFICE.COM31_Sat, 29 Jan 2005 10:47:09 -0500582_ISO-8859-1 The way to use synonym is to have your current sqlid ='TEST' and then SELECT * FROM synonym without creator. A program written with SELECT ... FROM synonym get the table specified by the SYNONYM of the bind package owner.
Grainger, Phil wrote:
>A synonym only exists for the user that created it > >SO > >If you are "test" then you CAN select from TEST.TABLE > >If you are anyone else then you cannot as YOUR synonym does not exist. >Synonyms are not like views or aliases > > >Phil Grainger >Computer Associates >Product Manager, DB2 >Tel: +44 (0)161 [...]
526 34 24_Re: Merging of Databases12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Jan 2005 12:16:16 -0600632_- The redbook, Moving Data Across the DB2 Family, SG24-6905, sounds like one of the best resources for you. The base is two years old, but it was updated a year ago. http://www.redbooks.ibm.com/redbooks/pdfs/sg246905.pdf
Roger Miller
On Fri, 28 Jan 2005 23:52:46 -0800, ali hasnain wrote:
>Hi; > >I work in a bank which has 75 distributed databases of >avg size of 2GB. I want to consolidate all of them in >one. > >Is there any good way that i can consolidate them >fast.I've written consolidation programs but they take >too much time. > > >From >Ali Hasnain >DBA-Bank Al Habib [...]
561 26 26_Re: Sub tasks in Reorg....12_Kornelis Abe26_a.kornelis@PINKROCCADE.COM31_Sun, 30 Jan 2005 09:13:32 +0100404_iso-8859-1 Raquel,
Off the top of my head (i.e. I may be wrong): With sortkeys and sortdev specified DSNUTILB will dynamically determine the number of tasks to be used. I think also, SORTDEVT causes DB2 to bypass any pre-allocated datasets and use dynamic allocation.
From experience I know that if your Zparms do not specify enough batch connections you'll see the subtasks abend :-( [...]
588 67 26_Re: Sub tasks in Reorg....13_Michael Ebert18_mebert@AMADEUS.NET31_Sun, 30 Jan 2005 10:19:37 +0100331_US-ASCII No, that is not the case. Raquel, can you post your full JCL and SYSIN statement and the SYSPRINT output? It is strange that you are limited to 7 subtasks. In our installation, it is in the range of several dozen...
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...]
656 80 26_Re: Sub tasks in Reorg....25_Thanikachalam Sundarrajan21_billysundar@YAHOO.COM31_Sun, 30 Jan 2005 07:22:54 -0800309_us-ascii What is your region size (i.e REGION= in the JCL)? Your region size may be constraining the number of subtaks. I would check with your z/OS folks and monitor the jobs with various region sizes.
Also, you can use dynamic allocation of SORTWK, or SW by just using SORTNUM n SORTDEVT xxxDA. [...]
737 32 26_Re: Sub tasks in Reorg....33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Sun, 30 Jan 2005 22:08:06 +0100561_iso-8859-1 Raquel,
look up for msg DSNU397I. I also believe it's the region size or perhaps IEFUSI. We use REGION=0M for utilities.
Roland
-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Raquel Rodriguez Gesendet: Samstag, 29. Januar 2005 09:33 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: [DB2-L] Sub tasks in Reorg....
DSNU395I DSNUCRIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 7 DSNU397I DSNUCRIB - NUMBER OF TASKS CONSTRAINED BY VIRTUAL STORAGE [...]
770 14 42_Re: Simple query taking forever to run....33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Mon, 31 Jan 2005 03:25:34 -0600702_- Raquel
I think, there will be some value if you add this column to your index: you will get index only access. Or if all the rows have the value 'EM', it would be better, to eliminate this condition from your WHERE-clause.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
785 76 9_Need Help14_Mamata V Hegde19_mamhegde@IN.IBM.COM31_Mon, 31 Jan 2005 17:29:15 +0530450_US-ASCII Hi all,
I have some queris. Pls answer this queries
My requirement is something like this. I have a AIX server and installed DB2 server on that system.
Now i needs to 1. Add user for that Db2 server.
2. Need to give particular permission to taht user.
3. I need to access that Db2 server from Db2 client which resides on Windows system. Is this possible to change the Presmission from client? [...]
862 39 27_O'Reilly Safari book on DB212_McKown, John26_john.mckown@UICIINSCTR.COM31_Mon, 31 Jan 2005 09:25:30 -0600575_us-ascii This may be of interest to some/all of you.
http://safari.oreilly.com/?XmlId=0131477005
DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions.
902 65 26_Re: Sub tasks in Reorg....0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 31 Jan 2005 09:21:11 -0800457_iso-8859-1 Just a note. REGION=0M is not always the best answer. Some installations limit the size of 0M. Ours is 32M and you need special authorizations to get more than that. Check with your sys progs. cliff:-)
-----Original Message----- From: Schiradin,Roland HG-Dir itb-db/dc [mailto:SchiradinR@ALTE-LEIPZIGER.DE] Sent: Sunday, January 30, 2005 1:08 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Sub tasks in Reorg.... [...]
968 157 17_DB2 Forum meeting12_Robert Brock28_brock@KRYPTON-CONSULTING.COM31_Mon, 31 Jan 2005 11:44:46 -0600491_Windows-1252 Come to our special 1st quarter DB2 Forum meeting. See our website for more details www.db2forum.com. The migration workshops are just about full, we could take one or two more people. There are plenty of open slots for taking the DB2 certification tests.
You are invited to join the Dallas DB2 Forum, i.e. The Dallas/Fort Worth DB2 User’s Group, and it’s sponsor The IBM Corporation to join us at our 2005 First Quarter meeting for two days of exciting activities. [...]
1126 61 13_Re: Need Help14_Barry D. Noble25_barry_noble@SBCGLOBAL.NET31_Mon, 31 Jan 2005 19:24:38 -0500492_ISO-8859-1 Mamata V Hegde wrote:
> > Hi all, > > I have some queris. Pls answer this queries > > My requirement is something like this. > I have a AIX server and installed DB2 server on that system. > > > Now i needs to > 1. Add user for that Db2 server. > > 2. Need to give particular permission to taht user. > > 3. I need to access that Db2 server from Db2 client which resides on > Windows system. Is this possible to change the Presmission from client? > > How to do that? > [...]
1188 230 13_Re: Need Help14_Mamata V Hegde19_mamhegde@IN.IBM.COM30_Tue, 1 Feb 2005 09:47:11 +0530574_US-ASCII Hi , Thanks a lot
Regards, Mamata --------------------------------------------------------------------------- Mamata Hegde IBM Global Service India, 7th Floor,Prestige Tower,99,Residency Road, Bangalore -560025,INDIA Ph: 91-80-22079999 Ext 3473 Mail:mamhegde@in.ibm.com
"Barry D. Noble" Sent by: DB2 Data Base Discussion List 02/01/2005 05:54 Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] Need Help [...]