| Bug #54795 | QSQSRVR in the Same SubSystem of mysqld | ||
|---|---|---|---|
| Submitted: | 25 Jun 2010 7:46 | Modified: | 23 Aug 2010 19:12 |
| Reporter: | Eduardo Pascual | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: DB2SE for IBM i | Severity: | S3 (Non-critical) |
| Version: | 5.1.48 | OS: | IBM i (V5R4) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | QSQSRVR, SubSystem | ||
[28 Jun 2010 19:07]
Tim Clark
The ability to change the subsystem for QSQSRVR jobs was added after the storage engine support. Consequently, the storage engine support will need to be updated to enable this behavior. I will update this bug report when a PTF for this becomes available.
[3 Aug 2010 19:10]
Tim Clark
This is now fixed with the following IBM i PTFs: 7.1 - SI40585 6.1 - SI40584 v5r4 - SI40583 Refer to INFO APAR II14442 for more information about any requisite PTFs: http://www-912.ibm.com/n_dir/nas4apar.nsf/c79815e083182fec862564c00079d117/67d12878076e482...
Description: I'm trying to run QSQSRVR jobs in the same subsytem of MySQL daemon. I have followed the instructions of the IBM APAR SE35252 when adding the environment variable QIBM_SRVRMODE_SBS system level ( ADDENVVAR ENVVAR(QIBM_SRVRMODE_SBS) VALUE('*SAME') LEVEL(*SYS) ) and create QSQSRVR prestart jobs in the same subsystem that the MySQL daemon ( ENDSBS MYSQLSBS ADDPJE SBSD(QGPL/MYSQLSBS)PGM(QSYS/QSQSRVR) STRJOBS(*YES) INLJOBS(5) THRESHOLD(3) ADLJOBS(2) MAXUSE(*NOMAX) STRSBS MYSQLSBS ) but still MySQL connects to the database through the Subsystem QSQSRVR QSYSWRK jobs. I have SI34259 PTF temporarily applied Is that possible? It's for performance reason. How to repeat: Following IBM APAR SE35252.