RE: VOC corruption

te, 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>

RE: VOC corruption

Hi Ray, I have just switched it on now. I didn't realise you could turn it on and off like that. Thanks David The file is sized pretty well and is a type 11 Thanks Wol, I have had engineers go through all the hardware logs to no avail. There was a couple of small glitches during the last epis

VOC corruption

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 al

RE: [UV] Problem reactivating select list

Hi John, I think the problem you are seeing is a result of the EXECUTE command being executed in a separate shell or workspace. It can't see your select list. There are a couple of ways around this, use the PASSLIST keyword in the EXECUTE command (that is for ideal flavour, your mileage may vary a

RE: Memo: Re: UV: How do I determine whether a file is using 64 bitor 32 bit addressing

>0 %c >40char>0 %c end of magic file=== 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: [

RE: Modern Universe (TESTING)

Hi Joe, I must admit to being completely baffled as to your point. Are you 1) Trying to prove you know something about MS SQL? 2) Trying to prove you know something about Oracle? 3) Trying to prove you know nothing about Universe? 4) Trying to prove you haven't been to any course on the presentat

RE: Label printers on AIX and/or Solaris

Hi Karjala, If you don't wish to use the Solaris printing interface, install LPrng http://www.lprng.org as this is probably closer to what you are familiar with. This is more along the lines of the BSD setup and as such has a /etc/printcap file. Regards David Logan Database Administrator HP Mana

RE: Memo: Re: UV: How do I determine whether a file is using 64 bit or 32 bit addressing

Hi Steve, Use the filepeek verb, it is in the Universe bin directory (I presume this is unix as filepeek does not exist on windows (AFAIK)). Run this and look at the header information, it will tell you either 32 or 64 bit file. I also have a magic file (thanks to Glenn Herbert) that tells me from

RE: The lists are closing - REPRIEVE

I promise I won't make any more comments about "modern Universe", mea maxima culpa 8-o Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PRO

RE: Modern Universe - was: The lists are closing

Hi Will, troll( P ) Pronunciation Key (trl) v. trolled, troll*ing, trolls v. tr. 1. 1. To fish for by trailing a baited line from behind a slowly moving boat. 2. To fish in by trailing a baited line: troll the lake for bass. 3. To trail (a baited line) in fishi

RE: Modern Universe - was: The lists are closing

Hi Joe, Perhaps you could share your actual searches, code and database structure? Were you searching 20 million records in a single column table? Multiple "fields (or columns if you insist)" in the Universe database? What is this PICK you keep talking about? Universe doesn't have a component name

RE: Modern Universe - was: The lists are closing

ts after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Logan, David (SST - Adelaide) Sent: Monday, March 29,

RE: Modern Universe - was: The lists are closing

sponsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE

RE: The lists are closing

Best of luck Jeff, however I will point out the obvious, what is your definition of modern? I would have thought the good old "relational databases" have been around since before pick anyway? 8-) Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Austra

RE: The lists are closing

Hi Clif, I would like to pass on many thanks for all the hard work you have put in over the past years I have been subscribed. I am sure many others share my sentiments. Always the professional, courteous manager, I have been impressed by your ability to stay above the fray and moderate with skil

RE: UV 10.1.0 on Linux

Hi Phil, I am not too sure about the UV certication but for Informix IBM certify to a certain release of glibc etc. so it doesn't matter which release you wish to use just make sure your libraries are the correct level. I would presume UV will be pretty similar, perhaps Leroy or Wally could shed

RE: UNCLASSIFIED RE: UV - Database backup

Works for me 8-) > sudo /usr/opt/uv/bin/uv -admin uv [ -admin option] -c{learshm} clear BASIC catalog bit. -start start uniVerse. -stop shutdown uniVerse. -L{ock} Suspend file I/O. -R{eport} Current suspension status.

RE: [UD] 8 Bite Integers

Hi Fawaz, I must admit to being a little curious as to how the data is being loaded into informix. Which server are you using? Is this Dynamic Server? Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665

RE: [UD] 8 Bite Integers

2004 6:13 AM To: U2 Users Discussion List Cc: Logan, David (SST - Adelaide) Subject: RE: [UD] 8 Bite Integers Hi David, Thanks for the info. May be I didn't explain my problem correctly. I have a Unidata numeric field (Amount- 100.00 or -100.00) and I need to convert it to a 8 Bite integer so t

RE: [UD] 8 Bite Integers

Hi Fawaz, Is this what you are looking for? SEQ function Syntax SEQ (expression) Description Use the SEQ function to convert an ASCII character to its numeric string equivalent. Expression evaluates to the ASCII character to be converted. If expression evaluates to the null value, null is retu

RE: Two ways to acquire the U2 Tech Support Survival Kit CD

Hi Wally, What about us down here? Is it available outside the US? Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: telnet

