[U2] AUTO: Asvin DATTANI is out of the office (returning 30/10/2012)

I am out of the office until 30/10/2012. Note: This is an automated response to your message "[U2] STARTUP file issue with UV11.1 PE version (Linux)" sent on 1/10/2012 17:36:50. This is the only notification you will receive while this person is away. ---

[U2] AUTO: Asvin DATTANI is out of the office (returning 01/05/2012)

I am out of the office until 01/05/2012. Note: This is an automated response to your message "Re: [U2] Job at Rocket in Denver" sent on 28/3/2012 18:48:49. This is the only notification you will receive while this person is away. - SAVE PAPER - THINK

[U2] AUTO: Asvin DATTANI is out of the office (returning 16/01/2012)

I am out of the office until 16/01/2012. I will then be out of the country until 30/01/2012, but will be contactable by telephone, email and sametime. Note: This is an automated response to your message "Re: [U2] Corrupted compiled code" sent on 22/12/2011 19:59:16. This is the only notificat

[U2] MQI on Universe 11

Hi, Is anybody using the MQI interface in Universe 11 to connect to MQ? We currently use the AMI interface on Universe 10.3 but will have to move to MQI at some stage. If you are using MQI, any information, tips, gotcha's, or description of problems encountered would be very welcome thank

Re: [U2] Dynamic Connect TimeOut

Hi, Have you checked the AUTOLOGOUT setting? AUTOLOGOUT Use AUTOLOGOUT to enable or disable automatic logout. With AUTOLOGOUT enabled, UniVerse logs you out automatically if you have not pressed a key within a specified time. SYNTAX AUTOLOGOUT [time]

Re: [U2] Avoiding deadly embraces

> > To Asvin, you cannot set locks in the same sequence every time. > This is because, in a sufficiently complex system you will have > changes to Customer's possibly affecting Orders, Inventory, Payables... > You can then have changes to Inventory possibly affecting Orders, > Customers, Receiva

