Re: [U2] Universe Server Hibernation

2011-07-20 Thread Arnold Bosch
Many thanks for the responses :) - lost of food for thought!

George, Thanks; I'm aware of the UPS being able to trigger processes; in 
fact I'm working toward a control system that will in future help to 
handle such incidents; there is a handful of less critical servers 
involved as well.

Wol - the hibernation is not set up yet; and yes; I want to suspend the 
entire server and operating system to disk - no VMs involved.  Our UV 
server is the server least often shut down or rebooted; to the point where 
I actually delay OS patches for months on end; having a 100% uptime of 6 
months on the UV server is nothing new here.  In fact last week's incident 
was the first in 3 years where this server went down without pre-scheduled 
downtime. 

John, a generator is high on my priority list.  Proposals and funding for 
one have been repeatedly rejected during the last couple of years by my 
directors.  We have invested heavily in wireless technology in our 
warehouses in the last year though, and I'm busy preparing new proposals 
which should be more open to acceptance, as power outages will have a much 
bigger impact on our business operations than in the past.  We don't have 
a large user base - just 120 users at present, but that incorporates a 
whopping 50% growth in just the last year; it's been playing havoc with 
capacity planning and licensing!

Thanks Stuart - it looks like I'll have to do some testing then.  I'll 
just install a copy of UV on a test machine and restore a backup to it and 
run the tests within the 30 day licensing grace period; I really feel 
Rocket wouldn't bust my butt for a once-off test like this.  If anybody 
from Rocket reads this, I would appreciate your comments before I do it 
though.  If/Once I'm happy with the software tests, I can do a controlled 
test on the actual server to check for hardware related issues.  There are 
two other small UV sites here in Namibia that may also benefit from this 
localised experience - I'll post feedback on the test results.

Ross, thanks; the processes run in serial from a paragraph list - 
unfortunately it needs some user data inputs to start up thus the need for 
a telnet session on the server console to start it; we learnt years ago 
it's not good to run this lot from a networked session!  No SAN / NAS - 
just a proper RAID system in the server itself.  The console telnet 
session is my main concern though...  I might have to see if we can start 
the processing off from a local UV shell; that might be more feasible than 
a local telnet session.

Kind Regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
--


-
Disclaimer: This email message is intended solely for the use of the 
individual or entity to whom it is addressed and may contain confidential 
information which may be privileged and protected by law. If you are not 
the intended recipient, please notify us at our email address, delete this 
message and do not disclose the contents of this email message to any 
other person use it for any purpose or store or copy this email in any 
manner or form. Opinions, conclusions and other information contained in 
this email message that do not relate to our official business shall be 
understood as neither given nor endorsed by us. We do not represent, 
warrant and/or guarantee that the integrity of this communication has been 
maintained or that this communication is free of errors, virus, 
interception or interference.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Universe Server Hibernation

2011-07-19 Thread Arnold Bosch
Hi

Has anybody ever tested how Universe behaves if the server is hibernated 
to disk ?  Does it work and resume locally logged on sessions properly 
when the server is brought back up again?
Obviously all network sessions will be aborted, but I'm not concerned 
about that.

For background:
We're running Universe 10.2.10 on Windows 2003 Enterprise X64 Server.
Every night we have backups,  a lot of batch update jobs and reporting 
that runs on the UV server.  During this time period, there are no users 
connected to the system; only administrators can connect.
Last week one night we had a power failure that outlasted the 4 hours 
run-time we have on our UPS, resulting in the server going down without a 
proper shutdown; fortunately not while in the middle of doing updates.

I am concerned that something similar might happen while the system is 
processing; during the day it is OK as there are IT staff on-site that can 
make sure that user sessions are terminated as normally as possible and 
the server brought down gracefully during long-running outages.

Why I'm asking about the hibernation: If there are local UV processes 
running, and the server is suspended to disk, will such processes carry on 
from where they left off when the server is brought up again ? - this 
could save us a lot of recovery time in such cases - rare as they are. 
Currently we have to look at at what point of the nightly jobs the server 
went down; if it was during backups no processing would be done; if it was 
during processing, we have to restore the backup to get the server back to 
a known state and so on.

Kind regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
--


