Re: [U2] Resurrecting a crashed session

2013-06-12 Thread Dan Goble
If you are using unix / linux as your OS then, use the tandem command to attach to the session. At the unix prompt as root type in tandem unidata_session_number Then the esc key F to enter and esc key X to exit HTH -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East

Re: [U2] Convert data from UniData to Microsoft SQl server

2013-05-15 Thread Dan Goble
space than the variable length data types. Another piece that will contribute to your size is the fact you will need to create cross-reference tables, where you can do multivalues in UniData. As a rough estimate we have seen a 2:1 ratio in the amount of disk space used. HTH -Dan Dan Goble

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Dan Goble
Tom, We use a tool called Kourier from Koretechologies that does a nice job. Very flexible and you can schedule the tasks to be done. -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile

Re: [U2] TCL input and response logging such as COMO

2013-04-24 Thread Dan Goble
In UniVerse in the SAVEDLIST directory a user's TCL statements are saved as $$userid:user# Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com

Re: [U2] is this an INDEX ISSUE?

2013-04-16 Thread Dan Goble
One other thing you may want to check. See if there are any multivalued or subvalues in the item ids. In unidata this has caused major headaches with indices. HTH -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office

Re: [U2] WRITESEQ Error

2013-04-11 Thread Dan Goble
More times than not it is a permissions problem with the user / file Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website

Re: [U2] Compressing PDFs

2013-03-28 Thread Dan Goble
I have not used p7zip, but HP-UX has a native zip command on it. The thing is PDFs are pretty well compressed so you may not gain much disk space back. HTH, -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office

Re: [U2] Apparent Data Problem

2013-03-21 Thread Dan Goble
To tell the version of UniVerse edit the VOC RELLEVEL and it will display the version on attribute2 To the file for corruption I would recommend running the unix command fixtool supplied by Rocket. fixtool -helpwill show you all the options and syntax Dan Goble | Senior Systems Engineer

Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly

2013-01-16 Thread Dan Goble
As another alternative I would see if syslogging is turned on. Look at /etc/syslog.conf . Check for any lines that do not have a # in front. These lines would be the paths to the logs. Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel

[U2] Wally Terhune

2012-12-13 Thread Dan Goble
Congratulations on your upcoming retirement. Thanks for all the support you have given us over the years for us Unidata guys. Your breadth of knowledge will surely be missed. Enjoy retirement, -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100

Re: [U2] Things you shouldn't do.....

2012-12-02 Thread Dan Goble
If you want to clear the PH record but retain the inode, at the Unix prompt put filename In Unix it nulls out the file but retains the inode. I use this method very often for clearing UniData, UniVerse and Unix logs. HTH Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804

Re: [U2] [UD] Pause When Executing Query

2012-11-13 Thread Dan Goble
We have been using Unidata 7.2.12 for about a year and have not come across that issue.My first question would be what OS are you using. We are using AIX 6.1. -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office

Re: [U2] [UD] Pause When Executing Query

2012-11-13 Thread Dan Goble
the PHANTOM_WAIT value to 0 so no delay will occur. Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail

Re: [U2] [UD] Determining number of users licensed

2012-09-12 Thread Dan Goble
You can use the PORT.STATUS command. It shows the number of user licenses and the number of sessions used Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go

Re: [U2] Etymology of Q-Pointer

2012-09-07 Thread Dan Goble
This comes from the PICK days where code had a 32k limit. I still code using it this way ( old habits are hard to break ) Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail

Re: [U2] Scrub HangUp Fixed

2012-09-01 Thread Dan Goble
I think we have beat this dead horse enough. Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail

Re: [U2] Running a command in a different account

2012-07-31 Thread Dan Goble
code. Hth -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted

Re: [U2] Redback port

2012-07-12 Thread Dan Goble
You would need to look in your rgwresp.ini file to see what it is set to. Path to the file is $RBHOME/rgw/conf Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go

Re: [U2] XML arrays

2012-03-01 Thread Dan Goble
This is a case where the programmer is getting the start and end tags, but data is missing in the middle.The vendor is saying that the data is an array in xml that is missing. Dan Goble | IT Senior Software Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ

[U2] XML arrays

2012-02-29 Thread Dan Goble
7.2.12 on AIX. Thanks, Dan Dan Goble | IT Senior Software Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files

Re: [U2] UniVerse Dynamic File Question

2012-01-30 Thread Dan Goble
Yes ... all files on a universe system have a 2 gig limit unless you are doing 64bit files. The advantage of the dynamic file would the the size of the dat file and the size of the over file . Thus in theory would have a 2 gig of each -Dan Dan Goble | IT Senior Software Engineer

Re: [U2] A Thursday Quandry...

2012-01-26 Thread Dan Goble
We have used the -D and -Z2 options when compiling and it lets us see the code from the included items when in the debugger. -Dan Dan Goble | IT Senior Software Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E

