Hidden Value – January 2004

 

Q: I was running QTP accessing a database. For some reason the program froze. I cannot break it. I've tried aborting (job and IO) and switching priority queue, but it is still stuck.

 

%showproc pin=26

QPRI  CPUTIME   STATE  JOBNUM  PIN  (PROGRAM) STEP

 

                      #s3, rb0023,mgr.virgin,temp (ldev 3)

B100  0:16.803  MSG    S3      26   (QTP.PH839C.COGNOS) auto=paxxx.prog

 

What could be happening?

 

A: Reid Baxter and Brian Donaldson replied:

 

It looks like the program is hung either reading an empty message file or writing to a full message file. [Editor's note: It turns out Netbase was enabled but not being used and the message file buffer was full.]

 

 

Q: Is there a way to see the IP address associated with a particular login?

 

A: Matthew Perdue replied:

 

Any user with SM can do the following, for example:

 

:SHOWVAR HPSTDIN_NETWORK_ADDR;JOB=#S495

HPSTDIN_NETWORK_ADDR = 172.16.0.30

 

Glenn Mitchell and David Lukenbill added:

 

:listf ci.pub.sys,8 will list all sessions and will show their associated IP address.

 

 

Q: Recently, we've starting seeing these messages on the system console. They do not seem to affect anything, but it worries me. What can be causing this?

 

A: Guy Paul replied:

 

nettool.net.sys 'res;dis;q' will most likely have a frown :-( next to one of your Outbnd Buf Pool meaning you have hit your High Water mark. Because it is referring to UDP I would suspect your DNS lookups are failing. Increase your outbound buffers in NETXPORT.NI.niname

 

James Hofmeister added:

 

In this case of the outbound buffer pool full and the UDP messages, increasing the size of the pool would be treating a symptom. Does this system have the current GR patches installed?

 

NSTHD06 for C.75.00

NSTHD01 for C.70.00

NSTHD00 for C.65.00

 

UDP was reworked in MPE/iX 6.5 and 7.x. To see if you have the current UDP fixes perform a ":nmmaint,3" and look for UDP versions:

 

6.5: NL procedure:    NET_UDP_VERS                Version:  B06050B5

 

7.0: NL procedure:    NET_UDP_VERS                Version:  B07000A8

 

7.5: NL procedure:    NET_UDP_VERS                Version:  B07050A0

 

If your versions are less than these, then I recommend you install the General Release patches.

 

 

Q: I have been told that chkptstat can be a cause/reason for system hesitation. While checking my system it is disabled but I have never changed this so 2 questions.

 

1) What does chkptstat do?

2) Why is the default set to disable vs enable?

 

I am on 7.0 pp1 with patches and this is a 928LX.

 

A: Craig Lalley replied:

 

Chkptstat, more correctly "Enhanced chkptstat" was a way of reducing XM overhead in MPE/iX 6.0 when dealing with large files, however it does not work with Jumbo files (> 4GB). It does nothing on 6.5 and up, it is only there for compatibility.

 

 

Q: Why am I getting this error?

 

isql=> connect to 'mursdbe';

isql=> grant connect to mgr@mbfoster;

DDL commands disabled.  (DBERR 2765)

isql=>

 

A: Michael Berkowitz replied:

 

STOP the DBEnvironment, use the SQLUtil ALTDBE command to set the DDL Enabled flag to YES, then START the DBEnvironment and proceed with data definition.

 

 

Q: I am removing a DTC 48. Is reboot required or can this be done dynamically?

 

A: Michael Berkowitz and Ron Horner replied:

 

Dynamically. However, be sure to stop the spooler on any configured printers first before you enter NMMGR. Then make your changes, validate and answer yes to do the change dynamically.

 

 

Q: I seem to be running into a problem with the CI buffer. What is the limit?

 

A: Jeff Vance replied:

 

The MPE CI's input buffer is 512 bytes, however since it appends a cr to the end of line there are 511 bytes to hold user input. CI string variable can be up to 1024 bytes in length.  There is a 255-byte limit in portions of the CI that still are in compatibility mode (CM). The MYCOMMAND intrinsic restricts parameter values to be <= 255 characters, and MYCOMMAND is still called by several CI commands.

 

 

Q: Is there away for us to get a hardware map using the STM? Not the map that uses the configuration, but a map that performs like MAPPER out of ODE. I do not want to have to reboot just to get a hardware map, but I have not been able to find a way to do this. Does anyone know of a way?

 