-
Disclaimer: This email message is intended solely for the use of the 
individual or entity to whom it is addressed and may contain confidential 
information which may be privileged and protected by law. If you are not 
the intended recipient, please notify us at our email address, delete this 
message and do not disclose the contents of this email message to any 
other person use it for any purpose or store or copy this email in any 
manner or form. Opinions, conclusions and other information contained in 
this email message that do not relate to our official business shall be 
understood as neither given nor endorsed by us. We do not represent, 
warrant and/or guarantee that the integrity of this communication has been 
maintained or that this communication is free of errors, virus, 
interception or interference.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Refresh UV user permissions without restarting UV Service ?

2011-01-28 Thread Arnold Bosch

Hi everyone.

Is it possible to force Universe to refresh it's internal permissions
list without restarting the UV service?

I have a user that I added to the Windows Administrators group after the
user was created on Windows and in Universe.
It does not appear that UV picks up that this user is now allowed
administrative privileges - and I really don't want to restart the UV
service at this point in time on the server to get this going.

For info: UV 10.2.1 on Windows Server 2003.

Any suggestions would be most welcome.

Kind regards,

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: arno...@tc.com.na
--
-
Disclaimer: This email message is intended solely for the use of the individual 
or entity to whom it is addressed and may contain confidential information 
which may be privileged and protected by law. If you are not the intended 
recipient, please notify us at our email address, delete this message and do 
not disclose the contents of this email message to any other person use it for 
any purpose or store or copy this email in any manner or form. Opinions, 
conclusions and other information contained in this email  message that do not 
relate to our official business shall be understood as neither given nor 
endorsed by us. We do not represent, warrant and/or guarantee that the 
integrity of this communication has been maintained or that this communication 
is free of errors, virus, interception or interference.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


RE: [U2] PDF printing, LaTeX, Ghostscript, etc. - [OT]

2009-01-28 Thread Arnold Bosch
Having noticed that a good part of development is done in Delphi, and the
cross-platform dilemma, has anyone looked into FPC-Lazarus for development
around UV ?
Also coming from a Delphi environment, I have so far found it relatively
easy to port my Delphi applications to FPC-Lazarus, and then with very
minor modifications cross-compile for Windows, Linux and Windows CE.

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Batch conversion of 32bit files to 64bit

2008-12-23 Thread Arnold Bosch
Hi

Does anyone know of an easy way to convert a lot (+/- 100) 32 bit UV files
to 64 bit ?

Doing them one-at-a-time is a pain, and I'd like to convert all of our
files, as we regularly run into the 32bit filesize limits.
Is it possible to RESIZE.FILE on a 32 bit file to convert it to 64 bit?

My System: UV 10.2.10 on W2K3 Server.

Regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: arno...@tc.com.na
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] ACS Embrace

2008-04-16 Thread Arnold Bosch
Hi Dennis

We use it both in South Africa and Namibia for the Taeuber  Corssen group
of companies for full financials and Inventory.  We pay extra to have
access to source code, as we had to modify the standard system fairly
extensively for multi-company and multi-division use in our industry.

Currently we are on a fairly old version - we will be upgrading later this
year here in Namibia, and a part of our SA operation has already been
upgraded. The version we are on does have some limitations; I am not yet
sure how much of those will be addressed by the upgrade.

In general, it copes well - we have 73 licenses with 100 users fighting for
login sessions, especially around month ends.
Our users are distributed throughout the country on VPN links - comms
failures on these can cause some issues.
The standard system also does not make use of indexing, and the data
dictionaries could do with refinement. In the past this was not a problem,
but we are starting to have performance issues, as some of our data files
have grown to a couple of gigabytes.  In the near future, we'll further
customise to use indexing - preliminary tests for this looks good.

To give an indication of what Embrace copes with here in Namibia - We print
roughly 2 invoices per month, and the necessary picking requests for
the warehouses, with a product range of about 1200 items.  For the volume
of transactions we do, the amount of user support we have to do is
surprisingly minimal.

We migrated from HP UX to Windows 5 years ago - I did a lot of preparation
before the migration(writing scripts to automate file copying etc), and
over a weekend I switched everything across.  The Monday users continued as
if nothing had happened - we only had some issues with Windows user
accounts that had uppercase letters in them. This means that Embrace copes
well with server migrations.

Server Administration (on the Embrace/Universe server) for me consists of
once-a-month loading Windows patches, and while everyone is off-line
defragmenting the data file systems.  We encounter severe fragmentation on
some of the files on the NTFS file systems.

