RE: [U2] Longstanding aversion to CNAME?

2004-07-23 Thread Hona, David S
With UV at least, CNAME is a Unix executable, hence able to handle the
renaming of very large sequential files and the like... Unlike a UV BASIC
program, the UV line editor or the UV COPY verb (the latter two being UV
BASIC programs).

So it, can come in very handy!

Regards,
David

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder
Sent: Friday, 23 July 2004 3:10 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Longstanding aversion to CNAME?


Wendy Smoak wrote on 07/22/2004 07:26:59 PM:

 From a UniBasic program, why would you open a file, read a record, 
 write it back to the same file under a different key, then delete the 
 original record, when you could just:

   X.CMD = CNAME filename :X.ID:',':X.NEW.ID
   EXECUTE X.CMD

The overhead of the execute would be greater than if you did it
programmatically.  CNAME will be doing everything you'd be doing, but there
will also be the overhead of the execute.  If you're doing it once within a
program, the difference will be negligible.  But don't think about doing it
in a loop.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Universe Phantom Problem

2004-07-23 Thread Ross Ferris
If you are moving programs between type 19 files, why even bother using a phantom ? If 
on Unix, why not have a cp CRON job, and if you are on Windows use AT

. OR, why not have the C routine process File1 directly ?

Ross Ferris
Stamina Software
Visage  an Evolution in Software Development


-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of djordan
Sent: Friday, 23 July 2004 8:19 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Universe Phantom Problem

I would say that the file B is still being read by the C program or has not
been released.  Check if the file is locked before you try to write using a
READL or READU.  If you don't use the locked clause it will wait until the
C
program releases File B.

Also consider looking at new features of UniVerse such as Sockets or MQ
(Message Que) to do the same process.  These have a lot of sophisticated
features to handle this environment.

Regards
David Jordan

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of prem jaisinghani
Sent: Friday, 23 July 2004 5:51 AM
To: [EMAIL PROTECTED]
Subject: [U2] Universe Phantom Problem


Hi,

I am facing following problem regarding Phantoms in universe:

We have a phantom which keeps on polling a type 19 file, say File1 for
data and transfers it to another type 19 file, say

File B. File B in turn is being read by a 'c' program.

The first phantom gets killed sometimes and pretty randomly. The error code
thrown is 40019, but I could not get any the information about this error.

Please find below a sample error message:

FATAL - Unable to write 7545698440*13346*25966.940943 on FileB

If someone has experienced such problem and/or has a workaround, please let
me know.

Thanks and Regards,

Prem
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


SV: [U2] startud

2004-07-23 Thread Björn Eklund
Thanks you very much for the details Ken!

Bjvrn Eklund