[U2] Avoiding deadly embraces (was Re: [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.)

Hi, You can avoid a deadly embrace if you can arrange it so that all processes lock related tables/files in the same sequence. Take the example of a system with a CUSTOMER file, a ORDER HEADER file and an ORDER DETAILS file. If some processes lock the ORDER HEADER file first and the CUSTOMER f

Re: [U2] Sending interrupt to UniBasic program

Hi Bradley, We run everything under screen, batch processes (like you describe) and interactive terminal sessions. We dont have the problems that you are describing, and can break whenever we need to. But we are using UV and that may be better at handling break then udt. How are you invoking

Re: [U2] UV Memory issues

I too would suspect disk issues. We had exactly the same symptoms on our HP UX Universe installation, and tracked it down (eventually) to disk issues caused by problems with a Veritas replication link which copied data from the live server to an offsite DR server... "Symeon Breen" Sent by

Re: [U2] Universe and stripped drives

We use snapshots to perform a backup as well. We do a dbpause/SUSPEND.FILES ON and a Unix sync() to flush the buffers to disk before creating a snapshot. Once the snapshot is created, you can then do a dbresume (is that the right verb - long time since I worked on ud) or SUSPEND.FILES OFF. The

Re: [U2] Using JDBC on Unidata 7.1 on HPUX

Hi, We use JDBC to talk to a Microsofot SQL server database, and have used it to talk to Sybase in the past. You need the JDBC driver for the database that you are talking to (we use jTDS for the SQL Server database). Then you will need some java code to read/write to the SQL database and some

Re: [U2] File corrupt

Hi Robert, As I see it you have three choices: 1. Move old inactive records to an archive file. If you move enough, you should avoid the 2gb limit. Of course, the records you move will no longer be available to the normal programs and you may hit referential integrity problems - so this is pro

Re: [U2] Connecting to a Universe Database

another option is to use JDBC - this involves getting a JDBC driver for the target system (widely and freely available) and writing some fairly simple java code which uses Uniobjects to connect to the Universe database and the JDBC driver to talk to the SQL database.. cheers, asvin John C

Re: [U2] General guidelines on indexing

Hi, A general point on indexes. You should be careful in choosing the data that you index on. Indexing on a data field where a substantial number of records in the file have the same value in that field can cause performance problems. An extreme example is a field that can contain Y or N. But

Re: [U2] Dimensioned Array Question

INMAT(array) works on Universe too. If you cant get it to work, you could try MATPARSE. cheers, asvin u2-users-boun...@listserver.u2ug.org wrote on 01/06/2009 16:08:03: > "Edward Brown" > Sent by: u2-users-boun...@listserver.u2ug.org > > Jun 01 2009 16:08 > > Mail Size: 22529 > > Ple

Re: [U2] Any limitation in UniVerse decimal places

Hi, Th String maths routines (SDIV, SMULT etc) that Martin alludes to at the bottom of his post are very effective, but do require code changes to all the calcuations in the program. You can achieve the same effect in Universe by putting $OPTIONS STRING.MATH at the top of the program. Howeve

Re: [U2] Inter-Process Control...

Hi Tom, You could use the LOCK/UNLOCK Basic statements. These are designed for interprocess control, but I dont know if they will achieve your goal of not wasting resources. So in each program you would have something like this: LOOP UNTIL LOCK n DO RQM REPEAT process stuff here UNLOCK n

Re: [U2] A-correlative explanation

Perhaps: IF 0 > ATT5 OR ATT6 <> '' THEN ATT5 ELSE 0 because I believe the correlative can be read as: ((C0 > 5) OR ("" <> 6) + C0) * 5 and to think that I actually used to enjoy reverse polish once upon a time... [EMAIL PROTECTED] wrote on 05/11/2008 17:23:27: > A coworker asked me if I co

Re: [U2] group locks and user nbr's

[EMAIL PROTECTED] wrote on 19/06/2008 17:51:55: > > If we have a pick file called "CONTROL" and there is a group lock on the > CONTROL file what I am curious about would be: > > 1. why would a group lock be set? A group lock which actually locks the group is normally transient. It is set b

Re: [U2] Too many users

Hi Dennis, Replies embedded below... [EMAIL PROTECTED] wrote on 11/02/2008 10:54:07: > > (1) I have too many users + phantoms logging on and we have run out of > licences. Is there a utility out there that monitors this? uvlictool [-clean] I think you need to be superuser to use the -clean op

Re: [U2] Dynamic Connect keyboard definitions

I have had issues with Dynamic Connect where if you change anything else on the setup and save it, it seems to revert to the default keyboard file. [EMAIL PROTECTED] wrote on 22/01/2008 16:30:50: > I am trying to save keyboard definitions from one session to the next. Mainly > the keypad. The d

Re: [U2] Problems with disconnects - telnet

Hi Gabe, We are using screen (version 4.0.2) on Unix to ensure that we have no disconnected sessions. We are only using it on our development machine for the moment but intend to roll it out to production pretty soon. In the unix profile for the user we check to see if there is any active scre

RE: [U2] phantom ?

Just to amplify, the hex number is the instruction counter. It can be translated to the Basic source line number by doing a VLIST on the basic program. It can be an incredibly useful piece of information. <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/12/2007 19:57 Mail Size: 5323 Pl

Re: [U2] Unable to Create A Pipe

Hi Bill, We came across something like this sometime ago. The error message is caused by entries being left in the uvtemp directory, but that is just a symptom. In reality, the problem is that a phantom or background process that opens a file and then executes another process seems to corrupt a

[U2] CN=Asvin DATTANI/OU=IBEU/O=HSBC is out of the office.

I will be out of the office starting 03/10/2007 and will not return until 22/10/2007. - SAVE PAPER - THINK BEFORE YOU PRINT! This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be

RE: [U2] UniVerse and Shadow copy on Windows 2003

One way is to use the GNU screen software that was mentioned some time ago. This allows another user to "adopt" other users sessions and take them over, like TANDEM should (but TANDEM doesnt seem to work reliably on HPUX). Then it is simply a question of firing the various quit commands that t

[U2] CN=Asvin DATTANI/OU=IBEU/O=HSBC is out of the office.

I will be out of the office starting 24/08/2007 and will not return until 03/09/2007. - SAVE PAPER - THINK BEFORE YOU PRINT! This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be

Re: [U2] Serious problem with open files

Hi John, I do not know about your second issue, but we have had the first issue using Universe on HP UX. In our case, it was one program opening and clearing a file (using CLEARFILE) and then executing another program as a phantom. The Unix process for the second program inherits file handle

[U2] CN=Asvin DATTANI/OU=IBEU/O=HSBC is out of the office.

I will be out of the office starting 11/05/2007 and will not return until 12/05/2007. - SAVE PAPER - THINK BEFORE YOU PRINT! This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not b

[U2] CN=Asvin DATTANI/OU=IBEU/O=HSBC is out of the office.

I will be out of the office starting 11/05/2007 and will not return until 29/05/2007. - SAVE PAPER - THINK BEFORE YOU PRINT! This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not b

Re: [U2] Users of UniVerse

HSBC in their investment banking division have been using Universe or it's predecessors for the last 20 odd years and look likely to do so for the next twenty .. "Liesse, Dave" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 27/04/2007 14:28 Mail Size: 4842 Please respond to u2-users

Re: [U2] PORT.STATUS bug?

Hi Scott, this is a known issue in some versions of Universe. It is fixed at one of the 10.1.nnn releases - not sure which. From our experience, it seems to only occur when you have a program that is sleeping, and you run PORT.STATUS more than once without any appreciable gap in between. cheer

Re: [U2] [UV] Help PORT.STATUS broken

Sorry, that should be UNLOCK PSTATLOCK to unlock it [EMAIL PROTECTED] 03/10/2006 17:19 Mail Size: 6261 Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2] [UV] Help PORT.STATUS broken Entity Investment Banking Europe - IBEU Its the P