Top of the wishlist would be a decent report generator - I know ACS is
addressing that in the newer versions.  Also, in the past they did not seem
keen on supporting Embrace on a Linux server, and the Embrace Desktop
client is not available for anything but Windows.

You are welcome to email me off-list for more detail.

HTH

Regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Email: [EMAIL PROTECTED]
--


   
 Dennis Bartlett 
 [EMAIL PROTECTED] 
 .co.zaTo 
 Sent by:  u2-users@listserver.u2ug.org  
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   [U2] ACS Embrace
 16/04/2008 10:19  
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




Hi

Does anybody use ACS (South Africa) Embrace software - if so, any comments
on usage, eg problems, wishlist, whatever?

dennis
---
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] [UD] Possible causes of corrupt data on a UniData static file

2007-11-01 Thread Arnold Bosch
Is guide only available on UD ?

It does not work with UV (10.0).  Is there a similar command available in
UV?

Thanks!

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: [EMAIL PROTECTED]
--

[EMAIL PROTECTED] wrote on 01/11/2007 23:14:16:

 I wrote previously:
 UniBasic does not prevent you from writing out a record or ID with
char(0)
 imbedded. It is a legal character.
 No guesses as to the cause of your particular issue.
 To assist in diagnosis, you can search your problem file for all
occurances
 of char(0) in data records or keys using an option on 'guide'.
 For instance:

 guide -U0 PROBLEM.FILE.NAME
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Exporting files

2007-03-29 Thread Arnold Bosch
Hi Anita

You didn't specify the operating system(s) you are using - so I'll presume
Windows, and also presume that an equivalent UV account already exists on
the destination PC

You can use UVBACKUP on the source PC to backup the file, and UVRESTORE on
the destination PC to restore the file - make sure that the Universe BIN
directory is in the search paths on both PCs (normally C:\IBM\UV\BIN).  If
you enter just UVBACKUP or UVRESTORE in a command shell window, you will
get a list of command line parameters for these programs.

In a command shell window, change to the directory where the file has to be
backed up from, and do:
UVBACKUP -v -t backup.image.name name(s) of file(s) to backup
The backup.image.name is a name for a directory path and file name that
will contain the backup image - this then needs to be copied to the
destination PC, and must be restored using UVRESTORE.

Remember, you also need to include the file's data dictionary in the
backup/restore process if needed.
Example:
You have a UV account called TEST in directory C:\DATA\TEST, on both the
source and destination PC
You want to backup a file called FILE1 from TEST to the other PC - the
dictionary file would then (normally) be called D_FILE1.

On the source PC:
Open a command shell (Start - Run - cmd)
cd c:\data\test
uvbackup -v -t BACKUP.DAT D_FILE1 FILE1

Now copy file backup.img to the other PC's C:\DATA\TEST directory (using
network / memory stick / whatever other means you have available)
On the destination PC:
Open a command shell
cd c:\data\test
uvrestore -v BACKUP.DAT

This is a _very_ basic example. There are also other things to keep in mind
- Indexes (which also needs to be backed up), you should have no activity
(reads/writes/record locks) on the file(s) being backed up  restored etc.
If the destination UV account does not exist on the destination PC, you'll
have to create it first.  It is also important that you backup your base UV
account regularly, as it contains a lot of things needed to restore a
crashed system - such as user accounts, ODBC settings, VOC entries etc.

Below, I pasted extracts from shell scripts that I use for regular backups
/ restores on my system.

HTH

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: [EMAIL PROTECTED]


BACKUP.CMD:
-
@echo off
REM XSERV Universe Backup script
REM Usage: backup -d|-f DAYNAME
REM Command-line parameters:
REM   -d Perform Daily Backup
REM   -f Perform Full Backup
REM DAYNAME: Weekday (e.g. MONDAY) or MONTHLY for monthly backup
REM Daily backup makes full backup of live data and UV account
REM Full backup backs up history as well.
REM Original: A. Bosch 26/10/2003

REM Assign more readable values
if x%1==x set BU_Type=DAILY
if x%1==x-d set BU_Type=DAILY
if x%1==x-D set BU_Type=DAILY
if x%1==x-f set BU_Type=FULL
if x%1==x-F set BU_Type=FULL

Set WDAY=%2

@echo off
echo Starting XSERV Universe %BU_Type% Backups %DATE% %TIME%


