I would like to use DB2 workload manager feature but I don't understand what is really required to use it.
From the documentation I read that one of the following licensed products is required:
- DB2 Enterprise Server Edition for Linux, UNIX, and Windows
- DB2 Advanced Enterprise Server Edition for Linux, UNIX, and Windows
- Database Enterprise Developer Edition for Linux, UNIX, and Windows
- IBM® InfoSphere® Warehouse, all editions
- IBM Smart Analytics System
I have applyied on both my production server and test server the same license, on the production server it works but on the test server when I try to execute the following
query: create service class SC_1 I riceve this error:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL8029N A valid license key was not found for the requested function. The
current license key for this product does not allow the requested
functionality. Purchase the license key for this function from your IBM
representative or authorized dealer and update your license using the License
Center or the db2licm command line utility.
This is the output of db2licm -l command on both the servers:
Product name: "DB2 Enterprise Server Edition"
License type: "Authorized User Option"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "9.7"
Enforcement policy: "Soft Stop"
Number of licensed authorized users: "25"
DB2 Performance Optimization ESE: "Not licensed"
DB2 Storage Optimization: "Not licensed"
DB2 Advanced Access Control: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"
What do you think the problem is? The only difference is that on the test server "DB2 Connect Server" is expired and on the production server it hasn't yet; but this
should not be a requirement for this feature.
some info in infocenter
DB2 workload manager is licensed as part of the Performance Management Feature, and use of the full set of workload management functionality requires that you obtain this additional license.
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be