Re: [U2] UniVerse and Shadow copy on Windows 2003
On 9/17/07, David Jordan [EMAIL PROTECTED] wrote: I have a client who is implementing snapshot backup method onto all of their windows 2003 servers. I suspect Universe 10.1 is not VSS (Microsoft volume shadow copy service) aware. Does anyone have thoughts and suggestions the best steps the client could use with doing incremental live snapshots of the U2 database on Windows 2003 throughout the day using Microsoft Volume Shadow copy services. Honestly, I'm not that familiar with Win2k3's Volume Shadow Copy services, but the best approach to backing up any U2 database, I've been told recommended by the IBM U2 support team, is to perform the following. They always suggest to never run OS-level command on a live database to avoid file corruption. The below assumes a RAID-1 disk configuration as a minimum. Steps 1-3 are relatively brief. 1) $UDTBIN/dbpause 2) Break the RAID-1 mirror 3) $UDTBIN/dbresume 3) Backup the offline mirror disk using any backup software either to disk or tape; do NOT touch the live main disk files! Also, backup any RFS logs...particularly, the offloaded archive LSN log files before/after image logs. 4) Once backup is finished, run a post backup script to resync re-enable the mirror. HTH, Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] create file
Interesting point, but here is why I used the touch command. The touch command has more specific standard error codes. If you use openseq else writeseq and both the openseq and writeseq fail, the touch command should provide a little more info. Only happens in obscure cases but it can save you some time. For example, if the filename contains an invalid character, like an exclamation point, the touch command will tell you what the problem is. The openseq and writeseq will tell you the generic could be permissions, could be something else status code. (One major drawback is that the touch command will not work on Windows.) -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- Larry Hiscock [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/14/2007 07:57 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject RE: [U2] [UD] create file You don't need to do the touch command. If the OPENSEQ takes the ELSE branch, but the content of STATUS() is 0, the file does not currently exist, but you can still WRITESEQ to the file handle, and the file will be created. Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor Sent: Friday, September 14, 2007 7:41 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] create file A lot more lines of code, but this should work. (Please double-check for typos.) FILE.IS.OPEN = 0 LOOP OPENSEQ '/path/file' TO FV ON ERROR PRINT;PRINT 'Could not open the /path/file file, status ':STATUS():'.' STOP END LOCKED PRINT;PRINT 'File /path/file is locked.' SLEEP 1 END THEN FILE.IS.OPEN = 1 END ELSE CMD = '!touch /path/file' EXECUTE CMD CAPTURING OUTPUT RETURNING ERROR.MESSAGE IF @SYSTEM.RETURN.CODE = -1 THEN PRINT;PRINT 'Could not create the /path/file file, status ':STATUS():'.' STOP END END UNTIL FILE.IS.OPEN DO REPEAT [EMAIL PROTECTED] wrote on 09/13/2007 09:44:15 PM: Hello group, I am a UV guy and I need some UD assistance. In UV I can OPENSEQ /path/file TO FV ELSE CREATE FV ELSE STOPM nope END Which will create the file if it doesn't exit, after which I can READEQ or READBLK to my heart's content. But UD dies at the CREATE statment. Also, instead of READBLK WRITEBLK it is OSBREAD, OSBWRITE in UD, correct ? Thanks, /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [BB] Does UD need the equivalent of uv/errlog?
Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages (and a few things that aren't really errors) that normally appear on the screen or PH file of the user generating the error. It shows what, who, when, where the error occurred. Does Unidata need the same? Chuck S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: Wednesday, September 12, 2007 1:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV basic assignment error ? As far as I can tell, UD doesn't have a BASIC runtime-error log. Oops - haphazard reading on my part. You're correct, of course. I actually get a lot of good information from the UniData logs that do exist, but then those are things that pertain more to what I normally do. And, as you pointed out, you shouldn't be making programming errors, anyway. ;-) OK - administering self-imposed cyber-spanking... Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [ud] Question on Alpha Sorting...
Could anyone elaborate on the optimization around Field-marks. A while back, I started avoiding traditional references to dynamic arrays (arraycounter) within loops because of the inefficiencies of having to traverse the array from the first character to the desired attribute during each iteration of the loop. I traditionally use a LOOP + REMOVE construct which seems to be much faster. Is there some sort of Unidata optimization related to Field marks/Attribute marks that I am not aware of as referenced by Rex in the comment below or is this just a Universe thing? Dan Eichholz Internet Production, Inc. 651-717-4323 [EMAIL PROTECTED] David, In terms of which is better for sorting inside a program, working with in-memory strings should be faster than writing to disk. And with less than a thousand names, it probably won't be noticeably faster whether you UPCASE() each time you insert, or maintain a separate UPCASE'd variable. I'm guessing that you'll also have an ID value associated with the name; that means LOCATE'ing on values. Field-marks in Universe (and I'm guessing in Unidata too) are optimized for traversing back and forth. Value-marks aren't, so when you INSERT a value after a LOCATE, the run-machine has to start at character one and find each value until it hits the specific value mark count. Ideally, you should be using field-mark delimited lists, but practically I don't think it would be noticeable. rex --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: SAPUG Meeting September 20th (was: Re: [U2] User Groups)
Larry: Can I get authorization to attend this meeting? The afternoon session is at 3pm, so I would need to leave about noon driving to get there on time. Session cost is $35, plus mileage of course. I could take care of my dinner if needed. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Morrissey Sent: Thursday, September 13, 2007 10:42 AM To: u2-users@listserver.u2ug.org Subject: SAPUG Meeting September 20th (was: Re: [U2] User Groups) Speaking of User Groups... If you're in the Northwest, you definitely want to attend the next SAPUG - Seattle Area Pick User Group meeting next Thursday September 20th. We're going to hear details about the most ambitious UV project I know of from Steve Ritchie of Market America: Join Steve Ritchie, VP of R/D and founding member of Market America to hear about how Universe is being in numerous unique ways to run their company as well as their growth financially and the steady buildup of their IT department. Steve will talk about challenges with rolling out a truly massive UniVerse project and about how the power of UniVerse has helped propel Market America to a billion dollar company in 5 countries. This is the project that elicited gasps at the U2UG Meeting at last year's Cincinnati Spectrum show. Our afternoon session will feature a technology preview from MITS looking at some of the technology underlying the advanced features in the next releases of MITS Discover and MITS Report. Special thanks to MITS for making their expertise available and underwriting this meeting. For details, see http://www.sapug.org and make sure to RSVP soon. Thanks, Ross VP Events - SAPUG --- 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] UniVerse and Shadow copy on Windows 2003
Hi all, Beware 1) $UDTBIN/dbpause 2) Break the RAID-1 mirror 3) $UDTBIN/dbresume 4) Backup the offline mirror disk This guarantees you a backup where there are no structural integrity problems from saving files in the middle of a change to overflow pointers, etc but it does not necessarily give you a backup that has business level data integrity. Unless your application uses transaction processing throughout (and few do), the dbpause may occur in the middle of a business level transaction. For example, if I transfer money between two client accounts, the dbpause may occur between taking it out of one account and adding to the other. If I restore the backup, the money is in neither account (Good news really... I've made a profit!). The only way to guarantee business level data integrity in non-transactional applications is to force all users off the system briefly while you do steps 1 - 3. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [BB] Does UD need the equivalent of uv/errlog?
Charles: This has been requested years ago. I've also posted a list of basic (not BASIC) enhancements to old the U2 Better and Better list. I don't know if it's still there, but I couldn't find it. So, I'm revising it to post again. :-) I'm was very surprised this isn't a normal part of UD. The enhancement is essential in the current IT environment where access to U2 is via pipes, sockets, web, and other means where noone is watching the results on a screen and BASIC is the ideal language to use in this environment. But, hey, that's just me...I have a tendency to make mistakes when developing applications. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, September 17, 2007 8:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] [BB] Does UD need the equivalent of uv/errlog? Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages (and a few things that aren't really errors) that normally appear on the screen or PH file of the user generating the error. It shows what, who, when, where the error occurred. Does Unidata need the same? Chuck S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: Wednesday, September 12, 2007 1:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV basic assignment error ? As far as I can tell, UD doesn't have a BASIC runtime-error log. Oops - haphazard reading on my part. You're correct, of course. I actually get a lot of good information from the UniData logs that do exist, but then those are things that pertain more to what I normally do. And, as you pointed out, you shouldn't be making programming errors, anyway. ;-) OK - administering self-imposed cyber-spanking... Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] create file [not-secure]
snip (One major drawback is that the touch command will not work on Windows.) /snip You can have touch available if you install Services for Unix. C:touch myself C:ls -latr myself C:rm myself And of course: C:rm -r * :) All work from within a 'Dos' window, not just a shell session. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [BB] Does UD need the equivalent of uv/errlog?
Chuck Stevenson wrote: Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages (and a few things that aren't really errors) that normally appear on the screen or PH file of the user generating the error. It shows what, who, when, where the error occurred. Does Unidata need the same? The enhancement requests exists in our system - e8201. At this point - there is only one customer associated with this request. If there is interest in this - the best way to get visibility for the request is to open a support case and ask to be added to that ecase. Regards, Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! [demime 1.01d removed an attachment of type image/jpeg which had a name of 12983515.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 12955357.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [BB] Does UD need the equivalent of uv/errlog?
Yes, I think the errlog is a great feature on universe. I utilize a background phantom process to monitor the file and send an email of recent errors every few minutes. It is a great way to see what programs have issues especially if you make a coding mistake and a user receives a 'variable unassigned' error for example. Not that that ever happens -Troy [snip] If there is interest in this - the best way to get visibility for the request is to open a support case and ask to be added to that ecase. Regards, Wally Terhune [snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse and Shadow copy on Windows 2003
The only way to guarantee business level data integrity in non-transactional applications is to force all users off the system briefly while you do steps 1 - 3. That's a good point. However, it's important to have a controlled way to do so. I've had people think they were safe to just log everybody off. Of course, there's no way to ensure you're not doing *that* in the middle of a transaction. ;-) Much worse, I've even had people with good intentions of getting everybody off of the system so they could have stable backups. How did they do it? With stopud -f or by doing a kill -9 on each user. Either one could create a mess at least as bad as backing up hot, since processes are not terminated cleanly. Actually, the mess could be worse with the unconditional kill methods, since they could result in corruption of the live database files, while backing up hot only impacts the backup copy. And if you do that while running RFS, head for the hills. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: SAPUG Meeting September 20th (was: Re: [U2] User Groups)
I don't know, can you? :-) -Original Message- From: Oaks, Harold [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 11:33 AM To: u2-users@listserver.u2ug.org Subject: RE: SAPUG Meeting September 20th (was: Re: [U2] User Groups) Larry: Can I get authorization to attend this meeting? The afternoon session is at 3pm, so I would need to leave about noon driving to get there on time. Session cost is $35, plus mileage of course. I could take care of my dinner if needed. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Morrissey Sent: Thursday, September 13, 2007 10:42 AM To: u2-users@listserver.u2ug.org Subject: SAPUG Meeting September 20th (was: Re: [U2] User Groups) Speaking of User Groups... If you're in the Northwest, you definitely want to attend the next SAPUG - Seattle Area Pick User Group meeting next Thursday September 20th. We're going to hear details about the most ambitious UV project I know of from Steve Ritchie of Market America: Join Steve Ritchie, VP of R/D and founding member of Market America to hear about how Universe is being in numerous unique ways to run their company as well as their growth financially and the steady buildup of their IT department. Steve will talk about challenges with rolling out a truly massive UniVerse project and about how the power of UniVerse has helped propel Market America to a billion dollar company in 5 countries. This is the project that elicited gasps at the U2UG Meeting at last year's Cincinnati Spectrum show. Our afternoon session will feature a technology preview from MITS looking at some of the technology underlying the advanced features in the next releases of MITS Discover and MITS Report. Special thanks to MITS for making their expertise available and underwriting this meeting. For details, see http://www.sapug.org and make sure to RSVP soon. Thanks, Ross VP Events - SAPUG --- 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/
Re: [U2] [ud] Question on Alpha Sorting...
Hi Dan, I tried some experiments a few years ago and convinced myself that UniData does not have field hints as supported in UniVerse. This may have changed but I cannot recall seeing any announcement of this. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [BB] Does UD need the equivalent of uv/errlog? [not-secure]
snip Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages (and a few things that aren't really errors) that normally appear on the screen or PH file of the user generating the error. It shows what, who, when, where the error occurred. Does Unidata need the same? Chuck S /snip While I'm not a UD user, I should think that it would benefit from the errlog function. But everyone would benefit by making it smarter... I would like to be able to configure it similar to syslog. I'd like 'low grade' errors either logged elsewhere or not at all... Usually half of my error log is generated from menu errors: Invalid command. Type ? for help. Usually someone has put a book on their Enter key Right now the only configurable option is the number of lines before the log rolls over. I'd like to have the option of pushing the error messages to the syslog service, where I could then do with them what I like. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and Shadow copy on Windows 2003
So, what is the best way to log users off cleanly in mass? You certainly can't depend on users to log off for themselves. Asking, begging, threateningnone of that works. I know for certain if I log in at 03:00, there will be 15 to 20 users still logged in, even though the building has been empty for hours. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Sometimes I wake up grumpy. Other times I let her sleep. === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: Monday, September 17, 2007 3:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse and Shadow copy on Windows 2003 The only way to guarantee business level data integrity in non-transactional applications is to force all users off the system briefly while you do steps 1 - 3. That's a good point. However, it's important to have a controlled way to do so. I've had people think they were safe to just log everybody off. Of course, there's no way to ensure you're not doing *that* in the middle of a transaction. ;-) Much worse, I've even had people with good intentions of getting everybody off of the system so they could have stable backups. How did they do it? With stopud -f or by doing a kill -9 on each user. Either one could create a mess at least as bad as backing up hot, since processes are not terminated cleanly. Actually, the mess could be worse with the unconditional kill methods, since they could result in corruption of the live database files, while backing up hot only impacts the backup copy. And if you do that while running RFS, head for the hills. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- 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] UniVerse and Shadow copy on Windows 2003
I have transaction processing in the application, but I don't believe that Universe has the dbpause and dresume options. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and Shadow copy on Windows 2003
We have a UNIX script that does a 'wall' warning people that they will be
logged off in
6 minutes
and 2 minutes
If they are not off:
/usr/ud/bin/listuser | egrep 'udt|phantom|unijdbc' | awk '{print deleteuser
$2 }' | ksh
and they usually are gone. Sometimes on Solaris, the UNIX Pid will be gone, but
listuser will still show the process. So we end up having to do a stopud -f as
a last resort.
So, what is the best way to log users off cleanly in mass?
===
Norman Morgan [EMAIL PROTECTED] http://www.brake.com
===
Sometimes I wake up grumpy. Other times I let her sleep.
===
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [BB] Does UD need the equivalent of uv/errlog?
Where is this $UVHOME file? I can't find it in my UV directory. -- Louie $ ls -l *HOME* ls: 0653-341 The file *HOME* does not exist. $ ls -l *UV* -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.ACCESS -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.ACCOUNT -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_LOGS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRPUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSYS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.ACCESS -rw-r--r-- 1 root system 4096 Jul 05 12:31 UV.ACCOUNT -rw-r--r-- 1 root system 4096 Jan 11 2007 UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_LOGS -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRPUB -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_UDRSYS On 9/17/07, Stevenson, Charles [EMAIL PROTECTED] wrote: Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [BB] Does UD need the equivalent of uv/errlog?
LOL, it is the uv directory. -Original Message- From: Louie Bergsagel [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 5:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [BB] Does UD need the equivalent of uv/errlog? Where is this $UVHOME file? I can't find it in my UV directory. -- Louie $ ls -l *HOME* ls: 0653-341 The file *HOME* does not exist. $ ls -l *UV* -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.ACCESS -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.ACCOUNT -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_LOGS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRPUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSYS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.ACCESS -rw-r--r-- 1 root system 4096 Jul 05 12:31 UV.ACCOUNT -rw-r--r-- 1 root system 4096 Jan 11 2007 UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_LOGS -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRPUB -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_UDRSYS On 9/17/07, Stevenson, Charles [EMAIL PROTECTED] wrote: Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages --- 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] UniVerse and Shadow copy on Windows 2003
I always just set MAXUSR to 0, and then walked around the company and logged everyone off who had gone home without logging out. Oh, yeah, that was PRIMOS, twenty years ago. And it only worked for the remote branches if I could find someone working late there, or the janitor, to log terminals out. -- Louie On 9/17/07, Norman Morgan [EMAIL PROTECTED] wrote: So, what is the best way to log users off cleanly in mass? You certainly can't depend on users to log off for themselves. Asking, begging, threateningnone of that works. I know for certain if I log in at 03:00, there will be 15 to 20 users still logged in, even though the building has been empty for hours. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Sometimes I wake up grumpy. Other times I let her sleep. === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: Monday, September 17, 2007 3:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse and Shadow copy on Windows 2003 The only way to guarantee business level data integrity in non-transactional applications is to force all users off the system briefly while you do steps 1 - 3. That's a good point. However, it's important to have a controlled way to do so. I've had people think they were safe to just log everybody off. Of course, there's no way to ensure you're not doing *that* in the middle of a transaction. ;-) Much worse, I've even had people with good intentions of getting everybody off of the system so they could have stable backups. How did they do it? With stopud -f or by doing a kill -9 on each user. Either one could create a mess at least as bad as backing up hot, since processes are not terminated cleanly. Actually, the mess could be worse with the unconditional kill methods, since they could result in corruption of the live database files, while backing up hot only impacts the backup copy. And if you do that while running RFS, head for the hills. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- 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/
RE: [U2] UniVerse and Shadow copy on Windows 2003 {unclassified}
I find that MASTER OFF ALL at TCL in the UV account works really well and cleanly. We kick all users off at midnight in order to stop the UV services so we can cleanly split off a 3rd level mirror for backup. I have scripted a MASTER OFF ALL, followed by a double check via tasklist (UV 10.1.18 on Windows 2003) for any hangers on. They get sorted out with a kill. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Norman Morgan Sent: Tuesday, 18 September 2007 8:40 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse and Shadow copy on Windows 2003 So, what is the best way to log users off cleanly in mass? You certainly can't depend on users to log off for themselves. Asking, begging, threateningnone of that works. I know for certain if I log in at 03:00, there will be 15 to 20 users still logged in, even though the building has been empty for hours. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Sometimes I wake up grumpy. Other times I let her sleep. === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: Monday, September 17, 2007 3:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse and Shadow copy on Windows 2003 The only way to guarantee business level data integrity in non-transactional applications is to force all users off the system briefly while you do steps 1 - 3. That's a good point. However, it's important to have a controlled way to do so. I've had people think they were safe to just log everybody off. Of course, there's no way to ensure you're not doing *that* in the middle of a transaction. ;-) Much worse, I've even had people with good intentions of getting everybody off of the system so they could have stable backups. How did they do it? With stopud -f or by doing a kill -9 on each user. Either one could create a mess at least as bad as backing up hot, since processes are not terminated cleanly. Actually, the mess could be worse with the unconditional kill methods, since they could result in corruption of the live database files, while backing up hot only impacts the backup copy. And if you do that while running RFS, head for the hills. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- 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/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and Shadow copy on Windows 2003
Universe 10.2.2 on Solaris 10 ASSIGN 1 TO SYSTEM(43) to suspend And 0 to un-suspend Or UVSUSPEND.FILES ON/OFF (APP.PROGS/UVSUSPEND.B) Ron Bertrand ISD/LIS Group Health 206-901-4519 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Monday, September 17, 2007 2:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse and Shadow copy on Windows 2003 I have transaction processing in the application, but I don't believe that Universe has the dbpause and dresume options. Regards David Jordan --- 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] [BB] Does UD need the equivalent of uv/errlog?
LOL, I'm IN the uv directory. LOGTO UV is a valid UniVerse command. It isn't my fault that Unix is UPCASE challenged. On 9/17/07, Jerry Banker [EMAIL PROTECTED] wrote: LOL, it is the uv directory. -Original Message- From: Louie Bergsagel [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 5:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [BB] Does UD need the equivalent of uv/errlog? Where is this $UVHOME file? I can't find it in my UV directory. -- Louie $ ls -l *HOME* ls: 0653-341 The file *HOME* does not exist. $ ls -l *UV* -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.ACCESS -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.ACCOUNT -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_LOGS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRPUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSYS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.ACCESS -rw-r--r-- 1 root system 4096 Jul 05 12:31 UV.ACCOUNT -rw-r--r-- 1 root system 4096 Jan 11 2007 UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_LOGS -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRPUB -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_UDRSYS On 9/17/07, Stevenson, Charles [EMAIL PROTECTED] wrote: Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages --- 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/
RE: [U2] UniVerse and Shadow copy on Windows 2003
Hi Ron Thanks for that. Are you aware of any issues I need to look out using this? Regards David Jordan Universe 10.2.2 on Solaris 10 ASSIGN 1 TO SYSTEM(43) to suspend And 0 to un-suspend Or UVSUSPEND.FILES ON/OFF (APP.PROGS/UVSUSPEND.B) Ron Bertrand --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [BB] Does UD need the equivalent of uv/errlog?
It is stored in the root directory (/) and is called .uvhome To find the contents of the uvhome file, just type in cat /.uvhome Rgds Bernard Lubin Development Department Reynolds and Reynolds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Tuesday, 18 September 2007 8:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [BB] Does UD need the equivalent of uv/errlog? Where is this $UVHOME file? I can't find it in my UV directory. -- Louie $ ls -l *HOME* ls: 0653-341 The file *HOME* does not exist. $ ls -l *UV* -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.ACCESS -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.ACCOUNT -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_LOGS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRPUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSYS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.ACCESS -rw-r--r-- 1 root system 4096 Jul 05 12:31 UV.ACCOUNT -rw-r--r-- 1 root system 4096 Jan 11 2007 UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_LOGS -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRPUB -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_UDRSYS On 9/17/07, Stevenson, Charles [EMAIL PROTECTED] wrote: Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages --- 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] [BB] Does UD need the equivalent of uv/errlog?
Thanks. I also had to log in as root. Not much there: # ls -l .uvhome -r--r--r-- 1 root system7 Jan 11 2007 .uvhome # cat /.uvhome /u2/uv On 9/17/07, Bernard Lubin [EMAIL PROTECTED] wrote: It is stored in the root directory (/) and is called .uvhome To find the contents of the uvhome file, just type in cat /.uvhome Rgds Bernard Lubin Development Department Reynolds and Reynolds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Tuesday, 18 September 2007 8:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [BB] Does UD need the equivalent of uv/errlog? Where is this $UVHOME file? I can't find it in my UV directory. -- Louie $ ls -l *HOME* ls: 0653-341 The file *HOME* does not exist. $ ls -l *UV* -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.ACCESS -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.ACCOUNT -rw-r--r-- 1 root staff 4096 May 11 2005 D_UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_LOGS -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRPUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 D_UV_UDRSYS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.ACCESS -rw-r--r-- 1 root system 4096 Jul 05 12:31 UV.ACCOUNT -rw-r--r-- 1 root system 4096 Jan 11 2007 UV.FLAVOR -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV.TRANS -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_LOGS -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRPUB -rw-rw-r-- 1 root system 208896 Jan 11 2007 UV_UDRSUB -rw-rw-r-- 1 root system 4096 Jan 11 2007 UV_UDRSYS On 9/17/07, Stevenson, Charles [EMAIL PROTECTED] wrote: Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages --- 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/
RE: [U2] UniVerse and Shadow copy on Windows 2003
1) If you want to do any error tracking or suspend/unsuspend verification flags you have to do it at the unix level - see #2!! I write status flags out to the backup dir for the process. 2) We are running the process from from a backup cron (with root access) and I found with that you need an account with a login voc that does not run anything that writes to Universe files. Pretty obvious once you do it!!! The backup process is doing a cd //bkup and then /usr/ibm/uv/bin/uv SUSPEND.ON, breaking a mirror and then a SUSPEND.OFFwith a resync later. So far we average 4 seconds suspended. Ron From: [EMAIL PROTECTED] on behalf of David Jordan Sent: Mon 9/17/2007 5:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse and Shadow copy on Windows 2003 Hi Ron Thanks for that. Are you aware of any issues I need to look out using this? Regards David Jordan Universe 10.2.2 on Solaris 10 ASSIGN 1 TO SYSTEM(43) to suspend And 0 to un-suspend Or UVSUSPEND.FILES ON/OFF (APP.PROGS/UVSUSPEND.B) Ron Bertrand --- 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] $UVHOME /.uvhome
Where is this $UVHOME file? I can't find it in my UV directory. In the root directory there is a hidden file called .uvhome that is a simple text file pointing to where universe is installed. Mine says: $cat /.uvhome /dbms/uv $ UVHOME is a variable that many people typically set up in their .profiles: UVHOME=`cat /.uvhome` export UVHOME So if I say echo $UVHOME I get this: $echo $UVHOME /dbms/uv $ Usually it is included in PATH, too: PATH=$PATH:$UVHOME/bin:/software/bin export PATH -Original Message- On 9/17/07, Stevenson, Charles [EMAIL PROTECTED] wrote: Is there a UniData enhancement request buried in the discussion below? UniVerse has a handy file called $UVHOME/errlog that logs runtime error messages --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] $UVHOME /.uvhome
From the Help, quote From a BASIC program there are two ways to find the UV account: * Use the UV.ROOT replace token that is defined in the FILENAMES.H header file * Use the SYSTEM (32) BASIC function Note: You cannot find the location of the UV account by opening and reading the /.uvhome file because this file does not exist on Windows NT (the location of the UV account is saved in the Windows NT Registry). unquote I tried the System(32) call and it worked for me. Jef. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