REM Go to d:\mydata, so that relative backups can be done
REM   Relative backups can be easier to restore to alternate locations.
REM Create file lists for all Universe Accounts that must be backed up
REM and save to temporary files.  These lists will be used for UVBackup
REM Do Daily lists first, and skip rest if not a full backup

d:
cd \mydata
echo %TIME% Creating  file list for MYDATA.LIVE
uvwalk MYDATA.LIVE -recurse  d:\temp\mylive.lst

REM Backup UV account as well - this stores user and account info
c:
cd \ibm
echo %TIME% Creating  file list for UV
uvwalk uv -recurse  d:\temp\uv.lst


REM Don't create following backup lists if this is a daily backup
if %BU_Type%==DAILY goto SkipFullLists


REM Start of lists to include in full backup

REM History is in d:\mydata, so go there before creating list
d:
cd mydata
echo %TIME% Creating file list for MYDATA.HISTORY
uvwalk MYDATA.HISTORY -recurse  d:\temp\myhist.lst


:SkipFullLists


REM Now do actual backups.  Take care to start from appropriate
REM directories, otherwise it will not work
REM Backups go to files to minimise time.  Veritas Backupexec is then
REM used externally from this script to create backups to tape.

REM First make sure destination folder exists
if not exist f:\backup\%WDAY% mkdir f:\backup\%WDAY%

REM Now proceed with the backups
d:
cd \mydata

if exist f:\backup\%WDAY%\mylive.bak del f:\backup\%WDAY%\mylive.bak
echo %TIME% Creating  Backup for MYDATA.LIVE
uvbackup -f -b 65536 -cmdfil d:\temp\mylive.lst 
f:\backup\%WDAY%\mylive.bak

REM Backup UV account as well - this stores user and account info

if exist f:\backup\%WDAY%\uv.bak del f:\backup\%WDAY%\uv.bak
c:
cd \ibm
echo %TIME% Creating  Backup for UV
uvbackup -f -b 65536 -cmdfil d:\temp\uv.lst  f:\backup\%WDAY%\uv.bak


REM Don't create backups for rest if this is a daily backup
if %BU_Type%==DAILY goto SkipFullBU

REM Start of backups to include in full backup

REM History is in d:\mydata, so go

Re: [U2] Upper Case and Editors

2007-03-15 Thread Arnold Bosch
I have been following this thread (and some other threads resulting from
fairly obvious newcomers to UV/UD) with interest.  Being pretty much a
newbie to UV myself I'd like to throw in a few comments:

Many, if not most, of the regular posters in this list seem to have MANY
years of experience in this environment, and are still coding according to
habits acquired way back in time.
I do not mean this disrespectfully - for those that are happy with using
line editors and all upper case, that is the way you work.

From a newbie's point of view though - anybody learning UV/UD now most
likely will come from a C or Visual Basic background, where (especially in
the case of C) almost all coding is done in lower case.  Personally I use
Delphi a lot, which is also done mostly in lower case.  I find it
inconvenient to switch to the convention of doing coding in all
uppercase, especially as I have made a habit of keeping a separate word
processor window open to document programs and changes while I am doing the
coding.  In between, I also have to provide end-user support to 100+ users
in MS Office, Lotus Notes etc., and being of a lazy (and efficient) nature,
this is done using VNC.  Then I also have my email open all the time, and
is constantly checking and replying to messages.

With all the above (and more!) happening, I find it annoying having to
switch caps-lock all the time - what happens a lot is that I switch to
another window and start typing away merrily, only to realise after a
couple of words that everything is cASE iNVERTED, or that the help I'm
trying to give to a user is not working because of case inversion.

As to editing, having become accustomed over the years to the convenience
of full-screen editors, and not initially knowing that it was possible to
use a full-screen editor to edit BPs, it was a nightmare for me to get the
simplest things done in UV.  I think there are many other newbies out there
that feels the same...

Add together to this the naming of things ( a UV ACCOUNT is not a login
account, but is similar to a MS SQL database etc.), and it was extremely
challenging for me to get to grips with UV - the namings make self-help
research difficult. Initially I actually hated UV for this, but I was
forced to use it because our core financial system runs on it.

After having come to grips with how UV works and interacts, I have come to
like and very much respect it for what it can do, but I see many of my
initial frustrations echoed in posts from other newcomers.  This can
possibly steer newcomers to the MV environment away from it - it takes a
lot of time and effort to make the switch.

