RE: [U2] Why does the IF statement think these values are different?
Hi All, I thought I would send out the solution to this problem. The IF statement took these values to be different although they appear equal. We used string math as was suggested to us and that worked. Our Vendor (Columbia Ultimate) escalated to IBM, and the suggestion was to use $OPTIONS COMP.PRECISION. We inserted this at the start of the subroutine, and the IF statement handled the comparison as one would expect. CUSTOMCALC: 451: PRINT INTREC:' ':PRNREC:' # ':INTPAY:' ':PRNPAY :: S 24016.35 978.56 # 24016.35 978.56 IBM's response was: IBM response This is a case of 'what you see' isn't what you get. UniVerse is applying a PRECISION to the values on display. Hence, UniVerse might display for example 1. but the actual value stored could be 1.01. In the example (in the case), the values are stored internally as 'float' data types. The comparison using equals or non-equals (=/#) is based upon what UniVerse considers a zero. That is determined by the setting for WIDE0 in the uvconfig. For example would .0001 (+ or -) be considered a zero? While UniVerse includes several features (WIDE0, $options STRING.MATH, VEC.MATH, COMP.PRECISION) the reason the routines fail in the relational test is not due to UniVerse but do to how floating values are stored by the hardware. A failure in a UniVerse basic program can be reproduced within a c-program as well. One simply needs to do the same arithmatic operations in the same order and the comparison test should be the same. You can change WIDE0 which will for the entire system alter how comparisons (=, , =, , =, #, etc) are handled. Or, alter the logic for a specific program by adding '$OPTIONS' to the program. Can this problem be worked down to a smaller program, ie. retrieve the fields indicated and do the math, rather than having all of the other program logic included? End IBM response Regards, Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Locked tape drive
Hi All, AIX 5.3 UV 10.1.14 We have a tape drive that we cannot access. It appears to be locked and barring a reboot, we don't know how to clear it. At the Unix prompt: server:/u1/dbms/TCR# tctl -f /dev/rmt1 rewind /dev/rmt1: Resource temporarily unavailable server:/u1/dbms/TCR# At the uv prompt: ASSIGN MT1 TO MTU 0 --- I'm stuck here We did LIST.READU, and cleared the locks that were set against my id: unlock user 313 all Clearing Record locks. Clearing GROUP locks. Clearing FILE locks. There is obviously someone else who had locked the drive before I arrived, but there are no more users listed in LIST.READU, or PORT.STATUS that show a tape drive being used. PORT.STATUS: 519788 t.stevef 313 /dev/pts/37 ASSIGN MT1 TO MTU 0 Any suggestions? Thanks, Steve Chief Cook/Bottle Washer --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Locked tape drive
try ps -ef | grep rmt (whatever the tape is) in aix that might give you a pid and user whio has it -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steve Ferries Sent: 24 January 2007 14:36 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Locked tape drive Hi All, AIX 5.3 UV 10.1.14 We have a tape drive that we cannot access. It appears to be locked and barring a reboot, we don't know how to clear it. At the Unix prompt: server:/u1/dbms/TCR# tctl -f /dev/rmt1 rewind /dev/rmt1: Resource temporarily unavailable server:/u1/dbms/TCR# At the uv prompt: ASSIGN MT1 TO MTU 0 --- I'm stuck here We did LIST.READU, and cleared the locks that were set against my id: unlock user 313 all Clearing Record locks. Clearing GROUP locks. Clearing FILE locks. There is obviously someone else who had locked the drive before I arrived, but there are no more users listed in LIST.READU, or PORT.STATUS that show a tape drive being used. PORT.STATUS: 519788 t.stevef 313 /dev/pts/37 ASSIGN MT1 TO MTU 0 Any suggestions? Thanks, Steve Chief Cook/Bottle Washer --- u2-users mailing list u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Locked tape drive
SH out and get to su (su -) and then do: fuser -u /dev/rmt1 That should give you a list of PIDs 'attached' to the device. Do: ps -ef | grep PID where PID = one of the PIDs the fuser command returned. You can then determine of those processes can be killed or not. Be careful. HTH Karl quote who=Steve Ferries Hi All, AIX 5.3 UV 10.1.14 We have a tape drive that we cannot access. It appears to be locked and barring a reboot, we don't know how to clear it. At the Unix prompt: server:/u1/dbms/TCR# tctl -f /dev/rmt1 rewind /dev/rmt1: Resource temporarily unavailable server:/u1/dbms/TCR# At the uv prompt: ASSIGN MT1 TO MTU 0 --- I'm stuck here We did LIST.READU, and cleared the locks that were set against my id: unlock user 313 all Clearing Record locks. Clearing GROUP locks. Clearing FILE locks. There is obviously someone else who had locked the drive before I arrived, but there are no more users listed in LIST.READU, or PORT.STATUS that show a tape drive being used. PORT.STATUS: 519788 t.stevef 313 /dev/pts/37 ASSIGN MT1 TO MTU 0 Any suggestions? Thanks, Steve Chief Cook/Bottle Washer --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why does the IF statement think these values are different?
From: Steve Ferries I thought I would send out the solution to this problem...[snip] I, for one, truly appreciate it when people post back their Real World solution to a problem posed to the list. This list has great gurus, and I am so grateful for their explanations, suggestions, advice for best practice, workarounds, etc.. But after the pontification, I like to know which bits ended up working out pragmatically in the field. Thanks, Steve! Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Locked tape drive
Hi Karl, Forgot about fuser... As root, I entered the following: server:/u1/dbms/TCR# fuser -u /dev/rmt1 /dev/rmt1: server:/u1/dbms/TCR# It did not return any users. Then: server:/u1/dbms/TCR# fuser -u /dev/rmt1.1 /dev/rmt1.1: 1503458(t.luisu) server:/u1/dbms/TCR# Luis is in my group. Right now I have him in a headlock. Killed him, I mean his process. Thank you very much! Steve SH out and get to su (su -) and then do: fuser -u /dev/rmt1 That should give you a list of PIDs 'attached' to the device. Do: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Locked tape drive
Be careful with fuser - you need to make sure you get the right device. You may need to check if rmt1 is linked (hard or soft) to any other devices. If you do an ls -l what is the numeric value after the permissions column? If that is anything other than 1 then it would indicate that the file is linked to/from other files - and that could be why fuser doesn't give you the information you expect. Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ferries Sent: 24 Jan 2007 16:02 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Locked tape drive Hi Karl, Forgot about fuser... As root, I entered the following: server:/u1/dbms/TCR# fuser -u /dev/rmt1 /dev/rmt1: server:/u1/dbms/TCR# It did not return any users. Then: server:/u1/dbms/TCR# fuser -u /dev/rmt1.1 /dev/rmt1.1: 1503458(t.luisu) server:/u1/dbms/TCR# Luis is in my group. Right now I have him in a headlock. Killed him, I mean his process. Thank you very much! Steve SH out and get to su (su -) and then do: fuser -u /dev/rmt1 That should give you a list of PIDs 'attached' to the device. Do: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Locked tape drive
HI Robert, Here is the display: crw-rw-rw- 1 root system 24, 8 Jan 11 13:05 rmt1 crw-rw-rw- 1 root system 24, 9 Jan 11 13:56 rmt1.1 crw-rw-rw- 1 root system 24, 10 Jan 11 13:05 rmt1.2 crw-rw-rw- 1 root system 24, 11 Jan 11 13:05 rmt1.3 crw-rw-rw- 1 root system 24, 12 Jan 11 13:05 rmt1.4 crw-rw-rw- 1 root system 24, 13 Jan 11 13:05 rmt1.5 crw-rw-rw- 1 root system 24, 14 Jan 11 13:05 rmt1.6 crw-rw-rw- 1 root system 24, 15 Jan 11 13:05 rmt1.7 The major and minor numbers are not 1. The 'c' means it is a special device file, but no links. Steve Be careful with fuser - you need to make sure you get the right device. You may need to check if rmt1 is linked (hard or soft) to any other devices. If you do an ls -l what is the numeric value after the permissions column? If that is anything other than 1 then it would indicate that the file is linked to/from other files - and that could be why fuser doesn't give you the information you expect. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD: Login users
I run UD 7.1 on Windows 2K3. We're testing an ASP server and find the need for our Windows staff to create user's to login to UniData quite onerous. We'd prefer that our ASP clients be able to create their own users from within UniData and manage this process themselves. Is this even possible in the U2 products? We created a directory for all ASP accounts in E:\ASP. We've created a unique Windows group called UniData and removed all permissions on this directory except for Administrators and UniData group members (certain support personnel get assigned to the UniData group. Each account has a group called UniData{AcctName} (so we end up with a number of groups at least equal to the number of accounts under the E:\ASP directory. Again, we remove all permissions on this account-directory except for Administrators, UniData, and UniData{AcctName} group members. Now when each user is created we need to: 1) Create a Windows user as a member of users and UniData{AcctName} groups 2) Use UniAdmin to create a user profile for this user that sets up the users startup directory to their account 3) Create a user profile within the application with the same password as the Windows user to be used by the application. Previous to UniData, we could manage all access to the dbms from within the application, so we were never involved with managing ASP client's users. I'm hoping there is some way we can avoid this administration task. Thanks, Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Locked tape drive
We have a tape drive that we cannot access. It appears to be locked and barring a reboot, we don't know how to clear it. Keep any eye on the frequency of these. In our case this turned out to be the tape drive slowly failing (actually the scsi back plane adapter on the tape drive). If it is hardware, you may be stuck with a reboot. Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Locked tape drive
Hi all, I had unsubcribe from this u2 list.. but I am still getting email.. is there anyway to stop this? Regards Frederick Please respond to u2-users@listserver.u2ug.org Sent by:[EMAIL PROTECTED] To: u2-users@listserver.u2ug.org cc: Subject:Re: [U2] [UV] Locked tape drive We have a tape drive that we cannot access. It appears to be locked and barring a reboot, we don't know how to clear it. Keep any eye on the frequency of these. In our case this turned out to be the tape drive slowly failing (actually the scsi back plane adapter on the tape drive). If it is hardware, you may be stuck with a reboot. Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Locked tape drive
Cod buy a tipo unsubscribe Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, January 24, 2007 2:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Locked tape drive Hi all, I had unsubcribe from this u2 list.. but I am still getting email.. is there anyway to stop this? Regards Frederick Please respond to u2-users@listserver.u2ug.org Sent by:[EMAIL PROTECTED] To: u2-users@listserver.u2ug.org cc: Subject:Re: [U2] [UV] Locked tape drive We have a tape drive that we cannot access. It appears to be locked and barring a reboot, we don't know how to clear it. Keep any eye on the frequency of these. In our case this turned out to be the tape drive slowly failing (actually the scsi back plane adapter on the tape drive). If it is hardware, you may be stuck with a reboot. Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] General Guidelines
All, If you are reading this discussion group through Indexfocus, Nabble, or any of the other mirrors, here's how you can sign up directly and contribute: To subscribe or resubscribe please visit http://listserver.u2ug.org/. When you post to any of these lists and offer a service of represent a product, please mark the advertising portion of your post with [AD] and [/AD]. When you are going off-topic, please add an [OT] to let people know. If it is very off-topic, use the u2-community list. When you post to any of these lists, please observe courtesy in language and manner. This is a loosely moderated list and we expect you to police yourselves. - Charles Barouch, Moderator U2-Users, U2-Community, SBSolutions --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] IBM News
All, For anyone who hasn't heard via Spectrum Xtra or DBTA 5 Minute Briefings: (1) IBM and Revelation have entered into a deal where Revelation will be reselling U2 products with OpenInsight as a front end. (2) IBM will develop, market and sell an IBM version of mv.NET as a product. More on both stories as they develop and congratulations to Revelation and BlueFinity on their new arrangements with IBM. -- Charles Barouch ([EMAIL PROTECTED] or [EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] BlueFinity Press Announcement[/AD]
*London, UK - January 22, 2007 -* BlueFinity International Limited today announced an agreement with IBM that will allow IBM to market and sell BlueFinitys flagship product, mv.NET. Under the agreement, IBM will develop, market and sell an IBM version of mv.NET through its sales force, as well as offer the product through its widely established network of VARs and OEM partners. The agreement enables IBM to receive mv.NET source code for integration with its UniData and UniVerse (U2) data server environments, develop an IBM version of the product, and fully support its customer base. Customers will immediately benefit from our ability to leverage mv.NET technology to deliver a tool that will facilitate development of .NET-based solutions for the U2 data servers, said Susie Siegesmund, Director of U2 Data Services for IBM. This will open up opportunities for existing U2 customers to create .NET-based interfaces to their extended-relational data servers and help facilitate development of new innovative business applications. mv.NET is a comprehensive solution for accessing MultiValue databases from within Microsoft's .NET environment. It enables software designers to combine the power and flexibility of proven MultiValue technology with the feature rich .NET environment. IBM UniVerse is an extended relational data server designed for embedding in a variety of solutions. UniVerse offers configurable internationalization capabilities, high-end security and encryption features, standards-based interfaces with Web services support, and high-availability options used as part of a variety of top-shelf solutions. UniVerse is a mainstay in a variety of industry solutions such as automotive, banking, ERP, and insurance. IBM UniData is a nested relational data server designed for embedding in a variety of solutions. UniData excels in data server interoperability, offers robust high-availability, with proven stability, scalability and performance. UniData is the foundation for many best-of-breed solutions in such industries as higher education, finance, and emergency services. UniData offers low total cost of ownership by remaining easy to administer and maintain. The mv.NET products from BlueFinity are currently attracting considerable attention as they are introduced to markets around the world. This partnership will help accelerate the introduction of mv.NET, particularly into IBMs established customer base and distribution channels, said Pete Loveless, General Manager of BlueFinity. The synergy between our respective product lines and target markets makes this relationship a natural fit. ### *About BlueFinity International *BlueFinity International (www.bluefinity.com http://www.bluefinity.com/), part of the Mpower1 group of companies, supplies leading-edge software development tools and consultancy services to the MultiValue database and Microsoft developer communities. Founded in 2002, BlueFinity has created a series of products. Its flagship product - /mv.NET/ is a comprehensive solution for developers wishing to access MultiValue databases from within Microsoft's .NET environment. For more information about IBM U2, visit www.ibm.com/software/data/u2/ http://www.ibm.com/software/data/u2/ *More information can be found at www.bluefinity.com/may2007.html http://www.bluefinity.com/may2007.html* * * -- Charles Barouch ([EMAIL PROTECTED] or [EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/