Q: How is the maximum number of jobs or sessions set by the LIMIT command related to the user license limit?

A: Duane Percox replied:

The maximum value you can use in the LIMIT command for number of jobs and number of sessions is set in SYSGEN-->MISC. It has no direct relationship to the user license. In fact, not only can you set, for example, the limit on sessions to a value greater than the user license limit, under some circumstances you need to do just that. If you use RPM to create sessions, these will show up in SHOWJOB under sessions and be subject to the value set by the LIMIT command but do not count against the user license. Think of the job and session limits set by the LIMIT command as examples of resource management.

Q: How can I give some Super Users access to spooler commands without giving them OP or SM capability?

A: Tom Brandt replied:

ALLOW User.Account;commands=<command> allows User.Account to use the specified command, but only if User.Account is logged on when the ALLOW is issued. Once the user logs off, the permission evaporates. ALLOW @.@ grants permission to all users whether they are logged on or not.

Q: [Editor's note: the following was not in the form of a question, but rather a tip from Duane Percox.]

Its common knowledge that you can specify the NM libary (XL) for a NM executable by either linking/altprog an XL list or by specifying it at run time with the ';xl=' parameter. This allows you to use a specific named XL instead of the acct/group XL feature (;lib=).

What isn't common knowledge is that the file names in the ';xl=' list can be formal names preceded with an '*'. File equations can then be used to direct the loader to the specific library (XL) you wish.

For example, you can specify ;xl="*mylib" at link time and resolve the libary at run time by issuing a file equation: FILE MYLIB=...

This is a handy way to introduce different libraries for testing purposes when the application system doesn't allow you to easily overide the ;xl= at run time.

Also, if you specify multiple formal names like this: xl="*liba,*libb,*libc" then you can make allowances for multiple libraries even though you currently only have one (1). If the library is not needed (or available) you just file equate to $NULL.

Q: I noticed there is a parallel port on one of my cards in my HP e3000. How do I configure it to work?

A: Steve Dirickson replied:

You can't. If you try to configure it into SYSGEN you'll get an LLIO error (6, I vaguely recall) during startup. Which doesn't cause any problems; it's just an indication that the system can't find anything to talk to the configured device. For no obvious reason, HP e3000 no speak parallel.

Q: I will be doing a system INSTALL replacing all disk drives. The system has three user volumes. The system will be backed up using the following store command:

STORE /SYS/, / - /SYS/;*DDS;DIRECTORY;ONVS=MPEXL_SYSTEM_VOLUME_SET,APPL1,APPL2,APPL3

If I restore

RESTORE *T;@.@.@-log####.pub.sys;directory;olddate;keep;show=offline

will all of the user volume directory information be restored as well? Is it necessary to do a restore of only directory first?

A: Gilles Schipper replied:

Your command should work, but I would restore the directory first and separately, as in:

:restore *t;;directory;show

Then, check it out using

:REPORT n.@;onvs=APPLn

I would also add ";create;partialdb" to your restore command and use the Posix syntax to ensure all your posix structures get restored. So, the second restore should look as follows:

RESTORE *T;/ - /SYS/PUB/LOG####;olddate;keep;show=offline;create;partialdb

Now, all of this assumes that you will have first re-created your user volume environment using VOLUTIL and the appropriate NEWSET and NEWVOL commands therein.

Q: [Editor's note: this has been answered several times before, but it keeps getting asked...] Please let me know how I can reset my spoolfile numbers. Right now I am on o1066970. Can I start it from 1 without rebooting the System?

A: Ron Horner replied:

The MPE setcounter command will do the job. Just set your limit to the desired value and the system does the rest. In your case enter the following:

setcounter counter=outsp;max=<desired max spool number>;base=1

Q: Does anyone know how to reset the internal support modem without rebooting?

A: Gilles Schipper replied:

You can do it with SYSDIAG, but the module within sydiag, CONSOLAN, requires a suplicense code to run. Assuming you have it, the command required is:

consolan pdev=56/56 section=16

(Your pdev number varies according to your model of HP3000. 56/56 would apply to 9x8 models. I believe the appropriate 9x9 pdev is 10/4/0)

[Editor's note: if you have a hardware support agreement, you can get the suplicense code online at http://us-support.external.hp.com/]

Q: We have a database that has a field that is stored as a J2. In the Query manual J2 is described as an integer value but it doesn't explain how it is stored in the database. Is a J2 item packed, asciii, or something else?

A: Wirt Atmar replied:

A J2 data item is identical in format to an I2 integer, the only difference is that the range is limited to an "even" decimal series (the largest power of 10 that will fit under 2**31). However, IMAGE doesn't enforce that rule. In fact, IMAGE enforces virtually no rules at all about how data is stored in the database. It's essentially up to the application to enforce any language (COBOL for example)-specified artificial range restriction.

Q: If I have used the newlink command and at a later date I want to verify that I did the command, how can I see it? I tried showlink and that does not seem to exist.

A: Donna Garverick replied:

listfile fileset;seleq=[object=symlink] to list symbolic links.

Harry Morris added, if you want to see the target of the link, use

listfile linkname,7

Editor's note: Here's an example,

:Listfile @.pub.sys,2;seleq=[object=symlink]

ACCOUNT= SYS GROUP= PUB

FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----

SIZE TYP EOF LIMIT R/B SECTORS #X MX

TSTORE 1B BAL 14 1024 1 16 1 *

:listfile tstore.pub.sys,7

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

FILE: TSTORE.PUB.SYS

SYMLINK TARGET: /SYS/PUB/STORE

Q: What does this mean and how can I correct it?

TURBOIMAGE RESULT AT $0168a654; RETURN STATUS = 42
DBUPDATE, MODE 1, ON LINE-CONTENT OF ??????????????
DBUPDATE WILL NOT ALTER A READ-ONLY DATA ITEM

A: Dennis Heidner replied:

The password used to open up the database does not give you write access to all fields. Your program has used DBGET to retrieve a record, then modify an item (for which the password says you can view), and then DBUPDATE was called to update the entry (perhaps with @; as the item list).

Correct the problem by:

1. Using different password OR
2. Fix program logic not to modify the read only field in the programs copy of the data OR
3. Change program to use a list of only the fields that truly need to be updated.

Q: We use mirrored disks for our non-system data. Last night I had the first hiccup since they were installed. One of the disks went into a "disabled" state. I put in a hardware call and began reading the User's Guide. It instructed me to do a REPLACEMIRRVOL and call a CE if the problem persisted. It worked. At least for now. Does anyone know what would cause a mirrored disk to flip to a disabled state?

A: Chris Bartram replied:

It's been my experience that Mirror/iX is very aggressive in flagging discs "bad" (and un-mirroring them). Since all our drives are under contract (and we keep a hot spare on site) when it drops one, we pull it and swap it, then have HP come out and replace our spare (don't like to take chances with them). [Note: all our mirrored drives are in hot-swappable Jamaica enclosures.]

The few times we have just enabled the drives back, we usually found that it would get dropped again later.

We did have one continuing episode of drives being dropped off frequently that turned out to be because the original engineer that installed several of our discs had put several instances of both discs (of a pair) on the same controller. Under heavy loads the controller got overloaded and would drop one of the mirrored discs.

Also beware running sysinfo as it is also known to interfere with mirroring and can cause drives to drop off.

Bob Johnson added:

Timing problems arise on busy systems with Mirror/iX if interrupts are allowed to delay writes between the mirrored drives. Placing the pairs on adjacent interfaces greatly reduces dropping good discs.

Q: Is there a way to get the MAC (hardware) address of the NIC in a PC running an emulator connected (NS/VT or telnet) to a HP e3000 from the HP e3000 side?

A: [Editor's note: many people replied, but I'm going to use my editor's prerogative and use my answer]

If the PC is on the same subnet as the HP e3000, then the program "nettool.net.sys" will show you the MAC address. That is, assuming it has had any communication with the 3000 (a ping is sufficient to put the value in the table). nettool.net.sys "name;map;map;quit" will list a table of IP addresses and MAC addresses. If the PC is on the same subnet, then the MAC address is that of the PC. If the PC is not on the same subnet, then the MAC address is that of the router.

I do not know of any way to find the MAC address of a PC on another subnet.

Q: Can anyone refresh my memory as to the name and location of a utility that would build scripts to restore your IMAGE/SQL configuration after a detach?

A: Denys Beauchemin replied:

The utility name is called DBTune/SQL (DBTSQL) and you can download it free from our web page.

www.hicomp.com/hp3000.htm

or directly at

www.hicomp.com/dbtune.htm

JAZZ also has a link to the above.

Q: We have a system failure each day when a "cleanup" job hits a certain spoolfile. fscheck dutifully indicates corruption in the file label, and the ";FIX" option seems to have no effect. And, yes, purging the file via fscheck also crashes the system. Any ideas?

A: Goetz Neumann replied:

If you are on RC support, a knowing engineer can dial-in and mark the file label(s) as unused/free and then run FSCHECK to delete the relating directory entry. Another reboot and all should be OK. The disadvantage of this method is that you will 'lose' the disc space that the extents of this file used. How bad that is compared to rebuilding a volume set depends on your own judgement.

Q: If I have NS/3000 on two systems, can I print a spool file created on one system to a printer connected to another HP e3000?

A: Lars Appel replied:

:dsline other3k
:remote hello user.acct
:file remprt;dev=other3k#lp
:print whatever,*remprt
:remote bye
:dsline ;close