As Mr. Glorfield stated in his farewell message, this is most definitely a
very helpful and courteous group, but on the odd occasion I have also seen
replies posted to obvious newcomers that is given based on years of
experience, but without regard to the fact that the newcomer does not
actually have the necessary foundation to understand it.
The U2UG web site proudly advertises the growing Knowledge Base, but how
does one get to it? - for a newcomer, there is no direct link to click
(unless I am not looking properly) - surely this will be one of the first
ports of call for anybody looking for information.

I am prepared to dedicate some personal time to do write-ups (how-tos etc)
for newcomers, from the perspective of a newcomer, which can then be vetted
by more experienced UV users for correctness - this will be a bit
intermittent as I have a lot on my plate though.  Is anyone prepared to vet
and host such write-ups?

For the newcomers out there who read this far - stick to it like a
foxterrier to a tennis ball - it will pay of in the end and you will be
surprised at the new world that opens up.
For the UV longtimers - thanks for all the help and feedback to the group -
it is much appreciated!

Regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Windhoek
Namibia
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: [EMAIL PROTECTED]
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Upper Case and Editors

2007-03-15 Thread Arnold Bosch
Thanks Craig - I'm aware of PTERM -CASE INVERT.  Unfortunately updating 
the LOGIN paragraph is not an option, as it impacts 75+ other users.  The 
best I can do is to manually issue the command each time I get to TCL.
So sometimes one has to suffer at the expense of others :-)
Regards

Arnold
--



Craig Bennett [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
15/03/2007 11:54
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
Re: [U2] Upper Case and Editors






Hi Arnold,

I haven't really been following this thread -- I gave up and learned to 
love THE BOMB years ago (despite coming to UV from a C background).
 With all the above (and more!) happening, I find it annoying having to
 switch caps-lock all the time - what happens a lot is that I switch to
 another window and start typing away merrily, only to realise after a
 couple of words that everything is cASE iNVERTED, or that the help I'm
 trying to give to a user is not working because of case inversion.

 
If you are running UV then issuing

PTERM -CASE INVERT

at TCL or in your LOGIN paragraph will apply case inversion just to the 
session you are logged into. It might make life simpler for you.

Sorry if this was covered elsewhere in the thread.


regards,


Craig
---
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] UniData and indexing

2006-09-20 Thread Arnold Bosch
I think this might be as relevant to UD as to UV - I am testing indexing on
UV currently:

LIKE type of queries on text fields that start with a known part e.g.
SELECT XDATA WITH CUST LIKE PARTCU... uses the indexing.  I'm not sure
about UNLIKE queries - these I have not tested yet.  LIKE type queries that
have a wildcard at the start do not use the indexing.  I have not tested
multiple wildcards with a known start though... (LIKE PARTCU...ME... for
example)

To make an analogy, it is like using a dictionary: it is easy to find all
words starting with wh (LIKE wh...) - just go to w, then to wh, start
making the list, and stop when wi is encountered.
To find all words with wh somewhere in them, you would have to start at
the beginning, and examine each word to see if it contains wh ( LIKE
...wh...) - this will take a lot longer ;-)

I also found that ALL D type dictionary items that point to the same
field benefit from indexing if an index is created on any one of them - for
example in:
LIST DICT AFILE
...
PRODUCT D 1 ...
PRODD 1 ...
PART.NO D 1 ...
...
An index created on PRODUCT (CREATE.INDEX AFILE PRODUCT) gets used with
a SELECT AFILE WITH PROD LIKE APRO... and SELECT AFILE WITH PART.NO LIKE
APRO... as well.

On our system I found a lot of I-type entries in dictionaries pointing to
plain D-type entries:
LIST DICT AFILE
...
PRODUCT D 1   ...
PRODI PRODUCT ...
PART.NO I PRODUCT ...
...
These I-types do NOT benefit - so I am busy writing a program that will
find these types of entries and convert them to D types to benefit from
indexes.  I don't understand why the suppliers of the system did this - My
sense tells me that to do a select on an I type takes an additional
calculation for each record - so that a select on an unindexed I type will
actually take longer than a select on the (unindexed) D-type it is pointing
to...

Regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: [EMAIL PROTECTED]

