RE: [U2] Delete files on secondary server before restore
I tried it out this morning, works great! Thank you for your help John! The following command saved in a .bat file should do it: rmdir /S D:\UVDir That will remove the directory and all subdirectories and files. You could add the uvrestore command immediately following that line to insure the deletion gets completed first. -John By D:\UVDir, I mean whatever directory or directories you've put your data in (in UV terms, the user accounts), not the UV installation directory. I just made the assumption that drive C: is probably your OS partition, and drive D: is probably your data storage partition, but this certainly may not be the case. You definitely don't want to remove the UV installation files, or any other OS files. Only remove the UV data that you're going to be restoring. If you have multiple accounts, you might have to execute multiple rmdir commands, or you could use a wildcard if they're all at the same level (eg: rmdir /S D:\UVDirs\*). We don't run UV on Windows, but I use the linux equivalent, rm -rf, on a nightly basis to remove our development account prior to refreshing it with live data. I assure you, it is that easy. -John --- 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] UniObjects connection timeouts?
UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a connected session. The timeout period is used by the UniVerse remote procedure call utility (UniRPC). The default value of this property is 0 (no timeout period). For values greater than 0, you must specify seconds. Session Object: Properties 3-52 C:\Program Files\Adobe\FrameMaker7.0\UniVerse Note: If you enter a value that is too small, a running process (for example, the Read method) may time out. If this occurs, an error code is returned and the connection to the server is dropped. This applies to both session and read timeouts. Again, I am not changing these properties at all. Yet, sessions unattended for more than an (unknown) amount of time, about 4 hours at the latest incident (but I hit it with less time earlier, somewhere around 1 hour), are causing the following exceptions to be caught: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.[IBM U2][UODOTNET-UNIRPC][ErrorCode=81009] The RPC failed. Note that message 81009 does not exist in SYS.MESSAGE. Does anyone know how to make the sessions truly NOT time out, or fix whatever this problem is about?? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects connection timeouts?
Look at the setting in the unirpcservices file on the server - you can find this in your unishared directory. The entries for uvcs and defcs are those for UniRPC. The final entry on the line is the timeout period in 1/10 second. Regards Brian -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: 01 April 2009 18:35 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects connection timeouts? UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a connected session. The timeout period is used by the UniVerse remote procedure call utility (UniRPC). The default value of this property is 0 (no timeout period). For values greater than 0, you must specify seconds. Session Object: Properties 3-52 C:\Program Files\Adobe\FrameMaker7.0\UniVerse Note: If you enter a value that is too small, a running process (for example, the Read method) may time out. If this occurs, an error code is returned and the connection to the server is dropped. This applies to both session and read timeouts. Again, I am not changing these properties at all. Yet, sessions unattended for more than an (unknown) amount of time, about 4 hours at the latest incident (but I hit it with less time earlier, somewhere around 1 hour), are causing the following exceptions to be caught: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.[IBM U2][UODOTNET-UNIRPC][ErrorCode=81009] The RPC failed. Note that message 81009 does not exist in SYS.MESSAGE. Does anyone know how to make the sessions truly NOT time out, or fix whatever this problem is about?? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx? ref=/egov/index .aspx --- 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] UniObjects connection timeouts?
Have you checked your unirpcservices file timeout value. It may be UniRPC timing out the connection on the server. Glenn -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Wednesday, April 01, 2009 10:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects connection timeouts? UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a connected session. The timeout period is used by the UniVerse remote procedure call utility (UniRPC). The default value of this property is 0 (no timeout period). For values greater than 0, you must specify seconds. Session Object: Properties 3-52 C:\Program Files\Adobe\FrameMaker7.0\UniVerse Note: If you enter a value that is too small, a running process (for example, the Read method) may time out. If this occurs, an error code is returned and the connection to the server is dropped. This applies to both session and read timeouts. Again, I am not changing these properties at all. Yet, sessions unattended for more than an (unknown) amount of time, about 4 hours at the latest incident (but I hit it with less time earlier, somewhere around 1 hour), are causing the following exceptions to be caught: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.[IBM U2][UODOTNET-UNIRPC][ErrorCode=81009] The RPC failed. Note that message 81009 does not exist in SYS.MESSAGE. Does anyone know how to make the sessions truly NOT time out, or fix whatever this problem is about?? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/ index .aspx --- 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] RE: UniObjects connection timeouts?
What version of the UniObjects assembly are you using.. We ran into this alot with the first .Net assemblies IBM shipped, but later releases are a lot better, and the RPC issue seems to have been largely resolved. FYI - We use the same assembly on Unidata and UniVerse, and had the same/similar issues on both U2 Products - moving to a later release of the assembly solved a lot of problems on both U2 products.. Regards Ray From: owner-u2-us...@listserver.u2ug.org [owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen [lhan...@redwoodcity.org] Sent: 01 April 2009 12:34 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects connection timeouts? UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a connected session. The timeout period is used by the UniVerse remote procedure call utility (UniRPC). The default value of this property is 0 (no timeout period). For values greater than 0, you must specify seconds. Session Object: Properties 3-52 C:\Program Files\Adobe\FrameMaker7.0\UniVerse Note: If you enter a value that is too small, a running process (for example, the Read method) may time out. If this occurs, an error code is returned and the connection to the server is dropped. This applies to both session and read timeouts. Again, I am not changing these properties at all. Yet, sessions unattended for more than an (unknown) amount of time, about 4 hours at the latest incident (but I hit it with less time earlier, somewhere around 1 hour), are causing the following exceptions to be caught: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.[IBM U2][UODOTNET-UNIRPC][ErrorCode=81009] The RPC failed. Note that message 81009 does not exist in SYS.MESSAGE. Does anyone know how to make the sessions truly NOT time out, or fix whatever this problem is about?? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- 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] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list, Yes, I can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ; FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen exactly what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no fun...
I could open a como file, list the output with no headings close the como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
Is this Unidata or Universe? In Unidata, when using the Unidata ECL, I
could use SAVING SWITCHIT
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, April 01, 2009 4:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list, Yes,
I can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
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] SQL a possibility?
SELECT FILENAME SAVING SWITCHIT
Will work from TCL I believe
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 2 April 2009 11:01 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list,
Yes, I can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no
fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
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] SQL a possibility?
George,
I use to pull a little trick saving a list of ids to the SAVEDLISTS file.
Think of the SAVEDLISTS as any file name and your list as a Record.
Within the Record write each cleaned Id on a new line.
There is a limit to the number of Ids you can place in each record.
The first record you save should be name001. After you hit your limit save
the
record and start name002. When you are finished writing your ids use
a GET.LIST name to have an active save list within your program.
To view a SAVEDLISTS name just create a SAVE.LIST and list the
SELECT SAVEDLISTS name then LIST SAVEDLISTS by Id this will give you a way to
test
for any issues. If your list has name001 name002 name003 look at name002 for
the limit.
Also check your SAVEDLISTS structure some admins have all SAVEDLISTS in one
area
others each user has there own SAVEDLISTS.
Just another way to control the task.
Laurie Blain
Unidata Programmer Analyst
Live, Love, Code!
Columbus, Ohio
laurie_bl...@yahoo.com
--- On Wed, 4/1/09, phil walker p...@gnosys.co.nz wrote:
From: phil walker p...@gnosys.co.nz
Subject: RE: [U2] SQL a possibility?
To: u2-users@listserver.u2ug.org
Date: Wednesday, April 1, 2009, 6:21 PM
SELECT FILENAME SAVING SWITCHIT
Will work from TCL I believe
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 2 April 2009 11:01 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list,
Yes, I can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen
exactly what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no
fun...
I could open a como file, list the output with no headings close the
como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Question about indexing
Hello everyone,
I have a question about indexing. I have just a little of experience,
so be patient with me.:)
First of all I'm using Universe 10.0.4.0 and SB 5.2 on a Windows 2003
Server on a Dual-Core Opteron Server and 4Gb of RAM SCSI drives
I wanted to simplify (just a little) my database, to improve the
performance. with the changes I made, i got to the point that I have
to compare 2 tables:
TABLE1
DetID - KeyField
InvID -
InvDt -
LinIt -
ItmType
ItmID -
QtyReq -
TABLE2
DetID - KeyField
PurID -
PurDt -
LinIt -
ItmID -
ItmType -
QtyPur -
QtyAva -
What I want to do is to scan the first table/file (TABLE1), substract
inventory ammounts and create a third file (LOG)with the following:
TABLE3
DetID
InvID
InvLI
PurID
PurLI
QtyDis
On TABLE1 I have around 4,000,000 records; and on TABLE2 i have around 60,000.
I have been testing on how to create index. CREATE.INDEX /
UPDATE.INDEX. But after looking on the manuals and online (everything
points into here :)) i don't know how that works
How I can have access to the index?
Is the index applied when i use a SELECT command?
I created the index like this:
CREATE.INDEX TABLE1 InvID InvDt
CREATE.INDEX TABLE2 PurID ItmType PurDt QtyAva
and I updated the indexes like this:
UPDATE.INDEX TABLE1 ALL
UPDATE.INDEX TABLE2 ALL
mmm ,mmm now that I'm writing this...i'm thinking... do I need to
create an index for the third file? (probably an obvious question).
By the way I'm running this from a basic program, something like this:
(I didn't copy/paste the code, but it's something similar)
.
MyListFromTable1 = {I get this variable from after reading from my
SAVEDLISTS file}
QtyOfItemsOnList1 = dcount(MyListFromTable1,CHAR(254))
for i=1 to QtyOfItemsOnList1
c_ItemID = MyListFromTable1i
read RegItmTable1 from TABLE1_file,c_ItemID else
ErrMsg = Unable to read [:c_ItemID:]
goto ExtitSub
end
InvID = RegItmTable11
InvDt = RegItmTable12
InvLI = RegItmTable13
InvIT = RegItmTable14
InvQT = RegItmTable16
CmdToFindAvail = \SELECT TABLE2 WITH ItmID = \:InvIT:\ AND WITH
QtyAva 0 and PurDt = \:oconv(InvDt,'D4\'):\ BY PurDt BY PurID BY
LinIt\
EXECUTE CmdToFindAvail
..
next i
Thanks!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
If you can move between your PC and the server. Open the spreadsheet, delete
all the columns you don't want, save the one column as a text file, move the
file back to the server in SAVEDLISTS and you have created a list.
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 1 Apr 2009 16:21:28 -0500
Subject: [U2] SQL a possibility?
I'm trying to save the first field of a .csv file to a select list, Yes, I
can
write a program,
but I also wanted to try to do it on the fly.
Using UV10.0.2 , unix on Information format
The source data looks like:
'#12345566#','first','last',.
'#12344555#','first','last',.
Basically, field one has the item ID of another file.
The source file gets read into a tempory file input file
I created an I-desc of the following:
SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
FIELDS(@1,REUSE(,),REUSE(1))
;
CONVERT(REUSE('# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
The above will convert the whole record into one mutlivalue attribute,
then strip off the first field delimited by the ,
then strip out the # ,' and spaces
LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen exactly
what
I want
and so does
SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
NowHow can I put that data into a saved-list? (Using either TCL or
SQL?)
for that matter, how do you save a list using SQL on Universe? I tried
creating a view, but was told I
had to create a schema in order to create tables...that's no fun...
I could open a como file, list the output with no headings close the como
file,
edit it clean, the form-list the como file (work around 1)
George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
_
Rediscover Hotmail.: Get e-mail storage that grows with you.
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Stor
age1_042009
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Host Access on Vista
Hi all are there any HostAccess users out there running the above emulator on Vista prior to release 7.4. If so did you have any problems. Any feedback appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