-Ursprungligt meddelande-
Fren: Ken Wallis [mailto:[EMAIL PROTECTED]
Skickat: den 23 juli 2004 04:12
Till: [EMAIL PROTECTED]
Dmne: RE: [U2] startud


Bjvrn Eklund wrote:

 I've decided to make an new start script for Unidata that
 includes startud and the start command of my program.

Bjvrn,

That would be what I'd do, sort of.

Usually I set up a script in /etc/init.d to start and stop unidata cleanly,
and then I link to it from the appropriate /etc/rc?.d directories, and for
good measure put a script in /usr/local/bin which I whack higher in the PATH
than $UDTBIN which intercepts any startud or stopud commands and pushes them
through my /etc/init.d/unidata script.

By doing this, I make a decent fist of driving any normal mechanism for
starting or stopping unidata through a single spot so I can do other useful
stuff at the same time - like write a message to syslog, or more
importantly, make sure that the current RFS archive log file has been copied
to the DR server.

If someone knows what they are doing they can always get direct access to
stopud or startud via $UDTBIN/st...ud, but it isn't often that you'd want to
do that.

The decision then is whether to put the startup for you phantoms into the
same script as the one that starts unidata, or whether to put it in a
separate /etc/init.d script and maybe link to it from a higher run level
/etc/rc?.d.

UniData commands not providing any reliable exit status is very annoying,
but it has always been that way I'm afraid.  What I usually do is add an
extra capability to my /etc/init.d/unidata so that it understand not just
the start and stop commands, but also a 'status' command which will use
showud and look for a complete daemon set running to determine if it really
believes that UniData is running.  I then make it exit with a known status
so in other scripts I can do:

if /etc/init.d/unidata status
then
# stuff that relies on UniData being up
else
echo better start UniData first!
exit 2
fi

I'd wrap something this around your phantom initiation commands, and think
hard about whether you need some way to shut your phantoms down neatly or is
it OK simply to have stopud -f kill them?

Cheers,

Ken

 -Ursprungligt meddelande-
 Fren: Bjvrn Eklund [mailto:[EMAIL PROTECTED]

 anyone who start unibasic programs automatically when you
 start unidata?
 I would like my a phantom process started each time I run startud.
 All tips are welcome. Could cron be a way to go?
 We are on ud5.2 and solaris 8.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Longstanding aversion to CNAME?

2004-07-23 Thread Martin Phillips
Probably doesn't apply in this case but there's a trap to beware of

If the file is type 1/19 and the record contains binary data, a simple
read/write will corrupt it.  On reads from a type 1/19, newlines are
replaced by field marks.  On write the opposite translation happens.  For a
normal text type database record this is fine, however, if you store
bitmapped data (e.g. scanned images) in a type 1/19 file they will be
damaged by this process.

This was a long standing problem in COPY in UV but was fixed some time ago.
The fix uses an (undocumented?) mode flag:
   ASSIGN 1 TO SYSTEM(1017)to turn off character translation
and
   ASSIGN 0 TO SYSTEM(1017)to turn it on again

Until this morning, I thought that CNAME had also been fixed but it seems
that I am wrong (though the system I tried it on is still using 9.6.1.2).

To demonstrate this problem, compile a one line program that prints -2.  Use
CNAME to change the name of the object record and the program prints -62963.
I can't imagine that many users rename their object files but it shows the
effect.  I know of one very big UV site where they decided to save time by
copying the object code from a test system to the live system using COPY
rather than recompiling.  This neatly destroyed every program along the way.

A favourite variant on this problem was for users who went home from system
adminstration courses and decided that GLOBAL.CATDIR might be better as a
type 19 file instead of type 1.  Yes, RESIZE used to have the same bug.  The
only way to get going again was to rebuild the catalog.  Thankfully, this
one has been fixed.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Longstanding aversion to CNAME?

2004-07-23 Thread Bob Witney
This is from Universe 10.2
RUN BP A
-2
CNAME BP.O A,V
Changed record A to V in file BP.O.
RUN BP V
-246

Same problem except I get -246 not -6293 !!

Bob


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Martin Phillips
Sent: 23 July 2004 09:11
To: [EMAIL PROTECTED]
Subject: Re: [U2] Longstanding aversion to CNAME?


Probably doesn't apply in this case but there's a trap to beware of

If the file is type 1/19 and the record contains binary data, a simple
read/write will corrupt it.  On reads from a type 1/19, newlines are
replaced by field marks.  On write the opposite translation happens.  For a
normal text type database record this is fine, however, if you store
bitmapped data (e.g. scanned images) in a type 1/19 file they will be
damaged by this process.

This was a long standing problem in COPY in UV but was fixed some time ago.
The fix uses an (undocumented?) mode flag:
   ASSIGN 1 TO SYSTEM(1017)to turn off character translation
and
   ASSIGN 0 TO SYSTEM(1017)to turn it on again

Until this morning, I thought that CNAME had also been fixed but it seems
that I am wrong (though the system I tried it on is still using 9.6.1.2).

To demonstrate this problem, compile a one line program that prints -2.  Use
CNAME to change the name of the object record and the program prints -62963.
I can't imagine that many users rename their object files but it shows the
effect.  I know of one very big UV site where they decided to save time by
copying the object code from a test system to the live system using COPY
rather than recompiling.  This neatly destroyed every program along the way.

A favourite variant on this problem was for users who went home from system
adminstration courses and decided that GLOBAL.CATDIR might be better as a
type 19 file instead of type 1.  Yes, RESIZE used to have the same bug.  The
only way to get going again was to rebuild the catalog.  Thankfully, this
one has been fixed.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Universe Phantom Problem

2004-07-23 Thread Ray Wurlod
Look up error codes in the SYS.MESSAGE file.  This has six digit keys.
LIST SYS.MESSAGE '040019'
or
SELECT * FROM SYS.MESSAGE WHERE @ID = '040119';

If it's not there, the next best choice is, for connectivity questions, the InterCall 
manual.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] looking for software - dry cleaner

2004-07-23 Thread Richard A. Wilson
you can probably snoop around the internet for information on the 
following two listings I have

Rich
NA.MAINTName/Add Maintenance   08:27:08  2
   Name/Add Number:5486 Fazio Cleaners Los Angeles CA
01)Name/Add Name:Fazio Cleaners
02)Sort Key.:
03)Address one..:
04)Address two..:
05)City.:Los Angeles
06)State:CA   07)Country:
08)Zipcode..:
09)Telephone: 10)Fax:
11)Contact..:
12)Hourly Rate..:.00
13)Contract Date:
14)Category.:P-U Pick UserAdd Date  05-03-2004
15)Tax Rate.:.00  Mod Date  05-03-2004
16)Systems..:D3/Linux
17)Sftwre Pkgs..:The Cleaner System, drycleaning app
18)Follow Date..:
19)Mgmnt Fee:
20)Source...:comp.databases.pick, discussion on pick users
Mods,Delete,EXit,File,Remarks,Screen 2,3,4:
===
NA.MAINTName/Add Maintenance   08:29:43  2
   Name/Add Number:4520 Applications Liberate Hardware somewhere aroun
