RE: [U2] UV: Linux configuration question {Unclassified}

[HENDERSON MIKE, MR]

John & Jerry,

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of John Hester
> Sent: Friday, 4 November 2005 10:45
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UV: Linux configuration question

[snip]
 
> These are the uvconfig parameters that have been changed from 
> the default:

Our Production system is a 220-user Windows system ...

> MFILES 70
we use 1000
> GLTABSZ 75
> RLTABSZ 75
we use 300
> RLOWNER 300
> MAXRLOCK 74
we use 299
We also set
  T30FILE = 2500 (we use lots of Dynamic files)

> I don't know why IBM doesn't just make them the default.

Or better still, make the installer a little more intelligent (less 
stupid?) so that the generated values are affected by the amount of 
memory in the host system.


Then offer a UniAdmin plug-in or similar that gathers statistics
and produces a report that says 'based on system activity from  to , we recommend that you change these 
parameters ...'

Ah well, dreams are cheap!
:-)


> 
> -John
> --
> John Hester
> System & Network Administrator
> Momentum Group Inc.
> (949) 833-8886 x623
> http://memosamples.com
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] AIX Backup, Format Disk, Restore

[Scott Richardson]

Well, after a few have chipped in to the other side, I am going to have to
beg to differ.

Unix file systems, as all file systems, do tend to fragment, especially in
times of rapid growth of data on the file system, or in situations where
free space and free inodes on any given file system, become tight. Once file
systems have been heavily utilized, (75% full or higher), even if files have
since been deleted, there will be fragmentation.

Another situation where fragmentation may bite you is if you write large,
sequential files to disk, then delete them, then re-write similar large
files frequently, (i.e. spool files, etc...). Some post-relational database
applications can tend to do this. Any combination of these two situations
occuring can certainly contribute to fragmentation.

Granted, this does not seem to occur as often as it has in the past, or seem
to have as much impact. I have come across situations in the past where this
has brought platforms and applications running on them, to it's knees. If
the systems folks really would like to perform such a function, (AIX Backup,
Format Disk, Restore), it is not necessarily such a bad thing. I would go so
far as to recommend such operational functions be performed periodically,
especially if percent utilization of file systems can exceed 75%.

My two cents.

Regards,
Scott Richardson
Sr Systems Engineer / Consultant
Marlborough, MA 01752

DPMonitor - http://www.deltek.us

- Original Message - 
From: "Anthony W. Youngman" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, November 03, 2005 6:49 PM
Subject: Re: [U2] [UV] AIX Backup, Format Disk, Restore


> In message
> <[EMAIL PROTECTED]
> .com>, [EMAIL PROTECTED] writes
> >Does anyone out there still do this (if you ever have)?
> >
> >Take a backup of the file systems (in our case, AIX UNIX), format the
disks
> >clean, then restore the data back down to lay it back contiguous.
> >
> >Are there any (noticeable) I/O advantages to doing this for a UniVerse
> >database on today's servers?  Provided our files are properly sized, of
> >course.
> >
> >Our Systems guys are itching to do this.
> >
> Are they Microsoft-trained? :-)
>
> Unless you fill up the hard disk, Unix file systems don't fragment. The
> only real reason for this is if you're using LVM and your partition
> allocation has fragmented badly.
>
> In normal use, you should never need to defragment.
>
> Cheers,
> Wol
> -- 
> Anthony W. Youngman <[EMAIL PROTECTED]>
> 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
> thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The
man
> lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
> Visit the MaVerick web-site -  Open Source
Pick
> ---
> 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] UV: Linux configuration question

[karlp]

> I was wondering if anyone knows if I should change any of the
> configuration
> parameters on our new system. We have a Dell Poweredge system running Red
> Hat
> Enterprise Linux AS release 3 (Taroon Update 2), Kernel 2.4.21-15.EL, and
> uniVerse rev. 10.1.12 in Reality flavor, 117 user license. It has dual
> 3.33
> GHz/8MB Cache Xeon processors with 8GB DDR2 400 MHZ DIMM memory and over
> 500GB
> of disk space. The configuration parameters are set to the following:
>
> UVTEMP=/tmp

Aside from what John Hester recommended, I always move UVTEMP somewhere
else. Having it cluttering up the 'OS' tmp directory makes
trouble-shooting the system just a bit harder.

> SHDISPATCH=/bin/sh
> SHDISPATCH=/bin/sh

Are you missing CSHDISPATCH? I usually change it to /bin/sh (on AIX
/usr/bin/ksh). The C-shell has some problems which most users won't see,
but having the random problem crop up now and then causes more grief than
using csh merits. Most users don't have a clue about csh/ksh/bash(sh)
anyway, but who knows about the support folks?

Karl

>
> Jerry Banker
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] AIX Backup, Format Disk, Restore

[Anthony W. Youngman]