PS - PLEASE! don't blame me for the funny examples above - I inherited a
system with such wild and wonderful entries and absolutely no indexing...
And the users wonder why enquiries and reports take so long when run on 3
Gigabyte files...


   
 Jeffrey Butera
 [EMAIL PROTECTED] 
 e.edu To 
 Sent by:  u2-users@listserver.u2ug.org
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   [U2] UniData and indexing   
 20/09/2006 14:53  
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




This may be a naive question, but I'll ask nonetheless... I'm on Unidata
6.1
(soon to be 7.1), if it matters.

We have a slew of fields in various files indexed.  My question is how
indexing improves performance for LIKE and UNLIKE comparisons.  I know
indicies make EQ and NE queries much quicker, but I'm not sure if the
LIKE/UNLIKE operators benefit as well.

Any thoughts/insight appreciated.  If LIKE/UNLIKE don't see similar
benefit, I
can alter the way I'm storing data to use EQ/NE.

--
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

You're not right, Daddy
   my 3-year old showing her wisdom
---
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] Universe Logins

2006-08-24 Thread Arnold Bosch
Hi John

Check the case (upper/lower/mixed) of the user's name in Active Directory -
If the case there doesn't not match the case in UV.LOGINS, you get this
problem.

For example:  In Active Directory username = ArnoldB.  In UV.LOGINS,
username = arnoldb causes this.

I learnt this the hard way when we migrated from Unix to Windows a couple
of years ago; now I set up usernames in lowercase as a rule.

HTH

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd



   
 Haas, John  
 [EMAIL PROTECTED] 
 omTo 
 Sent by:  u2-users@listserver.u2ug.org  
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   [U2] Universe Logins
 24/08/2006 16:09  
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




I am using the Windows Universe platform version 10.1.18.

I have a user that receives the message indicating that she is restricted
from
logging into the account, and the telnet session closes.

Other users login without any problem.   There is an entry in UV.LOGINS,
the
domain is set correctly and the path to the account is set correctly.  I
have
the user policy set to 'home directory' and the full path D:\dir\uvaccount
set
for the users.  There is no local login.

Are there any permissions that need to be set on the Windows directory?

Any thoughts on what I missed in the set-up of this user.

Thanks.




 |http://www.bakerlaw.com/ Web site   |



This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged,
confidential, or protected by law.  If you are not the intended
recipient you are hereby notified that any dissemination, copying
or distribution of this email or its contents is strictly prohibited.
If you have received this message in error, please notify us immediately
by replying to the message and deleting it from your computer.

Internet communications are not assured to be secure or clear of
inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. Therefore,
we do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result
of e-mail transmission.

---
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] Changing server IP address

2006-07-10 Thread Arnold Bosch
We had an issue with this on UV 8 on HP UX 9 a couple of years back...

Then, after an upgrade to UV 9 on the HP UX box, we didn't have the
problem, and after that we have successfully done a migration from the UV
9/HP UX to UV10 on Win2k using exactly this method - took me just a weekend
to transfer the UV data (a total of 43G 2 years ago) and make the new
server live.  Users only noticed that their reports ran quicker on the
Monday morning;-)

I'm not sure about UV's reaction on Solaris though.

Regards

Arnold Bosch



   
 [EMAIL PROTECTED] 
 igerinfotech.com  
 Sent by:   To 
 [EMAIL PROTECTED] u2-users@listserver.u2ug.org  
 stserver.u2ug.org  cc 
   
   Subject 
 10/07/2006 14:13  [U2] Changing server IP address 
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




We are currently upgrading to a new solaris server.  The plan was to go
live with the new server this week.  In order to minimise disruption, we
had planned to modify the IP address and hostname of the new server to
match the current production server (as well as changing the IP address
and hostname of the current production server to avoid a clash).  This
would have meant that no client terminal emulator settings would need
changing.

Will this be possible or will the UniVerse software complain because it
thinks it has been copied to a different server?  Are we better off
configuring the client PCs?

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
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] Universe / W2k Application Log messages

2006-07-03 Thread Arnold Bosch
Hi

We sometimes get the following warning messages appearing on our W2k
Server's Application log:
Event Type: Warning
Event Source: IBM UniVerse
Event Category:   None
Event ID:   1002
Date:   30/06/06
Time:   16:57:31
User:   N/A
Computer:   UVSERV
Description:
UniVerse warning: Unable to write to socket.. WSA error: 10054.
--
Event Type: Warning
Event Source: IBM UniVerse
Event Category:   None
Event ID:   1002
Date:   30/06/06
Time:   16:57:31
User:   N/A
Computer:   UVSERV
Description:
UniVerse warning: Unable to read from stdin.. WSA error: 10054.