01)Name/Add Name:Applications Liberate Hardware
02)Sort Key.:
03)Address one..:
04)Address two..:
05)City.:somewhere around irvine
06)State:CA   07)Country:
08)Zipcode..:
09)Telephone:714-557-8799 10)Fax:
11)Contact..:Steven Davies-Morris
12)Hourly Rate..:.00
13)Contract Date:
14)Category.:P-C Pick Consultant/DeveloperAdd Date  05-14-1998
15)Tax Rate.:.00  Mod Date  05-14-1998
16)Systems..:Ap/Pro
17)Sftwre Pkgs..:dry cleaning store software
18)Follow Date..:
19)Mgmnt Fee:
20)Source...:comp.database.pick email
Mods,Delete,EXit,File,Remarks,Screen 2,3,4:
Peter Gonzalez wrote:
Does anybody know of a MV package for dry cleaners?

Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
--
Richard A. Wilson
Lakeside Systems
Smithfield, RI, USA
Voice 401-231-3959
Fax   401-231-3943
[EMAIL PROTECTED]
www.lakeside-systems.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Longstanding aversion to CNAME?

2004-07-23 Thread Adrian Matthews
In the old Prime Information days (where I believe CNAME came from) the
runtime engine would actually block an attempt to do a CNAME from
anywhere other than the colon (TCL) prompt.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 23 July 2004 13:45
To: [EMAIL PROTECTED]
Subject: [U2] Longstanding aversion to CNAME?

Wendy Smoak wrote on: Thu, 22 Jul 2004 17:26:59 -0700

 It seems that CNAME is not a popular UniBasic command.  Is there
 some history here I'm not aware of, maybe it was unreliable?

 From a UniBasic program, why would you open a file, read a record,
 write it back to the same file under a different key, then delete
 the original record, when you could just:

   X.CMD = CNAME filename :X.ID:',':X.NEW.ID
   EXECUTE X.CMD

Two reasons for me:

1) I learned MV under Pick, where CNAME wasn't available.  As previously
stated, you had to use the COPY command (with the (D option) and DATA
the
destination.  I've only been using UniData for about 3 years under SB+,
so
I'm still learning some of the non-Pick syntax options.

2) Crash safety net :-  If the system were to crash during the CNAME
operation, I wouldn't know for certain where the record was, and it
could
be completely lost.  If it crashed during the WRITE/DELETE sequence, I
would either have just the original, just the new, or possibly both.

--Tom Pellitieri
  Century Equipment
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


The information contained in this email is strictly confidential and for the use of 
the addressee only, unless otherwise indicated. If you are not the intended recipient, 
please do not read, copy, use or disclose to others this message or any attachment. 
Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 
0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that 
do not relate to the official business of this company shall be understood as neither 
given nor endorsed by it.  IG Markets Limited and IG Index Plc are authorised and 
regulated by the Financial Services Authority and, in Australia, by the Australian 
Securities and Investments Commission.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Universe Phantom Problem

2004-07-23 Thread Brian Leach
As David said, you get this if the C program has the file open.

Another work around is to use the ON ERROR clause for the write:

WrittenOk = @True
Loop
  Write TheItem On FL, TheId ON ERROR WrittenOk = @False
Until WrittenOk Do
  Nap 10
Repeat

Brian

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of prem jaisinghani
Sent: 22 July 2004 20:51
To: [EMAIL PROTECTED]
Subject: [U2] Universe Phantom Problem

Hi,

I am facing following problem regarding Phantoms in universe:

We have a phantom which keeps on polling a type 19 file, say File1 for
data and transfers it to another type 19 file, say

