home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT19279 Status: Closed

SYSIBMADM.ENV_SYS_INFO RUNS SLOWER IN DB2 V10.5 BY 1 SECOND

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
The administrative view runs relatively slow in DB2 v10.5 . It
takes 1 second samples and results in 1 second extra processing.

$ time db2 "SELECT HOST_NAME , CURRENT SERVER FROM
SYSIBMADM.ENV_SYS_INFO"

HOST_NAME     2               
----------------   ----
testhost            TEST            

  1 record(s) selected.

real    0m1.67s
user    0m0.01s
sys     0m0.01s

Ideally it should take few milliseconds to complete.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
****************************************************************
Local Fix:
1. SELECT HOST_NAME,  CURRENT SERVER
FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS SYSTEMINFO




or 




2. Create new view in different schema:
db2 "CREATE OR REPLACE VIEW DB2INST1.ENV_SYS_INFO              

( OS_NAME, OS_VERSION, OS_RELEASE, HOST_NAME, TOTAL_CPUS,      

CONFIGURED_CPUS, TOTAL_MEMORY )                                

AS                                                              

SELECT  os_name, os_version, os_release, host_name, total_cpus,

configured_cpus, total_memory                                  

  FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) as t                  

WITH NO ROW MOVEMENT"                                          

                                                               

And then run following command:                                

                                                               

$ time db2 "SELECT HOST_NAME , CURRENT SERVER FROM
DB2INST1.ENV_SYS_INFO"  
Solution


Workaround


not known / see Local fix


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.02.2017
16.01.2020
16.01.2020


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)