HP MPE/iX 7.x Operating System 40

Checking the Number of Processes For Each Listener

You can use the SHOWPROC command as an alternativ e to the ANSTAT command. To display the number of processes active in eac h listener job, use the SHO WPROC command with the TREE option. The INF O string used when the process w as created is displa yed after the process name. For example:

: showproc ;job=#j22;tree

QPRI		CPUTIME	STATE	JOBNUM		PIN	(PROGRAM) STEP
C152		0:01.985	WAIT	J22		36	:HPDALSTN '-l NS'
B149		0:02.934	WAIT	J22		65	(HPDALSTN.PUB.SYS) -l NSC
C152		0:00.099	WAIT	J22		37	(HPDADVR.PUB.SYS) 11000001,1,NS
:showproc; job=#j23
QPRI		CPUTIME	STATE	JOBNUM		PIN	(PROGRAM) STEP
C152		0:02.076	WAIT	J23		68	:HPDALSTN '-l ARPA'
B149		0:02.666	WAIT	J23		54	(HPDALSTN.PUB.SYS) -l ARPA
C152		0:00.106	WAIT	J23		40	(HPDADVR.PUB.SYS) 11000001,1,ARPA
:

A user without the appropriate privilege (SM or OP) will get the following error when a showproc is attempted:

:showproc; job=#j22;tree

Cannot access job #J22. (CIERR 11002)

:

Checking the Listener Log File

To check the listener log le, HPD ANSLG (for NS) or HPD AARLG (for ARPA), use the PRINT command. This can be done when the listener is not running or if the listener w as started with the DEBUG option. F or example:

:PRINT HPDANSLG.PUB.SYS

The listener log le sho ws the date and time when the listener w as started or restarted. It then shows the client node name of the user that has been successfully connected b y the listener and the clien t version. The clien t version indicates whether the clien t is on an MPE/iX system (-) or on an HP-UX (*) system. If the connection w as made with a clien t running a version of ALLBASE/NET that is earlier than A.30.00 (MPE/iX) or A.08.00 (HP-UX), the ALLBASE/NET v ersion number is shown. Listener error codes are also sho wn. Refer to the ALLBASE/SQL Message Manual for descriptions of listener error codes.

The listener log le is a circular le that holds 1000 en tries. The last en try in the le is the most recent.

Here is an example of a t ypical listener log le:

MON, JUL 30, 1993. 9:01 AM: ***** ALLBASE / NET LISTENER *****

MON, JUL 30, 1993. 9:01 AM: - ALLBASE/NET LISTENER FOR ARPA IS ALREADY ACTIVE.

2-12 Setting Up ALLBASE/NET

Contents

900 Series HP 3000 Computer Systems Hewlett-PackardCompany 3000 Hanover Street Palo Alto, CA 94304 U.S.A Printing History ALLBASE/SQL Manuals Additional Resources Preface What's New in this Release Page Page Page Page Page Page Page Conventions Conventions (continued) Contents Page Figures Tables Getting Started How ALLBASE/NET Works ALLBASE/NET Configurations Hardware and Software Requirements The NETUtil Utility The Listener Cross-SystemConnectivity Page Native Language Support Gathering Your Data Page Setting Up ALLBASE/NET Using NETUtil to Migrate Profiles Before Installing HP-UX10.0 Migration Log File After migration is successfully , you can delete the follo wing temporary les: DAALFMBK.PUB.SYS TMPALMBK.PUB.SYS DAUSFMBK.PUB.SYS Server List File Here is a sample serv er list le Using NETUtil Setting Up ALLBASE/NET on the Client Page Page Page Setting Up ALLBASE/NET on the Serv er Network Interfac e is one of either ARPA, NS or NETWARE. This indicates whic h access indicates that the spool le for the listener job should not be deleted automatically and that the log le is alwa ys readable Here are some examples of stopping the listener Stop the listener for the ARP A interface Stop the listener for the NS interfac e Stop the listener for NetWar e Alternatively, you c an use the following NETW ARE command Check the status of the listener for the NS interfac e Check the status of the listener for NetWar e If the given listener is curr ently running, the following message is returned Alternatively, you can use the NWSTAT command Check the status of all listners at onc e Page Assigning a Server Login The session name is optional If you are setting up ALLBASE/NET on an MPE/iX serv er but the user is on an HP-UXclient, refer to \Cross-SystemConnectivity" in the \Getting Started" chapter Adding a User Profile 2.Type ADD USERat the NETUtil prompt 3.Respond to eac h prompt as follo ws: Enter the name of the clien t node where the user is located. The clien t node name is not case-sensitive Page Page Checking the Services File on the Server Examples of Setting Up ALLBASE/NET 3.Type show aliasto check the alias prole in the AliasDB le: 1.Invoke NETUtil: The ADD USER command creates the NETUsers le and adds a user prole to it 3. Type show userto check the user prole in the NETUsers le: Using ALLBASE/SQL Through ALLBASE/NET Using ALLBASE/ISQL Using the Preprocessor Running an Application Program Authorizations Using ALLBASE/Query Using ALLBASE/4GL Using Information Access SQL/XL Using PC-basedApplication Softw are Conditions for Connecting to a Remote DBEnvironment Page NETUtil Reference Command Summary ADD ALIAS is the node name of the serv er you want to access. The serv er node name is not case-sensitive and is stored and displa yed exactly as it was entered. However, \node" is the same as \NODE" when the SQL application is running and executes a CONNECT or ST ART DBE command with an alias name. The name format is based on the ADD USER The client login name is stored and displa yed exactly as it w as entered CHANGE ALIAS is the fully qualied lename of the DBEn vironment on the MPE/iX system on whic h the DBEnvironment resides The MPE/iX DBEnvironment name cannot exceed 26 c haracters in length and is not case-sensitive The HP-UXDBEnvironment name cannot exceed 128 c haracters in CHANGE USER Examples to be changed to DELETE ALIAS In this example, all alias proles for a specic node are deleted DELETE USER Page EXIT HELP Press 4Return5 to continue Page MIGRATE ALIAS Page Page Page MIGRATE ALIAS BACKWARD MIGRATE USER Page MIGRATE USER BACKWARD QUIT SET ECHO SHOW ALIAS Page SHOW USER In this example, all the user names are sho wn for a particular node In this example, all proles in the NETUsers le are sho wn SYSTEM ALLBASE/NET File Names The following les are created b y the migration commands: Glossary Page Page Index