Hidden Value – June 2003

 

Q: I've got our HP 3000 connected to the Internet and am trying to establish a VT connection with Reflection from home. I put in our IP address but get the following VT error:

 

VT error: 39; REMOTE NOT ACCEPTING SERVICE REQUESTS

 

What am I doing wrong?

 

A: Doug Werth replied:

 

This error means the HP 3000 is seeing the packets coming in but doesn't know how to route back. Your firewall (or router if you do have not firewall) is configured correctly to forward the packets to the HP 3000. But, now you need to configure the firewall/router as the HP's default gateway in NMMGR.

 

 

Q: I am trying to parse the output of showproc job=@ looking for a CPU problem. I am doing a str on a line from showproc as in

 

SETVAR SUBS,STR('!ID_REC',1,1)

 

This fails if there is a single quote ' in the variable ID_REC, as in

 

run fred;info=' data '

 

How can I work around this?

 

A: Jeff Woods and Jeff Vance replied:

 

If ID_REC is a CI variable (as opposed to a parameter/argument) try:

 

SETVAR SUBS,STR(ID_REC,1,1)

 

Anytime you explicitly reference a CI variable (!var) it's type is lost to the CI and it must be quoted to remain a string. The best solution is to not explicitly reference the variable, instead just use its name and no exclamation mark. This works for all CI commands that accept expressions (CALC, IF, ELSEIF, SETVAR, WHILE) and inside ![expr].

 

 

