|
Problem IC63258
|
Status: Closed |
"MEMEORY VISUALIZER" DOES NOT DISPLAY "DATABASE GLOBAL MEMORY" FOR ALL DATABASES. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
"Memeory Visualizer" does NOT display "Database Global Memory"
for all databases.
Here is an example of how to reproduce it.
-- 1. Create a DB2 instance named "db2inst1".
-- 2. Create 3 local databases under the instance "db2inst1":
sample1
sample2
sample3
-- 3. Start up the instance "db2inst1" by "db2start" command.
-- 4. Connect to the 3 databases respectively in 3 DB2 CLP
windows:
db2 connect to sample1
db2 connect to sample2
db2 connect to sample3
-- 5. Issue "db2 list active databases" and make sure all the 3
databases are active.
-- 6. Launch DB2 "Memory Visualizer".
-- 7. Select the instance "db2inst1" when Memory Visualizer
prompts you to select an instance.
-- 8. In Memory Visualizer, expand the cascading menu "Database
Global Memory".
Then you will only see the database "sample3", although all the
3 databases are active.
Even if you clicked on the "Refresh", nothing would change.
The fix of this problem will make "Memeory Visualizer" display
"Database Global Memory" for all databases. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of version 9.5 on Linux, Unix and *
* Windowsplatforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* "Memeory Visualizer" does NOT display "Database *
* GlobalMemory" for all databases.Here is an example of how to *
* reproduce it.-- 1. Create a DB2 instance named "db2inst1".-- *
* 2. Create 3 local databases under the *
* instance"db2inst1":sample1sample2sample3-- 3. Start up the *
* instance "db2inst1" by "db2start"command.-- 4. Connect to *
* the 3 databases respectively in 3 DB2 CLPwindows:db2 connect *
* to sample1db2 connect to sample2db2 connect to sample3-- 5. *
* Issue "db2 list active databases" and make sure allthe 3 *
* databases are active.-- 6. Launch DB2 "Memory Visualizer".-- *
* 7. Select the instance "db2inst1" when Memory *
* Visualizerprompts you to select an instance.-- 8. In Memory *
* Visualizer, expand the cascading menu"Database Global *
* Memory".Then you will only see the database "sample3", *
* although allthe 3 databases are active.Even if you clicked *
* on the "Refresh", nothing would change.The fix of this *
* problem will make "Memeory Visualizer"display "Database *
* Global Memory" for all databases. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.5 FixPak 6 or higher levels. *
**************************************************************** |
| Local Fix: |
Launch "Memory Visualizer" prior to activating the databases.
Using the same example mentioned in "Problem Description",
the steps will be:
-- 1. Start up the instance "db2inst1" by "db2start"
command.
-- 2. Launch DB2 "Memory Visualizer".
-- 3. Select the instance "db2inst1" when Memory Visualizer
prompts you to select an instance.
-- 4. Connect to the 3 databases respectively in 3 DB2 CLP
windows:
db2 connect to sample1
db2 connect to sample2
db2 connect to sample3
-- 5. Issue "db2 list active databases" and make sure all the
3 databases are active.
-- 6. In Memory Visualizer, expand the cascading menu
"Database Global Memory".
Then you will all the 3 databases. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.5 FixPak 6 |
| Workaround |
Launch "Memory Visualizer" prior to activating the databases.
Using the same example mentioned in "Problem Description",
the steps will be:
-- 1. Start up the instance "db2inst1" by "db2start"
command.
-- 2. Launch DB2 "Memory Visualizer".
-- 3. Select the instance "db2inst1" when Memory Visualizer
prompts you to select an instance.
-- 4. Connect to the 3 databases respectively in 3 DB2 CLP
windows:
db2 connect to sample1
db2 connect to sample2
db2 connect to sample3
-- 5. Issue "db2 list active databases" and make sure all the
3 databases are active.
-- 6. In Memory Visualizer, expand the cascading menu
"Database Global Memory".
Then you will all the 3 databases. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC63422
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.09.2009
25.05.2010
25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