In message 
<[EMAIL PROTECTED]

.com>, [EMAIL PROTECTED] writes

Does anyone out there still do this (if you ever have)?

Take a backup of the file systems (in our case, AIX UNIX), format the disks
clean, then restore the data back down to lay it back contiguous.

Are there any (noticeable) I/O advantages to doing this for a UniVerse
database on today's servers?  Provided our files are properly sized, of
course.

Our Systems guys are itching to do this.


Are they Microsoft-trained? :-)

Unless you fill up the hard disk, Unix file systems don't fragment. The 
only real reason for this is if you're using LVM and your partition 
allocation has fragmented badly.


In normal use, you should never need to defragment.

Cheers,
Wol
--
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UV: Linux configuration question

[John Hester]

Jerry Banker wrote:

I was wondering if anyone knows if I should change any of the configuration
parameters on our new system. 


We're running RH AS 3 update 5 on an IBM xSeries 345.  These are the 
uvconfig parameters that have been changed from the default:


MFILES 70
GLTABSZ 75
RLTABSZ 75
RLOWNER 300
MAXRLOCK 74
ALLOWNFS 1

Those changes aren't OS specific though.  We had them set that way on 
our prior unix platform as well.  AFAIK the defaults for those settings 
can cause problems on any OS (except ALLOWNFS).  I've got a cheat sheet 
from a class I attended at a Spectrum show back in '96 that recommends 
the values above.  I don't know why IBM doesn't just make them the default.


-John
--
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UV: Linux configuration question

[Jerry Banker]

I was wondering if anyone knows if I should change any of the configuration
parameters on our new system. We have a Dell Poweredge system running Red Hat
Enterprise Linux AS release 3 (Taroon Update 2), Kernel 2.4.21-15.EL, and
uniVerse rev. 10.1.12 in Reality flavor, 117 user license. It has dual 3.33
GHz/8MB Cache Xeon processors with 8GB DDR2 400 MHZ DIMM memory and over 500GB
of disk space. The configuration parameters are set to the following:

MFILES=12
T30FILE=200
OPENCHK=1
WIDE0=3dc0
UVSPOOL=/usr/spool/uv
UVTEMP=/tmp
SCRMIN=3
SCRMAX=5
SCRSIZE=512
QDEPTH=16
HISTSTK=99
QSRUNSZ=2000
QSBRNCH=4
QSDEPTH=8
QSMXKEY=32
TXMODE=0
LOGBLSZ=512
LOGBLNUM=8
LOGSYCNT=0
LOGSYINT=0
TXMEM=32
OPTMEM=64
SELBUF=4
ULIMIT=128000
FSEMNUM=23
GSEMNUM=97
PSEMNUM=64
FLTABSZ=11
GLTABSZ=50
RLTABSZ=50
RLOWNER=50
PAKTIME=300
NETTIME=5
QBREAK=1
VDIVDEF=1
UVSYNC=1
BLKMAX=8192
PICKNULL=0
SYNCALOC=1
MAXRLOCK=40
ISOMODE=1
PKRJUST=0
PROCACMD=0
PROCRCMD=0
PROCPRMT=0
ALLOWNFS=1
SHDISPATCH=/bin/sh
SHDISPATCH=/bin/sh
DOSDISPATCH=NOT_SUPPORTED
LAYERSEL=0
OCVDATE=0
MODFPTRS=1
THDR512=0
UDRMODE=0
UDRBLKS=10
MAXERRLOGENT=100
JOINBUF=4095
64BIT_FILES=0
TSTIMEOUT=60
PIOPENDEFAULT=0
MAXKEYSIZE=255
SMISDATA=0
EXACTNUMERIC=15
MALLOCTRACING=0
CENTURYPIVOT=1930
SPINTRIES=10
SPINSLEEP=1
CONVERT_EURO=0
TERM_EURO=164
SYSTEM_EURO=164
SQLNULL=128
UVNET_CONNECT=0
ALLOWMARKS=0
PICKDATE=0
PICK_MT=0
UVTSORT=1
PHANTOMSAMEUV=0
CPLOGRLS=0
BGINPUTTIMEOUT=0
TXNEXTHOLD=1
TIMEACCURACY=1
TXWMFSYNCMODE=0

Jerry Banker
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Bug in UV.VI

[karlp]

Awesome. I'll give it a try (after bringing my mail/web/client-access
server back from the dead after the mirror broke).

Karl