A: John Clogg replied:

 

The map that you get when you enter the MAP command is constructed by a hardware scan, not from the system configuration. The reason it displays so rapidly is because the map is built when the STM daemons are first launched. To re-scan the system and refresh the map, use the REMAPSYSTEM command (can be abbreviated 'RS'). CSTM will tell you how long it is expected to take and request confirmation. Once you confirm the request, the re-mapping function begins.  After it completes, the map command will display the new map. If you want to know when the re-mapping operation is complete, you can type WAIT at the prompt and CSTM will suspend until the map completes. You will get another prompt when it is complete.

 

 

Q: I would like to define a string using the -D option when compiling C (on mpe) where the string contains spaces. But it appears that the parsing used by CCXL stops on spaces even when inside quotes. Is there any way around this?

 

A: Walter Murray replied:

 

When parsing the options string, the compiler treats a space as a delimiter, even when the space is in a string literal. You can fake it out by using an escape sequence instead of the space. In general, I'd recommend a three-digit octal escape sequence, to guarantee that the following character can't be interpreted as part of the escape sequence. This seems to work fine for your example:

 

     CCXL C5C,,,'-DVSTR=""OK\040sam""'

 

 

Q: A client of mine is running an HP 3000 922LX with an HP 2345A DTC. The DTC is connected to about a dozen HP dumb terminals with DB-25 male connectors. I have not assessed the OS situation on the 922LX. Can I dump the HP dumb terminals and emulate them on Windows XP with Hyperterminal or some other application? If this is possible I'm guessing I would just use the equivalent pin-out for a DB-9 female and connect to a standard PC serial port.

 

A: Mark Underhil replied:

 

Yes you can dump the dumb terminals and replace them with a terminal emulator. HP Terminals aren't so dumb so Hyperterminal most probably won't hack it. There are a number of HP terminal emulators available ranging in price from free to lots. The main players are, in no special order:

 

    www.wrq.com/products/reflection

    www.screenjet.com (follow the link for terminal emulation)

    http://aics-research.com/qcterm

    www.minisoft.com

 

You can continue connecting to the 922LX via a serial connection to the DTC. If you are running a LAN you can put the 922LX on the LAN and connect to it that way.

 

 

Q: What is the easiest way to install a laser network printer on a remote network?

 

A: John Pitman replied:

 

The only necessary things are that the printer is reachable over the network, and it is PCL capable. We have 3000s in Oz, Houston, and China, coupled by VPN, and anybody in any site can print on a printer in any other site that is configured on their local system. PCs on the local network can use them to if configured.

 

 

Q: Can we do a store to the disk (STD) without any additional software purchase?

 

A: John Clogg and Christian Lheureux replied:

 

STD on FOS has been made available with a patch for 6.5 (sure) and 6.0 (perhaps). It's in FOS in 7.5. I think 7.0 needs a patch too, but am not sure. Don't count on it if you're not at least on 6.0.

 

 

Q: I want to upgrade my tape drives from a DDS-3 to either a DLT8000, or an LTO drive. I know about the DLT drive, but can anyone tell me if the LTO can work on the 3000, and what are the pros and cons of it.

 

A: Denys Beauchemin replied:

 

Yes, you can have an LTO Ultrium drive on an HP 3000. It must be a PCI-architecture machine (A or N-class) and must be running 7.5 with a patch. I am not sure of the patch name, but that can be easily found. The pros are simple. Given a proper machine (uncrippled N-class) and the appropriate backup software, you can really get some speed on the backup. The benefit is the amount of data that will fit on an LTO Ultrium tape. The LTO Ultrium tape holds 100GB native, and add compression for better capacity. The LTO-2 doubles that compression. I do not know if LTO-2 is supported on the 3000, I would guess that it should be if LTO is supported, but I would get that verified. The cons?  Cost for one. The other is the fact you have so much data on one tape. If you lose the tape or it's bad, you can have some issues. The main issue you will face in using LTO is being able to feed the tape fast enough. The MPE machines are slow, unless you have the uncrippled N-4000, preferably multiprocessor, with some fast disk drives. Even if you could connect the LTO drive to non-PCI systems (bypassing the problem of connecting LVD devices to HVD HBAs, which can be done with more hardware) they are far too slow to properly use an LTO. DLT is the best you can do.