Re: [U2] Simple Export to Excel
Careful Tony, the AD police will be after you :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony G Sent: Tuesday, 23 June 2009 7:22 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simple Export to Excel As Robert describes, double quotes are used in freeware I've published called ExcelExport, which exports full workbooks and individual worksheets to CSV. You can get the software from our freeware page and see the TXT Readme for details. no.spam.pleaseNebula-rnd.com/freeware/ Rather than making another post, I'll mention here that people are using our NebulaXLite from SB+, and it even displays progress info through SBClient as it works through large reports. And for people who say use XML, well, that's exactly what NebulaXLite does. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Visit PickWiki.com! Contribute! From: Robert Porter Double-quotes can be embedded within the quoted field by escaping them. Just double up the double-quote character. So the text: This is my description field. Would go be exported as: This is my description field. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor for long filename in type 1 file
Why not just resize UFD to a type 19? Norman, David (Health) wrote: UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1 level. I have created an I-type to extract delimited fields within the @ID which either spans the 2 levels, or is wholly in the 2nd level. Using this I-type to display in a LIST works perfectly. However, as soon as a WITH references this field, nothing is returned. E.g.: LIST UFD WITH @ID LIKE ...as... SAMPLE 5 DATE2 11:10:14 23-06-09 PAGE 1 OS filename...DATE LOG.as13713_15125_49176 29.05.09 LOG.as13713_15125_58659 29.05.09 LOG.as13713_15125_59104 29.05.09 LOG.as13713_15125_59132 29.05.09 LOG.as13713_15125_60631 29.05.09 Sample of 5 records listed. ::LIST UFD WITH DATE2 = 29.5.09 0 records listed. The DICT of DATE2 is: 0001: I 0002: FIELD(@ID,'_',2) 0003: D2. 0004: DATE 0005: 8R 0006: S I don't want to resize UFD to type 19 on this mission-critical 24x7 system - how else can I get WITH to use these fields ??? David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor for long filename in type 1 file
Create a type 19 file and redirect the logs to the new file. UFD is a bad place to store these types of files anyway because it is the account directory. When yo go to clean up the file you may accidently remove part of your account. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, June 23, 2009 8:55 AM To: U2 Users List Subject: Re: [U2] I Descriptor for long filename in type 1 file Why not just resize UFD to a type 19? Norman, David (Health) wrote: UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1 level. I have created an I-type to extract delimited fields within the @ID which either spans the 2 levels, or is wholly in the 2nd level. Using this I-type to display in a LIST works perfectly. However, as soon as a WITH references this field, nothing is returned. E.g.: LIST UFD WITH @ID LIKE ...as... SAMPLE 5 DATE2 11:10:14 23-06-09 PAGE 1 OS filename...DATE LOG.as13713_15125_49176 29.05.09 LOG.as13713_15125_58659 29.05.09 LOG.as13713_15125_59104 29.05.09 LOG.as13713_15125_59132 29.05.09 LOG.as13713_15125_60631 29.05.09 Sample of 5 records listed. ::LIST UFD WITH DATE2 = 29.5.09 0 records listed. The DICT of DATE2 is: 0001: I 0002: FIELD(@ID,'_',2) 0003: D2. 0004: DATE 0005: 8R 0006: S I don't want to resize UFD to type 19 on this mission-critical 24x7 system - how else can I get WITH to use these fields ??? David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits
Can some one help me with a problem we have. The STATUS() is returning a 4 digit uid of the person who has a record locked. I need this to reflect the actual 5 digit uid number. It is causing a problem by informed a user that a record is locked by user 1234 but it is actually locked by user 51234. I pretty sure that this is related, but the LISTUSER is only displaying a 4 digit UID with the first digit being truncated. Wyatt Buffington Manitoba Hydro ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits
What OS? I _think_ we had that issue with aix 5.3, and it was resolved with one of the July patch releases. Buffington, Wyatt wrote: Can some one help me with a problem we have. The STATUS() is returning a 4 digit uid of the person who has a record locked. I need this to reflect the actual 5 digit uid number. It is causing a problem by informed a user that a record is locked by user 1234 but it is actually locked by user 51234. I pretty sure that this is related, but the LISTUSER is only displaying a 4 digit UID with the first digit being truncated. Wyatt Buffington Manitoba Hydro ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits
Sorry, I should know better. We are running Unidata 7.2 on a HP Unix 11.23. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 23, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits What OS? I _think_ we had that issue with aix 5.3, and it was resolved with one of the July patch releases. Buffington, Wyatt wrote: Can some one help me with a problem we have. The STATUS() is returning a 4 digit uid of the person who has a record locked. I need this to reflect the actual 5 digit uid number. It is causing a problem by informed a user that a record is locked by user 1234 but it is actually locked by user 51234. I pretty sure that this is related, but the LISTUSER is only displaying a 4 digit UID with the first digit being truncated. Wyatt Buffington Manitoba Hydro ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] XML mapping to multiple files records
Hi Folks, Here's a scenario for you: Let's say there is an XML file containing album track data that we'd like to import into 2 different Universe files. A sample layout might be something like: albums album album_ID/ album_title/ album_total_runtime/ album_total_tracks/ tracks track number=1 track_ID/ track_title/ track_artist/ /track track number=2 track_ID/ track_title/ track_artist/ /track /tracks album /albums What I'm trying to do is have an ALBUMS file and a TRACKS file. I want a single record in the ALBUMS file for each album and a record in the TRACKS file for each track. Essentially every album record in the XML will product one ALBUMS record and potentially multiple TRACKS records. The trouble I'm having is getting more than one TRACKS record. I'm wondering if anyone has ever tried this before and how their experience went. I end up with just one TRACKS record with the first iteration. Is what I'm trying even possible? I've opened a case with IBM as well but figured maybe one of you has been in this situation before. - Josh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XML mapping to multiple files records
Why two files? That would be the approach with a SQL type database, but in Universe, you can make the track data multi-valued related fields in the albums file. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Tuesday, June 23, 2009 10:38 AM To: U2 Users List Subject: [U2] XML mapping to multiple files records Hi Folks, Here's a scenario for you: Let's say there is an XML file containing album track data that we'd like to import into 2 different Universe files. A sample layout might be something like: albums album album_ID/ album_title/ album_total_runtime/ album_total_tracks/ tracks track number=1 track_ID/ track_title/ track_artist/ /track track number=2 track_ID/ track_title/ track_artist/ /track /tracks album /albums What I'm trying to do is have an ALBUMS file and a TRACKS file. I want a single record in the ALBUMS file for each album and a record in the TRACKS file for each track. Essentially every album record in the XML will product one ALBUMS record and potentially multiple TRACKS records. The trouble I'm having is getting more than one TRACKS record. I'm wondering if anyone has ever tried this before and how their experience went. I end up with just one TRACKS record with the first iteration. Is what I'm trying even possible? I've opened a case with IBM as well but figured maybe one of you has been in this situation before. - Josh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XML mapping to multiple files records
The scenario and sample I posted is theoretical. The actual data structure is much larger and has way too many nested levels. Unfortunately splitting data is a must. The two files piece is working fine it's just the multiple records in the second file that's an issue. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Tuesday, June 23, 2009 1:42 PM To: 'U2 Users List' Subject: Re: [U2] XML mapping to multiple files records Why two files? That would be the approach with a SQL type database, but in Universe, you can make the track data multi-valued related fields in the albums file. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Tuesday, June 23, 2009 10:38 AM To: U2 Users List Subject: [U2] XML mapping to multiple files records Hi Folks, Here's a scenario for you: Let's say there is an XML file containing album track data that we'd like to import into 2 different Universe files. A sample layout might be something like: albums album album_ID/ album_title/ album_total_runtime/ album_total_tracks/ tracks track number=1 track_ID/ track_title/ track_artist/ /track track number=2 track_ID/ track_title/ track_artist/ /track /tracks album /albums What I'm trying to do is have an ALBUMS file and a TRACKS file. I want a single record in the ALBUMS file for each album and a record in the TRACKS file for each track. Essentially every album record in the XML will product one ALBUMS record and potentially multiple TRACKS records. The trouble I'm having is getting more than one TRACKS record. I'm wondering if anyone has ever tried this before and how their experience went. I end up with just one TRACKS record with the first iteration. Is what I'm trying even possible? I've opened a case with IBM as well but figured maybe one of you has been in this situation before. - Josh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] FW: Valid Backup on Windows Universe
All - We are attempting to enact IBM's double mirrored striped set backup alternative. This is where your server has a RAID array of 0+1 and then a second Raid 1 that is mirrored to the first mirror. The process as IBM describes it is: 1. Quiesce the database (pause all writes, data can still be read, no loss of data) 2. Split off the second set of mirrored drives 3. Restart the database 4. Backup system using split off hard-drives 5. Rejoin the mirrors Has anyone used this scenario in a windows environment? Wondering what types of RAID systems people are using? - (3) Arrays all of which are Raid 0 and in the OS you mirror those RAID 0's - A Raid 0+1 Array and another Raid 0+1 and then in the OS mirror the 2 Arrays - (3) Arrays Raid 0+1 and in the OS you mirror the 3 arrays Were there any drawbacks to this scenario? Any scenarios that works better? 2 final things to keep in mind, we are not in a SAN and we are not doing Transaction Logging. Thanks. Kevin Gusler Applications Developer Mortgage Builder Software, Inc. http://www.mortgagebuilder.com www.mortgagebuilder.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Kevin Gusler wrote: All - We are attempting to enact IBM's double mirrored striped set backup alternative. This is where your server has a RAID array of 0+1 and then a second Raid 1 that is mirrored to the first mirror. The process as IBM describes it is: 1. Quiesce the database (pause all writes, data can still be read, no loss of data) 2. Split off the second set of mirrored drives 3. Restart the database 4. Backup system using split off hard-drives 5. Rejoin the mirrors Has anyone used this scenario in a windows environment? Wondering what types of RAID systems people are using? - (3) Arrays all of which are Raid 0 and in the OS you mirror those RAID 0's - A Raid 0+1 Array and another Raid 0+1 and then in the OS mirror the 2 Arrays - (3) Arrays Raid 0+1 and in the OS you mirror the 3 arrays Were there any drawbacks to this scenario? Any scenarios that works better? We use this scenario with aix. Should work ok with windows. As long as you are using HARDWARE raid, I think it is safe. I wouldn't trust software raid to this task. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor for long filename in type 1 file
The suggestion about including the OCONV in the i-descriptor should do it for you. It has to do with how the system looks at the data in input or output format. The D2 conversion is not part of the ouput but moving the OCONV up should change the data to match the with clause. From: david.nor...@health.sa.gov.au To: u2-users@listserver.u2ug.org Date: Tue, 23 Jun 2009 11:16:25 +0930 Subject: [U2] I Descriptor for long filename in type 1 file UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1 level. I have created an I-type to extract delimited fields within the @ID which either spans the 2 levels, or is wholly in the 2nd level. Using this I-type to display in a LIST works perfectly. However, as soon as a WITH references this field, nothing is returned. E.g.: LIST UFD WITH @ID LIKE ...as... SAMPLE 5 DATE2 11:10:14 23-06-09 PAGE 1 OS filename...DATE LOG.as13713_15125_49176 29.05.09 LOG.as13713_15125_58659 29.05.09 LOG.as13713_15125_59104 29.05.09 LOG.as13713_15125_59132 29.05.09 LOG.as13713_15125_60631 29.05.09 Sample of 5 records listed. ::LIST UFD WITH DATE2 = 29.5.09 0 records listed. The DICT of DATE2 is: 0001: I 0002: FIELD(@ID,'_',2) 0003: D2. 0004: DATE 0005: 8R 0006: S I don't want to resize UFD to type 19 on this mission-critical 24x7 system - how else can I get WITH to use these fields ??? David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ Insert movie times and more without leaving Hotmail®. http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd_062009 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
How many disks are in your array and are they all raid 0? What kind of controller (if hardware) are you using that is doing a Raid 0+1+1?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main: 800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 23, 2009 2:04 PM To: U2 Users List Subject: Re: [U2] FW: Valid Backup on Windows Universe Kevin Gusler wrote: All - We are attempting to enact IBM's double mirrored striped set backup alternative. This is where your server has a RAID array of 0+1 and then a second Raid 1 that is mirrored to the first mirror. The process as IBM describes it is: 1. Quiesce the database (pause all writes, data can still be read, no loss of data) 2. Split off the second set of mirrored drives 3. Restart the database 4. Backup system using split off hard-drives 5. Rejoin the mirrors Has anyone used this scenario in a windows environment? Wondering what types of RAID systems people are using? - (3) Arrays all of which are Raid 0 and in the OS you mirror those RAID 0's - A Raid 0+1 Array and another Raid 0+1 and then in the OS mirror the 2 Arrays - (3) Arrays Raid 0+1 and in the OS you mirror the 3 arrays Were there any drawbacks to this scenario? Any scenarios that works better? We use this scenario with aix. Should work ok with windows. As long as you are using HARDWARE raid, I think it is safe. I wouldn't trust software raid to this task. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Kevin Gusler wrote: How many disks are in your array and are they all raid 0? What kind of controller (if hardware) are you using that is doing a Raid 0+1+1?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 23, 2009 2:04 PM To: U2 Users List Subject: Re: [U2] FW: Valid Backup on Windows Universe Kevin Gusler wrote: All - We are attempting to enact IBM's double mirrored striped set backup alternative. This is where your server has a RAID array of 0+1 and then a second Raid 1 that is mirrored to the first mirror. The process as IBM describes it is: 1. Quiesce the database (pause all writes, data can still be read, no loss of data) 2. Split off the second set of mirrored drives 3. Restart the database 4. Backup system using split off hard-drives 5. Rejoin the mirrors Has anyone used this scenario in a windows environment? Wondering what types of RAID systems people are using? - (3) Arrays all of which are Raid 0 and in the OS you mirror those RAID 0's - A Raid 0+1 Array and another Raid 0+1 and then in the OS mirror the 2 Arrays - (3) Arrays Raid 0+1 and in the OS you mirror the 3 arrays Were there any drawbacks to this scenario? Any scenarios that works better? We use this scenario with aix. Should work ok with windows. As long as you are using HARDWARE raid, I think it is safe. I wouldn't trust software raid to this task. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users I'm sorry, I am more of a user/dev than sysadmin. Our var set it up for us. What I do know is: AIX 5.3, external drive enclosure with 15 sas drives (I think). 12 are used for the udvg, in what they called a triple-mirror. I know that is not a technical term, but I never pushed the issue to determine what raid level it is. We use tivoli storage manager (that comes with aix) and use mkvgback. We basically do a dbpause, run a script called do-sbom-1, which creates the split mirror /sbom fs, resumes the ud db, startes the backup. After the backup completes to tape, do-sbom-2 is called which rejoins the mirror. It takes like 30 seconds for step 1, 4 hours for backup to tape, and a couple of hours to resync the raid. The users only see a 30second pause. The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. The only way to achieve that is to stop all scheduled jobs, logoff oall users, and complete all transactions. Hard to do in a 24-7 business. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Steve - Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main: 800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 23, 2009 2:34 PM To: U2 Users List Subject: Re: [U2] FW: Valid Backup on Windows Universe Kevin Gusler wrote: How many disks are in your array and are they all raid 0? What kind of controller (if hardware) are you using that is doing a Raid 0+1+1?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 23, 2009 2:04 PM To: U2 Users List Subject: Re: [U2] FW: Valid Backup on Windows Universe Kevin Gusler wrote: All - We are attempting to enact IBM's double mirrored striped set backup alternative. This is where your server has a RAID array of 0+1 and then a second Raid 1 that is mirrored to the first mirror. The process as IBM describes it is: 1. Quiesce the database (pause all writes, data can still be read, no loss of data) 2. Split off the second set of mirrored drives 3. Restart the database 4. Backup system using split off hard-drives 5. Rejoin the mirrors Has anyone used this scenario in a windows environment? Wondering what types of RAID systems people are using? - (3) Arrays all of which are Raid 0 and in the OS you mirror those RAID 0's - A Raid 0+1 Array and another Raid 0+1 and then in the OS mirror the 2 Arrays - (3) Arrays Raid 0+1 and in the OS you mirror the 3 arrays Were there any drawbacks to this scenario? Any scenarios that works better? We use this scenario with aix. Should work ok with windows. As long as you are using HARDWARE raid, I think it is safe. I wouldn't trust software raid to this task. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users I'm sorry, I am more of a user/dev than sysadmin. Our var set it up for us. What I do know is: AIX 5.3, external drive enclosure with 15 sas drives (I think). 12 are used for the udvg, in what they called a triple-mirror. I know that is not a technical term, but I never pushed the issue to determine what raid level it is. We use tivoli storage manager (that comes with aix) and use mkvgback. We basically do a dbpause, run a script called do-sbom-1, which creates the split mirror /sbom fs, resumes the ud db, startes the backup. After the backup completes to tape, do-sbom-2 is called which rejoins the mirror. It takes like 30 seconds for step 1, 4 hours for backup to tape, and a couple of hours to resync the raid. The users only see a 30second pause. The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. The only way to achieve that is to stop all scheduled jobs, logoff oall users, and complete all transactions. Hard to do in a 24-7 business. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Kevin Gusler wrote: Steve - Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com The db is basically in mid sentence. The commits are not atomic. If you restore to the tape, you may in my case have half an order or an invoice half processed. the unidata dbpause does not make people get out of maitnenance screens or release locks, so records can be in an uncommitted state. Risk is small, but it is present. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Are you using the Quiesce database command? (pause all writes, data can still be read, no loss of data)? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main: 800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 23, 2009 2:45 PM To: U2 Users List Subject: Re: [U2] FW: Valid Backup on Windows Universe Kevin Gusler wrote: Steve - Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com The db is basically in mid sentence. The commits are not atomic. If you restore to the tape, you may in my case have half an order or an invoice half processed. the unidata dbpause does not make people get out of maitnenance screens or release locks, so records can be in an uncommitted state. Risk is small, but it is present. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Kevin Gusler wrote: Are you using the Quiesce database command? (pause all writes, data can still be read, no loss of data)? we use dbpause in unidata. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? The db is basically in mid sentence. The commits are not atomic. If you restore to the tape, you may in my case have half an order or an invoice half processed. the unidata dbpause does not make people get out of maitnenance screens or release locks, so records can be in an uncommitted state. Risk is small, but it is present. Yes, have integrity at the UD OS level , but application layer may lack integrity at the logical transaction level. I don't know UD, but on UV this can be mitigated by using Transaction Logging in simple checkpoint mode, if nothing else. Your programs do not need to have transaction start/commit structures to take advantage of this. This is really update, not transaction, logging. I administered a system that didn't use Transaction Logging because of a bug (I think it's been fixed). We decided that our ap could live with a couple half baked transactions in the event of a restore, so we used the same double mirror/pause/split/tape backup as described by others, with one variation: We left the mirror split and stale for most of the day. That way if problems arose (e.g., broken file, file cleared inappropriately, etc.) I had fast access to the previous day's data. I occasionally took advantage of that feature. We never had a catastrophic failure during my tenure, but restoring from the stale mirror would have been much faster than restoring from backup tapes. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Charles - When you did this: so we used the same double mirror/pause/split/tape backup as described by others How many disks were in your array and were they all raid 0? What kind of controller were you using that was doing a Raid 0+1+1?? Sounds like you were on Universe, was it windows as well? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main: 800.850.8060 ext. 106 Fax: 248.304.0601 www.mortgagebuilder.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Tuesday, June 23, 2009 3:30 PM To: U2 Users List Subject: Re: [U2] FW: Valid Backup on Windows Universe Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? The db is basically in mid sentence. The commits are not atomic. If you restore to the tape, you may in my case have half an order or an invoice half processed. the unidata dbpause does not make people get out of maitnenance screens or release locks, so records can be in an uncommitted state. Risk is small, but it is present. Yes, have integrity at the UD OS level , but application layer may lack integrity at the logical transaction level. I don't know UD, but on UV this can be mitigated by using Transaction Logging in simple checkpoint mode, if nothing else. Your programs do not need to have transaction start/commit structures to take advantage of this. This is really update, not transaction, logging. I administered a system that didn't use Transaction Logging because of a bug (I think it's been fixed). We decided that our ap could live with a couple half baked transactions in the event of a restore, so we used the same double mirror/pause/split/tape backup as described by others, with one variation: We left the mirror split and stale for most of the day. That way if problems arose (e.g., broken file, file cleared inappropriately, etc.) I had fast access to the previous day's data. I occasionally took advantage of that feature. We never had a catastrophic failure during my tenure, but restoring from the stale mirror would have been much faster than restoring from backup tapes. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
Charles Stevenson wrote: with one variation: We left the mirror split and stale for most of the day. That way if problems arose (e.g., broken file, file cleared inappropriately, etc.) I had fast access to the previous day's data. I occasionally took advantage of that feature. We never had a catastrophic failure during my tenure, but restoring from the stale mirror would have been much faster than restoring from backup tapes. I have considered this and have a plan to do the same. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Valid Backup on Windows Universe
UV on HPUX. Disks were part of a huge SAN (vendor slips my mind at the moment) where our ap was just a small part of a mix of unix, windows, linux. I don't recall raid level. The SAN was administered by someone else. Tape backup was Legato. I really liked the idea of keeping the backups mirror split for most of the day, resynching just before the next split. Charles - When you did this: so we used the same double mirror/pause/split/tape backup as described by others How many disks were in your array and were they all raid 0? What kind of controller were you using that was doing a Raid 0+1+1?? Sounds like you were on Universe, was it windows as well? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] What Program Am I?
We've got a UV client/server application with a thick VB client. The vintage is around 1997, and the architecture has a debug mode that I leave on all the time that logs the calls back to the server and the arguments passed back and forth. The server side stuff is all phantomed off, so the output is in the PH file. Additionally, you can put display statements in the server side programs and the output from these will be sent to the PH record, mingled in with the other stuff. Debugging is old school, as you can't step through programs and any DEBUG statement will halt the server side program with no ability to do interactive I/O, and the client side window will appear hung, requiring the three finger salute. So you spend a lot of time putting in lines of code that look like: DISPLAY HERE I AM #17 and the like. Eventually I got fed up with counting value marks in PH file records and wrote a routine that formats MV data up nicely for display and makes a lot of tedious stuff easier. It makes my life easier. For tricky parts of the system, I often leave the debugging output calls in the programs; in case I need to come back some day and fiddle some more. But there is one thing I'd like to be able to do... It would be super if it were possible to see the call stack from a running program. Kind of like the the UV T debugger command. Sometimes I'm just wondering, How the hell did I get *there*. Or I'll see debugging output in the PH file and I wonder, What program is that from?. In those cases it would be useful to have the call stack sitting beside the output in the PH file. Does anybody know a way to do this? I've even considered building a little $INCLUDE snippet that updates @USER1 or a named common area and recompiling ever server side program with it added. Any help will be greatly appreciated. Dave Barrett, Lawyers' Professional Indemnity Company ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What Program Am I? {Unclassified}
Dave, From (IIRC) 10.0 onwards, there's the SYSTEM(9001) pseudo-variable which contains the UV CALL Stack. It's formatted a bit funny, but there may be a routine on the Pickwiki to make it a sensible format. HTH Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A Barrett Sent: Wednesday, 24 June 2009 8:33 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] What Program Am I? [Snip] It would be super if it were possible to see the call stack from a running program. Kind of like the the UV T debugger command. Sometimes I'm just wondering, How the hell did I get *there*. Or I'll see debugging output in the PH file and I wonder, What program is that from?. In those cases it would be useful to have the call stack sitting beside the output in the PH file. Does anybody know a way to do this? I've even considered building a little $INCLUDE snippet that updates @USER1 or a named common area and recompiling ever server side program with it added. Any help will be greatly appreciated. Dave Barrett, Lawyers' Professional Indemnity Company 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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What Program Am I?
Depending on the version of UV you are on you should be able to access SYSTEM(9001) from memory. This is an array which contains the call stack. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David A Barrett Sent: Wednesday, 24 June 2009 8:46 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] What Program Am I? We've got a UV client/server application with a thick VB client. The vintage is around 1997, and the architecture has a debug mode that I leave on all the time that logs the calls back to the server and the arguments passed back and forth. The server side stuff is all phantomed off, so the output is in the PH file. Additionally, you can put display statements in the server side programs and the output from these will be sent to the PH record, mingled in with the other stuff. Debugging is old school, as you can't step through programs and any DEBUG statement will halt the server side program with no ability to do interactive I/O, and the client side window will appear hung, requiring the three finger salute. So you spend a lot of time putting in lines of code that look like: DISPLAY HERE I AM #17 and the like. Eventually I got fed up with counting value marks in PH file records and wrote a routine that formats MV data up nicely for display and makes a lot of tedious stuff easier. It makes my life easier. For tricky parts of the system, I often leave the debugging output calls in the programs; in case I need to come back some day and fiddle some more. But there is one thing I'd like to be able to do... It would be super if it were possible to see the call stack from a running program. Kind of like the the UV T debugger command. Sometimes I'm just wondering, How the hell did I get *there*. Or I'll see debugging output in the PH file and I wonder, What program is that from?. In those cases it would be useful to have the call stack sitting beside the output in the PH file. Does anybody know a way to do this? I've even considered building a little $INCLUDE snippet that updates @USER1 or a named common area and recompiling ever server side program with it added. Any help will be greatly appreciated. Dave Barrett, Lawyers' Professional Indemnity Company ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor for long filename in type 1 file
David, In the second LIST you're looking for 29.5.09 yet the I-desc is returning 29.05.09. Try LIST UFD WITH DATE2 = 29.05.09. Just a thought. Norman, David (Health) wrote: UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1 level. I have created an I-type to extract delimited fields within the @ID which either spans the 2 levels, or is wholly in the 2nd level. Using this I-type to display in a LIST works perfectly. However, as soon as a WITH references this field, nothing is returned. E.g.: LIST UFD WITH @ID LIKE ...as... SAMPLE 5 DATE2 11:10:14 23-06-09 PAGE 1 OS filename...DATE LOG.as13713_15125_49176 29.05.09 LOG.as13713_15125_58659 29.05.09 LOG.as13713_15125_59104 29.05.09 LOG.as13713_15125_59132 29.05.09 LOG.as13713_15125_60631 29.05.09 Sample of 5 records listed. ::LIST UFD WITH DATE2 = 29.5.09 0 records listed. The DICT of DATE2 is: 0001: I 0002: FIELD(@ID,'_',2) 0003: D2. 0004: DATE 0005: 8R 0006: S I don't want to resize UFD to type 19 on this mission-critical 24x7 system - how else can I get WITH to use these fields ??? David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits
Here's a lead, not an answer. When we upgraded from 11.11 on HP Risc to 11.23 on HP Itanium, some of the permissions on files in /etc changed from rw-r--r-- to rw---. Owner remained root. That made a couple UV (not UD) utilities that relied on that unix info to yield up user counts stop working, except for user root. For whatever it's worth, cds We are running Unidata 7.2 on a HP Unix 11.23. Can some one help me with a problem we have. The STATUS() is returning a 4 digit uid of the person who has a record locked. I need this to reflect the actual 5 digit uid number. It is causing a problem by informed a user that a record is locked by user 1234 but it is actually locked by user 51234. I pretty sure that this is related, but the LISTUSER is only displaying a 4 digit UID with the first digit being truncated. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor for long filename in type 1 file
Thanks to those who responded - changing the I-Type didn't work, but Jerry offered sound advice to not use UFD anyway. What were temporary debugging files are now in use everyday, so a specific type 19 file is appropriate. I've now moved all these entries from UFD to their own file and all's well !! David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users