Re: VOC corruption
I can relay one UV customer's experience. After months of sporadic file corruption episodes, they finally had their hardware folks come out and check over the system (one of the first things our support group had suggested, of course). They had memory boards seated in improper slots. Once they correctly re-seated the memory boards - all file corruption issues ceased. Even though the hardware diagnostic programs for this platform reported no errors - it is always prudent to check hardware. Anything that interrupts a clean movement of a block of data from memory to the physical disk platters could result in database file corruption. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Logan, David (SST - Adelaide) [EMAIL PROTECTED] To om U2 List [EMAIL PROTECTED] Sent by: cc u2-users-bounces@ oliver.comSubject VOC corruption 04/27/2004 08:05 PM Please respond to U2 Users Discussion List Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Objectcall headache...
Ken is correct that we have end-of-lifed ObjectCall - after years of advanced warnings. Regardless - we haven't removed it from the product. It is still there. You can still try to use it. We have stopped engineering work on it. Epicor does have an open case with U2 support. We are working with them to try to get it functioning for them. There are a number of sites (including Epicor sites - if I'm not mistaken - Martin/David - feel free to correct me if I'm misremembering) where ObjectCall is working with UniData 6.0.x and AIX, so why this particular system is having problems is under investigation and likely to be successfully resolved. It does rely on tcp/ip so the problems may not be with ObjectCall itself. Ascential does have a new version of DataStage that no longer uses ObjectCall. I'll let the ASCL folks elaborate if they choose. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Martin Canty [EMAIL PROTECTED] m To Sent by: U2 Users Discussion List u2-users-bounces@ [EMAIL PROTECTED] oliver.com cc Subject 04/08/2004 09:00 RE: Objectcall headache... PM Please respond to U2 Users Discussion List On behalf of Dave, let me expand. We have a DataStage job which is still relying on ObjectCall (until we can rewrite it to utilise the new UniData6 stage), unfortunately, after the UniData upgrade ObjectCall ceased to function no matter what we do we just cannot get it to work again Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Thursday, April 08, 2004 5:05 PM To: 'U2 Users Discussion List' Subject: RE: Objectcall headache... Client upgraded UD to 6.0.3 on an AIX 4.31 box. Try as I may, I can no longer get an Objectcall connection to that server. Well, IBM end-of-lifed ObjectCall a while ago, but I still think they ship it. IBM also end-of-lifed AIX 4.3 mid last year IIRC. Having just checked the availability matrix at https://www-927.ibm.com/software/data/u2/support/u2techconnect/matrix.asp, I see that 6.0.3 and 6.0.8 ARE both certified for AIX 4.3.3, but 4.3.1 definitely isn't mentioned. Moving beyond this bunch of uncertainty I have about the supportability of your client's platform set, it might be worth asking what they upgraded from and what you are trying to connect with. ObjectCall is a highly version dependent beast. If they upgraded from an early UniData version like 3.3.2 or 4.0 and went straight to 6.0, then whatever ObjectCall client piece you used to be able to connect with would now be incompatible. Anyway, how to resolve this? First push the server and client logging levels up high (level 9?), then start off on the AIX box with objping and see if you can get a connection on the same box. Once you have that working, see if you can connect an external client. HTH, Ken -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV on Itanium
Glenn: I'm curious. Do you have a 64-bit port of DataStage on Itanium (or any other 64-bit platform) at this time? Thanks Wally Terhune Manager - U2 Advanced Technical Services IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
U2 Maintenance
Folks: I really shot myself in the foot on this one. I had intended to indicate we took this seriously, but I didn't feel it needed to be discussed in this forum. IBM really does consider this a very important issue and is working very hard to rectify this. Yes, we are using a U2 database to track the license and maintenance data. We have pulled resources from our technical support group and reassigned them (temporarily) to resolving maintenance issues. This is painful - as additional technical work is added to the rest of the department's work queues - but necessary. This is just one indication of how important this issue is. We do value our clients and want this to work for you and for IBM. If you have any concerns about your particular situation, I advise you to contact your maintenance provider (if a Partner) or your IBM sales rep. If you have a direct support agreement, you may also get some direction/assistance by emailing [EMAIL PROTECTED] You may also email me directly, though I'm not personally directly involved in the project (and may not be the quickest route to resolution). I hope we can discontinue this thread on u2-users at this point. I, for one, appreciate the efforts by everyone in keeping this a technically focused forum. Please direct any additional comments to me, personally - if you like. Again - my apologies. Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online!-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Unidata 6.05 - Redhat ES 2.1 (not AS)
We have a patch for systest. While testing the limits of shared memory, the original systest (on some - not all systems) will loop beyond some pre-defined buffers and coredump. I emailed that privately to Adrian. Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Adrian Merrall [EMAIL PROTECTED] omTo Sent by: [EMAIL PROTECTED] u2-users-bounces@ cc oliver.com Subject Unidata 6.05 - Redhat ES 2.1 (not 03/01/2004 08:55 AS) PM Please respond to U2 Users Discussion List Dear All, I will give IBM a call about this but thought I would ask the list first. Before signing up for the most expensive RHEL AS option, I am checking to see if 6.0.5 will run on RHEL ES 2.1. This seems quite reasonable to me as the 2 CPU limit on the ES product would suffice for many U2 sites. The problem I have struck is the udtinstall script runs a program called $UDTBIN/systest and on ES this segfaults as below. IPC Facilities Test Results Max # of Shmem Segments: 4091 # of Shmem Seg. Per Process: 4091 Max / Min Shmem Seg. Size: 134217728 (128M) / 1 SHMLBA: 4096 (4K) Max # of Message Queues: 128 Max # of Bytes On Queue: 16384 (16K) Max Message Size: -1 (unknown) Max # of Semaphores: 128 Max # of Undo Structures: -1 Segmentation fault This is a critical part of the install as it tests system memory parameters and generates the udtconfig file. The obvious answer is ES is not a certified release, AS is, but what intrigues me is 6.0.5 is certified on pretty much everything else (7.1, 7.2, 7.3, 8.0, RHEL AS on 2 different kernels) so I'm curious as to why it seems to fail on ES. Redhat state that the WS/ES/AS versions are based on the same core kernel, libraries and utilities. I did manage a work around by commenting out the systest call in the install script and copying a udtconfig file from a temporary install of 6.0.5 on 7.3 and a quick test shows Unidata starting and stopping OK and doing some basic stuff but this isn't a solution I'd feel comfortable with. The only idea I have as to why systest is failing on ES is I have stuffed up the shared memory kernel settings (possibly) or it encounters some function enforcing the CPU or memory limits on the ES product that aren't present on the AS version or any of the other releases and chokes. So, has anyone else attempted this and did they manage to find anything? Thanks, Adrian -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Two ways to acquire the U2 Tech Support Survival Kit CD
Limited supplies will be available at the IBM booth at two upcoming conferences: Spectrum Datatel Users Group (U2 partner) Both conferences are the week of March 14. I know many of you plan to attend Spectrum. There are also a number of Datatel clients who post to this list, as well. Drop by the IBM booth! ps - I will also be speaking at the Datatel Users Group conference on Sunday March 14 - 10:00am - 12:15 pm. Then lounging around until a 4:30 round table session. Stop by and say hello... Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
The U2 Tech Support Survival Kit CD - explained
Ok. Let me shed some light on all of this... 1) The email address Tony refers to below is mine. 2) This CD was originally created as a handout for the Ardent/Informix/IBM annual user conferences. I'm sure it will be available at the DMG User Conference in Las Vegas this year (September 19-24). See you there??? 3) The intent is to provide additional technical information in a convenient/portable format that can be used to solve U2 problems without resorting to contacting IBM U2 technical support. 4) As it has been well received, we tried to expand the audience to include our support-providing distributors and partners - giving them another tool to use in providing technical assistance to their end-users. 5) More folks continued to ask for it, so we TRY to accomodate requests. We have sent it to directly supported (IBM support contract) end-users. 6) We also try not to interfer with partner/end-user relationships - by sending this directly to the end-user of a partner. 7) We did announce this in the IBM Data Management email newsletter. A secondary agenda was - 'how many folks are reading this newsletter?'. 8) If you email me asking for a copy, I will want to confirm that you are AT LEAST an active customer with an active/entitled support contract - whether it is direct or via a partner. (hint, hint - send me your U2BC serial number, though I can lookup by client name). I'm sure you can understand my perspective on this point. 9) If you are not in the US or Canada, I will forward to the U2 support group in UK or AUS and they will see if they can fulfill the request from there. 10) If you email me, I will need a full shipping address (no PO boxes) and a local phone number (both requirements of the shipper we use). 11) Our inventory is seriously depleted at this point - so if we need to re-run, there may be a significant delay. You probably won't experience Tony's excellent turn-around. 12) Most important of all, please provide feedback (to me - my team puts it together). We try to update and improve it each year. Is it useful? What's missing? Those of you who have already seen it - is it worth asking for? Any documents or presentations you find particularly useful? Regards, Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Tony Wood [EMAIL PROTECTED] om.au To Sent by: U2 Users Discussion List u2-users-bounces@ [EMAIL PROTECTED] oliver.com cc Subject 03/02/2004 03:34 Re: Two ways to acquire the U2 Tech PMSupport Survival Kit CD Please respond to U2 Users Discussion List Hi David, In the latest IBM U2 Newsletter they have an email address with instructions to get the CD sent to you. I got mine yesterday so about two to three working days. What about us down here? Is it available outside the US? Yes it is available outside the US (I'm in Melbourne). Regards, T. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Avoid using AIX extended shared memory with large UniData sites
Ken Wallis wrote (different thread): With decent tuning you should be able to find a reasonable compromise between making lots of memory available for big jobs without lumbering little jobs with a huge footprint. Even on AIX now there are some extended shared memory facilities which allow you to have more segments instead of just making them all huge! I can't remember the exact details but EXTSHM rings a bell. __ My comment: Due to the way UniData uses shared memory (eg - all udt processes have to attach the smm - ctl (global control table) segment) and the way AIX implemented extended shared memory (memory mapped files), there can be performance issues (contention for access to a single segment). This was identified at a site running 12-1500 users, but I imagine it would raise its ugly head at smaller sites as well. In spite of suggesting this when I originally wrote a white paper on UniData and AIX, we no longer recommend implementing it. Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online!-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Confprod running with 99.9% cpu
confprod is a tool to configure UniData licenses and generate config code, enter auth code. Sounds like someone disconnected somehow. Go ahead and kill it from the Unix shell. Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! kafsat taiyus [EMAIL PROTECTED] kafsat taiyus [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/03/2004 03:52 PM Please respond to U2 Users Discussion List To '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc Subject Confprod running with 99.9% cpu Hi, I am supporting an Unidata 5.2 system running on Tru64 UNIX V5.1A with two CPU. When I look at the processes running in the system I find a process with command confprod is taking 99.9% CPU. Can anybody please tell me what is it and why is it happening? Collect -S -s p -n 4 # Process Statistics (RSS VSZ in Decimal units, i.e 1K = 1000 bytes) # PID User %CPU RSS VSZ UsrTim SysTim IBk OBk Maj Min Command 21467 root 99.9 475K 4.9M 0.516 0.483 0 0 0 0 confprod 45766 CSAMGR1 3.3 3.8M 25M 0.008 0.007 0 0 0 1 udt 58765 VICCO01 1.7 5.2M 30M 0.023 0.017 0 6 0 34 udt 105494 VICCSA23 0.7 5.8M 30M 0.001 0.001 0 1 0 12 udt Have a lovely day. Regards, Kafsat Taiyus Network Administrator Retail Decisions Pty Ltd Incorporating Motorpass, Motorcharge Ltd T: 61 3 9274 9163 F: 61 3 9274 9130 E: [EMAIL PROTECTED] W: www.retaildecisions.com.au This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law.-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users inline: graycol.gifinline: pic29421.gifinline: ecblank.gif-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users