Does anybody know what could be causing it, and/or what the implications
for our data might be?

We're running Universe 10.0.10D on Windows 2000 Server

Thanks!

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Tel +264 (0)61 293 2106
Cell +264 (0)81 124 8625
Fax +264 (0)61 293 2104
Email: [EMAIL PROTECTED]
Email Disclaimer: This email message is intended solely for the use of the
individual or entity to whom it is addressed and may contain confidential
information which may be privileged and protected by law. If you are not
the intended recipient, please notify us at our email address, delete this
message and do not disclose the contents of this email message to any other
person use it for any purpose or store or copy this email in any manner or
form. Opinions, conclusions and other information contained in this email
message that do not relate to our official business shall be understood as
neither given nor endorsed by us. We do not represent, warrant and/or
guarantee that the integrity of this communication has been maintained or
that this communication is free of errors, virus, interception or
interference.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Arnold Bosch is on leave.

2006-02-10 Thread Arnold Bosch
I will be out of the office starting  11/02/2006 and will not return until
06/03/2006.

For IT Related questions and problems, please contact Nicholas Preller -
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Best practices

2006-01-29 Thread Arnold Bosch
I have a question / concern regarding the D and I types:

If a D type is created (F1 below)  and an I type added to the dictionary
referencing this D type directly (PRODUCT below), what is the impact on
indexing?

For example, if an index is created on the D type, will UNIBASIC code using
the I type benefit from this index?
The reason I am asking this, is that we have a system with all the data
tables created with D types called F1, F2, F3 etc, and all the coding is
using the I types for data access.  The system has NO indexes created, and
even simple queries take ages to execute because of this...
I know from previous posts that it is not a good idea to create indexes on
fields that are TRANSed from other tables, but we can definitely benefit
from indexing on some of the more-used fields in our tables.  My problem is
on which fields to create these indexes

   Type 
Field. Field. Field Conversion.. Column. Output
Depth 
Name.. Number Definition... Code Heading Format
Assoc..
F1 D1Product Code20LS
PRODUCTI  F1 Product 20LS

Thanks  regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd
Email: [EMAIL PROTECTED]

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


Re: [U2] Running Universe on AMD processor

2006-01-04 Thread Arnold Bosch
We're running UV 10 on a quad Xeon box with Windows 2000 server - without
any problems at all.  Windows 2003 shouldn't be a problem either - I
originally tested our server with this, but fell back to W2k because we
implemented _just_ after W2k3 became available, and I didn't want our
enterprise system running on a new and possibly buggy (then) OS.

Regards

Arnold Bosch
Taeuber  Corssen SWA (Pty) Ltd



   
 Peter Wezenaar
 [EMAIL PROTECTED] 
 ne.netTo 
 Sent by:  u2-users@listserver.u2ug.org
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   [U2] Running Universe on AMD
 05/01/2006 01:11  processor   
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




Has anyone tried to running Universe on a Windows 2003 Server (32 bit) not
running on an Intel chip but a AMD Operton Chip, I don't see it as a option
on their platform matrix, hoping someone has tried this.

Alternatively has anyone tried running on Intel/Xeon chip.

Thanks

Peter Wezenaar
---
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] [UD] LOGTO question...

2005-12-14 Thread Arnold Bosch
You could try:

LOGTO C:\Progra~1\david\data\AccountOfStuff

Possibly the 8.3 notation for the directory will work - it's not ideal, and
you might have to confirm whether that is the actual 8.3 notation directory
for Program Files...

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd



   
 DAVID WOLVERTON 
 [EMAIL PROTECTED] 
 etTo 
 Sent by:  u2-users@listserver.u2ug.org  
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   [U2] [UD] LOGTO question... 
 15/12/2005 02:50  
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




How do I include a space in a LOGTO command? I've tried quoting.,
slashing... I must be missing something brutally simple...

It seems to always give a syntax error...

Exampl:?  Account is in the path:

C:\Program Files\david\data\AccountOfStuffas an example...

How do I log to this from the UniData DEMO account from the 'Colon' prompt?

While I know I should NOT do this, I need to do this at a site that is
running Windows...

TIA!!
DW
---
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] Off-topic? Problems with DigiPortServer - Win2003 server SP1 - Universe

