Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2014
    Posts
    3

    Unanswered: DB2 workload manager problem

    Hi guys,

    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:

    Production

    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"
    Features:
    DB2 Performance Optimization ESE: "Not licensed"
    DB2 Storage Optimization: "Not licensed"
    DB2 Advanced Access Control: "Not licensed"
    IBM Homogeneous Replication ESE: "Not licensed"

    Product name: "DB2 Connect Server"
    License type: "Trial"
    Expiry date: "02/03/2014"
    Product identifier: "db2consv"
    Version information: "9.7"


    Test

    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"
    Features:
    DB2 Performance Optimization ESE: "Not licensed"
    DB2 Storage Optimization: "Not licensed"
    DB2 Advanced Access Control: "Not licensed"
    IBM Homogeneous Replication ESE: "Not licensed"

    Product name: "DB2 Connect Server"
    Expiry date: "Expired"
    Product identifier: "db2consv"
    Version information: "9.7"
    Concurrent connect user policy: "Disabled"
    Enforcement policy: "Soft Stop"


    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.
    Thanks

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    check with IBM. Authorised-user option and WLM together? Previous sites I've worked always had the CPU based licensing if using WLM.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •