Db/2 – LUW – Command Line Client Tools – Day 1

Background

A quick review of Db/2 Command Line Client Tools.

Outline

  1. db2ilist
    • List Instances
  2. db2level
    • Version/Release/Fix Pack Information
  3. db2licm
    • Licensing Information

Tools

db2ilist

Syntax


db2ilist

Output

Windows

db2ilist.20181005.0443PM.PNG

Linux

db2ilist.linux.20181005.0448PM.PNG

 

Explanation

  1. Default Instance Name
    • MS Windows
      • DB2
    • Linux
      • db2inst1

 

db2level

Syntax


db2level

Output

Windows

db2level.windows.20181005.0456PM.PNG

Linux

db2level.linux.20181005.0452PM.PNG

 

Explanation

  1. Default Instance Name
    • MS Windows
      • DB2
    • Linux
      • db2inst1
  2. Bitness
    • “64” bits
  3. Information Tokens
    • Valid Values
      • Informational tokens are “DB2 v10.5.0.10”, “s180615”, “IP24053”
      • Informational tokens are “DB2 v11.1.3030.239”, “s1803021700”,
        “DYN1803021700WIN64“, and Fix Pack “3”.
  4. Fix Pack
    • Fix Pack “10”
    • Fix Pack “3”
  5. Installed Locations
    • Valid Values
      • Product is installed at “/apps/IBM/db2/v10.5
      • Product is installed at “M:\Program Files\IBM\SQLLIB” with DB2 Copy Name “DB2COPY1”

 

db2licm

Syntax


db2licm -l

Output

Windows

db2licm.windows.20181005.0502PM.PNG

Linux

db2licm.linux.20181005.0503PM.PNG

 

Explanation

  1. Product Name
    • Valid Values
      • DB2 Enterprise Server Edition
      • IBM DB2 Developer-C Edition
  2. License Type
    • Valid Values
      • CPU Option
      • Community
  3. Expiry Date
    • Valid Values
      • Permanent
  4. Product Identifier
    • Valid Values
      • db2ese
        • Enterprise
      • db2dec
        • Db2 Developer-C Edition (Non-production)
  5. Version Information
    • Valid Values
      • 11.1
      • 10.5
  6. Enforcement policy
    • Valid Values
      • Soft Stop
  7. Features
    • Valid Values
      • IBM DB2 BLU Acceleration In-Memory Offering: “Not licensed”
      • IBM DB2 Performance Management Offering: “Not licensed”
      • IBM DB2 Encryption Offering: “Not licensed”
      • IBM DB2 Business Application Continuity Offering: “Not licensed”
  8. Hardware Limits
    • Max amount of memory (GB)
      • Max amount of memory (GB): “16”
    • Max number of cores
      • Max number of cores: “4”
    • Max amount of table space (GB)
      • Max amount of table space (GB): “100”

References

  1. IBM
    • IBM Support
      • How to determine the DB2 LUW Product, Version and Fix Pack level of an Instance
        Link
    • Knowledge Center
      • Home > Db2 11.1 > Database fundamentals > Configuring
        •  Db2 license files
      • Home > Db2 11.1 > Database administration > Interfaces (Tools, Commands, APIs) > Commands System commands
        • db2level – Show Db2 service level command

 

Summary

Day 1, more to come.

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