1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2009, week 1
2 32 42_DB2 V9 z/OS - how to get rid of claimers ?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM30_Thu, 1 Oct 2009 05:28:11 +0000547_UTF-8 Hello, our utility jobs occasionally fail due to timeouts cased by claimers. Claimers are distributed applications that, in my opinion, use cursors WITH HOLD ( Is there anything else that may cause claims not to be released ?). What options do we have to remove claimers before the utility access the object? I'm thinking of a REXX or USS script that would display claimers on a object, parse the output to obtain the thread token and then would issue cancel thread command. Would that make sense or there are other ways? Regards,Nenad [...]
35 83 40_V8 APAR PK46170 - v7 compiler for DB2 v828_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Thu, 1 Oct 2009 11:13:56 +0530593_US-ASCII Hello List,
DB2 v8 Migration scenario :-)
In our shop, we are trying to run old COBOLs in our Production for about a quarter (that is having the most of holidays and a production freeze) with the help of PTF PK46170 ( http://www-01.ibm.com/support/docview.wss?uid=swg1PK46170).
We will primarily be running in CM with the help of this PTF and before we do v8 ENFM, COBOLs would be migrated to Enterprise version. Does anyone have experience making use of this PTF and if so, can I get some inputs/experiences/how-to's etc.. (may be on the list or offline) ? [...]
119 176 46_Re: DB2 V9 z/OS - how to get rid of claimers ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Thu, 1 Oct 2009 11:39:01 +0530555_US-ASCII In one of the earlier experience, I had to Load Replace few tables but, the distributed threads left idle from workstations kept the claimers on. I think, an ambiguous query as in host application would keep the claimers until UOW is complete.
If you resort to writing a script / rexx and not able to find that in code place of IDUG or anywhere in your shop, just let me know. I have one that I have been using to kill the "culprit threads". I inserted the batch rexx ahead of the utility job step. My Sundays are relatively peaceful [...]
296 46 30_Re: DB2 Connect Gateway Server16_Vial R. (Robert)25_robert.vial@NL.FORTIS.COM30_Thu, 1 Oct 2009 07:00:45 +0000621_utf-8 Jeff,
We had the same issue here. W've implemented a Connect Gateway and are using the type-4 driver (the universal one). Maybe in the (near) future we are going to do the connection to z/OS without the Connect Gateway. Your questions: 1. If you're going to use the type-4 driver you only need the java jar-files at the client. 2. With the Gateway you can use connection pooling and connection concentrator. The parameters to play with are: num_poolagents, num_initagents, max_coordagents and max_connections. You should be able to find documentation about this. 3. That I don't know but the two things [...]
343 66 46_Re: DB2 V9 z/OS - how to get rid of claimers ?20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM30_Thu, 1 Oct 2009 10:05:26 +0300649_us-ascii Hello Nenad,
We have a similar automation...
Basically it does;
It issues Dis Thread Detail Captures tokens Issues Can Thread
Regards, Cuneyt
> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Nenad Vidak > Sent: Thursday, October 01, 2009 8:28 AM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] DB2 V9 z/OS - how to get rid of claimers ? > > > Hello, > our utility jobs occasionally fail due to timeouts cased by > claimers. Claimers are distributed applications that, in my > opinion, use cursors WITH HOLD ( Is there anything else that [...]
410 47 46_Re: DB2 V9 z/OS - how to get rid of claimers ?13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Thu, 1 Oct 2009 10:34:10 +0200444_utf-8 Hi Nenad,
If you run your utilities Shrlevel Change and are intelligent with the drain-related parms, you can have them -DISplay the CLAIMERS out there that are stopping the Logfinal phase from starting (just before switching/renaming clusters) and wait/retry until you've done something about them yourself - or the utility gives up. Killing the claimers themselves is a task for you though; the utility won't do it for you. [...]
458 92 46_Re: DB2 V9 z/OS - how to get rid of claimers ?10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 1 Oct 2009 11:09:14 +0200635_US-ASCII Well we had in the past a similar problem, but using a REXX (which was democratic, killed ALL claimers using that table, usually you cannot manage all claimers to detect the good and the evil ) sometimes we 'killed' the wrong claimer causing rollbacks (long rollbacks sometimes). When DDF connections were limited it was easy, but now with all java programs, ODBC connections, connection coming from everywhere in the universe etc. cancelling a thread could be dangerous leaving some thread indoubt (it happened twice). In some shops they canceled/restarted DDF before reorg (some years ago, anyway). If you're behind in [...]
551 191 45_DB2 will not release mounted log archive tape11_Krnic, Ivan23_Ivan.Krnic@ALLSTATE.COM30_Thu, 1 Oct 2009 06:24:40 -0500558_us-ascii
DB2 will on occasion call for mount of old archived tape log
in order to perform particular work.
Once done, DB2 does not release this tape. It remains allocated
until it is recycled. Is there a way to dismount this tape prior to recycle???
Ivan Krnic
DBA
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
743 129 10_Re: STDSQL13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Thu, 1 Oct 2009 08:14:50 -0400370_utf-8 Do the Begin/End Declare sections do more than provide documentation of the location of your host variables?
My choice would be STDSQL(NO) and making the begin/end section clauses comments.
I suppose I'm missing something though.
If you code your own version of SQLCA, you're asking for maintenance with any new release of DB2, possibly. [...]
873 82 30_Re: DB2 Connect Gateway Server12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Thu, 1 Oct 2009 12:36:50 +0000348_UTF-8 Jeff, as long as you only connect via Java type 4 (DB2 Universal Driver), there's no need to install DB2 clients. To my experience, new jar files are not necessarily required with every update of the Gateway, but certain version upgrades of the Java driver require you to bind new packages to the target system - rather simple and easy. [...]
956 35 62_New APAR PK96661 if the table is PBG and have Editproc on this11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Thu, 1 Oct 2009 13:06:45 +0000343_utf-8 Hi All, Earlier i have put a warning if you are in DBv9 and having PBG tables with Editproc. There is a problem with the tables having Editproc and defined as PBG, when DB2 tries to add new partition it fails and create dumps. This has caused a big outage for us. IBM is working on the APAR PK96661 for this. It should be out soon. [...]
992 339 44_Re: V8 APAR PK46170 - v7 compiler for DB2 v813_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM30_Thu, 1 Oct 2009 09:52:18 -0400470_us-ascii Hello Bala, If you are having a production freeze, and will no longer need to re-compile any of the old COBOL programs, then you do not need to do or change anything. If you do need to re-compile an older COBOL program after moving to DB2 V8 in CM, then what this PTF provides is an alternate batch pre-compiler, named DSNHPC7 instead of DSNHPC. You simply change that one PGM= statement in your compile JCL for the older COBOL programs, and all is happy. [...]
1332 110 30_Re: DB2 Connect Gateway Server16_Wolters, Jeff B.24_Jeff.Wolters@PGNMAIL.COM30_Thu, 1 Oct 2009 10:02:17 -0400439_us-ascii Jeff,
1) With the gateway I assume there is still some kind of thin client on each PC which would still need to be kept current. Is that true?
We have DB2 Connect Enterprise Server on two corporate servers that are behind a "content sensitive switch" for load balancing and for maintenance windows (so both servers are never out of service during maintenance). We run DB2 Connect admin client V8.2 on the PC's. [...]
1443 149 30_Re: DB2 Connect Gateway Server15_Schade, Jeffrey15_JSchade@ISO.COM30_Thu, 1 Oct 2009 10:18:26 -0400627_us-ascii I want to thank all those who replied to my question. This is very good information and gives me an idea how to size this effort.
Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering
ISO 545 Washington Boulevard Jersey City, NJ 07310 Voice: (201) 469-3738 FAX: (201) 748-1500 jschade@iso.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Wolters, Jeff B. Sent: Thursday, October 01, 2009 10:02 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Connect Gateway Server [...]
1593 258 24_Plan Management Question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Thu, 1 Oct 2009 11:52:29 -0500373_us-ascii This one is for Troy Coleman or any other Plan Management Guru.
If we have rebound using control cards, not the zparm setting, to save the original bind as a backup. How do we identify that the saved bind is there? I cannot find an entry in the catalog. If someone switched back and forth how do we determine what which bind is active? [...]
1852 154 32_DB2 V8 z/OS - SQL/VIEW question.13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US30_Thu, 1 Oct 2009 10:34:29 -0700426_us-ascii Esteemed SQL gurus,
Help! I can't figure this out so I thought I would ask the experts. I need to create a view that will return a 'Y' or 'N' depending on the existence of a row. Here is my clumsy attempt.
SELECT CASE WHEN T2.CUST_NO IS NULL THEN 'N' ELSE 'Y' END AS SWITCH FROM ( SELECT 'Y' AS X FROM SYSIBM.SYSDUMMY1) AS T1 LEFT OUTER JOIN (SELECT C.CUST_NO FROM MMAIN1.TABLE1 C ) AS T2 ON 1 = 1 [...]
2007 234 36_Re: DB2 V8 z/OS - SQL/VIEW question.14_Arnold, Mark S20_Mark.Arnold@BNSF.COM30_Thu, 1 Oct 2009 13:16:57 -0500609_us-ascii If I'm understanding what you want, wouldn't a function be the solution? Something like:
Create function xx.IS_CUSTOMER(in_cust_no char(10)) returns char(1)
declare valid_cust char(1); set valid_cust = 'N';
select 'Y' from MMAIN1.TABLE1 C where C.CUST_NO = in_custno;
return valid_cust; end
________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of BOND Victor A Sent: Thursday, October 01, 2009 12:34 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 V8 z/OS - SQL/VIEW question. [...]
2242 346 49_Re: DB2 will not release mounted log archive tape13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM30_Thu, 1 Oct 2009 14:19:36 -0400529_us-ascii Hello Ivan, are you sure that you don't have something site-specific, like an automation tool, doing a mount for your DB2 ? If not, I don't know of any command to release the tape, normally it should deallocate dynamically when the rollback or whatever needed it is finished. On a side note, and assuming this is z/OS we are talking about, most shops changed over to having their archive logs on disk and then letting DFHSM migrate them to tape. If you have enough DASD to accommodate that , I highly recommend it. [...]
2589 85 36_Re: DB2 V8 z/OS - SQL/VIEW question.14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 1 Oct 2009 14:20:12 -0400350_iso-8859-1 Interesting! Victor, I think you're going about this the wrong way. Try this view:
SELECT 'N' FROM SYSIBM.SYSDUMMY1 WHERE NOT EXISTS (SELECT C.CUST_NO FROM MMAIN1.TABLE1 C) UNION SELECT 'Y' FROM MMAIN1.TABLE1
By the way, you know your query returns a 'Y' if _any_ row exists in that table, right? You might prefer this: [...]
2675 101 36_Re: DB2 V8 z/OS - SQL/VIEW question.14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 1 Oct 2009 14:40:07 -0400371_iso-8859-1 Okay, my first attempt sucked because I didn't read the problem correctly. I can't get a row to exist in the view for a nonexistent CUST_NO. Your program SQL has to pose the existence test or you don't have a way to generate the no-customer return.
If you want simple SQL, you'll probably have to use a stored procedure to return the value. --Phil [...]
2777 32 36_Re: DB2 V8 z/OS - SQL/VIEW question.14_Peter Vanroose17_pvanroose@ABIS.BE30_Thu, 1 Oct 2009 18:24:55 +0000353_UTF-8 Try this:
CREATE VIEW cust_exists (bool) AS (SELECT CASE COUNT(*) WHEN 0 THEN 'N' ELSE 'Y' END FROM MMAIN1.table1 WHERE cust_no = .... )
The access path for the above is an index-only matching index access on the cust_no index which (I assume) is the primary key of table1.
-- Peter Vanroose, ABIS Training & Consulting. [...]
2810 28 28_Re: Plan Management Question11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Thu, 1 Oct 2009 18:56:13 +0000698_utf-8 Hi Gerald, What is the version of DB2 ? Are you rinning on DB2V9 ?
Thanks Mukesh Jain DB2 DBA & System programmer (517) 9801064
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "I had my first experience with certifications (and passed)! I learned a lot about DB2 version 9 (LUW) that hopefully will enable me to convince management a timely migration will be of benefit for the business." _____________________________________________________________________
2839 39 69_Survey: What are the best resources for answering your DB2 questions?16_Michael A Wendel19_mawendel@US.IBM.COM30_Thu, 1 Oct 2009 11:58:23 -0700461_US-ASCII The DB2 for z/OS Information Development team wants to know how you find answers to your questions about DB2 for z/OS. We are particularly interested in how you use social media tools like forums, blogs, RSS feeds, Linked In, Facebook, Twitter, or other online collaboration tools.
Please complete the following short survey to help us learn about the DB2 resources that you use the most: https://www-950.ibm.com/survey/oid/wsb.dll/s/ag25e [...]
2879 58 28_Re: Plan Management Question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Thu, 1 Oct 2009 14:36:23 -0500423_utf-8 Mukesh:
Yes, it is Version 9 we are working with on this question. Where else would we be?
Gerald Hodge HLS Technologies, Inc. www.hlstechnologies.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mukesh Jain Sent: Thursday, October 01, 2009 1:56 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Plan Management Question [...]
2938 58 36_Re: DB2 V8 z/OS - SQL/VIEW question.13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US30_Thu, 1 Oct 2009 12:37:10 -0700374_us-ascii Peter, Sorry I wasn't clear. I need to be able to supply the cust_no when I execute the view. Thanks, Victor
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter Vanroose Sent: Thursday, October 01, 2009 11:25 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 V8 z/OS - SQL/VIEW question. [...]
2997 231 28_Re: Plan Management Question13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Thu, 1 Oct 2009 14:42:48 -0500530_ISO-8859-1 Hey Gerry, is it OK if I take shot at an answer for you?... (smile)...
Take a look at the column DTYPE in SYSIBM.SYSPACKDEP, where DTYPE is "O" or "P".
Willie
Gerald Hodge wrote: > > This one is for Troy Coleman or any other Plan Management Guru. > > > > If we have rebound using control cards, not the zparm setting, to save > the original bind as a backup. How do we identify that the saved bind > is there? I cannot find an entry in the catalog. If someone switched > back and forth how do [...]
3229 615 28_Re: Plan Management Question15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Thu, 1 Oct 2009 16:08:00 -0400624_us-ascii Hi Gerald,
I assume you are talking about Plan Stability http://www-01.ibm.com/support/docview.wss?uid=swg1PK52523
This is not stored in the catalog. It is being stored in the directory.
The purpose is to save off the "good" access path.
If you REBIND and change any of the following you will lose your original access path:
OWNER
QUALIFIER
DBPROTOCOL
ENABLE
DISABLE
PATH
PATHDEFAULT
IMMEDWRITE
I am not aware of any way to compare the ORIGINAL access path with the current ACCESS PATH. [...]
3845 256 36_Re: DB2 V8 z/OS - SQL/VIEW question.14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM30_Thu, 1 Oct 2009 15:21:58 -0500533_us-ascii Victor If you have a table where all the key values exist you can use the following query for your view :
SELECT A.KEY, VALUE((SELECT 'Y' FROM MMAIN1 B WHERE B.KEY = A.KEY),'N') FROM TAB_WITH_ALL_THE_KEYS A
HTH Khalid
Okay, my first attempt sucked because I didn't read the problem correctly.
I can't get a row to exist in the view for a nonexistent CUST_NO. Your program SQL has to pose the existence test or you don't have a way to generate the no-customer return. [...]
4102 771 28_Re: Plan Management Question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Thu, 1 Oct 2009 15:32:21 -0500431_us-ascii Troy:
Thanks for the answer. The name for the function appears to be in flux. Our question is how do we know what is there. We are not supposed to read the directory. We also understand the purpose and with caution recommend its use. Our only solution to date is to add a comment to the SYSPACKAGE entry. This has to be done separately from the bind or the switch and so could get out of sync. [...]
4874 56 28_Re: Plan Management Question3_W F20_myblackz06@GMAIL.COM30_Thu, 1 Oct 2009 15:45:59 -0500317_ISO-8859-1 Hey Gerry, is it OK if I take shot at an answer for you?... (smile)...
Take a look at the column DTYPE in SYSIBM.SYSPACKDEP, where DTYPE is "O" or "P". That will tell you which copy the package is. You can probably join this to SYSIBM.SYSPACKAGE to list more pacakge details and maybe a count. [...]
4931 190 10_Re: STDSQL15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Thu, 1 Oct 2009 16:07:47 -0600368_us-ascii Not really. We're converting from VSE where the DECLARE SECTION markers are required. And visually I think it helps a bit, and it makes people keep all of the host variables in one place. But perhaps that isn't really important. And as you said, they could be included and just commented out. I may survey some of our developers and see what they think. [...]
5122 148 102_IDUG Regional Forums - coming in Novemeber (Camp Hill PA, Dallas, austin, Minneapolis and Kansas City)11_Suresh Sane21_data_arch@HOTMAIL.COM30_Thu, 1 Oct 2009 17:14:09 -0500403_Windows-1252
Trouble with travel budgets?
IDUG is bringing training to your home-town...the top-notch speakers you've come to know and trust from IDUG!
If you live near Camp Hill PA, Dallas, Austin, Minneapolis or Kansas City, please read on ......,
2 days / 2 parallel tracks (z/OS and LUW)
Day 1 – 4 x 90 minute sessions per track Day 2 – Educational seminars [...]
5271 561 28_Re: Plan Management Question15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Thu, 1 Oct 2009 23:16:35 -0400758_us-ascii Interesting in that this didn't show up in a log update... I'll have to look at the logs again.
Thanks for the note Willie.
Troy Coleman
CA, Inc.
Principal Product Manager
Office: +1630 505 6025
Mobile: +1224 343 0073
Blog: http://ibmsystemsmag.blogs.com/db2utor/
Twitter: http://twitter.com/DB2utor
Twitter: http://twitter.com/troycoleman
Linkedin: http://www.linkedin.com/in/troylcoleman
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Thursday, October 01, 2009 2:43 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Plan Management Question [...]
5833 371 36_AW: [DB2-L] Plan Management Question35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Fri, 2 Oct 2009 11:18:20 +0200565_iso-8859-1 Hi Gerald
We are using this feature in our production system, but up to now, never had an issue, that we have to switch back to a prevoius or to the original copy.
As Willie already mentioned, you can see in SYSPACKDEP, if there are any previous (DTYPE = P) or original (DTYPE = O) copies. If you always bind with EXPLAIN(YES) (I believe you do that), then it's easy to get the access path for the original copy (the access path with the lowest bindtime for that version) and the current (the access path with a bindtime which matches [...]
6205 622 40_Re: AW: [DB2-L] Plan Management Question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Fri, 2 Oct 2009 05:06:08 -0500400_iso-8859-1 Walter:
This makes some sense. We will have to experiment. The explains are not the problem for the moment. However, I agree that finding the explain may present issues. We have a way for the present bind of recreating the explain without doing a bind or rebind. The question is matching it to an entry in the catalog. I will keep you informed of our findings. [...]
6828 62 52_Load Utility with SEQUENCE column assign next number14_Gwyn Pritchard27_Gwyn.Pritchard@BARCLAYS.COM30_Fri, 2 Oct 2009 11:52:08 +0000300_utf-8 I cannot find any documentation that confirms whether there is special syntax in the Load Utility (in V8 or above) that supports a Table with a Sequence Column.
So when you run a Load Utility for each row loaded it takes care of the SEQUENCE number by accessig the SEQUENCE object. [...]
6891 26 54_DB2 V9 for z/OS : Row change timestamp column overhead20_Jeroen van der Molen35_jeroen.van-der-molen@CORUSGROUP.COM30_Fri, 2 Oct 2009 12:32:52 +0000424_UTF-8 We've been experimenting (on small scale) with the Row Change Timestamp Column. We haven't been able to determine the amount of overhead this column generates. Does anyone have any experience with this type of column on a larger scale? And what are your findings?
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
6918 339 36_AW: [DB2-L] Plan Management Question35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Fri, 2 Oct 2009 16:20:28 +0200344_iso-8859-1 Gerald
I think, I didn't understand your first question correctly. What do you mena with "what bind is active"? It's always the current bind.
P.S,. If have heard rumors, that IBM will store each bind in the catalog, I am not sure where in SYSPACKAGE or in SYSPACKDEP.
Mit freundlichen Grüßen Walter Janißen [...]
7258 105 64_AW: [DB2-L] Load Utility with SEQUENCE column assign next number35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Fri, 2 Oct 2009 16:27:16 +0200455_iso-8859-1 Hi
I am not sure, if I understand you correctly. Are you talking DB2 z/OS? A sequence is not tied to a table, so you can use a sequence object for whatever you want. If you want to use a sequence object for a table, you may be look for identity generated always. Then DB2 will generate numbers during load. Afterwords you can alter the identity to generated by default and don't use it. Alter the sequence object to the next value. [...]
7364 566 40_Re: AW: [DB2-L] Plan Management Question12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Fri, 2 Oct 2009 09:46:20 -0500489_iso-8859-1 Walter:
There are all sorts of things coming. Unfortunately, we are covered by non-disclosures and so I must not go on with this.
Gerald Hodge
HLS Technologies, Inc.
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walter Jani ßen Sent: Friday, October 02, 2009 9:20 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] AW: [DB2-L] Plan Management Question [...]
7931 72 55_Re: How to change UDB enterprise edition to Workgroup ?13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM30_Fri, 2 Oct 2009 09:51:20 -0700399_ISO-8859-1 Since you're on DB2 v8.1, the most straight-forward method for doing this is to uninstall the existing ESE code and then install the WSE code.
You do not need to drop your instances since the WSE code will be installed in the same location that these ESE code was installed (/usr/opt/db2_08_01). You do need to shut down your DB2 (and DAS) instances during this work, though. [...]
8004 149 28_Re: Plan Management Question15_Douwe van Sluis21_d.b.van.sluis@HOME.NL30_Fri, 2 Oct 2009 21:22:46 +0200462_us-ascii Also make sure you keep your PLAN_TABLE entries around for the "saved packages". You need to match bind timestamp to find the right accesspath in the PLAN_TABLEs.
Vriendelijke groet, Douwe van Sluis
-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens W F Verzonden: donderdag 1 oktober 2009 22:46 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: Re: [DB2-L] Plan Management Question [...]
8154 314 36_Re: DB2 V8 z/OS - SQL/VIEW question.13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US30_Mon, 5 Oct 2009 13:29:18 -0700462_us-ascii Slick, unfortunately no such table exists. I decided to go with the sql stored procedure. Thanks everyone for your help and suggestions. I learn something new from you folks every day.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan Sent: Thursday, October 01, 2009 1:22 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 V8 z/OS - SQL/VIEW question. [...]
8469 22 35_Irwin Deutsch is out of the office.13_Irwin Deutsch28_ideutsch@PRINCESSCRUISES.COM30_Mon, 5 Oct 2009 16:02:44 -0700550_US-ASCII I will be out of the office starting 10/05/2009 and will not return until 10/13/2009.
I will respond to your message when I return.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "Conference was superb! Couldn’t fault anything. Very impressed." _____________________________________________________________________
8492 503 55_Re: DB2-L Digest - 3 Oct 2009 to 6 Oct 2009 (#2009-285)13_David Chapman24_David.Chapman@IAG.COM.AU30_Tue, 6 Oct 2009 12:40:25 +1100774_us-ascii _______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________
Hi Victor,
Here's some SQL that worked for me, I used a subselect on SYSTABLES to prove that it worked:
SQL #1 did not return a row: ---------------------------------- select 'Y' as found from sysibm.sysdummy1 where exists ( select 1 from sysibm.systables where creator = 'SYSIBM' and name = 'VICTOR') union all select 'N' as found from sysibm.sysdummy1 where not exists ( select 1 from sysibm.systables where creator = 'SYSIBM' and name = 'VICTOR') with ur ; [...]
8996 447 36_Re: DB2 V8 z/OS - SQL/VIEW question.17_Tunen, Marcel van31_Marcel.van-Tunen@CORUSGROUP.COM30_Tue, 6 Oct 2009 08:52:11 +0200312_us-ascii This works for V9, don't know if it does for v8?
with v1 as ( select 1 as col1 from sysibm.sysdummye ) ,v2 as ( select 1 as col2, yourtabelcolumn from yourtable where yourtabelcolumn = ???? ) select case when yourtabelcolumn is null then 'N' else 'Y' end from v1 left join v2 on col1 = col2 [...]
9444 22 14_Happy Birthday15_Michael Bednarz24_michael.bednarz@CITI.COM30_Tue, 6 Oct 2009 07:25:36 +0000526_utf-8 Off Topic!
Happy Birthday to Roy Boxwell!
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________
9467 171 62_connection-problem between a websphere-server and db2 on z/Os.14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Tue, 6 Oct 2009 11:36:39 +0200575_us-ascii Hi,
We are on z/Os v1.8 and db2 v8.1 rsu0806.
I have a connection-problem between a websphere-server and db2 on z/Os.
I find the next message in the master of db2.
16.42.01 STC25617 DSNL032I
335 REQUEST FROM REQUESTOR LOCATION=192.168.52.36 FOR THREAD WITH
335 LUWID=C0A83424.GB78.C4E050A436B4
335 REASON=00D3101A
335 ERROR ID=DSNLIRTR0003
335 IFCID=0192
335 SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000001 [...]
9639 78 66_Re: connection-problem between a websphere-server and db2 on z/Os.14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Tue, 6 Oct 2009 21:22:56 +1100484_US-ASCII I once had a similar sort of problem when the remote server was using a three part name. So I had
remote <-> intermediate <-> real server
The intermediate server had been upgraded to a later version of DB2 than the real server. Consequently when the remote server negoitated the DRDA level to use, it ended up thinking thought it could use a later version of DRDA - but the real server couldn't understand it - seeing the message as syntactically invalid. [...]
9718 232 51_DB2 for LUW, Recommended datatypes for partitioning35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE30_Tue, 6 Oct 2009 12:56:40 +0200919_iso-8859-1 Hi everyone out there,
is there a recommendation as to which data types to prefer when range-partitioning a table ?
Rumour has it that INTEGER-columns are to be prefered while TIMESTAMP/DATE/TIME-columns should not be used.
Any comments ?
Thanks a lot in advance
best regards
Ruediger
Rüdiger Kurtz Abteilung Informatik Betrieb
HUK-COBURG Bahnhofsplatz 96444 Coburg Telefon 09561 96-44147 Telefax 09561 96-44104 E-Mail Ruediger.Kurtz@HUK-COBURG.de Internet www.HUK.de ============================================================= HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021 Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg Vorsitzender des Aufsichtsrats: Werner Strohmayr. Vorstand: Dr. Wolfgang Weiler (Sprecher), Wolfgang Flaßhoff, Stefan [...]
9951 311 66_Re: connection-problem between a websphere-server and db2 on z/Os.9_Chris Tee25_chris.tee@NOVAMAGIC.CO.UK30_Tue, 6 Oct 2009 11:14:07 +0000669_iso-8859-1
Patrick
have you had a look at PTF PK79004? http://www-01.ibm.com/support/docview.wss?uid=isg1PK79004
Regards
Chris
Date: Tue, 6 Oct 2009 11:36:39 +0200 From: Patrick.Steurs@NBB.BE To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] connection-problem between a websphere-server and db2 on z/Os.
Hi,
We are on z/Os v1.8 and db2 v8.1 rsu0806.
I have a connection-problem between a websphere-server and db2 on z/Os.
I find the next message in the master of db2. [...]
10263 351 66_Re: connection-problem between a websphere-server and db2 on z/Os.14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Tue, 6 Oct 2009 13:30:18 +0200473_us-ascii Hi,
Yes, I had already a look at this PTF, but our network-guy told me it didn't make sense in our configuration.
greetings
Patrick
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Tee Sent: dinsdag 6 oktober 2009 13:14 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] connection-problem between a websphere-server and db2 on z/Os. [...]
10615 34 68_Re: AW: [DB2-L] Load Utility with SEQUENCE column assign next number14_Gwyn Pritchard27_Gwyn.Pritchard@BARCLAYS.COM30_Tue, 6 Oct 2009 13:15:15 +0000373_utf-8 Walter,
Thank you for responding so quickly, I should have said DB2 for zOS.
We looked at Identifiers and we are concerned that number might get re- generated (unload/reload) and since the assigned key will be the primary key across several Tables we cannot risk this. Hence Sequencers seems to be a good option but don't get assigned during Load. [...]
10650 48 18_Re: Happy Birthday10_Roger Hecq18_Roger.Hecq@UBS.COM30_Tue, 6 Oct 2009 09:25:26 -0400419_US-ASCII Another 10 and Roy will be old enough to be an IMS DBA
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Bednarz Sent: Tuesday, October 06, 2009 3:26 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Happy Birthday
Off Topic!
Happy Birthday to Roy Boxwell! [...]
10699 53 26_AW: [DB2-L] Happy Birthday12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 6 Oct 2009 15:45:02 +0200423_US-ASCII >>>> Another 10 and Roy will be old enough to be an IMS DBA <<<< ------------------------------------------------------------------------ ------
Hmmmm, in one of our last DB2 GUIDE meetings the chairman asks the attendees how old they are.....
Under 30 years - no one. Under 40 years - a few of the attendees. Under 50 years - some more people. Under/over 60 years - most of the attendees...... [...]
10753 191 18_Re: Happy Birthday11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 6 Oct 2009 15:50:16 +0200477_ISO-8859-1 I thank you from the Italian IDUG Europe.....my session is tomorrow by the way A10....now officially 44 and counting...
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert [...]
10945 97 18_Re: Happy Birthday0_24_carol.sutfin@REGIONS.COM30_Tue, 6 Oct 2009 09:29:14 -0500438_US-ASCII I don't know if that makes me old or just experienced.
I was an IMS DBA 30 years ago long before DB2.
Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com
Roger Hecq To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] Happy Birthday
10/06/2009 08:25 AM [...]
11043 67 18_Re: Happy Birthday12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM30_Tue, 6 Oct 2009 10:37:01 -0400806_US-ASCII I was an IMS system programmer about 30 years ago also. but that was straight out of 1st grade. :)
Jeffrey E. Frazier Lead Specialist - Infrastructure Services Wendy's/ Arby's Group Inc. 'Sometimes the road less traveled is less traveled for a reason' Notice: This e-mail message and its attachments are the property of Wendy's/Arby's Group Inc. or one of its subsidiaries and may contain confidential or legally privileged information intended solely for the use of the addressee(s). If you are not an intended recipient, then any use, copying or distribution of this message [...]
11111 147 18_Re: Happy Birthday10_Roger Hecq18_Roger.Hecq@UBS.COM30_Tue, 6 Oct 2009 10:47:41 -0400442_US-ASCII It makes you an invaluable, experienced resource.
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of carol.sutfin@REGIONS.COM Sent: Tuesday, October 06, 2009 10:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
I don't know if that makes me old or just experienced. [...]
11259 190 18_Re: Happy Birthday35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Tue, 6 Oct 2009 11:20:47 -0400453_iso-8859-1 I started on IMS in 1970....
Seems like yesterday...
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com
Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]
11450 533 18_Re: Happy Birthday14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 6 Oct 2009 11:41:06 -0400672_us-ascii ...I started junior high in 1970... --Phil Sevetson
________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Tuesday, October 06, 2009 11:21 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
I started on IMS in 1970....
Seems like yesterday...
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...]
11984 27 21_IDUG Abstract Cut Off10_Todd Burch17_toddburch@MAC.COM30_Tue, 6 Oct 2009 11:33:14 -0500266_US-ASCII I saw the cut off was this last Sunday, 10/4. I already had one suggestion in, but I sent another one last night - so I missed the cut off by a day.
What do you think the odds are of it being accepted anyways for consideration for IDUG NA 2010? [...]
12012 251 18_Re: Happy Birthday11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 6 Oct 2009 22:23:50 +0200638_ISO-8859-1 that wouldnt be a personal anecdote would it ???? :)
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert
Roger Hecq Gesendet von: DB2 Data Base Discussion List 06.10.2009 15:25 Bitte antworten an DB2 Database Discussion list at IDUG [...]
12264 267 30_Re: AW: [DB2-L] Happy Birthday11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 6 Oct 2009 22:37:22 +0200479_ISO-8859-1 strange you should mention that, I talked with a woman today at the stand and she said there was no-one under 30 there...
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert [...]
12532 145 18_Re: Happy Birthday12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 6 Oct 2009 13:50:28 -0700483_us-ascii I wish that I could say I was young enough that I was an IMS DBA only 30 years ago. Some of my IMS documentation states that features of the 360 operating system hadn't been designed yet, but that they expected to work such and so.
Myronn
________________________________ From: "carol.sutfin@REGIONS.COM" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, October 6, 2009 10:29:14 AM Subject: Re: [DB2-L] Happy Birthday [...]
12678 49 43_Reorg compression dictionary and partitions12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 6 Oct 2009 13:59:58 -0700330_us-ascii We had a situation happen yesterday that really puzzled us. We have a tablespace that was partitioned into two partitions and was compressed. It ran out of space in the second partition even though the limit key was not even close to being exceeded. And it was Index partitioned rather than table based partitioned. [...]
12728 282 18_Re: Happy Birthday10_Roger Hecq18_Roger.Hecq@UBS.COM30_Tue, 6 Oct 2009 17:06:07 -0400649_iso-8859-1 :-)
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: Tuesday, October 06, 2009 4:24 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
that wouldnt be a personal anecdote would it ???? :)
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...]
13011 310 23_Stored Procedure Limits19_Claypool, Alisa@EDD25_Alisa.Claypool@EDD.CA.GOV30_Tue, 6 Oct 2009 17:09:40 -0700393_us-ascii All,
A colleague has the following question.
Is there any documentation which states the stored procedure limits? Is there a limit to the number of parameters that can be passed? A limit for the amount of data passed? I'm using V8 on z/OS and creating the SPs within the Development Center.
Thanks in advance. [...]
13322 158 18_Re: Happy Birthday13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Tue, 6 Oct 2009 22:08:50 -0500603_ISO-8859-1 Just to join in on the fun...
I started my database career with IMS/360 (that's before there was an IMS/VS if you're counting).... I'm talking punch cards for maintenance... Between IMS and DB2 I'll be passing 33 years working on database this year.
And...
Happy Birthday Roy
Willie
Jeff Frazier wrote: > > I was an IMS system programmer about 30 years ago also. > but that was straight out of 1st grade. :) > > > Jeffrey E. Frazier > Lead Specialist - Infrastructure Services > Wendy's/ Arby's Group Inc. > 'Sometimes the road less traveled > is less [...]
13481 141 18_Re: Happy Birthday14_Wayne Driscoll18_wdrisco@US.IBM.COM30_Tue, 6 Oct 2009 23:11:07 -0500403_US-ASCII Ok, time for another perspective. One of the great things about working in the System z arena is the fact that it is one of the few areas where a 42 year old with only 20 years of experience is "one of the kids."
=============================================== Wayne Driscoll OMEGAMON DB2 L3 Support/Development wdrisco(AT)us.ibm.com =============================================== [...]
13623 288 18_Re: Happy Birthday10_Roger Hecq18_Roger.Hecq@UBS.COM30_Wed, 7 Oct 2009 07:48:09 -0400562_iso-8859-1 Since I forgot the first time, Happy Birthday - Frohliches Geburtstag. Best wishes for many more. You can start using slightly larger candles for the decades, so that you don't destroy the cake and set off the fire alarms.
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: Tuesday, October 06, 2009 4:24 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...]
13912 228 18_Re: Happy Birthday10_Roger Hecq18_Roger.Hecq@UBS.COM30_Wed, 7 Oct 2009 07:52:02 -0400448_US-ASCII We had TOS, DOS, 'Big OZ', and rows of cabinets full of cards. With Think pads & pocket protectors!
Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Tuesday, October 06, 2009 11:09 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...]
14141 292 18_Re: Happy Birthday11_Roy Boxwell16_R.Boxwell@SEG.DE30_Wed, 7 Oct 2009 15:09:20 +0200651_ISO-8859-1 ROTFLMAO...I might be old but I still know some SMS codes....
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de
Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert
Wayne Driscoll Gesendet von: DB2 Data Base Discussion List 07.10.2009 06:11 Bitte antworten an DB2 Database Discussion list at IDUG [...]
14434 144 18_Re: Happy Birthday12_Isaac Yassin20_yassini@BEZEQINT.NET30_Wed, 7 Oct 2009 15:16:16 +0200673_iso-8859-1 Hi,
Started on 1976
Isaac
---- Original message ---- >Date: Tue, 6 Oct 2009 11:20:47 -0400 >From: Joel Goldstein - Responsive Systems >Subject: Re: [DB2-L] Happy Birthday >To: DB2-L@WWW.IDUGDB2-L.ORG > > I started on IMS in 1970.... > > Seems like yesterday... > > Joel Goldstein > Responsive Systems > IBM Gold Consultant > Buffer Pool Tool for DB2, the worldwide industry > standard > Performance software that works...... > Predicts IO Rate !! > Predicts Group Buffer Pool performance too > www.responsivesystems.com > > Buffer Pool Tool for DB2 on www.LinkedIn.com > Watch the 3-Minute Buffer Pool Tool [...]
14579 136 18_Re: Happy Birthday20_Bruzdzinski, Michael27_Michael.Bruzdzinski@SSA.GOV30_Wed, 7 Oct 2009 09:51:24 -0400606_iso-8859-1 Does anyone remember the RCA Spectra or CDC3500 machines?
Michael Bruzdzinski Social Security Administration DCS/OESAE/DDBS/DBSB 410-966-7185 (voice) 443-379-2282 (Blackberry)
The maxim is "qui tacet consentire." The maxim of the law is "Silence gives consent." - the character of Sir Thomas More in A Man for All Seasons by Robert Bolt
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Isaac Yassin Sent: Wednesday, October 07, 2009 9:16 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...]
14716 219 18_Re: Happy Birthday0_24_carol.sutfin@REGIONS.COM30_Wed, 7 Oct 2009 10:21:56 -0500451_ISO-8859-1 I worked on RCA machines many years ago. 1960's
If my memory serves, it was at a Railroad that has since gone out of business.
Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com
"Bruzdzinski, Michael" DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc Base Discussion List Subject [...]
14936 236 18_Re: Happy Birthday10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV30_Wed, 7 Oct 2009 10:48:08 -0500410_iso-8859-1 While it may be true that dinosaurs have small brains apparently they have GREAT memories. : )
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of carol.sutfin@REGIONS.COM Sent: Wednesday, October 07, 2009 10:22 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
I worked on RCA machines many years ago. 1960's [...]
15173 38 38_IDUG Members Get a Discount to IBM IOD19_McBride, Michael C.31_michael.mcbride@DOT.STATE.FL.US30_Wed, 7 Oct 2009 16:08:09 +0000347_utf-8 Just wanted to remind everyone that IDUG members get a registration discount for the 2009 IBM Information On Demand Global Conference, October 25 - 29 in Las Vegas. As you know, IOD is the premier IBM event featuring leading-edge solutions from across IBM software, hardware and services, including DB2-related sessions and activities. [...]
15212 263 18_Re: Happy Birthday15_Gaston, Raymond17_GastonRay@ORU.COM30_Wed, 7 Oct 2009 12:18:50 -0400369_iso-8859-1 _.-_ __.' o "-. ___----"" ,,,' __--" _-_ ^^; ____--"" ___ _-\" `"" ..--===-------""" "( __-" ,} .'_/"\ .'/" `\`._ "-_c " '
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: Wednesday, October 07, 2009 11:48 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...]
15476 59 18_Re: Happy Birthday13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Wed, 7 Oct 2009 18:33:39 +0200288_us-ascii B*gger me, that got a laugh. I could do with it after having to see Mr. Boxwell every day so far at IDUG. I mean, it might be his birthday 'n' all but jeez, a guy has his limits!
Mr. Gaston, I just hope you drew that brilliant picture not on company time. Very good! [...]
15536 85 18_Re: Happy Birthday15_Gaston, Raymond17_GastonRay@ORU.COM30_Wed, 7 Oct 2009 13:07:56 -0400585_us-ascii Raymond...
Can't take credit for the picture. Actually saved it from an early 2001-1002 DB2 Discussion List. But it is "brilliant".
- Ray
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond Sent: Wednesday, October 07, 2009 12:34 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
B*gger me, that got a laugh. I could do with it after having to see Mr. Boxwell every day so far at IDUG. I mean, it might be his birthday 'n' all but jeez, a guy has his limits! [...]
15622 164 18_Re: Happy Birthday13_George Toolan19_gtoolan@COMCAST.NET30_Wed, 7 Oct 2009 13:48:54 -0400363_iso-8859-1 I took a COBOL course at a college in Lawton, OK that was remotely linked to a Spectra (70?) at the U of OK
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bruzdzinski, Michael Sent: Wednesday, October 07, 2009 9:51 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...]
15787 28 18_Re: Happy Birthday14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM30_Wed, 7 Oct 2009 13:16:47 -0500468_us-ascii When Christopher and I landed and took those first steps on what we thought was the East-Asian mainland.....
This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message. [...]
15816 74 24_Space Estimation in z/OS7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Wed, 7 Oct 2009 14:09:13 -0400371_ISO-8859-1 Hello:
We have about 27 volumes associated to the one of the SGs (the one I am interested in).
However, it is always either 4 or 5 volumes that have not used more than 10%. That is 'our threshold'. In other words, our threshold is, if there is just 3 volumes with less than 50% used, then it is a RED flag - as long as it is 4, we are good. [...]
15891 512 28_Re: Space Estimation in z/OS16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM30_Wed, 7 Oct 2009 13:30:49 -0500514_US-ASCII Josh,
In most of our production storage pools, we look for 10% free space (5% in the huge pools that have over 3 TB allocated). We also look for a specific amount of contiguous free space (say 10 or 15 extents of at least 1500 cylinders each). As long as we have adhered to these limits, we have not had a storage-related outage. Before we developed them, we had some sort of storage-related outage every couple of months. Our DASD folks had to loosen the purse strings a bit. [...]
16404 173 18_Re: Happy Birthday35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Wed, 7 Oct 2009 16:22:30 -0400448_iso-8859-1 Yes, I remember both..... How about Burroughs?
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com
Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]
16578 319 18_Re: Happy Birthday35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Wed, 7 Oct 2009 16:32:44 -0400449_iso-8859-1 How about COS? 650 with tubes??? Wiring boards?
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com
Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]
16898 47 35_DSSIZE on a partitioned tablespace.15_Marcia Dolenkei18_dolenkei@GMAIL.COM30_Wed, 7 Oct 2009 17:31:28 -0300218_ISO-8859-1 Hi All,
I have a tablespace created with DSSIZE 4 G. This tablespace has 5 partiton.
Each partiton has the limit of 4 G or the sum of the partitions size can't exceed 4 G?
Thanks
16946 768 18_Re: Happy Birthday10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV30_Wed, 7 Oct 2009 15:42:06 -0500690_us-ascii My first computer was made out of rocks and Mammoth bones. Do I win?.
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Wednesday, October 07, 2009 3:33 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
How about COS?
650 with tubes???
Wiring boards?
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...]
17715 412 18_Re: Happy Birthday10_Roger Hecq18_Roger.Hecq@UBS.COM30_Wed, 7 Oct 2009 16:45:12 -0400402_US-ASCII Now you are bringing back memories.
The 081 & 083 sorters and all of the ties that they snagged, 401, 402, & 407 accounting machines and all of the different wires, and the 514 gang punch reproducer. No machine could accordion fold cards like the 514. Splicing paper tape, after it made a paper cut 1/2 way through your finger. Using a loop and iron filings to read the mag tapes. [...]
18128 227 18_Re: Happy Birthday21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET30_Wed, 7 Oct 2009 17:18:22 -0400669_iso-8859-1 We ran all of our check sorters off of Burroughs...
Didn't Burroughs store stuff in a non binary format.. can't remember what base they used...
Willie
Joel Goldstein - Responsive Systems wrote: > Yes, I remember both..... How about Burroughs? > > > Joel Goldstein > Responsive Systems > IBM Gold Consultant > Buffer Pool Tool for DB2, the worldwide industry standard > Performance software that works...... Predicts IO Rate !! > Predicts Group Buffer Pool performance too > www.responsivesystems.com > > Buffer Pool Tool for DB2 on www.LinkedIn.com > Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 > [...]
18356 198 18_Re: Happy Birthday14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 7 Oct 2009 17:37:36 -0400387_us-ascii Burroughs here; I learned programming on a B1700 series. 128K of RAM and two removable disk drives. And LOTS of cards.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Wednesday, October 07, 2009 4:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...]
18555 199 18_Re: Happy Birthday13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US30_Wed, 7 Oct 2009 14:40:55 -0700398_us-ascii Started on a Burroughs B-200. 4K of memory, read the lights on the console.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Wednesday, October 07, 2009 1:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
Yes, I remember both..... How about Burroughs? [...]
18755 79 47_Re: Reorg compression dictionary and partitions9_Mike Bell21_mbell11a1@VERIZON.NET30_Wed, 7 Oct 2009 17:05:06 -0500343_us-ascii looking at the manual - I realized that if you specify 'compress yes' in the partition clause, it only compresses that partition. The V9 manual has an example that only compresses the odd partitions. When you added the partitions, did you specify compress yes, or were you expecting it to default from the tablespace definition? [...]
18835 141 39_Re: DSSIZE on a partitioned tablespace.13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM30_Wed, 7 Oct 2009 18:28:44 -0400579_iso-8859-1 Hello Marcia, DSSIZE=4G gives each partition a 4GB limit.
Kirk Hampton Capgemini Energy Dallas, TX
________________________________ From: DB2 Data Base Discussion List [DB2-L@IDUGDB2-L.ORG] On Behalf Of Marcia Dolenkei [dolenkei@GMAIL.COM] Sent: Wednesday, October 07, 2009 3:31 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DSSIZE on a partitioned tablespace.
Hi All,
I have a tablespace created with DSSIZE 4 G. This tablespace has 5 partiton. Each partiton has the limit of 4 G or the sum of the partitions size can't exceed 4 G? [...]
18977 73 39_Re: DSSIZE on a partitioned tablespace.12_Ayalew Kassa20_ayalakassa@YAHOO.COM30_Wed, 7 Oct 2009 15:30:58 -0700508_us-ascii Each partition should have 4 GB limit.
--- On Wed, 10/7/09, Marcia Dolenkei wrote:
From: Marcia Dolenkei Subject: [DB2-L] DSSIZE on a partitioned tablespace. To: DB2-L@WWW.IDUGDB2-L.ORG Date: Wednesday, October 7, 2009, 3:31 PM
Hi All,
I have a tablespace created with DSSIZE 4 G. This tablespace has 5 partiton. Each partiton has the limit of 4 G or the sum of the partitions size can't exceed 4 G? [...]
19051 246 18_Re: Happy Birthday12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 7 Oct 2009 15:37:44 -0700672_us-ascii Unfortunately all of them. 619, 409, etc. etc. 709, 7090, cdc 6400, etc. etc. Are all vividly remembered.
________________________________ From: Joel Goldstein - Responsive Systems To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, October 7, 2009 4:32:44 PM Subject: Re: [DB2-L] Happy Birthday
How about COS? 650 with tubes??? Wiring boards?
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...]
19298 698 18_Re: Happy Birthday13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US30_Wed, 7 Oct 2009 16:00:27 -0700630_us-ascii Wow! You had rocks? We just had lava.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: Wednesday, October 07, 2009 1:42 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday
My first computer was made out of rocks and Mammoth bones. Do I win?.
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Wednesday, October 07, 2009 3:33 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...]
19997 163 18_Re: Happy Birthday0_24_carol.sutfin@REGIONS.COM30_Wed, 7 Oct 2009 18:14:24 -0500533_UTF-8 If I recall correctly,
Burroughs and Honeywel both used octal instead of hexadecimal.
Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com
"wfavero@attgloba l.net" DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc Base Discussion List Subject
10/07/2009 04:18 PM
Please respond to DB2 Database Discussion list at IDUG [...]
20161 303 174_Upcoming IDUG Webcast - "The DB2Night Show Episode #3 - Theme: High Availability - Scott Hayes, DBI Software" - Thursday October 15 2009 at 10:00 am USA Central Daylight Time13_David Chapman24_David.Chapman@IAG.COM.AU30_Thu, 8 Oct 2009 10:25:52 +1100746_us-ascii
_______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________
Hello DB2 List,
The DB2Night Show Episode #3 - Theme: High Availability - Scott Hayes, DBI Software
The International DB2 Users Group (IDUG) is pleased to partner with DBI to deliver a free Webcast by renowned presenter Scott Hayes, President & CEO, DBI. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the presenter. Capacity is limited, so register early. [...]