Q: My 957 has been humming along for quite some time now on MPE/iX 6.0 with little or no help from me. We dropped hardware and software maintenance on the system some while back as we continue to expect this system to be phased out "soon" and bucks are tight here.  Unfortunately, we've been running into some problems with our old 7980XC tape drives.  I think it's time to get rid of them (the last HP-IB stuff we've got). We've got some DLT4000 tape drives lying around and I'd like to connect one or two to the 957 and use them for database, incremental, and full backups. Can I simply hook a DLT4000 drive to the SE-SCSI port on the MFIO card, set its SCSI address, and add the device as an HPC1521B?

 

A: Gilles Schipper replied:

 

It should be no problem at all. The DLT4000 SE SCSI device can also be utilized as a boot device on the 957. You should use the device id of DLT4000 and not HPC1521B. One issue that you should consider though is the patch level of your OS. If your 6.0 system is not patched, there may be an issue with very long restore times for specified filesets. However, if you have 6.0 PowerPatch 1 or 2 installed, that should not be a problem. Otherwise, you should consider using the device ID of HPC1521B as a workaround to the restore problem. In any case, it would be best to use device ID DLT4000 and test to ensure good restore performance and only resort to device ID HPC1521B if the restore speed is NOT satisfactory.

 

 

Q: We currently use REPORT to track CPU usage for individual GROUPS. I have been asked if it's possible to track CPU usage for individual USERS. I know I can do it if I have them log into unique GROUPS, but that's not an option. I don't need to look in the past; this is for future usage.

 

A: Lars Appel and Gavin Scott replied:

 

If you have system logging for event 102 (Job Initiation) and 103 (job termination) turned on, it should be possible to extract the CPU information. The Job Initiation log identifies who people are and the Job Termination log includes CPU usage rounded to seconds. Of course you then need a program to scan the log files and accumulate this information, dealing with issues like logons that happen in one log file but the log off may be in a subsequent log file, etc. There are (were) commercial (and possibly contributed) tools to do this sort of thing.

[Editor's note: remember when these charge back systems were a big thing? I remember writing one 20 years ago.]

 

 

Q: Having found that FSPACE(fn ,-1) does a logical (key sequence) backup in CM KSAM, does anybody know if the links work the same way in NM KSAM?

 

A: Bill Cadier replied:

 

There technically are no links, it's a tree and when you go forwards or backwards the tree is searched. The key used is the one that last positioned the pointer. One small difference between CM and NM KSAM is that CM KSAM preserves the path table that was used to position the key where it is. So if someone deletes a record out from under a process then CM KSAM knows how it came to be pointing where it is and can logically reposition. NM ksam cannot save its path table across calls and so in that scenario you get an FSERR 170.

 

 

Q: How can I find out what is installed on my system?

 

A: Andreas Schmidt replied:

 

HPSWINFO.PUB.SYS shows the OS Level, patch level, and hp patches applied as long as standard patch routines have been used. No third party software is listed in HPSWINFO, however.

Robert Mills added that for third party tools you could try the 'System Inventory Utility (SIU)' written by Jeff Vance. It's available as a free download from Jazz (http://jazz.external.hp.com/src/scripts/siu/index.html)

John Burke noted that for HP software, xeq psirpt.pred.sys gives a complete listing of products/bundles.

 

 

Q: I am trying to ftp a ZIP file in the posix environment to AIX using an FTP get. I can successfully navigate to the correct group and see the file from AIX within FTP. When I try to do the get it fails with a NONEXISTENT GROUP (FSERR 51) error. The file name is of format filename.zip.

 

A: James Hofmeister replied:

 

When specifying the file on the 3000, you trigger the "posix file name" mode by specifying "./" (example: ./ntp.tar.Z) or by fully qualifying the file name in posix name space (examle: /tmp/ntp.tar.Z). So, if you are attempting a GET on the AIX connected to the HP3000 you would:

 

cd /tmp

get ./ntp.tar.Z

 

~or~

 

get /tmp/ntp.tar.Z

 

Lars Appel added:

 

With more recent versions of the MPE/iX ftp server, I believe, you can also switch it to "posix style mode" with SITE POSIX ON (and this might even be configured as default in the SETPARMS.ARPA.SYS file. See FTPDOC.ARPA.SYS for details).

 

 

Q: I am trying to set up a script that opens FTP and does an open, user, and password command then gives control over to the user. How can you send commands to FTP through CI script? As soon as it gets to the FTP prompt commands are not being sent.

 

A: Paul Christidis replied:

 

The FTP client on the 3K supports 'netrc'. In other words if a file named 'netrc' exists in the user's group (or a file equation pointing to the actual file) then FTP will login to the indicated host using the user name and password listed in the 'netrc' file.  If you have access to a Unix system then issue the command "man netrc" for additional information.

Friedrich Harasleben added, use the CI ECHO command redirecting I/O to a file to create a CI command file with everything you want; then feed this file to ftp as input.

 

 

Q: I am running FTP from a 3000, connecting to an NT box. I can traverse down the directory structure on the NT box without problem until I reach a directory with spaces in the directory name: e.g.,

 

/NTBox/FTP/Directory Number 1/

 

However I format my 'CD' command, it won't recognize directories with spaces in them. Is there a solution to this?

 

A: Jeff Kell replied:

 

You might try QUOT CWD Number 1. QUOT supposedly passes the argument directly to the server's parser.

 

 

Q: I have been using Adager to add datasets and new fields to an Image database that already exists. This database was created using a Powerhouse Qschema and QDD 20 odd years ago. I have the current Qschema but there has never been an Image definition file for it. How can I find out security information for this database?

 

A: Mike Church replied:

 

One quick way is by using DBUTIL.

 

SHOW database_name PASSWORDS or SHOW database_name ALL

 

John Burke added since you have Adager, you could just use the report schema command.

Finally, from Rene Woc, you can also user Adager's "security" function to obtain the database's passwords (classes), and individual data item and dataset security definitions.

 

 

Q: I'm checking on some TurboIMAGE security and I need a sanity check. If you intend to have two TurboIMAGE passwords in your database, one for READ and another for READ/WRITE, it appears you need to set each password for each field in a dataset in order for it to work. Is this correct?

 

A: Tom Emerson replied: No. You only need to set passwords at the field level if you want field-level restrictions (very tricky to maintain). Want you want to do is set the passwords for each DATASET.

 

 

Q: Does anyone have JINETD setup information for that includes the newlink commands, etc.?

 

A: Mark Bixby replied:

 

Creating INETDCNF.NET.SYS as the real config file and /etc/inetd.conf as the symlink is the documented way to do it:

 

http://docs.hp.com/mpeix/onlinedocs/32650-90906/00/00/10-con.html

 

In general, you want the files in @.NET.SYS to be real files and the "alias" names in /etc or /usr/adm to be symlinks.

 

 

Q: MPEX has a way to display symbolic links and target files (e.g. %listf /etc/@(islink),2). Is there any way to do this in "pure" MPE?

 

A: John Burke replied:

 

listfile /etc/@,7;seleq=[object=symlink]

 

 ********************

 FILE: /etc/bootpd

 

 

 SYMLINK TARGET: /SYS/NET/BOOTPD

 

... etc.

 

 

Q: For the sake of argument, if my HP 3000 (lets say Series 9x8) does not fail mechanically for next 25 years, will there be any obstacles that will force us to stop using the machine?

 

A: Christian Lheureux and Wirt Atmar replied:

 

The issue is with the Calendar intrinsic, which has a 7-bit field to encode year. The reference year is 1900. O a 7-bit field, you can encode from 0 to 127. So the latest year you can encode with Calendar is 1900 + 127 = 2027. January 1, 2028 is going to be a problem. The internal calendar will overflow at midnight, December 31, 2027; thus you won't get your full 25 years. Rather, you only have 24 years, 6 1/2 months left.