File B. File B in turn is being read by a 'c' program. 

The first phantom gets killed sometimes and pretty randomly. The error code
thrown is 40019, but I could not get any the information about this error.

Please find below a sample error message: 

FATAL - Unable to write 7545698440*13346*25966.940943 on FileB

If someone has experienced such problem and/or has a workaround, please let
me know.

Thanks and Regards,

Prem
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


This email was checked by MessageLabs SkyScan before entering Microgen.



This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]

Microgen Information Management Solutions
http://www.microgen.co.uk
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Report Writer to Create MVquery Statements

2004-07-23 Thread Brian Leach
Mark,

If you wish to take a look at mvQuery, there is a free evaluation available.

Just drop an email to [EMAIL PROTECTED]

It is windows based, but then so is CR - mvQuery however sticks to the mv
modes and does not require ODBC or other layers.

Regards,

Brian

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: 22 July 2004 14:52
To: [EMAIL PROTECTED]
Subject: [U2] Report Writer to Create MVquery Statements

One of my new clients (new to MV as well) would like a program to help them
create their own ad-hoc mvquery reports. Presently, I'm creating a simple
2-section program where the first section indicates the verb, filename,
heading/footing and some of the popular modifiers. The second section is
free-form text for the actual 'work' of the statement.

Due to the complexity of these reports, I cannot imagine an easier approach
within MV. I've used MS Access on Access and Crystal Reports against a SQL
database and wonder if there's something already written for MV.

I want to stay within MV. I don't want to venture into CR or any other ODBC
item. Does anyone have any ideas on a simple MV report writer. Please don't
deviate from staying within MV.

Thanks in advance
Mark Johnson
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


This email was checked by MessageLabs SkyScan before entering Microgen.



This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]

Microgen Information Management Solutions
http://www.microgen.co.uk
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Longstanding aversion to CNAME?

2004-07-23 Thread Stevenson, Charles
UV10 STILL DOES NOT UPDATE INDEXES if the index is part of the ID.

 From:  Norman, David (SAAS)

 In UV9.4 CNAME didn't update secondary indexes, which left a bit of
 a mess behind. This has now been fixed, probably from 9.6.



Example. A 2-part id:  [internal-date]*[something] indexed on date (
@ID['*',1,1] or FIELD(@ID,'*',1) ) 

Changing a 0 to a 1 in a date in a particular id:

CNAME file 13350*ABC,13351*ABC  

will leave old, nonexistant id 13350*ABC indexed under date 13350
and will not add the new id to 13351.


IBM knows this (probably forwarded from the Vmark days), but resolutely
will not fix it because the underlying i/o routines used by CNAME are
different from the norm and won't easily support the change.  This
list's archives will support that claim.

One could reasonably restate that as, It's too hard to fix, so just
live with the inherent data integrity vulnerability.
Or even, Help, help we're being oppressed.  Come see the vulnerability
inherent in the system.
 
Chuck Stevenson


P.S.  As for speed, for type-1  -19 CNAME is faster than other
read/write/delete schemes one could program. I *believe* it invokes a
unix mv command which simply repoints the inode without actually
moving any files.   Similar on MS.

P.P.S. I recall CNAME was originally a PRIMOS command similar to unix
mv.  Information just borrowed the name and handled type-1 ( UFDs
(UserFileDirectories) ) with the primos mechanism, and used its own
mechanism for hashed records.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV on Win2003, refusing new logins, UniAdmin issues RPC errmsg

2004-07-23 Thread Herve Balestrieri
For your information, I had to know of repeated cases where Windows 2003
cannot reboot when the SharedSection third parameter of the Windows
registry entry in question = 8192.
An US U2 Technical Support Analyst told me : The quoted Technical
Bulletin is titled Maximizing performances for UniVerse systems - updated
for UniVerse 9.5.1F... So, theorically, the document wouldn't apply after
this (old) UniVerse release... ;-) In fact, we know that it can apply until
release 9.6.x and on Windows versions earlier than Windows 2003.
But, definitively :
- Windows 2003 manages Desktop heap differently than previous Windows
versions (This may have become dynamic... and... this point is not
documented by Microsoft)
- UniVerse Telnet Service at version 10.0.x have the option to Interact
with Desktop, which makes useless for the need of the database this
Windows tuning.
- UniVerse Telnet Service + UniRPC Service at release 10.1 are both able to
Interact with Desktop, and the need for this Windows tuning totally
disappears.

I answered individually to the initial message.

Regards,

