[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

PeopleSoft/Sqr/Unix/Process Sceduler

Subject: PeopleSoft/Sqr/Unix/Process Sceduler
From: Philip Latone <platone@MCC.MIRACOSTA.CC.CA.US>
Date: Thu, 18 May 2000 09:30:18 -0700

When I try to run a Cross Reference Window Listing (or any other SQR
Report) on the server and a printer output destination of lj925, the report
ends up in $PS_HOME/bin under the name lj925.

Question: How do you print a server side SQR from unix using Process
Scheduler without logging in to unix and issuing a lp command?

HPUX 11.0
Oracle 8.0.6
PSFT SA 7.6
Ptools 7.58

Here is a list of valid Unix printers:
#lpstat -t
scheduler is running
system default destination: lj925
device for lj925: /dev/null
device for lj970: /dev/null
device for lj950: /dev/null
device for lj900: /dev/null
device for ljlrc: /dev/null

Config File:
#cat psprcs.cfg
[Startup]
;=========================================================================
; Database Signon settings
;=========================================================================
DBName=HEDEV
DBType=ORACLE
OprId=PRCS
OprPswd=
ConnectId=
ConnectPswd=
ServerName=

[Database Options]
;=========================================================================
; Database-specific configuration options
;=========================================================================
; Please see Chapter "Tuning and Administration", in
; Sybase Installation and Administration Guide for details.
SybasePacketSize=512
; Please see Chapter "Tuning and Administration", in
; Oracle Installation and Administration Guide for details
UseLocalOracleDB=0


[Trace]
;=========================================================================
; SQL Trace flags
;=========================================================================

;-------------------------------------------------------------------------
; SQL Tracing Bitfield
;
; Bit       Type of tracing
; ---       ---------------
; 1         - SQL statements
; 2         - SQL statement variables
; 4         - SQL connect, disconnect, commit and rollback
; 8         - Row Fetch (indicates that it occurred, not data)
; 16        - All other API calls except ssb
; 32        - Set Select Buffers (identifies the attributes of columns
;             to be selected).
; 64        - Database API specific calls
; 128       - COBOL statement timings
; 256       - Sybase Bind information
; 512       - Sybase Fetch information
TraceSQL=0

[Process Scheduler]
;=========================================================================
; General settings for the Process Scheduler
;=========================================================================
LogFence=0
ProgramName=PSRUN_HEDEV PTPUPRCS
PrcsServerName=PSUNX
PSSQR1=%PS_HOME%/sqr
PSSQR2=
PSSQR3=
PSSQR4=
PSSQRFLAGS=-i%PSSQR1%/,%PSSQR2%/,%PSSQR3%/,%PSSQR4%/
-m%PSSQR1%/allmaxes.max -ZI
F%PSSQR1%/pssqr.unx
Log Directory=%PS_SERVDIR%/logs
OutputDirectory=%PS_SERVDIR%/output/

pshe@iceman : /home/pshe/he758/appserv/prcs/HEDEV
#


Starting Process Scheduler with PID 2475
The PID can be found in /home/pshe/he758/appserv/prcs/HEDEV/logs/PSPT_PSUNX.pid
Use ps -fp `cat /home/pshe/he758/appserv/prcs/HEDEV/logs/PSPT_PSUNX.pid`
to check if the server process is still running.

Current Environment is:
_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparray/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/audio/share/man:/opt/blinklink/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/imake/man:/opt/pred/share/man/%L:/opt/pred/share/man:/opt/hpnp//man
PS_SERVER_CFG=/home/pshe/he758/appserv/prcs/HEDEV/psprcs.cfg
SHLIB_PATH=/opt/cobol/cobdir/coblib:/home/pshe/he758/bin:/home/tuxedo/6.5/lib:/home/oracle/product/8.0.6/lib
PATH=/home/pshe:/opt/cobol/bin:/opt/bin:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/hparray/bin:/opt/langtools/bin:/opt/imake/bin:/opt/pred/bin:/opt/hpnp//bin:/opt/ignite/bin:/usr/bin:/bin:/home/oracle/product/8.0.6/bin:/opt/cobol/cobdir/bin:/home/sqr/4.3.4/ora/bin:/home/pshe/he758/bin:/home/tuxedo/6.5/bin
SQRDIR=/home/sqr/4.3.4/ora/bin
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
PS_DB=ORA
TUXCONFIG=/home/pshe/he758/appserv/HEDEV/PSTUXCFG
TUXDIR=/home/tuxedo/6.5
path=/home/pshe/he758/bin;/home/pshe:/opt/cobol/bin:/opt/bin:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/hparray/bin:/opt/langtools/bin:/opt/imake/bin:/opt/pred/bin:/opt/hpnp//bin:/opt/ignite/bin:/usr/bin:/bin:/home/oracle/product/8.0.6/bin:/opt/cobol/cobdir/bin:/home/sqr/4.3.4/ora/bin:/home/pshe/he758/bin:/home/tuxedo/6.5/bin
EDITOR=vi
HISTFILE=/home/pshe/.sh_history
COBPATH=/home/pshe/he758/cblbin
LOGNAME=pshe
LIBPATH=/opt/cobol/cobdir/coblib:/home/pshe/he758/bin:/home/tuxedo/6.5/lib:/home/oracle/product/8.0.6/lib
pidfile=/home/pshe/he758/appserv/prcs/HEDEV/logs/PSPT_PSUNX.pid
COBDIR=/opt/cobol/cobdir
ERASE=^H
ORACLE_SID=HEDMO
PS1=
pshe@iceman : $PWD
#
action=-start
PSSQR1=/home/pshe/he758/sqr
PSSQR3=
PSSQR2=
PSSQR4=
PS_PLT=HPUX_11_00
PS_HOME=/home/pshe/he758
PS_TUXDEV=/dev/null
HISTSIZE=256
SQRFLAGS=-i/home/pshe/he758/sqr/,/,/,/ -m/home/pshe/he758/sqr/allmaxes.max 
-ZIF/home/pshe/he758/sqr/pssqr.unx
HOME=/home/pshe
outlog=/home/pshe/he758/appserv/prcs/HEDEV/logs/PSPT_PSUNX.stdout
LD_LIBRARY_PATH=/opt/cobol/cobdir/coblib:/home/pshe/he758/bin:/home/tuxedo/6.5/lib:/home/oracle/product/8.0.6/lib
ORACLE_HOME=/home/oracle/product/8.0.6
PS_MACH=//iceman
PWD=/home/pshe/he758/bin
PS_SERVDIR=/home/pshe/he758/appserv/prcs/HEDEV
TZ=PST8PDT
PS_DBVER=8.0
PeopleTools 7.58 Process Scheduler
Copyright (c) 1988-1999 PeopleSoft, Inc.
All Rights Reserved

DB Type:[SQLBASE | ORACLE | INFORMIX | DB2 |
         DB2ODBC | DB2400 | DB2UNIX | SYBASE |
         MICROSFT]:ORACLE


Database:[HEDEV   ]:HEDEV


Username:[PRCS    ]:PRCS


Password:[********]:

Prcs Server [        ]:   PSUNX


Process Instance:[0]:


SQL Trace:[0]:

[05/18/00 05:02:20](0) ******************************************
[05/18/00 05:02:20](0) ******************************************
[05/18/00 05:02:20](0) ******************************************
[05/18/00 05:02:20](0) ******************************************
[05/18/00 05:02:20](0) ***
[05/18/00 05:02:20](0) *** Log messages will be written to 
PTPUPRCS_PSUNX_0518.log
[05/18/00 05:02:20](0) ***
[05/18/00 05:02:20](0) ******************************************
[05/18/00 05:02:20](0) ******************************************
[05/18/00 05:02:20](0) ******************************************
[05/18/00 05:02:20](0) ******************************************
2000-05-18 05.02.20 Server Initialization...

Prev by Date: Re: SQR Batching Software
Next by Date: Re: Hiding the password
Previous by thread: Re: SQR Batching Software
Next by thread: Re: PeopleSoft/Sqr/Unix/Process Sceduler
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page