> Hi Karl,
>
> Below is an email from Tony Wood explaining how to patch UV.VI to work
> correctly.
> Apparanently IBM have had a GTAR outstanding for years but it isn't
> considered important enough to fix (you can use ED after all).
>
>
> Craig
>
>
>
>  Original Message 
> Subject: Re: [UV] file type question
> Date: Wed, 14 May 2003 10:58:59 +1000
> From: Tony Wood <[EMAIL PROTECTED]>
> Reply-To: 
> Organization: Reynolds & Reynolds
> To: 
> References:
> <[EMAIL PROTECTED]>
>
> Longname refers to the filenames only I believe.
>
> A type 1 file allows for item name of 14 characters then it creates a
> subdirectory. This is described in the doco. Use a type 19 file instead if
> this is a problem.
>
> UV.VI has a bug that incorrectly identifies a type 19 file as having a
> type
> 1 item name structure and looks in a non-exisitant subdirectory for the
> item.
>
>  >From the UV account try ED BP UV.VI.B (the line numbers are a guide
> only)
>
> 125*** is edit file a directory
> 126
> 127if file.info<21> = 1 or file.info<21> = 19
> 128then
> 129   file.path = file.info<20>
> 130  *dirtype = file.info<20> ;* This is where is
> mis-identifies
> the file type.
> 131   dirtype = file.info<21>
> 132end
> 133else
>
> And futher on;
>
> 254  process.argument:
> 255
> 256  * if dirtype ne 19 then
> 257if dirtype eq 1 then
> 258   execute 'UNIX.PATH "':f.arg:'"' capturing item.id
> 259
> 260   item.id = item.id<1>
> 261end else
> 262   item.id = f.arg
> 263end
>
> File and compile and your away. Don't forget to take a copy of this and
> keep
> somewhere so the next upgrade doesn't overwrite it. I have reported this
> to
> IBM but I doubt it's a high priority.
>
> Regards,
>
> T.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Re: Universe File Corruption

[Mark Baldridge]

Another way to create random file corruption is to back up an active
database with a system-level utility that does not honor the lock manager,
and restore the backup.  Backing up the database in this manner creates an
inconsitent image.

Mark A. Baldridge
Principal Consultant
North American Lab Services
DB2 Information Management, IBM Software Group
(607) 351-5666
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] RE: U2 Users Digest V1 #908

[Boyd, Diane]

In regard to he corrupted data file .
Did you run UVFIXFILE to fix the file ?  If not you may want to run this
command first.  After the fix verify if the file is ok by running the
ANALYZE.FILE then list the file.  Is the file used in other programs
that locks a record but does not write to the record or release the
record?
Is the program acquiring a lock before it attempts to write to the file?
If not change the program, to check for the lock and if no lock acquire
a 
lock then write to the file.  

Hope that helps 
D. Boyd 
Programmer Analyst 



date: Thu, 03 Nov 2005 02:22:48 +0530
From: "shuchi bhandari" <[EMAIL PROTECTED]>
Subject: [U2] UV corrupted file

Hi,

One of our UV database files (type 30 - 64 bit) has become corrupt.

As a result of this, our programs fail to write to the corrupted file.

However even after exiting from the program, the unix session for the
logged 
in user is showing a CPU utilization of around 100%; which in turn his 
making the system unstable.

There seems to be no way of releasing these resources but to kill these
idle 
sessions that seem to have hung for hours.

If anybody has any pointers on why this is happening or how can we
control 
it please do let me know.

Thanks,

rg
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] PRINT @(-23)

[Dianne Ackerman]

Didn't think of that!  Thanks, I'll check that out on their site.
-Dianne

Bill_H wrote:


Dianne:

The next step would be to look at the term-type, to make sure the
appropriate control codes are called, then the term-type item itself to make
sure the appropriate control codes are in the terminfo file.

Of course you should ensure the terminal is complied properly with "uvtic".

Hope this helps.

Bill


 


-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of 
Dianne Ackerman

Sent: Wednesday, November 02, 2005 6:23 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] PRINT @(-23)

Using Accuterm.  The printer is fine because when I'm 
attached to other clients' sites it all works fine.

-Dianne

Bill_H wrote:

   


Dianne:

What client software are you using?  wIntegrate?  If so, check with 
File > Printer Setup.  Make sure a valid Windows printer is 
 

selected, 
   


or one that works with U2.

Hope this helps.

Bill




 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dianne 
Ackerman

Sent: Tuesday, November 01, 2005 12:24 PM
To: U2 List Server
Subject: [U2] [UV] PRINT @(-23)

I have a program which does a PRINT @(-23) at the beginning and a 
PRINT
@(-24) at the end so that all the information prints on the aux 
printer.  Works great, but when running at one particular 
   

client site, 
   

I get all kinds of weird characters printing on the 
   

document, at the 
   

beginning and end of each line.  Fine at any other site, but just a 
problem when connected to this one client.  Does anyone 
   

have an idea 
   


where I can look?
Thanks!
-Dianne

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] PRINT @(-23)

[Dianne Ackerman]

Yes, it happens with all workstations and printers at that client site; 
that's actually how I came to know about it - I'm troubleshooting for 
them.  When I install the same program anywhere else and run it there 
are no issues.

