IBM Support

50 DB2 Nuggets #42: Tech Tip - how to integrate the db2 and AIX WLM classes ?

Technical Blog Post


Abstract

50 DB2 Nuggets #42: Tech Tip - how to integrate the db2 and AIX WLM classes ?

Body

Do you want to know how to integrate the db2 and AIX WLM classes ?
 
You can do that while defining the db2 WLM class using the outbound correlator string constant.
 
Refer :
 
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0050550.html
 
OUTBOUND CORRELATOR NONE or OUTBOUND CORRELATOR string-constant Specifies whether or not to associate threads from this service class to an external workload manager service class.
If OUTBOUND CORRELATOR is set to a string-constant for the service superclass and OUTBOUND CORRELATOR NONE is set for a service subclass, the service subclass inherits the OUTBOUND CORRELATOR of its parent. OUTBOUND CORRELATOR must be set to NONE if the AGENT PRIORITY is not set to DEFAULT (SQLSTATE 42613). The default is OUTBOUND CORRELATOR NONE.
 

 
An example statement would be :


CREATE SERVICE CLASS ?Marketing? OUTBOUND CORRELATOR  ?_DB2_Marketing?;
 
In this case the _DB2_Marketing is the WLM class previously defined at the OS level.

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11141372