Hi Greg, I'm out of ideas, give me unix anyday, at least I understand most of that 8-). The only thing I would thinkg of to check is the event log to see if this is giving you any idea and also do a netstat -a to check nothing else is sitting on port 23. Regards David Logan Database Administrato

RE: telnet

Hi Greg, Check to see the original telnet daemon hasn't started (should be in services). Universe uses the same port and if it is already being used, you will not be able to start the universe daemon. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000

RE: [UV] PORT.SATUS error message

Hi Stuart, You can use >SEMAPHORE.STATUS File access State Netnode Owner Collisions Retries Semaphore # 1 00 0 0 0 snip snip Semaphore # 97 00 0 0 0 Login State Netnode Owner Collisions Retries Semaphore # 1

RE: [OT] Making Linux bootable CD

Hi Martin, Having finished this exact task less than 24hrs ago 8-0 go into Roxio CD, Create a Data CD and then goto File menu, Create a CD from an image, browse to the directory where your iso files are (don't forget to change the file mask in the drop down box from cif to iso) and click on the fi

RE: Universe/RedBack on Linux

There are a few modules on Apache that run the asp code. I've tried the ASP Version 2.53 but haven't worked it particularly hard, it works but would need a bit more testing to try redback. Would be most interesting and save having to use IIS with the attendant security issues. 8=)> Apache runs very

RE: UV on SCO Unix

I can only agree to placing option 7 where it is, I would seriously look at an X86 server running a couple of Xeon processors at 2.4Ghz or quicker. If you have good Unix skills, take a long look at Linux, the price is right and there haven't been too many complaints on the list about the Universe p

RE: 2 gig limits

Hi Dan, We can use filepeek quite happily on our 64bit files. Do you mean uvfixfile? I know that has restrictions and cannot be used on 64bit files. The parameter in the uvconfig file is 64BIT. If this is set to 1, all files are created by default as 64bit files. Regards David Logan Database Adm

RE: 2 gig limits

It would have to be a 64bit file, there are no exceptions as this is a limitation brought on by the size of a number. (I think a couple of earlier posters had the numbers involved) therefore you literally cannot create a file larger than 2Gb with 32 bit addressing. We have a substantial number of

RE: 2 gig limits

Hi Jason, Yes, it sure does (please note these examples are Universe). Also please be aware there are limits with dynamic files as well. The dynamic file has 2 sub files in which the actual data is kept and the 2Gb limit applies to them : u-orion1.faulding.com.au> ls -l AR.ARCHIVE6 total 5187936

RE: [UV/AIX] gzip data to file?

Hi David (sounds familiar doesn't it!) Perhaps if you were to try zip instead of gzip, as this has a slightly different methodology, that might cure the issue with the unzip on windows. You can get it from http://aixpdslib.seas.ucla.edu/aixpdslib.html Regards David Logan Database Administrator H

RE: [UV] Problem with GET(ARG.,1)

Hi Barry, Probably is documented but a ? at the end of a command line at TCL will not execute the line and just store it on the command stack. I am surprised your program is executing at all. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia

RE: [UD] Determining if list exists

Title: Message Hi Chris,   Why not just use the 'REQUIRE.SELECT' or 'SELECT.ONLY' keywords in your query? This will then only run if there is a select list present. The Uniquery manual documents this quite well.   HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-L

RE: UCI Error

nnecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject

RE: UCI Error

Title: Message Hi David,   The docs say   IM985 Error in RPC interface   I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error   >ED SYS.MESSAGE 081002The file "SYS.MESSAGE" is read-only and cannot be updated.2

RE: The result of VARIABLE[1,3] + 0

Title: Message Hi Marco,   Universe doesn't use the + for concatenation, it uses the : (colon) symbol eg. '123':'456' will result in '123456'.   Both these examples come up with the expected results (1 and 579) on version 10.0.2 (UV personal edition, Linux) and also on 10.0.8 on Tru64.   R

RE: Distributed & multipart files [as RE: [UV] Resize - Dynamicor64 bit?]

e OS or the programmer. One client of mine had 12 monthly files (2-3 million records each) and the software combined the data into work files for cross-month queries.   thanks. - Original Message - From: Logan, David (SST - Adelaide) To: U2 Users Discus

RE: Distributed & multipart files [as RE: [UV] Resize - Dynamic or 64 bit?]

Title: Message Hi Stuart,   One large advantage (from my perspective) is the ability to address the file as one large file or as an single part individually. The open statement in the program is the same, only the name changes.   The ability to put the parts on different file systems, balan

RE: SAMBA and VPN

Hi David, Check out your WINS settings it is something to do with that. I had a similar problem but can't recall the exact solution. If you look on google or elsewhere you can search on the exact error message. I think it is also in the docs and HOWTOs on www.samba.org Regards David Logan Databa

RE: mkdbfile: create file in another account

Title: Message Hi Kate,   These commands are designed to be run from the unix or (blerk, I hate this word) dos environment. Running them from TCL would require an sh -c type command.   Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australi