Hervi BALESTRIERI
Support Technique Avanci - IBM Data Management - Produits U2
Web   : http://www.ibm.com/software/u2/
- Forwarded by Herve Balestrieri/France/IBM on 23/07/2004 15:34 -
   
 Adrian Matthews 
 Adrian.Matthews@ 
 igindex.co.uk To 
 Sent by:  [EMAIL PROTECTED]  
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   RE: [U2] UV on Win2003, refusing
 23/07/2004 12:41  new logins, UniAdmin issues  RPC
   errmsg  
   
 Please respond to 
 u2-users  
   
   
   




Try this registry change using RegEdit. You won't be able to run more
than 60 sessions without this change on Windows.

\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control
\SessionManager\SubSystems\Windows

If the value is 1024,3072,512, change 512 to 3072.

It is in one of the UV manuals somewhere...

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joe Walter
Sent: 22 July 2004 18:04
To: [EMAIL PROTECTED]
Subject: [U2] UV on Win2003, refusing new logins, UniAdmin issues RPC
errmsg

This is about UV 10.1.x on Win2003 server.

I'm completely baffled by this recurring situation.

It goes like this - universe is up and running, lots of users connected,
life is
wonderful.

Sporadically - about two or three times in each
 24 hour period - the system gets into a state where it will not accept
any
 new Universe logins. Users already logged are often unaffected, but any

 attempt to start a new session with Dynamic Connect gets the message

 [Connection Aborted] right away - before telnet prompts for

 username/password are presented.

When the system is in this state, any attempt to use UniAdmin results in
an
error message something like 'RPC error 1' - I'm not sure if that is the
exact
error message, but that's the gist of it.

Tried stop/start all universe services and every time the Universe
Resource and
Universe Telnet services FAIL to restart, but the RPC service restarts
correctly.