Re: [U2] [UV] Help PORT.STATUS broken

Its the PORT.STATUS semaphore. Do a SEMAPHORE.STATUS in the uv account, and you should see it somewhere near the bottom. There is an UNLOCK SEMAPHORE command that you should be able to use to release it hth asvin [EMAIL PROTECTED] wrote on 03/10/2006 17:07:48: > Hi all, > > Can someone

RE: [U2] Multiple Data Files

Hi Charles, I am an old pickie, but you're right in saying that I am not familiar with the Multiple data files construct in Universe. I have used multiple data files in Pick, but that was very simple concept. This on the other hand, looks a bit contrived, but I can see what it's trying to d

Re: [U2] UV - Distributed files

Hi Jerry, Actually, I know about multi-data files too... I used to use them on Pick R83, to simulate what Universe later implemented much more cleanly as distributed files. Part numbers dont have to be sequential and dont have to start at 1 ( I didnt know that until I was told quite recently.

RE: [U2] Multiple Data Files

I suspect that the Ron is talking about distributed files.. Ron - this is a mechanism where you can split the data over several individual part files, but still be able to see it all together as one logical file. This means that you can open the file as a whole, and read records or select

Re: [U2] Runtime errors

HI Dave, Probably no use to you because I note that you are running Unidata, but on Universe there is file in the Universe install directory called errlog. This logs all these run time errors. It's been some years since I worked on Unidata, but I do vaguely recall a similar file there... .perh

Re: [U2] [uv] PORT.STATUS detail

Hi Brian, That is the hex instruction code address. You can see which line of code it is by doing a VLIST on the program. cheers, asvin Brian Grayson <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/04/2006 16:03 Mail Size: 4351 To "U2-Users@listserver.u2ug.org" cc Subject [U2] [uv] PO

Re: [U2] Universe: Version and serial number

CONFIG ALL from TCL [EMAIL PROTECTED] wrote on 27/02/2006 18:10:30: > How do I get version and serial number from a UniVerse AIX installation? I > am drawing a blank here. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.o

Re: [U2] Access IBM Knowledge base

My apologies - I replied to the wrong message last night [EMAIL PROTECTED] wrote on 22/02/2006 21:27:35: > You've gone very quiet > * > HSBC Bank plc > Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom > Registered in England - Number 14259

Re: [U2] Access IBM Knowledge base

You've gone very quiet * HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority * From: owner-u2-users

Re: [U2] UV: Tru64 to Solaris

Hi Gordon, Actually, as other posters have mentioned, 64 bit files allow for file sizes much larger than 2gb. However, there was a bug in Universe 9.6.x which in effect limited 64 bit files to 2gb. This was fixed on subsequent releases, but if the 64 bit file was created on 9.6, then it will

Re: [U2] UV 10.1.11 Windows 2003 server SP2

Hi Tony, Do you mean the errlog file? This keeps a record of run time errors, and is in the universe installation directory. hth, asvin [EMAIL PROTECTED] wrote on 16/02/2006 00:24:57: > Where is the Universe Log file? I wanted to check it after receiving the > following message and relized

RE: [U2] Java Platform Struggles

Hi Kathy, If you are on Unix, I believe each database connection spawns a separate process, with uvapi_slave in the command. So you could just do a ps -ef | grep uvapi hth. asvin [EMAIL PROTECTED] wrote on 24/01/2006 14:36:48: > You guys have lots of experience on using UniObjects. May I

RE: [U2] Difference between IBM Universe and IBM UniData

Hi, Leroy was kind enough to arrange for it to be ported to Universe as part of release 10. We have 10.0.19, and it is on that... cheers, asvin. "David Wolverton" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 20/01/2006 16:10 Mail Size: 4612 Please respond to u2-users@listserver.u2ug

RE: [U2] DATE conversion problem

Hi, Universe defaults to American style date format. To get round this, I explicitly set european date format when I create the session object: sess.command("DATE.FORMAT ON") where sess is the session object. hth, cheers, asvin [EMAIL PROTECTED] wrote on 11/01/2006 11:08:40: > REPOSTED FOR

Re: [U2][UV] Aborted Shutdown

Hi Michael, Hardly a guru, but fwiw I think the problem is likely to be a user process that has not completely died. When Universe starts, it creates a shared memory segment for its own use. As users login, a shared memory segment is created for each user. When the user logs off, the shared me

Memo: Re: [U2] UV: 64 bit files

Hi Mark, We use 64 bit files extensively for large files. The only drawback that we have found is that the Unix size of the file increases when you convert from 32 bit to 64 bit (because of larger forward and backward pointers). Theoretically, if you have a large number of very small records the

Memo: Re: [U2] Universe editor Help for ^ character

Hi Pankaj, Type in ^ and return. The editor will display ^ mode off or similar. You should then be able to type the strings you want. The ^ mode is there to allow you to enter control characters, for example ^253 for a value mark. It defaults to on, but you can toggle it on and off by pressing ^

Memo: RE: [U2] [UV] indexed 64 bit files {Unclassified}

Hi, Universe 64 bit files created on 9.6 do blow up at the 4gb limit, even if you subsequently upgrade. Solution appears to be do a resize * * * after upgrading... We're on HP UX - may not apply to other platforms. hth, asvin "John Jenkins" <[EMAIL PROTECTED] on 10 Jul 2005 11:28 Please re

Memo: Re: [U2] PRINTER memory segment removed

Hi Ang, You get the message "Printer Segment Removed" if you invoke universe when already running universe as another user. I usually get this message when I sh out to the shell from the Universe command language prompt, su to another user code, and then invoke universe by using the uv cmd from

Memo: RE: [U2] Source code question

>I'd also wonder about port-specific usage. I believe I > worked on a Unix > box a while back where they mapped the ports so that every > time a person logged > in they got the same port number. Don't ask me exactly how > they did this. HP-UX has a facility called DDFA. It is meant to be use

Memo: Re: [U2] VOC Out-Of-Date Error Message

Hi Bill, Updating the VOC in each is part of the process when upgrading Universe versions. This involve copying VOC entries from the NEWACC file in the UV account to the VOC in each user account. If there is already an entry in the user account VOC with the same ID but of a different type (e.g. c

Re: [U2] Extending U2 with gci/CALLC -- Factory Floor Automation - Serial Connectivity ?

We use gci and have done so for many year. The only gotcha is that the file handles opened by the C routines count towards the Universe mfiles limit * HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 1425

Memo: Re: [U2] [UV]Unable to get process lock semaphore

Hi Marco, analyze.shm -s at the os level will give you a list of active semaphores. That should show you which semaphore is set. The use the UNLOCK with the SEMAPHORE key word to release it. Do HELP UNLOCK to get more details... hth Marco Manyevere <[EMAIL PROTECTED] on 17 Feb 2005 10:56 P

Memo: Re: [U2] Uv Error

Hi Rudy, this is a real mystery then. We had a problem once with the number of open files in the rotating file pool getting confused. As you probably know, you can open many more files in a Universe program then the os allows. Universe will only keep open, at the os level, the number of files s

Memo: Re: [U2] Uv Error

Hi Rudy, Doesnt look like a UV message. Do you have the source of the program? It would be useful to know what line 8 is. Have you ruled out a backup locking the file? "Cooper, Rudy" <[EMAIL PROTECTED] on 15 Feb 2005 21:31 Please respond to u2-users@listserver.u2ug.org Sent by:[EMAIL

Memo: Re: [U2] UV - GROUP.STAT.DETAIL

to hand - i'll try and dig them out if no one else has them. cheers, asvin You could probably also use the replacement fixtool, but I've never used it for that. Asvin DATTANI/IBEU/[EMAIL PROTECTED] on 03 Feb 2005 17:50 Please respond to u2-users@listserver.u2ug.org Sent by:

Memo: Re: [U2] UV - GROUP.STAT.DETAIL

Hi Carolina, You could use the RECORD command... RECORD filename itemname will display the group that item hashes to. hth "Carolina Lizama" <[EMAIL PROTECTED] on 03 Feb 2005 13:43 Please respond to u2-users@listserver.u2ug.org Sent by:[EMAIL PROTECTED] To:u2-users@listserver.u

Memo: Re: [U2] test

it was thanksgiving yesterday in the states, so I guess most people have taken the weekend off... "Les Hewkin" <[EMAIL PROTECTED] on 26 Nov 2004 14:25 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:"U2 Users (E-mail)" <[EMAIL PROTECTED]> cc: bcc: Subject:[U2]

Memo: Re: [U2] PICK Assembler Language

Hi Sean, Before there was this new fangled Universe and Unidata, PICK was a platform independent os/database. It used to run on a variety of platforms from big IBM mainframes all the way down to small minicomputers, and then when PC's were invented (8086 based!!) even on them. This was all achiev

Memo: RE: [U2] Spooler question

Hi, Just a thought - Universe prints using a Unix script which you specify in attribute 6 of the &DEVICE& file. You could write a script which checks to see which of the two printers is less busy (use lpstat -0 perhaps?) and then output to that printer. I am no Unix scripting expert but I dont t

Memo: Re: [U2] [UV] Typo leads to discovery of new feature

HI Brian, Can you elaborate on what this bug was? UV 9.6 on HPUX about to move to UV10.0.19. thanks, asvin "Brian Leach" <[EMAIL PROTECTED] on 13 Oct 2004 10:44 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: bcc: Subject:Re: [U2]

Memo: Re: [U2] Tuning uvconfig parameters in universe 9.6

Hi Javed, 1. Universe does not have a 64 bit mode as you understand it. There is a uvconfig parameter that decided whether the default mode for newly created files is 64 bit or 32 bit, but I dont think that is what you are looking for. Individual files in Universe can be 64 bit or 32 bit. You ne

Memo: Re: [U2] Help - clobbered file !

Hi Andrew, You may also need to clear the resize bit. You can do this by using filepeek filname from unix and the entering rcl. hth asvin "Mats Carlid" <[EMAIL PROTECTED] on 22 Sep 2004 09:38 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: bc

Memo: Re: Unclassified RE: [U2] UniSession.connect error

Hi, there is tech tip on the techconnect web site that I found very useful when trying to get UniRpc working. IIRC, there was something about logs in there. You need to login to techconnect and then go to this url: https://www-927.ibm.com/software/data/u2/support/u2techconnect/u2kbdisplay.asp?i

Memo: RE: [U2] Universe file size limit

Truhans <[EMAIL PROTECTED] on 01 Sep 2004 17:51 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Asvin DATTANI/IBEU/[EMAIL PROTECTED] bcc: Subject:RE: [U2] Universe file size limit Hello! We have had problems with big UV 64-bit files

Memo: Re: RE: [U2] Universe file size limit

Hi Glen, This is the output when we first ran across the problem: 0008 Program "FIS00200": Line 551, Internal data error. 0009 Program "FIS00200": Line 555, Internal data error. 0010 Program "FIS00200": Line 555, WRITE failure. Line 551 is a MATREADU from the file, and line 555 is a MATWRITE to

Memo: RE: [U2] Universe file size limit

Hi, Thanks for all the responses. Ulimit, is set to unlimited so that shouldn't be the problem. Our unix support people cant find any other HPUX kernel parameter that would affect the maximum file size. Glen's recollection is correct - HPUX support file sizes up to 128 terabytes. It is looking i

[U2] Memo: Universe file size limit

Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large...

Memo: Re: [U2] PORT.STATUS

Hi Ang, Assuming that you are using Universe The PORT.STATUS command is usually locked by a semaphore. You can check the status of semaphores by using the SEMAPHORE.STATUS command (nomrally only available in the uv account) To unlock the PORT.STATUS semaphore: UNLOCK PSTATLOCK SEMAPHORE ht

Memo: RE: [U2] UOJ connect error 81009

Hi Guys, thanks for all the replies, Wendy Smoak wrote: > 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. Thanks, Wendy. Yes, it looks as if I'll h

[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: 810

Memo: Re: [U2] [UV] File corruption error, but ON ERROR branch not taken

Hi Craig, What we do here is to produce a como whenever a program is run from the menu system and then to check the como for common errors such as variable not assigned a value etc. The menu system executes a como on before executing the program. When the program returns back to the menu system,

Memo: Re: [U2] Universe error

Hi Ian, I used to get this on NT4 and universe 9.6. It happened whenever a user closed a Universe telnet session without logging off. maybe the same issue? cheers, asvin [EMAIL PROTECTED] on 30 Jun 2004 23:08 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL

[U2] Memo: [UV] analyze.shm -S failing with error code 2 2

Hi, We recently installed Universe 10.0.19 on one of our Universe servers, running HPUX 11.11. As part of the upgrade process, we copied over the uv.rc script from /opt/universe/sample to /etc/init.d, changed MFILES, ran uvregen and Dbsetup. All of this seemed to go through without any problems.