|
Upon restarting the subsystem I notice: Job User Type -----Status----- Function QEJBMQLSR QEJBSVR BATCHI ACTIVE PGM-RUNMQLSR SERVER1 QEJBSVR AUTO ACTIVE PGM-QEJBSTRSVR WAS5PORTAL QEJBSVR AUTO ACTIVE PGM-QEJBSTRSVR and after almost 20 minutes the browser shows server1 running and was5portal stopped. Server1 job has: Server starting with user profile QEJBSVR and JDK 1.3.1. WebSphere application server server1 ready. (Took just over 4 minutes between the two messages.) was5portal job has: Server starting with user profile QEJBSVR and JDK 1.3.1. Job 547746/QEJBSVR/ENDMQCSV started. ... Job 509847/QUSER/QSQSRVR used for SQL server mode processing. ... Job 547869/QUSER/QSQSRVR used for SQL server mode processing. WebSphere application server WAS5Portal ready. (Took 20 minutes for that last message to appear!) Now the browser finally shows it as running. wrkJob 547869/QUSER/QSQSRVR Job 547869/QUSER/QSQSRVR started on 02/08/05 at 10:48:06 in subsystem QSYSWRK in QSYS. Job entered system on 02/08/05 at 10:48:06. User Profile = WPSDBUSER Not enough SQLVAR entries were provided in the SQLDA. Not enough SQLVAR entries were provided in the SQLDA. Not enough SQLVAR entries were provided in the SQLDA. Not enough SQLVAR entries were provided in the SQLDA. That last message: SQL0237 Cause . . . . . : The SQLDA only provided 20 SQLVAR entries. Since at least one of the columns being described is a distinct type or a LOB, 36 SQLVAR entries should have been specified. None of the secondary SQLVAR entries have been set. Since at least one of the columns is a distinct type or a LOB, space should be provided for twice as many SQLVAR entries as the number of columns. Only the base SQLVAR entries have been set. >From program . . . . . . . . . : QSQRUN1 From library . . . . . . . . : QSYS From module . . . . . . . . : QSQPREP From procedure . . . . . . . : CLEANUP From statement . . . . . . . : 10866 To program . . . . . . . . . . : QSQRUN1 To library . . . . . . . . . : QSYS To module . . . . . . . . . : QSQPREP To procedure . . . . . . . . : CLEANUP To statement . . . . . . . . : 10866 Searching the ptf cover letters for MSGSQL0237 shows a plethora of hits for 520, 510 and a few earlier. None for 530. http://www-912.ibm.com/a_dir/as4ptf.nsf/as4ptfhome Our system is bored - it wants more work. DSPSYSSTS: % CPU used . . . . . . . : 6.5 Auxiliary storage: % DB capability . . . . : .0 System ASP . . . . . . : 776.2 G Elapsed time . . . . . . : 00:00:01 % system ASP used . . : 51.3195 Jobs in system . . . . . : 1569 Total . . . . . . . . : 776.2 G % perm addresses . . . . : .016 Current unprotect used : 16790 M % temp addresses . . . . : .123 Maximum unprotect . . : 26322 M System Pool Reserved Max -----DB----- ---Non-DB--- Pool Size (M) Size (M) Active Fault Pages Fault Pages 1 876.55 235.41 +++++ .0 .0 .0 .0 2 6030.31 4.95 446 .0 .0 11.0 10.1 3 1640.20 .00 381 .0 .0 3.6 4.6 4 1526.25 .00 22 .0 .0 .0 .0 5 101.75 .04 9 .0 .0 .0 .0 Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.