Only way out is to reboot the server - which is a big hassle of course
and make
for very unhappy users and sysadmins ;-(

Any ideas comments on this will be highly appreciated.

Thanks much,
joe

People  Technology delivering results
http://www.ClientsFirst-US.com

Joe Walter  Phone-Direct   :
330.867.3851
Senior Product Engineer - Central RegionPhone-Direct   :
330.990.9081
Phone-Main :
866.732.9191
26380 Curtiss Wright Parkway, Suite 108 Fax/Voice Mail :
435.514.5132
Cleveland, OH 44143 mailto:[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


The information contained in this email is strictly confidential and for
the use of the addressee only, unless otherwise indicated. If you are not
the intended recipient, please do not read, copy, use or disclose to others
this message or any 

RE: [U2] UV on Win2003, refusing new logins, UniAdmin issues RPC errmsg

2004-07-23 Thread Adrian Matthews
Interesting seeing that people are still being told to use this setting
by Vars (and IBM) post 9.6

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Herve
Balestrieri
Sent: 23 July 2004 15:00
To: [EMAIL PROTECTED]
Subject: Re: [U2] UV on Win2003, refusing new logins, UniAdmin issues
RPC errmsg

For your information, I had to know of repeated cases where Windows 2003
cannot reboot when the SharedSection third parameter of the Windows
registry entry in question = 8192.
An US U2 Technical Support Analyst told me : The quoted Technical
Bulletin is titled Maximizing performances for UniVerse systems -
updated
for UniVerse 9.5.1F... So, theorically, the document wouldn't apply
after
this (old) UniVerse release... ;-) In fact, we know that it can apply
until
release 9.6.x and on Windows versions earlier than Windows 2003.
But, definitively :
- Windows 2003 manages Desktop heap differently than previous Windows
versions (This may have become dynamic... and... this point is not
documented by Microsoft)
- UniVerse Telnet Service at version 10.0.x have the option to Interact
with Desktop, which makes useless for the need of the database this
Windows tuning.
- UniVerse Telnet Service + UniRPC Service at release 10.1 are both able
to
Interact with Desktop, and the need for this Windows tuning totally
disappears.

I answered individually to the initial message.

Regards,

Hervi BALESTRIERI
Support Technique Avanci - IBM Data Management - Produits U2
Web   : http://www.ibm.com/software/u2/
- Forwarded by Herve Balestrieri/France/IBM on 23/07/2004 15:34
-
 

 Adrian Matthews

 Adrian.Matthews@

 igindex.co.uk
To 
 Sent by:  [EMAIL PROTECTED]

 [EMAIL PROTECTED]
cc 
 stserver.u2ug.org

 
Subject 
   RE: [U2] UV on Win2003, refusing

 23/07/2004 12:41  new logins, UniAdmin issues  RPC

   errmsg

 

 Please respond to

 u2-users

 

 

 





Try this registry change using RegEdit. You won't be able to run more
than 60 sessions without this change on Windows.

\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control
\SessionManager\SubSystems\Windows

If the value is 1024,3072,512, change 512 to 3072.

It is in one of the UV manuals somewhere...

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joe Walter
Sent: 22 July 2004 18:04
To: [EMAIL PROTECTED]
Subject: [U2] UV on Win2003, refusing new logins, UniAdmin issues RPC
errmsg

This is about UV 10.1.x on Win2003 server.

I'm completely baffled by this recurring situation.

It goes like this - universe is up and running, lots of users connected,
life is
wonderful.

Sporadically - about two or three times in each
 24 hour period - the system gets into a state where it will not accept
any
 new Universe logins. Users already logged are often unaffected, but any

 attempt to start a new session with Dynamic Connect gets the message

 [Connection Aborted] right away - before telnet prompts for

 username/password are presented.

When the system is in this state, any attempt to use UniAdmin results in
an
error message something like 'RPC error 1' - I'm not sure if that is the
exact
error message, but that's the gist of it.

Tried stop/start all universe services and every time the Universe
Resource and
Universe Telnet services FAIL to restart, but the RPC service restarts
correctly.

Only way out is to reboot the server - which is a big hassle of course
and make
for very unhappy users and sysadmins ;-(

Any ideas comments on this will be highly appreciated.

Thanks much,
joe

People  Technology delivering results
http://www.ClientsFirst-US.com

Joe Walter  Phone-Direct   :
330.867.3851
Senior Product Engineer - Central RegionPhone-Direct   :
330.990.9081
Phone-Main :
866.732.9191
26380 Curtiss Wright Parkway, Suite 108 Fax/Voice Mail :
435.514.5132
Cleveland, OH 44143 mailto:[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


The information contained in this email is strictly confidential and for
the use of the addressee only, unless otherwise indicated. If you are
not
the intended recipient, please do not read, copy, use or disclose to
others
this message or any attachment. Please also notify the sender by
replying
to this email or by telephone +44 (0)20 7896 0011 and then delete the
email
and any copies of it. Opinions, conclusions (etc.) that do not relate to
the official business of this company shall be understood as neither
given
nor endorsed by it.  IG Markets Limited and IG Index Plc are authorised
and
regulated by the Financial Services Authority and, in Australia, by the
Australian Securities 

[U2] James Ronan/IIG/Prudential is out of the office.

2004-07-23 Thread james . ronan
I will be out of the office starting  07/23/2004 and will not return until
07/27/2004.

Please contact Tricia Shelly x 6531 in my absence.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [OT] Has anyone exoerienced a HUGE increase of Spam?

2004-07-23 Thread Debster
I have experienced a HUGE increase in SPAM lately and I was wondering if
somehow the users list has been utilized to facilitate that.  I am not
thinking that the origin is knowingliy from the administrators of this fine
list -- but if this list was somehow lifted or otherwise absconded...
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [OT] Has anyone exoerienced a HUGE increase of Spam?

2004-07-23 Thread Wendy Smoak
Debster wrote:
 I have experienced a HUGE increase in SPAM lately and I was 
 wondering if somehow the users list has been utilized to facilitate 
 that.

One possible source:  the list is now archived at gmane which barely
munges the email addresses, only replacing '@' with ' at '.
http://news.gmane.org/gmane.comp.db.u2.general/

I prefer mail-archive.com which doesn't even show them, it replaces
anything resembling an email address with '[EMAIL PROTECTED]'.
http://www.mail-archive.com/u2-users%40listserver.u2ug.org/
(and some older stuff:
http://www.mail-archive.com/u2-users%40oliver.com/)

The IndexInfocus archives are not indexed by search engines, when that's
all there was, we were fairly anonymous.

I have mail filters on everything coming in, so I don't really notice an
increase if it happens.  A few message slip through, just a  minor
annoyance.

-- 
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [OT] Has anyone experienced a HUGE increase of Spam?

2004-07-23 Thread Allen E. Elwood \(CA\)
A new technique called Phishing (pronounced Fishing) is being employed by
Spammers.  They just do the brute force method of emailing (i.e.
[EMAIL PROTECTED], [EMAIL PROTECTED]@yahoo.com, etc)  and if they don't get
a bounce back, then they know that they got a valid email address, and then
it goes out to the Spam lists.  This has happened to all of my email
addresses in the last couple of months.

Fun, eh?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Debster
Sent: Friday, July 23, 2004 09:22
To: [EMAIL PROTECTED]
Subject: [U2] [OT] Has anyone exoerienced a HUGE increase of Spam?


I have experienced a HUGE increase in SPAM lately and I was wondering if
somehow the users list has been utilized to facilitate that.  I am not
thinking that the origin is knowingliy from the administrators of this fine
list -- but if this list was somehow lifted or otherwise absconded...
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [OT] Has anyone exoerienced a HUGE increase of Spam?

2004-07-23 Thread George Gallen
Apparantly there are a few new varients of blaster and bagel out there,
our local news station ran a story on it. I'm guessing a bunch more
non-patched, non-updated XP's got owned and are sprewing spam.

George

-Original Message-
From: Larry Hiscock [mailto:[EMAIL PROTECTED]
Sent: Friday, July 23, 2004 2:34 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [OT] Has anyone exoerienced a HUGE increase of Spam?


It's unlikely that the list is being used directly for spam
for two reasons:

1) The lists are closed lists, which means that one must be
subscribed to
the list in order to post to it.

2) The majordomo commands to retrieve the list of subscribers have been
disabled, so one cannot harvest the addresses on the list.

The only persons with access to the full subscriber list are
the moderators.

Regards,

Larry Hiscock
Moderator


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Debster
Sent: Friday, July 23, 2004 9:22 AM
To: [EMAIL PROTECTED]
Subject: [U2] [OT] Has anyone exoerienced a HUGE increase of Spam?

I have experienced a HUGE increase in SPAM lately and I was
wondering if
somehow the users list has been utilized to facilitate that.
 I am not
thinking that the origin is knowingliy from the administrators
of this fine
list -- but if this list was somehow lifted or otherwise absconded...
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] wIntegrate Query Builder

2004-07-23 Thread Kevin Michaelsen
Is there a way to limit dictionary items from appearing in query builder. 
We are wondering if we can let the end users run with query builder but not 
give them access to all the dictionary items.

kevin
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] wIntegrate Query Builder

2004-07-23 Thread Mike Randall
Create a user version of the file with just the items you want them to see.

VOC:  FilenameForUsers

1: F
2: Original File name
3: D_CopyofDictforUsers

Could use CREATE.FILE DICT CopyofDictforUsers

Mike R.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen
Sent: Friday, July 23, 2004 2:58 PM
To: [EMAIL PROTECTED]
Subject: [U2] wIntegrate Query Builder

Is there a way to limit dictionary items from appearing in query builder. 
We are wondering if we can let the end users run with query builder but not 
give them access to all the dictionary items.

kevin
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Dale Bertke is out of the office

2004-07-23 Thread DBertke
I will be out of the office starting  07/23/2004 and will not return until
07/27/2004.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV on Win2003, refusing new logins, UniAdmin issues RPC errmsg

2004-07-23 Thread Joe Walter
Thanks Jordan. I wish licensing was the cause, but unfortunately it's something
far more insidious than that.

For awhile I was starting to think it had something to do with this gigabit NIC
card on the new server. The LAN is only wired for 10/100MBPS. When we set the
rate on the network card down to 100MBPS it seemed the condition did not occurr
as frequently. Now I'm not certain if that's true or not.

joe

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
 Sent: Thursday, July 22, 2004 6:06 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] UV on Win2003, refusing new logins, 
 UniAdmin issues RPC errmsg
 
 Have you checked the user license count using the Uv license 
 tool.  Users may not be exiting gracefully and are leaving 
 the license locked on the server.  To clean this use 
 UvLicTool with the clean option to release these licenses.  
 You will find it in the /uv/uv/bin directory.  It has options 
 to report licenses or fix license count.
 
 This can occur if a program has a fatal that logsout the system.  
 
 Other issues can be where users exit the Dynamic Connect 
 client without first logging out. 
 
 Regards
 
 David Jordan