2005-09-25 Thread Arnold Bosch
I once encountered a similar problem a couple of years ago at my previous
workplace.  The Digi controller card has two lines to which digis can be
connected on a daisy-chain RS422 interface.  Digis connected to the one
line did a similar thing; I eventually traced it to a faulty end-of-line
terminator - this might be an idea to check.

Also, if new electrical equipment was installed near digi lines, you could
try to drop the RS422 link speed (normally at 2 megabit) down a bit and see
if you have an improvement, especially if the RS422 link is fairly long.

This presumes that you are running digis as I know them, unless newer
models are ethernet-connected.

HTH

Regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd, Namibia



   
 Joe Walter  
 [EMAIL PROTECTED] 
 com   To 
 Sent by:  u2-users@listserver.u2ug.org  
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   RE: [U2] Off-topic? Problems with   
 25/09/2005 09:09  DigiPortServer - Win2003   server  
   SP1  - Universe
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




Thanks anthony.

All the digis are acting up - they are chained together. It does seem like
the
problem started around the time SP1 was installed, but they may very well
have
installed some other gear around the same time that they haven't mentioned
to me
yet.

I'll look into that - possible conflicts with IP addresses.

joe

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz
Sent: Friday, September 23, 2005 2:55 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Off-topic? Problems with DigiPortServer - Win2003 server
SP1
- Universe

How many digis do you have ?  Is it all of them that are acting up ?  If
you
only have one, then the possibility of a bad digi is not out of the
question.
Is something attached to the network recently that has the same ip as the
digi ?
Unplug the digi and then ping it by ip.

I have always found digi support to be pretty decent.  Is SP1 the last
'thing'
that was installed on the server ?  If so, maybe there is a compatibility
issue.
I would undo it (if that's possible and if you don't really need it for
anything
else).

If the digi is bad, you can find them on ebay now for very cheap.

It really doesn't sound like a Universe problem.

Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joe Walter
Sent: Friday, September 23, 2005 1:07 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Off-topic? Problems with DigiPortServer - Win2003 server
SP1 - Universe


We are baffled by a problem that just came up at a customer site. They are
running Universe on Win2003 server with SP1. Have had DigiPortServer's in
place
there seems like forever. The digi's where attached to an NT4 server which
we
decomissioned and went to new server running Win2003. Everything was just
fine
with all the dumb terminals for the first six or more months after
migrating to
Win2003 server with Universe 10.something.

Now, 'ports', dumb terminals attached to digi seem to 'hang' at random -
screen
freezes - any keystrokes have no effect - Ctrl-Q doesn't free them up (flow
control is xon/xoff). But, you can send a message to any of these hung
serial
ports via Universe MESSAGE command and it will appear on the hung terminal.

Anyone have any ideas about how to troubleshoot this problem?

universe support said it isn't a universe problem

digi support has been not much help. they suggested removing sp1 from the
win2003 server, although they have no other reported problems with
win2003 sp1 and their gear.

Any ideas?

Clueless in Cleveland.

Joe Walter
Fax/Voice mail: 1.435.514.5132

To the world you may be one person, but to one person you may be the world.
---
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

Re: [U2] Problems with uvrestore

2005-08-22 Thread Arnold Bosch
Hi Jay

You could try UVRESTORE -verify image name to allow uvrestore to verify
the image

In addition, check what blocksize was used on the original uvbackup image,
and specify the appropriate -b size uvrestore parameter

HTH

Regards

Arnold Bosch
IT Administrator
Taeuber  Corssen SWA (Pty) Ltd



   
 Jay Falck   
 unicorncomputing 
 [EMAIL PROTECTED]  To 
 ting.com u2-users@listserver.u2ug.org  
 Sent by:   cc 
 [EMAIL PROTECTED] 
 stserver.u2ug.org Subject 
   [U2] Problems with uvrestore
   
 22/08/2005 15:19  
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




I am trying to restore a backup from a UV 10 system running on AIX to a UV
10 system running on Windows. I can run the uvrestore -i command just fine
but when I try to run the actual restore I get the following error:



Unhandled exception raised at address 0x101F4198 : Access violation

Attempted to read from address 0x



Aborting UniVerse.



I am running 10.1.3 on Windows and the backup was done on a 10.1.something
on AIX.



Any ideas?



Thanks in advance,



Jay



Jay Falck, CISSP, CHSS

Unicorn Computing

512-563-4132
---
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/