DB2 : to check uptime for database

 [prd1ins1@db2prd603  ~]

$ db2 get snapshot for db on wcprd1 | grep -i connection

High water mark for connections            = 25

  Connection status      = Connected, 02/04/2025 08:37:41.027853




$ db2pd -db wcprd1 -

Database Member 0 -- Database WCPRD1 -- Active Standby -- Up 1 days 03:40:32 -- Date 2025-02-05-12.18.04.422332







$ db2 get snapshot for all databases

              Database Snapshot

Database name                              = WCTST3
Database path                              = /rd100/db2data/tst3ins3/tst3ins3/NODE0000/SQL00001/MEMBER0000/
Input database alias                       =
Database status                            = Active
Catalog database partition number          = 0
Catalog network node name                  = db2tst602
Operating system running at database server= LINUXAMD64
Location of the database                   = Local
First database connect timestamp           = 06/19/2025 21:08:03.287534
Last reset timestamp                       =


Comments

Post a Comment

Popular posts from this blog

Postgres: Clean up stopped replication slot

Image
  When a slot is inactive, that means that Murty and his team have stopped the replication on their side. The SQL below will identify inactive slots. We should schedule this script in a job , running every hour.    (1) SELECT  slot_name,  pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(),restart_lsn)) AS size,  active,  slot_type  FROM pg_replication_slots;       (2) Once you identify the replication slot, the job should drop it with the following command:     SELECT pg_drop_replication_slot ('pg_replication_slot_name_from_above');         (3) Restart the database instance to clean up unwanted disk space.   Notes from Google:- Thank you for contacting Google Cloud Support. My name is Jagadeesh and I will be assisting you with this issue.   I understand that WAL logs are expanding to over 1.5TB and you want to know what is causing WAL logs to grow and you want to reduce it. Please confirm if ...
Read more