RE: [U2] FW: How do I determine whether a file is using 64 bit or 32 bit a ddressing
Hi Ang, To change to a 64bit file just put 64BIT on the end of the resize command. The documentation is in the USER REFERENCE book. The manuals are available at http://www-306.ibm.com/software/data/u2/pubs/library/ In order to tell a 32bit file from a 64bit file, you can use filepeek (this is in the bin directory and must be run as root) or check the list archives at (I think) http://www.indexinfocus.com/ There are several solutions there for determining the difference Regards 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Sent: Tuesday, 3 August 2004 5:02 PM To: [EMAIL PROTECTED]; U2-Users New Lists Subject: [U2] FW: How do I determine whether a file is using 64 bit or 32 bit a ddressing Dear Steve Ferries, Hi . Just wondering if you resize the file from 32 to 64 bits using RESIZE command ? Coz i having a problem when using RESIZE at Universe version 10. Do u have any idea to change the file from 32 bit to 64bits ? error messages is below during resize mkdbfile: unable to create a 32-bit file greater than 2 gigabytes. -Original Message- From: Steve Lisa [SMTP:[EMAIL PROTECTED] Sent: Sunday, 04 April, 2004 10:22 PM To: [EMAIL PROTECTED] Subject: UV: How do I determine whether a file is using 64 bit or 32 bit addressing HI All, We have several files that are right at the 2 Gig limit. We are pretty sure that we have resized them using the 64 bit option. However, just to make sure, how may we determine if the file is indeed using 64 bit addressing. Thanks, Steve Ferries -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: U2 Users Digest V1 #165
Hi Karl, This problem does not happen on UniVerse 10.1.4 on Aix See Screenshot below :- 001: RTVEC = 002: VNM = TRIM(FIELD(RTVEC8),:,2) 003: END Bottom. *--: FIB Filed TESTER in file BP unchanged. Compiling: Source = 'BP/TESTER', Object = 'BP.O/TESTER' 02VNM = TRIM(FIELD(RTVEC8),:,2) ^ Incorrect number of arguments 1 Errors detected, No Object Code Produced. .L RELLEVEL RELLEVEL 001 X 002 10.1.4 003 INFORMATION 004 INFORMATION.FORMAT 005 10.1.4 Could be worthwhile upgrading .. Jonathan Smith IBM Certified Solutions Expert Advanced Support Engineer - U2 Advanced Technical Support IBM Data Management Solutions DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: U2 Users Digest V1 #165
Should this not read: VNM = TRIM(FIELD(RTVEC8,:,2)) NOT VNM = TRIM(FIELD(RTVEC8),:,2) or am I missing something? Regards Bjvrn Behr Programmer HYFLO Southern Africa (Pty) Ltd Tel : +27 11 386 5800 Fax : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan D Smith Sent: 03 August 2004 10:52 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [U2] Re: U2 Users Digest V1 #165 Hi Karl, This problem does not happen on UniVerse 10.1.4 on Aix See Screenshot below :- 001: RTVEC = 002: VNM = TRIM(FIELD(RTVEC8),:,2) 003: END Bottom. *--: FIB Filed TESTER in file BP unchanged. Compiling: Source = 'BP/TESTER', Object = 'BP.O/TESTER' 02VNM = TRIM(FIELD(RTVEC8),:,2) ^ Incorrect number of arguments 1 Errors detected, No Object Code Produced. .L RELLEVEL RELLEVEL 001 X 002 10.1.4 003 INFORMATION 004 INFORMATION.FORMAT 005 10.1.4 Could be worthwhile upgrading .. Jonathan Smith IBM Certified Solutions Expert Advanced Support Engineer - U2 Advanced Technical Support IBM Data Management Solutions DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: U2 Users Digest V1 #165
Try it like this: 0001: RTVEC = 0002: VNM = TRIM(FIELD(RTVEC8,:,2)) 0003: END Bottom at line 3. : .X BAS TEST filed in file BP. Executing the command BASIC BP TEST. Compiling: Source = 'BP/TEST', Object = 'BP.O/TEST' Compilation Complete. Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jonathan D Smith Sent: 03 August 2004 09:52 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [U2] Re: U2 Users Digest V1 #165 Hi Karl, This problem does not happen on UniVerse 10.1.4 on Aix See Screenshot below :- 001: RTVEC = 002: VNM = TRIM(FIELD(RTVEC8),:,2) 003: END Bottom. *--: FIB Filed TESTER in file BP unchanged. Compiling: Source = 'BP/TESTER', Object = 'BP.O/TESTER' 02VNM = TRIM(FIELD(RTVEC8),:,2) ^ Incorrect number of arguments 1 Errors detected, No Object Code Produced. .L RELLEVEL RELLEVEL 001 X 002 10.1.4 003 INFORMATION 004 INFORMATION.FORMAT 005 10.1.4 Could be worthwhile upgrading .. Jonathan Smith IBM Certified Solutions Expert Advanced Support Engineer - U2 Advanced Technical Support IBM Data Management Solutions DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Priorities for Unix udt processes
Does anyone have any experience of what the nice and priority values should be and how they can be changed? -- * This message has been scanned for viruses and dangerous content by * Blairs of Scotland MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to which they * are addressed. * * If you have received this email in error please notify us at Blairs * of Scotland via email at [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] RE: Copying data between two Universe servers
The way I really hoped would be implemented was to have the index files exist within the file subdirectory, i.e. all files with indexes would be similar in structure to Type30, but have a .index subdirectory within them. So, from then on, the indexes would be tied to the main data file. But then you wouldn't have the opportunity to put your data files and their indexes on different spindles / channels / file systems to maximise throughput by spreading I/O. In unix, use soft links. See man pages on ln -s. It lets you make an entry in the appropriate unix dir that UV will look for, but the file actually lives somewhere else. Kinda like a Pick Q-pointer, or an F pointer with 2 a fully qualified pathname to another directory. You can do that today to spread out INDEX.000, INDEX.001 INDEX.002, etc. across many spindles. Likewise, with Unidata, I'm sure you can use ln -s to relocate the X_... files elsewhere for better throughput. cds --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] FW: How do I determine whether a file is using 64 bit or 32 bit a ddressing
Dear David, Yes, i got it. Thanks for your information Thanks and Regards -Original Message- From: Logan, David (SST - Adelaide) [SMTP:[EMAIL PROTECTED] Sent: Tuesday, 03 August, 2004 4:06 PM To: [EMAIL PROTECTED] Subject: RE: [U2] FW: How do I determine whether a file is using 64 bit or 32 bit a ddressing Hi Ang, To change to a 64bit file just put 64BIT on the end of the resize command. The documentation is in the USER REFERENCE book. The manuals are available at http://www-306.ibm.com/software/data/u2/pubs/library/ In order to tell a 32bit file from a 64bit file, you can use filepeek (this is in the bin directory and must be run as root) or check the list archives at (I think) http://www.indexinfocus.com/ There are several solutions there for determining the difference Regards 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Sent: Tuesday, 3 August 2004 5:02 PM To: [EMAIL PROTECTED]; U2-Users New Lists Subject: [U2] FW: How do I determine whether a file is using 64 bit or 32 bit a ddressing Dear Steve Ferries, Hi . Just wondering if you resize the file from 32 to 64 bits using RESIZE command ? Coz i having a problem when using RESIZE at Universe version 10. Do u have any idea to change the file from 32 bit to 64bits ? error messages is below during resize mkdbfile: unable to create a 32-bit file greater than 2 gigabytes. -Original Message- From: Steve Lisa [SMTP:[EMAIL PROTECTED] Sent: Sunday, 04 April, 2004 10:22 PM To: [EMAIL PROTECTED] Subject:UV: How do I determine whether a file is using 64 bit or 32 bit addressing HI All, We have several files that are right at the 2 Gig limit. We are pretty sure that we have resized them using the 64 bit option. However, just to make sure, how may we determine if the file is indeed using 64 bit addressing. Thanks, Steve Ferries -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] many spindles - was Copying data between two UV servers
It's not just U2 that likes to have multiple spindles. Any disk intensive processing activity will benefit by having the load split accross multiple disk subsystems. Agreed .. So why when we bought our new RS6000 about 1 year ago did the IBM guys try to sell us on a SMALLER number of LARGER disks and seemed suprised when we said we wanted a LARGER number of SMALLER disks (small being relative, since the smallest I could get now was 36gb) .. I'll just put that down to the fact that they're sales guys, not technical guys ;) -Chuck --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Timothy Snyder/Philadelphia/IBM is out of the office.
I will be out of the office starting 07/31/2004 and will not return until 08/16/2004. I will respond to your message as soon as possible. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Priorities for Unix udt processes
I don't know if anyone replied yet, but I will try and answer this. Depending on your unix flavor, the nice values will be different. Linux nice values are between -20 (highest priority) and 19 (lowest priority), with a default of 0. For hpux, the values are from 0 to 39, with a default of 20. I don't know what the aix values are. The syntax for the nice and renice commands will be slightly different for each platform. The priority value that shows in the ps -l under the PRI column is not the same as the nice value, which shows under the NI column. The priority value (I think) is the order in which the process will get timeslices from the cpu(s). On a U2 system, there are many things that I would check before messing with nice values. In theory, even if you lowered the priority of a phantom process, you could clog up regular processes that are waiting on that phantom process to release a lock. And since you just lowered the priority, it's going to take longer than usual to release. The only occasion where I had to adjust the nice values was for some overnight reports. No locking, no writes, etc, Hope that helps. -Original Message- From: Jonathan Leckie [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 7:13 AM To: [EMAIL PROTECTED] Subject: [U2] Priorities for Unix udt processes Does anyone have any experience of what the nice and priority values should be and how they can be changed? -- * This message has been scanned for viruses and dangerous content by * Blairs of Scotland MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to which they * are addressed. * * If you have received this email in error please notify us at Blairs * of Scotland via email at [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] many spindles - was Copying data between two UV servers
Subject: RE: [U2] many spindles - was Copying data between two UV servers It's true that it's getting tougher to justify 4 spindles that happen to be 36gig each for a database that is only 15gig in total size. But the speed difference that is achieved by splitting the data files between 2 sets of mirrored disks is something that can be easily experienced by simply running a large month end type of job. Sales guys are well, their sales guys. Take what they say with a couple large grains of salt. Additional factor comment: Disk drive technology is going so fast in total size / disk, that getting smaller disks available for purchase is extremely difficult. At some point in time, one would hope that some disk drive manufacters would wake up to the fact that we don't necessarily need or want individual disk drives with 160 GB capacity, but 36 GB drives that cost a lot less, and that are a lot faster, and last a lot longer. Specific market applications may warrant a 160 GB disk. Most applications, that is huge over kill. And when that one disk dies, with all that data on it, and no backup, folks will really be up a creek w/o a paddle. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] many spindles - was Copying data between two UV servers
Gotta look at the disk specs. All things may not be so equal. Disks are getting faster and smarter as they get larger. Latest disk speeds are 15,000 RPM vs. 8k or 10k. Faster SCSI buses, bigger caches and smarter access algorithms on both the drives and the controller cards boost I/O throughput, too. Where fault tolerance is concerned, there's still no alternative to multiple drives that I know of. Bigger drives don't cost that much more than smaller drives, so the sales guys might have been trying to keep the cost down for you. FWIW, our newer disk cabinet with faster SCSI controllers and higher disk RPM (but fewer spindles) blows away the older one that has 2-3 times the spindles. :-) Regards, Tom [EMAIL PROTECTED] 08/03/04 10:16 AM Any disk intensive processing activity will benefit by having the load split accross multiple disk subsystems. Agreed .. So why when we bought our new RS6000 about 1 year ago did the IBM guys try to sell us on a SMALLER number of LARGER disks and seemed suprised when we said we wanted a LARGER number of SMALLER disks (small being relative, since the smallest I could get now was 36gb) .. - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Memo: UOJ connect error 81009
Hi everyone, I am writing some Uniobjects for Java code, and am having problems with the connect method. The first connect to the Universe system is successful, but if I then disconnect and then try to connect again, I get the error[IBM U2][UniObjects for Java][UniSession Exception][ErrorCode: 81009]The RPC failed. Has anybody else come across the same problem? Is there an RPC log file anywhere that will give me more information? Any ideas? System is HP UX, Universe 9.6 thanks in advance asvin Here is some sample code: UniJava uj_sess = new UniJava(); UniSession uSession = null; try { uSession = uj_sess.openSession(); } catch (UniSessionException e) { e.printStackTrace(); } uSession.setAccountPath(pathname); uSession.setHostName(hostname); uSession.setUserName(user); uSession.setPassword(password); try { uSession.connect(); } catch (UniSessionException e1) { e1.printStackTrace(); } try { uSession.disconnect(); } catch (UniSessionException e2) { e2.printStackTrace(); } try { uSession.connect(); } catch (UniSessionException e3) { System.out.println(second connect failed); System.out.println(e3.getExtendedMessage());--- get the error message here } try { uSession.disconnect(); } catch (UniSessionException e4) { e4.printStackTrace(); } HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] many spindles - was Copying data between two UV servers
FWIW, our newer disk cabinet with faster SCSI controllers and higher disk RPM (but fewer spindles) blows away the older one that has 2-3 times the spindles. :-) but 36 GB drives that cost a lot less, and that are a lot faster, and last a lot longer It's actually hard to think that a shop would NOT be mirrored/RAIDed these days, so the question of a big drive dying becomes moot, and I'd be suprised if the 36gb drives are actually faster than larger ones .. Also, besides single drive speed/seek times, etc, I'd like to see some sort of standard benchmark test, like this: we tested 12 of these 36gb drives using RAID 0+1 (striping and mirroring), for a total logical volume size of 216gb (6*36), with a combined seek rate of X, and were able to perform X transactions per second using (insert your DB of choice here) --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Memo: UOJ connect error 81009
[EMAIL PROTECTED] wrote: I am writing some Uniobjects for Java code, and am having problems with the connect method. The first connect to the Universe system is successful, but if I then disconnect and then try to connect again, I get the error[IBM U2][UniObjects for Java][UniSession Exception][ErrorCode: 81009]The RPC failed. I don't think you should try to reconnect a UniSession that you've disconnected. If you're done with it, disconnect and get rid of it. If you need to connect again, make another UniSession. BTW, you don't need the UniJava object, it was there for licensing but since IBM decided to include UOJ with U2, it's not necessary. You can just do: UniSession uSession = new UniSession(); There's sample code on the Wiki, I use a UniSessionFactory to produce sessions. http://www.pickwiki.com/cgi-bin/wiki.pl?JavaSource -- Wendy Smoak --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Primary:Index (mis)matching.
I think your assumption may be incorrect. I recently restored some indexes into an account where the files weren't defined as having an index and it caused some problems. However, it is easy to trick UD with a bogus index. I just copy another X_ file and rename it. If one doesn't exist I simply create an index on another (small) file, copy and rename it, and then delete both with the ALL keyword. Works like a charm. Of course, I make sure nobody will be trying to update the file while I'm doing it - just in case. I think I've even copied over a data file and renamed it before doing the DELETE-INDEX filename ALL. -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Thomas Derwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Primary:Index (mis)matching. FWIW, I learned the hard way that UD keeps a flag in the file header that knows there's an index on the file, then looks for the index in the same directory. Restored a file from a backup tape to another directory, but UD refused to let me even read the data until I went back and restored the index. (Yes, I tried to cheat and run DELETE-INDEX on the restored file, but it failed with an index missing error.) So would assume that UD doesn't go looking for the index unless the index exists flag is set in the file header. I haven't played around with how to trick UD with a bogus index, as that's just asking for trouble... Regards, Tom --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Memo: UOJ connect error 81009
Actually, it wasn't for licensing. Licensing is still accounted for, but it's dealt with on the server side. The only real point of the UniJava class was to provide a centralized marshalling and management class for the API. It provided a mechanism to manage multiple sessions, etc... I originally had more planned for it than that, but that's all it does right now. Like Wendy mentions, it's not required however. Dave I don't think you should try to reconnect a UniSession that you've disconnected. If you're done with it, disconnect and get rid of it. If you need to connect again, make another UniSession. BTW, you don't need the UniJava object, it was there for licensing but since IBM decided to include UOJ with U2, it's not necessary. You can just do: UniSession uSession = new UniSession(); There's sample code on the Wiki, I use a UniSessionFactory to produce sessions. http://www.pickwiki.com/cgi-bin/wiki.pl?JavaSource -- Wendy Smoak --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ David T. Meeks || All my life I'm taken by surprise Architect, Technology Office || I'm someone's waste of time Ascential Software || Now I walk a balanced line [EMAIL PROTECTED] || and step into tomorrow - IQ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] edit FI failed
Dave, I too will give this a stab. Try the following at TCL, RELEASE IBP -Original Message- From: Thomas Derwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 2:05 PM To: [EMAIL PROTECTED] Subject: Re: [U2] edit FI failed Hi Dave, Nobody seems to have responded, so I'll give it a go. My best guess is there's a file permissions issue. Are you sure you, or the user you're logged on as, has write permissions on IBP? I haven't seen an (E) option abort cause this problem on UD. Are you running UV? Hope this helps, Tom [EMAIL PROTECTED] 08/02/04 4:26 PM I got this error message from running program that was launched by RUN IBP AUTO.CAT.REQ (E It aborted and I did a Q to exit I need to know how to release the STATUS = 0 Thanks! 01 ED IBP AUTO.CAT.REQ 699 lines long. : FI Failed to file AUTO.CAT.REQ in file IBP. STATUS = 0 Top. : EX .X 01 ED IBP AUTO.CAT.REQ D Raven e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Memo: UOJ connect error 81009
David T. Meeks The only real point of the UniJava class was to provide a centralized marshalling and management class for the API. It provided a mechanism to manage multiple sessions, etc... I defer to the author. ; So... Is the 81009 coming from trying to reconnect a UniSession that's been disconnected? What happens inside that would cause a problem if you tried to reconnect? (And thanks for continuing to help with UOJ, I know it's not one of your current projects.) -- Wendy Smoak --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uvfixfile @ dynamic file
Ang Suan Please note: in order to repair a 64 bit file you *MUST* use FIXTOOL - uvfixfile cannot be used to repair a 64 bit file. You can use UVFIXFILE to test of course - though there are better ways of doing this without (by default) actually running UVFIXFILE over a complete file if it happens to be 32 bit.. Please also remember that in order to use a 64 bit file the underlying file system must also support 64 bit files. FIXTOOL replaced UVFIXFILE some time ago - although UVFIXFILE is still supplied (at least for the time being). Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Sent: 03 August 2004 06:06 To: U2-Users New Lists Subject: [U2] uvfixfile @ dynamic file Dear All, Do anyone experience this message when fixing the dynamic file on Universe 10 . The OVER.30 has size of 2GB and DATA.30 has 1.5GB AIS.PROD.XREF/OVER.30: Value too large for defined data type Thanks and Regards DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] index tips (was [UV] Primary:Index (mis)matching.)
Thanks for the tips, Colin. I've added them to my collection of goodies. Great point, too, about making sure nobody has the file open before deleting its index. Not sure if the docs have been updated, but they didn't used to warn you about this. So thinking it was safe, somebody here ran DELETE-INDEX filename ALL on a production file and everyone who had the file OPENed by their UniBasic program was blown out of the affected Unidata session. [EMAIL PROTECTED] 08/03/04 1:58 PM I think your assumption may be incorrect. I recently restored some indexes into an account where the files weren't defined as having an index and it caused some problems. However, it is easy to trick UD with a bogus index. I just copy another X_ file and rename it. If one doesn't exist I simply create an index on another (small) file, copy and rename it, and then delete both with the ALL keyword. Works like a charm. Of course, I make sure nobody will be trying to update the file while I'm doing it - just in case. I think I've even copied over a data file and renamed it before doing the DELETE-INDEX filename ALL. -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Thomas Derwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Primary:Index (mis)matching. FWIW, I learned the hard way that UD keeps a flag in the file header that knows there's an index on the file, then looks for the index in the same directory. Restored a file from a backup tape to another directory, but UD refused to let me even read the data until I went back and restored the index. (Yes, I tried to cheat and run DELETE-INDEX on the restored file, but it failed with an index missing error.) So would assume that UD doesn't go looking for the index unless the index exists flag is set in the file header. I haven't played around with how to trick UD with a bogus index, as that's just asking for trouble... Regards, Tom --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET (UO.NET)
From the text on the website and the conference info below I don't see how UO.NET is similar or different compared to UO except that it's re-written to be managed code. Does it support the full UO API? Does it support ADO.NET? Connection pooling is interesting. XML/DataSet support? I hope that doesn't imply using U2 XML support to populate a dataset - of course the web page says the XML support is all new. Is the SOAP interface through UO.NET? Do we need to wait a month for the conference before getting more info? :) Thanks. Tony Nebula RD Ron White wrote: The new UniObjects for .NET provides high-speed native access that runs in a managed .NET environment for increased performance. http://www-306.ibm.com/software/data/u2/unidata/ud61-ann.html From: Rajesh Menon Not sure when this will be available. But there is session for Uniobjects.NET (UO.NET) in the upcoming U2 and DB2 Information Management Technical Conference, September 2004 (LAS VEGAS) While all U2 Windows APIs are 100% compatible with .NET and can be used to develop .NET applications that talk to U2 databases, IBM U2 users now have a new API developed just for .NET - UniObjects For .NET(UO.NET). A 100% managed interface, UO.NET integrates seamlessly with .NETand new features such as connection pooling and XML/DataSet support will greatly improve performance for U2 .NET applications. A live demo and examples will be given to the audience to highlight the many important features of UO.NET. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Priorities for Unix udt processes
I have used nice for Unidata on HPUX many times and never had any problem. Renice is the command to change nice level. Use man renice to get help on the command. While using renice command just make sure to use correct pid for the process. Another command you may want to have a look is kill with correct parameter you can practically stop a low priority process to stop processing and give high priority process more resources, and start the process again when high priority process is done. Use man kill for details. Regards Kafsat -Original Message- From: Jonathan Leckie [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 August 2004 9:13 PM To: [EMAIL PROTECTED] Subject: [U2] Priorities for Unix udt processes Does anyone have any experience of what the nice and priority values should be and how they can be changed? -- * This message has been scanned for viruses and dangerous content by * Blairs of Scotland MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to which they * are addressed. * * If you have received this email in error please notify us at Blairs * of Scotland via email at [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ 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] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET (UO.NET)
I hope somebody from IBM-U2 will post some release dates for UO.NET here. Otherwise wait until September :-) -Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Tuesday, August 03, 2004 3:03 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UniObjects for .NET (UO.NET) From the text on the website and the conference info below I don't see how UO.NET is similar or different compared to UO except that it's re-written to be managed code. Does it support the full UO API? Does it support ADO.NET? Connection pooling is interesting. XML/DataSet support? I hope that doesn't imply using U2 XML support to populate a dataset - of course the web page says the XML support is all new. Is the SOAP interface through UO.NET? Do we need to wait a month for the conference before getting more info? :) Thanks. Tony Nebula RD Ron White wrote: The new UniObjects for .NET provides high-speed native access that runs in a managed .NET environment for increased performance. http://www-306.ibm.com/software/data/u2/unidata/ud61-ann.html From: Rajesh Menon Not sure when this will be available. But there is session for Uniobjects.NET (UO.NET) in the upcoming U2 and DB2 Information Management Technical Conference, September 2004 (LAS VEGAS) While all U2 Windows APIs are 100% compatible with .NET and can be used to develop .NET applications that talk to U2 databases, IBM U2 users now have a new API developed just for .NET - UniObjects For .NET(UO.NET). A 100% managed interface, UO.NET integrates seamlessly with .NETand new features such as connection pooling and XML/DataSet support will greatly improve performance for U2 .NET applications. A live demo and examples will be given to the audience to highlight the many important features of UO.NET. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects for .NET (UO.NET)
UO.net will be included in the release of UD 6.1, which is due Aug. 10. - Original Message - From: Rajesh Menon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 7:22 PM Subject: RE: [U2] UniObjects for .NET (UO.NET) I hope somebody from IBM-U2 will post some release dates for UO.NET here. Otherwise wait until September :-) -Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Tuesday, August 03, 2004 3:03 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UniObjects for .NET (UO.NET) From the text on the website and the conference info below I don't see how UO.NET is similar or different compared to UO except that it's re-written to be managed code. Does it support the full UO API? Does it support ADO.NET? Connection pooling is interesting. XML/DataSet support? I hope that doesn't imply using U2 XML support to populate a dataset - of course the web page says the XML support is all new. Is the SOAP interface through UO.NET? Do we need to wait a month for the conference before getting more info? :) Thanks. Tony Nebula RD Ron White wrote: The new UniObjects for .NET provides high-speed native access that runs in a managed .NET environment for increased performance. http://www-306.ibm.com/software/data/u2/unidata/ud61-ann.html From: Rajesh Menon Not sure when this will be available. But there is session for Uniobjects.NET (UO.NET) in the upcoming U2 and DB2 Information Management Technical Conference, September 2004 (LAS VEGAS) While all U2 Windows APIs are 100% compatible with .NET and can be used to develop .NET applications that talk to U2 databases, IBM U2 users now have a new API developed just for .NET - UniObjects For .NET(UO.NET). A 100% managed interface, UO.NET integrates seamlessly with .NETand new features such as connection pooling and XML/DataSet support will greatly improve performance for U2 .NET applications. A live demo and examples will be given to the audience to highlight the many important features of UO.NET. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET (UO.NET)
I hope somebody from IBM-U2 will post some release dates for UO.NET here. Otherwise wait until September :-) The date is in the link that is part of the message you replied to. Regards, LeRoy F. Dreyfuss Advanced Technical Services - U2 Technology Analyst IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support 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 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET (UO.NET)
Hi all, I'm a little confused... does the following PDF not answer the UO.NET questions posed so far? http://publibfi.boulder.ibm.com/epubs/pdf/25124070.pdf You can get to this link by going to the U2 Library: http://www-306.ibm.com/software/data/u2/pubs/ selecting Manual Online which takes you to http://www-306.ibm.com/software/data/u2/pubs/library/ and then selecting UniData 6.1 under Servers which take you to http://www-306.ibm.com/software/data/u2/pubs/library/61unidata/ a quick serach (ctrl-F) for .Net will take you to: IBM UniObjects for .NET Developers Guide, Version 6.1 Describes UniObjects for .NET, an interface to UniVerse and UniData databases through Microsoft .NET. Hope this helps, Anthony. --- Rajesh Menon [EMAIL PROTECTED] wrote: I hope somebody from IBM-U2 will post some release dates for UO.NET here. Otherwise wait until September :-) -Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Tuesday, August 03, 2004 3:03 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UniObjects for .NET (UO.NET) From the text on the website and the conference info below I don't see how UO.NET is similar or different compared to UO except that it's re-written to be managed code. Does it support the full UO API? Does it support ADO.NET? Connection pooling is interesting. XML/DataSet support? I hope that doesn't imply using U2 XML support to populate a dataset - of course the web page says the XML support is all new. Is the SOAP interface through UO.NET? Do we need to wait a month for the conference before getting more info? :) Thanks. Tony Nebula RD Ron White wrote: The new UniObjects for .NET provides high-speed native access that runs in a managed .NET environment for increased performance. http://www-306.ibm.com/software/data/u2/unidata/ud61-ann.html From: Rajesh Menon Not sure when this will be available. But there is session for Uniobjects.NET (UO.NET) in the upcoming U2 and DB2 Information Management Technical Conference, September 2004 (LAS VEGAS) While all U2 Windows APIs are 100% compatible with .NET and can be used to develop .NET applications that talk to U2 databases, IBM U2 users now have a new API developed just for .NET - UniObjects For .NET(UO.NET). A 100% managed interface, UO.NET integrates seamlessly with .NETand new features such as connection pooling and XML/DataSet support will greatly improve performance for U2 .NET applications. A live demo and examples will be given to the audience to highlight the many important features of UO.NET. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/