Re: [U2] File name of the RECORDS which are listed in LIST.READU output
I do the same but every time you login. Louis ' - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, August 06, 2005 12:43 AM Subject: Re: [U2] File name of the RECORDS which are listed in LIST.READU output : In a message dated 8/4/2005 1:56:49 AM Pacific Daylight Time, : [EMAIL PROTECTED] writes: : : : 2. Write a simple program to build your own register of inode numbers. You : can do this with a loop based on the following : : I take Martin's idea one step further. : I have a phantom, that every night rebuilds the inode-to-filename xref table. : Then when people run the LIST-READU command, I have it display the filename : instead of the inode. : While there *are* occasions when the filename is not in the list, because : it's been created that *day*, they are usually rather rare. : Will Johnson : Fast Forward Technologies : --- : 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] File name of the RECORDS which are listed in LIST.READU output
Louis Windsor [EMAIL PROTECTED] wrote on 08/06/2005 04:12:35 AM: I do the same but every time you login. The context of this is a bit blurred due to over-quoting, so I just want to make sure I understood correctly. Does the same mean going through all file references in an account and creating an entry in an i-node table for each? And does you mean every user? If so, you may want to reconsider this strategy. If you have five people logging on simultaneously, each of them is buzzing through the VOC, opening each file referenced therein, resolving the device and i-node, then constructing and writing a record in a reference table. Now, let's say you have dozens or hundreds of users logging on simultaneously - say, at the start of business in the morning. The overhead of all of the I/O (including many expensive OPEN operations) and contention for the lock table will be overwhelming. Not to mention the delay the user encounters before being able to start working. Maybe you could check a time stamp somewhere and bypass the procedure if the table has been rebuilt in the last, let's say, 10 minutes. That will still give you fairly current information, assuming somebody has logged in recently. However, if you don't have people logging in constantly throughout the day, the table could get rather stale at times. I'd be more inclined to have something that is scheduled on a regular basis. Or, since you apparently have a wrapper around LIST.READU, maybe have that wrapper check a time stamp to see how old the i-node look-up table is. If it's not very fresh, ask whether to rebuild it right before doing the native LIST.READU command. If, on the other hand, I misunderstood what you're doing, then please ignore the two previous paragraphs. ;-) Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] File name of the RECORDS which are listed in LIST.READU output
WARNING - LONG STORY I'm sorry Tim - I told a lie! The first User to login for the day causes the inode table to be refreshed. The logic is built in (through subroutines) called by ALL programs that update files. Should a lock occur the subroutine rerefreshes before notifying the User. The Users are told, with a bottom line message, which record is locked, in which file, by whom, running which program. Like :- Trying To Access PRODUCT MASTER FILE Locked By Fred User In Program No actual file names rather file descriptions are displayed. Security measure! The subroutine then beeps every second and loops on the lock. The User knows who to contact and whose butt to kick! I thought of including a phone number but Big Sister said No! Only the IT dept can query the full lock status with a function that reports on all locks set including the deadly embraces (UniVerse calls them Waiters) in progress, which Users are involved, which files, which records and how long each User has been idle so we (IT) know who has gone for a cup of coffee or gone home! We are in five States, and three (?) time zones. Complications occur when untrained (or impatient) Users kill their telnet sessions and go home leaving the lock in place then IT must use UNLOCK User etc etc. Pardon my lie, I did all this about 15 years ago! With a few tweaks as Unixes ( Unixi :) ) changed from time to time with hardware (and software) updates etc. I warned you it was a long story! Louis - Original Message - From: Timothy Snyder [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, August 07, 2005 12:19 AM Subject: Re: [U2] File name of the RECORDS which are listed in LIST.READU output : Louis Windsor [EMAIL PROTECTED] wrote on 08/06/2005 04:12:35 AM: : : I do the same but every time you login. : : The context of this is a bit blurred due to over-quoting, so I just want : to make sure I understood correctly. Does the same mean going through : all file references in an account and creating an entry in an i-node table : for each? And does you mean every user? : : If so, you may want to reconsider this strategy. If you have five people : logging on simultaneously, each of them is buzzing through the VOC, snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] File name of the RECORDS which are listed in LIST.READU output
I use a (borrowed) program that relies on GETREADU() (Unidata) GETREADU Syntax GETREADU() Description The UniBasic GETREADU function returns a dynamic array containing information about all records that have been locked by any UniBasic or ECL command that updates any record. This command delivers the same information as the ECL command LIST.READU, but in a different format. A value mark separates these pieces of information. An attribute mark separates the information about different locks. The number of locks is returned in @SYSTEM.RETURN.CODE. AE BP REC.LOCKS Top of REC.LOCKS in BP, 41 lines, 1,183 characters. 001: *-- REC.LOCKS --- 002: PROMPT '' 003: R.PH = GETREADU() 004: P = -1 005: Y = 25 006: PRINT @(-1): 007: MAX = COUNT(R.PH,@FM) + (R.PH # '') 008: IF MAX = 1 THEN 009: FOR CNT = 1 TO MAX 010: Y += 1 011: IF Y 21 THEN 012: P += 1 013: IF P 0 THEN 014: PRINT @(0,23):'RETURN TO CONTINUE :': 015: INPUT CR 016: IF CR[1,1] = 'S' OR CR[1,1] = 'Q' OR CR[1,1] = 'E' THEN 017: PRINT 018: STOP 019: END 020: END 021: Y = 2 022: PRINT @(-1):'*** RECORD LOCKS ***' 023: PRINT 'UID PT LOGINS.. FILE NAME... ': 024: PRINT 'RECORD KEY.. ..TIME.. ...DATE' 025: END 026: PORT = FIELD(R.PHCNT,5,'/',2,1) 027: FPOS = COUNT(R.PHCNT,6,'/') + (R.PHCNT,6 # '') 028: FNAME = FIELD(R.PHCNT,6,'/',FPOS,1) 029: PRINT @(0,Y):FMT(R.PHCNT,3,'R#3'):' ':FMT(PORT,'R#2'): 030: PRINT ' ':FMT(R.PHCNT,4,'L#8'):' ':FMT(FNAME,'L#20'): 031: PRINT ' ':FMT(R.PHCNT,9,'L#20'):' ':FMT(R.PHCNT,11,'R#8'): 032: PRINT ' ':FMT(R.PHCNT,12,'L#12') 033: NEXT CNT 034: END ELSE 035: PRINT @(-1):'* * * RECORD LOCKS * * *' 036: PRINT 037: PRINT ' No locks to report ' 038: PRINT 039: END 040: END 041: * Bottom. Output example: *** RECORD LOCKS *** UID PT LOGINS.. FILE NAME... RECORD KEY.. ..TIME.. ...DATE 288 6 honarya FIXED.ASSETS 6846 07:50:49 Aug 05 2005 313 4 cash RCPT.SESSIONS2372 07:52:19 Aug 05 2005 At 01:03 AM 8/4/2005, Pankaj Gupta04 wrote: Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta *---* Jon Wells Database Administrator Beloit College Information Services ResourcesBeloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* AIX 5.1.3 IBM RS6000 F50 UniData 6.0.8 *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] File name of the RECORDS which are listed in LIST.READU output
Unfortunately this is not in Universe. - Original Message - From: Jon Wells [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, August 05, 2005 7:59 AM Subject: Re: [U2] File name of the RECORDS which are listed in LIST.READU output I use a (borrowed) program that relies on GETREADU() (Unidata) GETREADU Syntax GETREADU() Description The UniBasic GETREADU function returns a dynamic array containing information about all records that have been locked by any UniBasic or ECL command that updates any record. This command delivers the same information as the ECL command LIST.READU, but in a different format. A value mark separates these pieces of information. An attribute mark separates the information about different locks. The number of locks is returned in @SYSTEM.RETURN.CODE. AE BP REC.LOCKS Top of REC.LOCKS in BP, 41 lines, 1,183 characters. 001: *-- REC.LOCKS --- 002: PROMPT '' 003: R.PH = GETREADU() 004: P = -1 005: Y = 25 006: PRINT @(-1): 007: MAX = COUNT(R.PH,@FM) + (R.PH # '') 008: IF MAX = 1 THEN 009: FOR CNT = 1 TO MAX 010: Y += 1 011: IF Y 21 THEN 012: P += 1 013: IF P 0 THEN 014: PRINT @(0,23):'RETURN TO CONTINUE :': 015: INPUT CR 016: IF CR[1,1] = 'S' OR CR[1,1] = 'Q' OR CR[1,1] = 'E' THEN 017: PRINT 018: STOP 019: END 020: END 021: Y = 2 022: PRINT @(-1):'*** RECORD LOCKS ***' 023: PRINT 'UID PT LOGINS.. FILE NAME... ': 024: PRINT 'RECORD KEY.. ..TIME.. ...DATE' 025: END 026: PORT = FIELD(R.PHCNT,5,'/',2,1) 027: FPOS = COUNT(R.PHCNT,6,'/') + (R.PHCNT,6 # '') 028: FNAME = FIELD(R.PHCNT,6,'/',FPOS,1) 029: PRINT @(0,Y):FMT(R.PHCNT,3,'R#3'):' ':FMT(PORT,'R#2'): 030: PRINT ' ':FMT(R.PHCNT,4,'L#8'):' ':FMT(FNAME,'L#20'): 031: PRINT ' ':FMT(R.PHCNT,9,'L#20'):' ':FMT(R.PHCNT,11,'R#8'): 032: PRINT ' ':FMT(R.PHCNT,12,'L#12') 033: NEXT CNT 034: END ELSE 035: PRINT @(-1):'* * * RECORD LOCKS * * *' 036: PRINT 037: PRINT ' No locks to report ' 038: PRINT 039: END 040: END 041: * Bottom. Output example: *** RECORD LOCKS *** UID PT LOGINS.. FILE NAME... RECORD KEY.. ..TIME.. ...DATE 288 6 honarya FIXED.ASSETS 6846 07:50:49 Aug 05 2005 313 4 cash RCPT.SESSIONS2372 07:52:19 Aug 05 2005 At 01:03 AM 8/4/2005, Pankaj Gupta04 wrote: Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta *---* Jon Wells Database Administrator Beloit College Information Services ResourcesBeloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* AIX 5.1.3 IBM RS6000 F50 UniData 6.0.8 *---* --- 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] File name of the RECORDS which are listed in LIST.READU output
In a message dated 8/4/2005 1:56:49 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: 2. Write a simple program to build your own register of inode numbers. You can do this with a loop based on the following I take Martin's idea one step further. I have a phantom, that every night rebuilds the inode-to-filename xref table. Then when people run the LIST-READU command, I have it display the filename instead of the inode. While there *are* occasions when the filename is not in the list, because it's been created that *day*, they are usually rather rare. Will Johnson Fast Forward Technologies --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] File name of the RECORDS which are listed in LIST.READU output
Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] File name of the RECORDS which are listed in LIST.READU output
on a RedHat 8.0 the following find commando will work : find /path_to_data/ -inum inode -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04 Sent: Thursday, August 04, 2005 8:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] File name of the RECORDS which are listed in LIST.READU output Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** ** Denne mail er blevet scannet af http://www.virus112.com ** ** Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] File name of the RECORDS which are listed in LIST.READU output
I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? The locking tables use device and inode numbers and have no reference to the file name. Two easy solutions... 1. Run ACCOUNT.FILE.STATS and look up the inode number in the resultant STAT.FILE. This is easy but is going to take a while! 2. Write a simple program to build your own register of inode numbers. You can do this with a loop based on the following OPEN 'VOC' TO VOC.F ELSE STOP 'Cannot open VOC' SELECT VOC.F TO 1 CT = 0 LOOP READNEXT ID FROM 1 ELSE EXIT READ VOC.REC FROM VOC.F, ID THEN TYPE = VOC.REC[1,1] IF TYPE = 'F' OR TYPE = 'Q' THEN OPEN ID TO DATA.F THEN STATUS VAR FROM DATA.F THEN INODE = VAR10 DEVICE = VAR11 ...Save this data somewhere... CT += 1 IF REM(CT, 100) = 0 THEN DISPLAY CHAR(13):CT:' files processed': END END END END REPEAT DISPLAY CHAR(13):CT:' files processed' END I have used this many times to build a file, keyed by inode that contains the file name and other useful information. It is very fast. Beware that resizing a file will usually change its inode so you need to run this program again. Martin Phillips Ladybridge Systems 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] File name of the RECORDS which are listed in LIST.READU output
That's what I did here and it works quite nicely. I have a nightly process that (re)builds a registry of all file with their device and inode number. Then I shelled the 'LIST.READU' command to produce a locks listing showing the file name for each locked item. Quite helpful for us here. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: Thursday, August 04, 2005 4:56 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] File name of the RECORDS which are listed in LIST.READU output I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? The locking tables use device and inode numbers and have no reference to the file name. Two easy solutions... 1. Run ACCOUNT.FILE.STATS and look up the inode number in the resultant STAT.FILE. This is easy but is going to take a while! 2. Write a simple program to build your own register of inode numbers. You can do this with a loop based on the following OPEN 'VOC' TO VOC.F ELSE STOP 'Cannot open VOC' SELECT VOC.F TO 1 CT = 0 LOOP READNEXT ID FROM 1 ELSE EXIT READ VOC.REC FROM VOC.F, ID THEN TYPE = VOC.REC[1,1] IF TYPE = 'F' OR TYPE = 'Q' THEN OPEN ID TO DATA.F THEN STATUS VAR FROM DATA.F THEN INODE = VAR10 DEVICE = VAR11 ...Save this data somewhere... CT += 1 IF REM(CT, 100) = 0 THEN DISPLAY CHAR(13):CT:' files processed': END END END END REPEAT DISPLAY CHAR(13):CT:' files processed' END I have used this many times to build a file, keyed by inode that contains the file name and other useful information. It is very fast. Beware that resizing a file will usually change its inode so you need to run this program again. Martin Phillips Ladybridge Systems 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] File name of the RECORDS which are listed in LIST.READU output
Doesn't LIST.READU DETAIL give you the file name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04 Sent: Thursday, August 04, 2005 2:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] File name of the RECORDS which are listed in LIST.READU output Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ### This message has been scanned by F-Secure Anti-Virus. ### This message has been scanned by F-Secure Anti-Virus. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] File name of the RECORDS which are listed in LIST.READU output
LIST.READU EVERY will show you what you should need regarding locks. Note the INODE number then shell to Unix/Linux and do ls -li | grep [inode] this will give you a file name. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Roberts Sent: Thursday, August 04, 2005 8:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] File name of the RECORDS which are listed in LIST.READU output Doesn't LIST.READU DETAIL give you the file name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04 Sent: Thursday, August 04, 2005 2:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] File name of the RECORDS which are listed in LIST.READU output Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ### This message has been scanned by F-Secure Anti-Virus. ### This message has been scanned by F-Secure Anti-Virus. --- 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] File name of the RECORDS which are listed in LIST.READU output
DETAIL does not appear to be an available option, at least on uv -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Roberts Sent: Thursday, August 04, 2005 09:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] File name of the RECORDS which are listed in LIST.READU output Doesn't LIST.READU DETAIL give you the file name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04 Sent: Thursday, August 04, 2005 2:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] File name of the RECORDS which are listed in LIST.READU output Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ### This message has been scanned by F-Secure Anti-Virus. ### This message has been scanned by F-Secure Anti-Virus. --- 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] File name of the RECORDS which are listed in LIST.READU output
Not on UV. UV 10.1.6 Pick flavor. It just returns a few more numbers. Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 63029562 528980 56380 1 RU 9156 login_1 020750*02#001*18#13516 630265603567660 42 2 RU 6993 login_2 MDC.GROUPS 63029562 528980 56941 19 RU 8595 login_1 386400*05#001*241#135 Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 08/04/2005 09:07:05 AM: Doesn't LIST.READU DETAIL give you the file name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04 Sent: Thursday, August 04, 2005 2:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] File name of the RECORDS which are listed in LIST.READU output Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] File name of the RECORDS which are listed in LIST.READU output
UV 10.1.7 on AIX 5.2.2 The LIST.READU DETAIL returns: LIST.READU DETAIL Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 2490371 255640 34 17 RU 08644 karen-sa 75 2490371 452720106 18 RU 35872 cp-tracy 001361 2490371 460660225 26 RU 41448 cp-linda 145544 2490371 254600 34 27 RU 08644 karen-sa 352017 2490371 255640108 37 RU 60434 jerry-sa 920575 2490371 259750 63 40 RU 13830 patti-ac ANGIE 2490371 252880108 49 RU 60434 jerry-sa 351959*024 2490371 247030108 56 RU 60434 jerry-sa 351959*025 2490371 254550 34 65 RU 08644 karen-sa 352017 24903713524520295 71 RU 40888 gary-aw 350701 2490371 251270236 88 RU 74892 arussell 253036*004**524498*001 2490371 246500294 88 RU 86586 clock013291*2*13731 2490371 251560108 94 RU 60434 jerry-sa 52162*01 LIST.READU EVERY returns: LIST.READU EVERY Active Group Locks:Record Group Group Group Device Inode Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX 2490371 253310315 12 IN 104000 1 0 0 0 2490371 452720106 18 IN 2A9000 1 0 0 0 2490371 251560108 23 IN 917800 1 0 0 0 2490371 460660225 35 IN 48800 1 0 0 0 2490371 255640 49 37 IN 115000 1 0 0 0 2490371 259750 26 40 IN 26000 1 0 0 0 2490371 247030108 58 IN 1E800 1 0 0 0 2490371 249420183 64 IN F800 1 0 0 0 2490371 252880108 76 IN 28000 1 0 0 0 2490371 460660225 77 IN 15800 1 0 0 0 2490371 251270133 88 IN 319000 1 0 0 0 Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 2490371 253310315 12 RU 00224 young-ac 013647 2490371 452720106 18 RU 35872 cp-tracy 001361 2490371 251560108 23 RU 60434 jerry-sa 52526*01 2490371 460660225 35 RU 41448 cp-linda 145536 2490371 255640108 37 RU 60434 jerry-sa 920575 2490371 259750 63 40 RU 13830 patti-ac ANGIE 2490371 247030108 58 RU 60434 jerry-sa 351959*034 2490371 249420 59 64 RU 17124 arussell ADJ-IN-USE 2490371 252880108 76 RU 60434 jerry-sa 351959*033 2490371 460660225 77 RU 41448 cp-linda 145536*001 2490371 251270236 88 RU 74892 arussell 253036*004**524498*001 Active Read Waiters: Owner Waiter Device Inode Userno Userno 249037125975 63 26 249037125975 63 47 Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Roberts Sent: Thursday, August 04, 2005 8:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] File name of the RECORDS which are listed in LIST.READU output Doesn't LIST.READU DETAIL give you the file name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04 Sent: Thursday, August 04, 2005 2:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] File name of the RECORDS which are listed in LIST.READU output Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: LIST.READU Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 34485434 99680 55990 9 RU 9546 appsadm GGB101031 34485434 99640 37921 12 RU 27615 appsadm CCB1011300764 344854334784380 60553 17 RU 4983 appsadm HHB1010300083 344854334784230 36137 31 RU 29399 appsadm GGB101031 34485434 99690 52754 63 RU 12782 appsadm FFB1010300015 34485434 99910 53543 102 RU 11993 appsadm GGB101031 34485434 99640 50360 107 RU 15176 appsadm GGB101031 34485434 103910 47313 121 RU 18223 appsadm GGB101031 Regards, Pankaj Gupta CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its