Book Image

IBM Db2 11.1 Certification Guide

By : Robert (Kent) Collins, Mohankumar Saraswatipura
Book Image

IBM Db2 11.1 Certification Guide

By: Robert (Kent) Collins, Mohankumar Saraswatipura

Overview of this book

IBM Db2 is a relational database management system (RDBMS) that helps you store, analyze, and retrieve data efficiently. This comprehensive book is designed to help you master all aspects of IBM Db2 database administration and prepare you to take and pass IBM's Certification Exams C2090-600. Building on years of extensive experience, the authors take you through all areas covered by the test. The book delves deep into each certification topic: Db2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, and security. IBM Db2 11.1 Certification Guide provides you with more than 150 practice questions and answers, simulating real certification examination questions. Each chapter includes an extensive set of practice questions along with carefully explained answers. This book will not just prepare you for the C2090-600 exam but also help you troubleshoot day-to-day database administration challenges.
Table of Contents (10 chapters)

Db2 pureScale db2cluster service command options

Db2 provides the db2cluster command to verify the health of a pureScale instance and perform management operations related to cluster services.

You can also use the db2cluster command to verify the health of the members:

db2cluster -cm -list -host -state
HOSTNAME STATE
------------------------ -----------
purescale05 ONLINE
purescale04 ONLINE
purescale03 ONLINE
purescale02 ONLINE
purescale01 ONLINE
purescalecf01 ONLINE
purescalecf02 ONLINE

You can use the db2instance -list command to check the status of all the members in the cluster:

db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
-- ---- ----- --------- ------------ ----- ---------------- ------------ -------
0 MEMBER STARTED purescale01 purescale01 NO 0 0 purescale01-roce0,purescale01-roce1
1 MEMBER STARTED purescale02 purescale02 NO 0 0...