Re: [U2] A Thursday Quandry...

2012-01-26 Thread Dan Goble
You will want the -D option also. This creates the cross reference table for the debugger. Need to use the -Z2 and -D in combination. -Dan Dan Goble | IT Senior Software Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile

[U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem

2011-05-10 Thread Dan Goble
We have been dealing with performance issues with our system and it seems to be I/O bound when we look at the stats using nmon and topas. We have our SAN engineers looking at it from the backend to make sure that it is tuned well, plus IBM looking from an AIX point of view. One thing I was

Re: [U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem

2011-05-10 Thread Dan Goble
: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Tuesday, May 10, 2011 9:23 AM To: U2 Users List Subject: [U2] Unidata take advantage of DIO / AIO /CIO in JFS2 filesystem We have been dealing with performance issues with our system

Re: [U2] Fault type is 11. Layer type is BASIC run machine.

2011-01-18 Thread Dan Goble
It sounds like you are blowing the memory stack with such a large item. With type 19 files you will want to do WRITESEQ so that it writes each individual line out keeping your memory intact. -Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org

[U2] U2 Wrapper

2011-01-11 Thread Dan Goble
I am trying to put a wrapper around SAVE-LIST and GET-LIST so that I can keep track of how often a list is used so I determine whether or not to purge it. On Unidata 7.2.6 it totally ignores the BASIC program SAVE.LIST and SAVE-LIST. Any recommendations on how to get this to work. Note

Re: [U2] U2 Wrapper

2011-01-11 Thread Dan Goble
To: 'U2 Users List' Subject: Re: [U2] U2 Wrapper Have you created a voc entry ? - A voc entry will override a globally catalogued program. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: 11 January 2011 21:19 To: U2 Users

Re: [U2] Reading a Unix file from another machine.

2010-11-09 Thread Dan Goble
Try using at the unix command line String filename newfilenamer This will strip out all control characters - Original Message - From: Roy Beard [mailto:r...@cfl.rr.com] Sent: Tuesday, November 09, 2010 05:05 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: [U2] Reading a

Re: [U2] Reading a Unix file from another machine.

2010-11-09 Thread Dan Goble
. NO joy! # cd /dbms # ls -l master -rwxrwxrwx 1 root system 54683259 Nov 08 18:16 master # string master newmaster ksh: string: not found. # -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent

Re: [U2] How many will be selected?

2010-10-19 Thread Dan Goble
SYSTEM(11) in basic code will return the number of items selected -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 19, 2010 1:41 PM To: U2 Users List Subject: [U2] How many will

Re: [U2] CREATE.TRIGGER - Permission denied

2010-10-18 Thread Dan Goble
In order to create a trigger in Unidata the Unix user you are logged in as needs to own the file. -Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, October 18, 2010 12:07 PM To:

Re: [U2] CREATE.TRIGGER - Permission denied

2010-10-18 Thread Dan Goble
Unidata does not require you to be root. Just that the person creating the trigger owns the file. We use triggers here all the time and never become root to create or remove. The key is being the owner of the file. -Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] where did everyone go ?

2010-09-27 Thread Dan Goble
No ... It's the end of third quarter and upper management keeps everyone busy at quarter end in most companies. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, September 27, 2010 12:07 PM To:

Re: [U2] [UV] Shared Record Locks

2010-08-31 Thread Dan Goble
When you have data you want to update, but do not want to prevent people from viewing the rest of the data. I.E. Updating patient information for the next insurance enrollment period, and still letting customer service reps access the data to help customers. HTH -Dan - Original Message

Re: [U2] TCL command history

2010-08-20 Thread Dan Goble
If you are using Universe the TCL command history is stored in the SAVEDLISTS file. If you are using unidata they are stored in the users home directory in a file .ustk_loginid -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]

Re: [U2] Sending interrupt to UniBasic program

2010-08-10 Thread Dan Goble
Brad, On UniData we use the @USER.TYPE to determine if it is a phantom / background process or not. IF @USER.TYPE = 1 THEN INPUT ELSE ...Below is a snippet from the Unibasic manual. @USER.TYPE Returns the type of process currently running. UniBasic has three types of processes: 0 -

Re: [U2] HP-Ux, Samba, and Windows 7

2010-07-22 Thread Dan Goble
You will want to make sure the netbios options are turned on for the samba. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, July 22, 2010 10:21 AM To: U2 Users List Subject: [U2] HP-Ux,

Re: [U2] HP-Ux, Samba, and Windows 7

2010-07-22 Thread Dan Goble
the button or at the command line, it does not seem to work. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Thursday, July 22, 2010 10:24 AM To: U2 Users List Subject: Re: [U2] HP-Ux, Samba

Re: [U2] @LOGNAME on Unidata