Tony Gravagno wrote:

>I had a site years ago where something like this was happening.  The server
>was in one office and remote end-users were connected over a multiplexor.
>Various @ sequences were interpreted by the MUX rather than being forwarded
>to the end-user.  For one particular sequence, a simple @(13) to reference
>column 13 of the current line, we had to update all programs to move screen
>data over by one character - there was no way to get around having the MUX
>translate that sequence into a ctrl-S to lock the port.
>
>Anyway, this might not be your exact problem but it may point in the right
>direction.  That is, something else like a device driver or communications
>line may be translating those characters for you.  It could also just be
>shot firmware in the printer - did you test with different workstations and
>printers?
>
>HTH
>T
>
>Dianne Ackerman wrote:
>  
>
>>I have a program which does a PRINT @(-23) at the
>>beginning and a PRINT @(-24) at the end so that all the
>>information prints on the aux printer.  Works great, but
>>when running at one particular client site, I get all
>>kinds of weird characters printing on the document, at
>>the beginning and end of each line.  Fine at any other
>>site, but just a problem when connected to this one
>>client.  Does anyone have an idea where I can look? 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UVODBC on AIX

[Andy Moore]

DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Further to this, I discovered today that when you try to activate an
account in the HS Admin menu, Universe drops you to the OS shell with a
nice error message.

Could the two be related or has our installer maybe not carried out the
installation correctly?

Error message below,

Abnormal termination of UniVerse.
Fault type is 11.  Layer type is BASIC run machine.
Fault occurred in BASIC program *HS.FILEINFO at address 44.
Segmentation fault(coredump) 


Andy Moore
Selima Software Ltd.

-Original Message-
From: Peter Dick [mailto:[EMAIL PROTECTED] 
Sent: 31 October 2005 12:57
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC on AIX

The daemon that UVODBC on AIX uses is the uvrpcd and this is defined in
the /etc/services file.

The daemon should automatically start following a boot / reboot of the
server.

The UVODBC group needs to be included as part of the UniVerse
installation process.

It is also worth doing a "netstat -a |grep rpc" to see what state it is
in.

I would be inclined to change your "installer" and start using your
Support Provider! ;)

Pete Dick

Technology Support

www.epicor.com





This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses.
---
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] NFA and Triggers

[Don Verhagen]

Wendy,

We use NFA pointers on our web server, so basically the kiddies can't get all 
of our production files [grin]. Triggers get executed on the server where the 
files live (aka not the remote server). However, you will not be  the 
"Enviroment" of the account, it's just Unidata running. We for example have SB+ 
Accounts, the SB enviroment is NOT loaded (ie @ACNT.NAME, @USER.ID, @PORT are 
initialized but values are not set.)

So if your triggers depend on these things you may have to setup a program in 
your login process to load these enviroment variables.

Hope this helps,


* Please NOTE NEW Telephone Number * 
--
Donald Verhagen  
Application Development Manager
[EMAIL PROTECTED]
Tandem Staffing Solutions, Inc.
1690 S Congress Avenue, Suite 210
Delray Beach, FL 33445  USA
Voice Phone: 561.226.8261 Fax Phone: 561.226.8118

>>> [EMAIL PROTECTED] 4:58:43 PM 11/01/2005 >>>
Wendy:
I have not tried this, but I would expect the trigger defined on the file
on the remote system would work fine. There is no NFA file on the 'client'
system - just an 'FX' style file pointer - so you couldn't define a trigger
to fire on an FX pointer in the 'client' environment. (using 'client'
loosely - as the system with the FX pointer to a file on a 'remote' system)

Wally Terhune
Manager - U2 Advanced Client Support
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969< New Number!
Fax: 303.773.5915< New Number!
[EMAIL PROTECTED] 





 Wendy Smoak
 <[EMAIL PROTECTED] 
 g> To
 Sent by:  u2-users@listserver.u2ug.org 
 [EMAIL PROTECTED]  cc
 stserver.u2ug.org
   Subject
   [U2] NFA and Triggers
 11/01/2005 10:47
 AM


 Please respond to
 u2-users






Given a file with a trigger, where does the trigger code actually execute
when you open a file with (over?) NFA and write a record to it?

We have some trigger code that needs a certain environment (Datatel's
Envision) to run, and that environment exists where the  file lives... but
not in the account from which we're opening files with NFA.

The backup plan is to get rid of the trigger and simply write records to a
file that gets processed later by a cron job.

Any advice or discussion to help me understand this better?

--
Wendy Smoak
---
u2-users mailing list
u2-users@listserver.u2ug.org 
To unsubscribe please visit http://listserver.u2ug.org/ 

[demime 1.01d removed an attachment of type image/gif which had a name of 
graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
pic07440.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
ecblank.gif]
---
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/