Re: * - COMMIT -- WEB400

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