Db/2 – LUW – Setting DB2_RESOURCE_POLICY to AUTOMATIC

Background

To reach for optimal system management one area that can help is having the Db/2 Instance’s DB2_RESOURCE_POLICY set to AUTOMATIC.

Script

Outline

  1. db2set
    • Set parameter
    • Review parameters
  2. Restart Instance
    • Stop Instance
    • Start Instance

db2set

Set

Code

db2set DB2_RESOURCE_POLICY=AUTOMATIC 

Review

Code

db2set

Output

DB2_RESOURCE_POLICY_20181001_1216AM.PNG

Restart Instance

Stop Instance

Code

db2 force applications all

db2 terminate

db2stop

Output

db2InstanceStop_20181001_1228AM

Start Instance

Code

db2start

Output
Image

db2InstanceStart_20181001_1231AM

Textual

 DB2-0 : The service has returned a service-specific error code.

10/01/2018 00:31:15     0   0   SQL1367N  Insufficient operating system configuration for resource policy support.
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

 

Explanation

Unfortunately, we are not able to go forward.

Let us go see why.

 

Troubleshooting

SQL1367N

Googling on the error code SQL1367N landed us here:

SQL1367N
Link

Resource policy does not support the current operating system configuration.

Summary

Our targeted OS, MS Windows 2012 R2 Standard, is not one of the supported OSes for Db/2 Resource Policy Automatic provisioning.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s