2010-06-17 Thread Dan Goble
I have seen this in the past where the file wtmp usually found in /var/adm is corrupt or too big ( over 2 meg ). To correct this just type at the unix prompt wtmp And it will clear the file.I recommend doing this just before a reboot of the system. -Dan -Original Message-

Re: [U2] Filesystem options cio for AIX 5.3

2010-06-04 Thread Dan Goble
an interesting snippet on page 9: Large hdisks are evil for I/O performance! http://www.circle4.com/papers/PAI22.pdf Hope this helps Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Friday, 4

[U2] Filesystem options cio for AIX 5.3

2010-06-03 Thread Dan Goble
I am working with an AIX 5.3 system using Unidata 7.1.10 We are having some performance issues that are directly related to I/O. The files have been resized and brought down some of the I/O problems. In the past with some Oracle system I have had to administer ( I still prefer the mv world

Re: [U2] Can't RESIZE some files

2010-05-27 Thread Dan Goble
From the Unix command line you may want to check to see if there is an abandoned shared memory segment. To do this type in the following at the Unix command line: ipcs -mo The following will return (dummied data below for an example : IPC status from /dev/mem as of Thu May 27 08:37:25 EDT

Re: [U2] Question about umask

2010-05-20 Thread Dan Goble
When it comes to setting up umasks on a system I prefer to set the default in the /etc/profile so that all who login in get this as default. Then anybody else who needs a different umask set in their /home/username/.profile -Dan -Original Message- From:

Re: [U2] OPENSEQ and Abnormal termination of UV

2010-05-17 Thread Dan Goble
You may want to check with your Systems Administrator to be sure your file system is setup to support files larger than 2gig - Original Message - From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org

Re: [U2] Redback jrgw.dll for Win64 systems

2010-05-14 Thread Dan Goble
I have not used redback in windows before, but other 32bit dll issues I have had with windows I corrected by doing the following: %systemroot%\SysWoW64\regsvr32.exe file.dll This takes the dll and registers it in the system for you and lets windows know it is a 32bit and how to work with it.

Re: [U2] fnuxi problem

2010-05-13 Thread Dan Goble
In the past when I had done fnuxi I always used the following syntax: find . -name * -exec fnuxi {} \; This takes and tries to fnuxi all files in the current directory and below. If the file is not a U2 file it will not harm anything. -Dan -Original Message- From:

Re: [U2] [UV] Locked License Seat {unclassified}

2009-07-29 Thread Dan Goble
Microsoft has a tool called procexp.exe that shows a process and all its children processes attached to it. Using this tool you can kill the parent and the child processes. This should free up what you need to. Just be careful, it is a very powerful tool. Good luck, Dan Goble

Re: [U2] 2gig limit sticking into bash shell

2009-07-07 Thread Dan Goble
ulimit is a limit on system resources that can be set on a per user base. This command is on all versions of *nix that I know of. Depending on the operating system the values under the ulimit may differ. Dan Goble Sr. Programmer Analyst -Original Message- From: u2-users-boun

Re: [U2] 2gig limit sticking into bash shell

2009-07-06 Thread Dan Goble
You may want to check the ulimit for the user. Shell down to Unix and perform a ulimit -f this will tell you if there is a max file size set on this specific user. Dan Goble Sr. Programmer Analyst RATEX Business Solutions, Inc. -Original Message- From: u2-users-boun

RE: [U2] SELECT problem with quote characters

2008-08-06 Thread Dan Goble
Try the select like this SELECT FILE WITH FIELD LIKE ...LLOYD'S... Dan Goble Systems Administrator RATEX Business Solutions, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, August 06, 2008 11:18 AM To: u2-users

RE: [U2] gfe check from unix?

2008-07-31 Thread Dan Goble
Run the fixtool command from the $uvhome/bin without the fix option and it will do diagnostics fixtool -filepath Path_to_file -file name_of_file Dan Goble Systems Administrator RATEX Business Solutions, Inc. (800) 417-2839 ext. 4116 --- u2-users mailing list u2-users@listserver.u2ug.org

RE: [U2] execute code/proc question HELP!!!!!!!!

2008-05-22 Thread Dan Goble
Why not just catalog the original in EURO.BP for the end users, and do a RUN DOUG.BP DOUG when testing your changes. Dan Goble RATEX Business Solutions, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Thursday, May 22, 2008 9:21 AM

[U2] Good ssh service for Windows

2008-05-02 Thread Dan Goble
Does anybody know of SSH service for Windows that works well with UniVerse.Most of the ones I have tested either have bad terminal information translation, or do not have the ability to read the users' profile for destination directory. Thanks, Dan Goble Systems Administrator RATEX

RE: [U2] Good ssh service for Windows

2008-05-02 Thread Dan Goble
is much appreciated, Dan Goble Systems Administrator RATEX Business Solutions, Inc. (800) 417-2839 ext. 4116 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, May 02, 2008 10:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2