snip
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] merge sort

2004-07-23 Thread Doyen Klein
Chuck, if what you wanted was to look at the code to see how it's done this
won't help but.

AD for MERGE.LIST

I've used MERGE.LIST which is very effective. I've written programs which
sort and merge many subsets just by executing this utilities and then doing
the good ol' READLIST.

SELECT PARTS BY REV.NO SAVING REV.NO TO 1
SELECT VENDOR.PARTS BY VEN.REV SAVING VEN.REV TO 2
MERGE.LIST 1 UNION 2
Or 
MERGE.LIST 1 DIFFERENCE 2

You can go on forever . (or at least I've gone up to 9 lists.)
SSELECT is best if you can use file ID's.

Even if you don't have a file structure already built, you can create a temp
file, write your data elements to be sorted out as ID's then use SSELECT.

Amazing what some programmers will do to avoid writing code :-)


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chuck Mongiovi
Sent: Friday, July 23, 2004 2:46 PM
To: [EMAIL PROTECTED]
Subject: [U2] merge sort

Does anyone know where I can get code for a generic BASIC Merge SORT
routine?
-Chuck
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] merge sort

2004-07-23 Thread Rosenberg Ben
EXECUTE MERGE.LIST 0 UNION 0 TO 0
will sort and de-dupe the current select list.

 -Original Message-
 From: Chuck Mongiovi 
 
 Does anyone know where I can get code for a
 generic BASIC Merge SORT routine?
 -Chuck
 ---


