Hi Su Li,
good question! A colleague of mine is maintaining the DMC image in OKD, but he's on holiday now.
1. DMC does not mention any version number in its splash screen during sign-on
2. After I solved my issues with signing on (details on that below, IBM case is following too), I could not find a decent spot, where DMC clearly states, I'm version 3.1.4 or 3.1.5. I just can find a "Productinfo" panel, which says: Build20210510-134804
Or is there another method for finding out, which version is running, if you don't know, what image of DMC was started?
P.S.: The logon issue: Due to German security regulations from BSI, my user was moved into the AD group "Protected Users Security Group" (see also
https://docs.microsoft.com/en-us/windows-server/security/credentials-protection-and-management/protected-users-security-group ). DSM is configured to lookup the users in AD via LDAP integration and as long as my user is in that group, logon is not possible. The security admin removed my group membership temporarily and now I was able to login again. I was told, here is something IBM has to fix in the logon process to allow such a logon.
Kind regards
------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen
------------------------------
Original Message:
Sent: Thu July 29, 2021 04:58 AM
From: Su Li Hou
Subject: DMC and DROPED TABLE RECOVERY
@KAI DING May you pls advise if this is valid problem in DMC v3.1.5?
------------------------------
Su Li Hou
Original Message:
Sent: Tue July 27, 2021 01:39 PM
From: Roland Schock
Subject: DMC and DROPED TABLE RECOVERY
Hi,
just a hint for all DMC users.
According to Db2 docs, the default for creating new tablespaces uses DROPPED TABLE RECOVERY = ON. See: Recovering a dropped table
If you use this script to create your tablespaces for DMC, you might get heaps of messages in your Recovery History File db2rhist.asc of your database of IBM_RTMON tables dropped and recreated in TS4MONITOR.
I ended up having a very imperformant db2rhist.asc file with 2.4 GB in size and millions of entries. :-(
At least the KC should be updated to include DROPPED TABLE RECOVERY OFF on this page.
SET STMT = 'CREATE TABLESPACE TS4MONITOR IN CONSOLEGROUP PAGESIZE 32768 MANAGED BY AUTOMATIC STORAGE AUTORESIZE YES INITIALSIZE 100M MAXSIZE 2G BUFFERPOOL CONSOLEPOOL DROPPED TABLE RECOVERY OFF';
Kind regards
------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen
------------------------------
#Db2