Re: [U2] Moving UniVerse over to another machine...
Hi, Simple if you have the same paths for uv and for your accounts in the target server. You can use Os file copying (with universe stopped on source server.) If you use SQL Schema you must prepare some informations with format.conv -export before file copying and run a format.conv -import. You must be carefull with uv (and subdirectories) some files must be copied : - uv\UV.ACCOUNT - uv\catdir (global catdir) - check the uv\VOC --- and other elements added/modified into uv account I you change the paths of uv or accounts, you must update all VOC files (there is full-OS-path inside records. We do it with a SEARCH-REPLACE prog here : * run as : UPDATE.UVACCOUNT startdir * startdir is a base-path for searching VOC files * -- * EFV 20-01-06 *--- EQU UVNT TO SYSTEM(91) EQU UVHOME TO SYSTEM(32) EQU OS.SEPTO IFS(SYSTEM(91),'\','/') EQU OS.RUN TO IFS(SYSTEM(91),'DOS /C ','SH -c ') * open UV.ACCOUNT OPEN 'UV.ACCOUNT' TO F.UVA ELSE EXECUTE 'SET.FILE UV UV.ACCOUNT UV.ACCOUNT' CAPTURING RIEN OPEN 'UV.ACCOUNT' TO F.UVA ELSE STOP 'UV.ACCOUNT NOT OPENED' END END * check start dir if @NULL, start fom first level of uvhomepath STMT = CHANGE(TRIM(@SENTENCE),' ',@AM) STARTDIR = '' IF STMT1 = 'RUN' THEN STARTDIR = TRIM(STMT4) END ELSE STARTDIR = TRIM(STMT2) END IF STARTDIR = '' THEN STARTDIR = FIELD(UVHOME,OS.SEP,1,2) * OPEN 'UV.ACCOUNT' TO F.UVA ELSE EXECUTE 'SET.FILE UV UV.ACCOUNT UV.ACCOUNT' CAPTURING RIEN OPEN 'UV.ACCOUNT' TO F.UVA ELSE STOP 'UV.ACCOUNT NOT OPENED' END END * lecture des fichiers VOC CRT 'Recherche dans 'STARTDIR:' de tous les VOC...' IF UVNT THEN EXECUTE OS.RUN:'DIR /B/S ':STARTDIR:'\VOC' CAPTURING VOCFILES END ELSE EXECUTE OS.RUN:'find ':STARTDIR: '-name VOC' CAPTURING VOCFILES END HEADING Mise ` jour de UV.ACCOUNT depuis :CHANGE(STARTDIR,'\','/'): 'TL' * upate uv.account with all VOC I can open LOOP REMOVE ID FROM VOCFILES SETTING EOS OPENPATH ID TO F.VOC THEN ACNT.NAME = UPCASE(FIELD(ID,OS.SEP,DCOUNT(ID,OS.SEP)-1)) ACNT.PATH = ID[1,COL2()-1] READ UVA FROM F.UVA,ACNT.NAME THEN IF UPCASE(UVA11) # UPCASE(ACNT.PATH) THEN PRINT '# ':FMT(ACNT.NAME,'ML#20'):' ':UVA11,ACNT.PATH END ELSE PRINT '= ':FMT(ACNT.NAME,'ML#20'):' ':ACNT.PATH END END ELSE WRITEV ACNT.PATH ON F.UVA,ACNT.NAME,11 PRINT '+ ':FMT(ACNT.NAME,'ML#20'):' ':ACNT.PATH END END WHILE EOS DO REPEAT * CHECK all UV.ACCOUNT if open VOC is ok SELECT F.UVA LOOP WHILE READNEXT ID DO READ UVA FROM F.UVA,ID THEN OPENPATH UVA11:OS.SEP:'VOC' TO F.DUMMY ELSE DELETE F.UVA,ID PRINT '- ':FMT(ID,'ML#20'):' ':UVA11 CONTINUE END END REPEAT I hope this help. Manu - Original Message - From: Gabriel Green [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 09, 2007 5:24 AM Subject: [U2] Moving UniVerse over to another machine... This weekend, I plan to move UniVerse (10.2, Win Server 2003 x64 Standard Edition, SP2) to another machine running the same OS. What is the proper procedure? I have already installed and authorized UV on the other machine. I take it it's not as simple as copying D:\IBM over to the other machine (the few UV accounts we use live in D:\IBM\CONV) Anybody have some tricks or tips? Thanks-- Gabe --- 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] Redirect printer to file
Hi, I wonder if someone can help, I am universe for Unix, and I would like to setup a printer device where the output from the print is sent to a directory as a unique file in that directory. how do i do this with the uv spooler thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Locks in a transaction
The order I use is to build the key by using a routine, then cut the KEY record lock loose, followed by a RECORDLOCK on the transaction to be written. We do a similar function, and have not seen signficant wait times. If you're already doing that, I'm not sure what could be occurring. john On 5/9/07, Moderator [EMAIL PROTECTED] wrote: REPOSTED FOR NON-MEMBER: Greg Livingston [EMAIL PROTECTED] I have a routine that runs in a transaction. Within the transaction I call a routine that generates the next sequential number for the record key. The problem I'm having is that one of my customer records has so many transaction to process that it holds the lock on the key generation program and my other users then hang as they are waiting for the record to unlock. Does anyone know a way of releasing the lock on a record with in a transaction before the final commit? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata error message
Is anyone familiar with this error message: Warning: Can't find the partition (1074266118) information in shared memory. The message appears on the screen, as well as in udt.errlog, whenever a dynamic file is accessed. If the dynamic file has four parts (dat001, dat002, ovr002, idx001 for example) the message appears four times. For example: :LIST TEST.FILE Warning: May 9 09:50:10, Can't find the partition (1074266118) information in shared memory. Warning: May 9 09:50:10, Can't find the partition (1074266118) information in shared memory. Warning: May 9 09:50:10, Can't find the partition (1074266118) information in shared memory. Warning: May 9 09:50:10, Can't find the partition (1074266118) information in shared memory. The message appears for existing dynamic files. If I create a new dynamic file, the message does not appear. Also, I have restarted Unidata and rebooted the server. Didn't help. We are on Unidata 6, hpux 11 tia -- 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] -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Locks in a transaction
I inherited a bunch of problematic final commits. Per the following, consider performing a Lock.And.Write as users change individual fields within a record. --Bill *--- SUBROUTINE SUB.LOCK.AND.WRITE.R1 ( R.This, This.File, Record.ID ) prompt '' open This.File to F.This.File else gosub Error.Opening.File gosub Lock.And.Write goThe.End *--- -- *--- -- Lock.And.Write: Lock.Test = recordlocked (F.This.File, Record.ID) begin case case Lock.Test = 0 ;recordlocku F.This.File, Record.ID write R.This on F.This.File, Record.ID release F.This.File, Record.ID case 1; gosub Error.Record.Locking end case return *--- --- Error.Opening.File: crt @(-1) crt @(-5) crt crt crt crt crt crt crt crt crt crt crt crt ' Big Problem...' : @(-6) crt crt ' _ ' crt ' \\ ' : This.File crt ' \ Error Opening File \' crt ' \\Contact HK.IT ' crt ' [X] ' crt '' : input Ans, 1 Ans = upcase(Ans) begin case case Ans = 'X' ; null case 1 ; go Error.Opening.File end case return to The.End *--- --- Error.Record.Locking: crt @(-1) crt @(-5) crt crt crt crt crt crt crt crt crt crt ' Big Problem...' : @(-6) crt crt ' _ ' crt ' \\ ' : This.File crt ' \ Error, Record Lock \' crt ' \\Contact HK.IT ' crt crt ' Open New Gull Session, Try UNLOCK.ME ' crt ' [X] ' crt ' ' : input Ans, 1 Ans = upcase(Ans) begin case case Ans = 'X' ; null case 1 ; go Error.Record.Locking end case return to The.End *--- --- The.End: RETURN END -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Moderator Sent: Wednesday, May 09, 2007 6:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] Locks in a transaction REPOSTED FOR NON-MEMBER: Greg Livingston [EMAIL PROTECTED] I have a routine that runs in a transaction. Within the transaction I call a routine that generates the next sequential number for the record key. The problem I'm having is that one of my customer records has so many transaction to process that it holds the lock on the key generation program and my other users then hang as they are waiting for the record to unlock. Does anyone know a way of releasing the lock on a record with in a transaction before the final commit? --- 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] Redirect printer to file
Mac, We do this type of thing all of the time. The following is one of our printer scripts (with bogus path names). In your printer device setup use the script that you create as the device driver. Make sure the script is executable. The case statement uses the form type to distribute the printout. The first case sends the printout to a file using the banner as the filename. Make sure you use valid system filenames in the banner, no spaces, I advise using a date and time stamp when creating the banner so it will be different every time. The second case is for both sending to a file and printing to a printer in landscape 132 character mode. The third case is for sending the file out through email using the banner as the email address and converting the printout to a pdf document using a free program from the internet (there are many out there, even with the same name, this one just happened to be freeware). I used mailx on this particular system so I could put in a return email address for bounced email but you can use whatever is available. You will notice the fields at the top of the script are the numbered positions of fields sent from the UniVerse spooler, these are used to determine how to treat the printout. If the form type is empty or not a case then the printout just prints on the printer in landscape 132 character mode. Jerry ptr.drv #!/usr/bin/sh # $1 = user no, $2 = job no, $3 = bytes, $4 = banner, $5 = form, # $6 = printer name # spool_file=/tmp/$1_$2 spool_file1=/tmp/$1_$2 spool_file2=/tmp/$2_$1 case $5 in TO_FILE) spool_file=/data/ibm/REPORTS/$4 cat - $spool_file ;; TO_FILEPTR) spool_file=/data/ibm/REPORTS/$4 cat - $spool_file echo ^027E^027l1o8D^027(s16.7H $spool_file1 cat $spool_file $spool_file1 echo ^027E $spool_file1 cat $spool_file1 | sed 's/$/^013/' $spool_file2 lp -d hpptr -o nobanner $spool_file2 ;; MAIL) if test $7 -lt 100 then cat - |/data/spool/text2pdf -c$7 -l$8 -v10 -F -s8 $spool_file else if test $7 -lt 200 then cat - |/data/spool/text2pdf -c$7 -l$8 -v10 -F -s6 -L $spool_file else cat - |/data/spool/text2pdf -c$7 -l$8 -v8 -F -s6 -L -y1008 $spool_file fi fi cat $spool_file | uuencode $2.pdf | mailx -r [EMAIL PROTECTED] -s Report from Account $4 ;; *) echo ^027E^027l1o8D^027(s16.7H $spool_file1 cat - $spool_file1 echo ^027E $spool_file1 cat $spool_file1 | sed 's/$/^013/' $spool_file2 lp -d hpptr -o nobanner $spool_file2 ;; esac - Original Message - From: Mac Bhyat [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 09, 2007 5:51 AM Subject: [U2] Redirect printer to file Hi, I wonder if someone can help, I am universe for Unix, and I would like to setup a printer device where the output from the print is sent to a directory as a unique file in that directory. how do i do this with the uv spooler thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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/
Fw: [U2] Redirect printer to file
Re: [U2] Redirect printer to fileI forgot two of the spooler fields that are used: $7 = line length, $8 = page length - Original Message - From: Jerry [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 09, 2007 10:40 AM Subject: Re: [U2] Redirect printer to file Mac, We do this type of thing all of the time. The following is one of our printer scripts (with bogus path names). In your printer device setup use the script that you create as the device driver. Make sure the script is executable. The case statement uses the form type to distribute the printout. The first case sends the printout to a file using the banner as the filename. Make sure you use valid system filenames in the banner, no spaces, I advise using a date and time stamp when creating the banner so it will be different every time. The second case is for both sending to a file and printing to a printer in landscape 132 character mode. The third case is for sending the file out through email using the banner as the email address and converting the printout to a pdf document using a free program from the internet (there are many out there, even with the same name, this one just happened to be freeware). I used mailx on this particular system so I could put in a return email address for bounced email but you can use whatever is available. You will notice the fields at the top of the script are the numbered positions of fields sent from the UniVerse spooler, these are used to determine how to treat the printout. If the form type is empty or not a case then the printout just prints on the printer in landscape 132 character mode. Jerry ptr.drv #!/usr/bin/sh # $1 = user no, $2 = job no, $3 = bytes, $4 = banner, $5 = form, # $6 = printer name # spool_file=/tmp/$1_$2 spool_file1=/tmp/$1_$2 spool_file2=/tmp/$2_$1 case $5 in TO_FILE) spool_file=/data/ibm/REPORTS/$4 cat - $spool_file ;; TO_FILEPTR) spool_file=/data/ibm/REPORTS/$4 cat - $spool_file echo ^027E^027l1o8D^027(s16.7H $spool_file1 cat $spool_file $spool_file1 echo ^027E $spool_file1 cat $spool_file1 | sed 's/$/^013/' $spool_file2 lp -d hpptr -o nobanner $spool_file2 ;; MAIL) if test $7 -lt 100 then cat - |/data/spool/text2pdf -c$7 -l$8 -v10 -F -s8 $spool_file else if test $7 -lt 200 then cat - |/data/spool/text2pdf -c$7 -l$8 -v10 -F -s6 -L $spool_file else cat - |/data/spool/text2pdf -c$7 -l$8 -v8 -F -s6 -L -y1008 $spool_file fi fi cat $spool_file | uuencode $2.pdf | mailx -r [EMAIL PROTECTED] -s Report from Account $4 ;; *) echo ^027E^027l1o8D^027(s16.7H $spool_file1 cat - $spool_file1 echo ^027E $spool_file1 cat $spool_file1 | sed 's/$/^013/' $spool_file2 lp -d hpptr -o nobanner $spool_file2 ;; esac - Original Message - From: Mac Bhyat [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 09, 2007 5:51 AM Subject: [U2] Redirect printer to file Hi, I wonder if someone can help, I am universe for Unix, and I would like to setup a printer device where the output from the print is sent to a directory as a unique file in that directory. how do i do this with the uv spooler thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ --- 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] UV Transactions when TXMODE is set to 0 {Unclassified}
Dear UniVerse Gurus, Our UniVerse system (10.1, Win2K3) is set up without any Transaction Logging parameters set in the UV Config. I.E. TXMODE = 0, and all the other related configration parameters are set to defaults. Transactions do however, still work from UniBasic or from UniObjects, even without TXMODE set - the UniAdmin documentation says A value of zero allows transactions to execute but not be logged So we can use UV Transactions to get all-or-none of a set of updates applied, i.e. ensure atomicity of operation, but not for roll-forward recovery from a crash. OK, so far so good ... But, where is the information needed to roll a transaction forward (Commit) or back (Rollback) stored in that situation? All the documentation in the PDF is about transaction logging, i.e. it assumes TXMODE = 1 Are there any configuration parameters which we ought to set, and if so, how could we determine the optimal values? TXMEM, for example. Thanks Mike 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] IPv6
IPv6 will be a non issue for most even if the potential for problems exists. When introduced I am sure you will find that internal subnets will still run IPv4 with bridges and an appropriate netmask e.g. 255.255.255.255.0.0. Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Locks in a transaction
Make sure that you do as little processing as possible within the actual transaction so that the transaction is short and sweet. Other than that, there is absolutely no way a lock should be released before a transaction completes. -Original Message- REPOSTED FOR NON-MEMBER: Greg Livingston [EMAIL PROTECTED] I have a routine that runs in a transaction. Within the transaction I call a routine that generates the next sequential number for the record key. The problem I'm having is that one of my customer records has so many transaction to process that it holds the lock on the key generation program and my other users then hang as they are waiting for the record to unlock. Does anyone know a way of releasing the lock on a record with in a transaction before the final commit? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Locks in a transaction
It would defeat the entire purpose of a transactions to allow a lock to be released during a transaction. Specifically, as the purpose is keep all related updates within the same transaction. If this next key update function does not need or *should* not to be rolled back, then this shouldn't be part of the transaction at all. I'm guessing a rollback of this key would cause serious implications. :-) As Stuart suggests...a redesign of update process to make the transaction smaller maybe your only course of action. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, May 10, 2007 11:11 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] Locks in a transaction Make sure that you do as little processing as possible within the actual transaction so that the transaction is short and sweet. Other than that, there is absolutely no way a lock should be released before a transaction completes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Incubator - News from the board
All, The U2UG board has been discussing the 'incubator plan' and we will soon be presenting a draft proposal to membership. Here's what we are discussing in broad brushstrokes - all feedback appreciated. We want an *easy* *legal* way to get PE editions into the hands of business people, college students, entrepreneurs, and other market expanders. More than that, we need to get people a version of the PE software which is chock full of examples, training materials, and useful information. Here's what we have in mind: We want to build an installer which pulls the PE editions from the IBM website (allowing the user to sign the IBM agreement), pulls Learner Packs from the U2UG website (allowing the user to sign the U2UG agreement - designed to protect the content all of you will - hopefully - contribute). Finally, the installer will bootstrap the Learner Packs into the PE installation, so the accounts, files, and programs, etc. are all in place. The end result will be a full install, with URLs to get them to the U2UG and other key locations. It will allow people to see our technology in the best light possible. Opinions? Flames? Offers to Help? Charles Barouch ([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/