The information contained in this e-mail message may be privileged 
and confidential information and is intended only for the use of 
the individual and/or entity identified in the alias address of 
this message.  If the reader of this message is not the intended 
recipient, or an employee or agent responsible to deliver it to the 
intended recipient, you are hereby requested not to distribute or 
copy this communication. If you have received this communication in 
error, please notify us immediately by telephone or return e-mail and 
delete the original message from your system.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UD] Returning data to ksh

2004-07-23 Thread Ralph Melia
Thanks guys.

I ended up using a file based on the calling shell's PID. It works but
thought there might be a more elegant solution.


- Original Message - 
From: Ken Wallis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 10:10 PM
Subject: RE: [U2] [UD] Returning data to ksh


 Doyen Klein wrote:

  You could at the start of the shell write an 'in-process flag' (simply
  create file with a specific name).
 
  As the final step in the process, when completed
  successfully, delete that file.
  Then .
 
  If [exists(file)] - you know the process failed.

 You could also look at it the other way round - rm -f a status file before
 you kick off the udt process, then afterwards, if the file exists and
 contains a good status code then all is well, otherwise it isn't.
Something
 a bit like this:

 #!/usr/bin/ksh
 # could try something clever to give you a unique temp file name here if
you
 like
 export STATFILE=/x/y/z
 rm -f $STATFILE
 udt !eof
 YOURCOMMANDSHERE
 WRITESTATUS
 quit
 !eof
 if [ -f $STATFILE ]
 then
 head -n 1 $STATFILE | read STAT ERRMSG
 else
 STAT=99
 ERRMSG=cannot find status file $STATFILE
 fi
 if [ $STAT = 0 ]
 then
 # cool
 else
 # not cool
 echo $ERRMSG 2
 exit $STAT
 fi

 And WRITESTATUS would be a cataloged program that might look like this:

 PROGRAM WRITESTATUS
 * maybe use the @USER... variables or your own specific named common to
keep
 track of things
 COMMON /STATCOM/ ERRSTAT, ERRMSG
 OSWRITE ERRSTAT: :ERRMSG TO GETENV(STATFILE) ON ERROR ABORT
 STOP
 END

 HTH,

 Ken

  Ralph Melia wrote:

  I'm working on a project that involves integrating our (UD 5.2 on AIX)
  programs into a job stream via ksh scripts. And I need a way of
  communicating back to the calling shell whether the unidata process
  (program) completed successfully or not. The relevant part of
  the shell would look something like:
 
  $UDTBIN/udt program parameters
 
  if [ it failed ]; then do something
 
 
  I'm thinking that there must be a simple solution, but I'm
  drawing a blank.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Mvquery Row

2004-07-23 Thread Dave S
Does anyone know how to prevent the column called ROW from getting
created when the results are produced ?


-
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] UniDK

2004-07-23 Thread Bill Pizer
Well that did not work. Thanks for all your help but my VP is going to overrule me 
('us').  Oh wellWhat can you do?!? :-)  Thanks again

Bill Pizer
Assistant Director of MIS and Benefactor System Administrator
The Sage Colleges
45 Ferry Street
Troy, NY  12180
518-244-2087
518-244-2085 (fax)
email: [EMAIL PROTECTED]



---
Original Email
From: Ray Wurlod [EMAIL PROTECTED]
Sent: Jul 17, 2004 06:54 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniDK

I wholeheartedly support the previous two posters' comments.
Best is to have your new person use PE on a machine not connected to the network, the 
only totally safe strategy.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/