When trying to setup the connection and try to connect, Unable to connect to the "" error shows. ... There is no problem with the connection since user can successfully connect via command line. ... Ensure that IBM 9.7 FP5 or above version client is installed.
When trying to make a new connection, the database alias drop-down is blank and will not populate. ... Opening the DB2 client, the directory show there are alias names showing. ... Without the database alias, the Spotlight connection window will gray out the OK button.
From www.quest.com Which software do I select for Spotlight on DB2 for LUW? ... The Client software is the GUI module that must be installed before connecting to the agents. ... The Agent software depends on which database server is in your environment.
DB2 8.2 is unsupported both by Spotlight 6.7 and 6.8. ... For the complete system requirements, check the release notes from Quest Support Portal.
When using the feature 'Automatic' storage, Spotlight on DB2 for LUW does not recognize this and always reports that the DMS utilization is very high in some DB2 instances. ... Is there a way to eliminate this?
Drilling down into "Tablespace Analysis | Tablespaces" tab, double-clicking on a tablespace name and selecting the Tables tab results in the error: ... SQL1013N The database alias name or database name "0" could not be found.
Spotlight on DB2 can show "the last backup" information. ... User wants to setup an action rule to do something when "the last backup" time is over 7 days (eg. send a mail, or backup again). ... How to setup this action rule?
Are there performance tuning and session browser features in Toad for DB2? ... How to monitor applications? ... Toad for DB2 is more of an administration tool and does not provide features for performance testing and tuning.
Error when launching classic Spotlight on DB2 6.2 from QCDB2 v 4.9.4, connecting to DB2 v 9.1: ... Spotlight on DB2 for LUW 6.2.0.22 ... An error occurred while refreshing the table "Stmt" in connection "DB_name ( test )".
Now Spotlight on DB2 for LUW Version: 6.7.2.105 does not work correctly, and here is the error... ... Spotlight on DB2 for LUW 6.7.2.105 - An error occurred while refreshing the table "DBaseAll" in connection "\PROD".
User installed both versions of the DB2 client v8.2 and v9.1 onto his client machine. ... When he launched Spotlight on DB2 and tried to create a new connection he received the following error: ... "QCC10000E - Unable to allocate environment handle for DBConnect."
The Spotlight main Home Page shows no connections or activity and indicates no last backup. ... Make sure you are on 6.9.3 before you apply the patch.</p><div></div><div> Spotlight.exe</div><div> ConnDB2.dll</div><div></div><div>With Spolight DB2 closed, Go to "C:\Program Files (x86)\Quest Software\Spotlight on IBM DB2 LUW\Console\" or where ever the install path is for your Spotlight.
Can Spotlight on DB2 report on database up time?
User upgraded DB2 v8 to V9.1 and used Spotlight for DB2 version 6.2 to connect to the database. ... User receives below error either on the SQL tab or on the History browser: ... Message: ... An error occurred while refreshing the table "DBaseHistory" in connection "EDT1D ( DB2EDT1D )".
SOLUTION: Rename configUDB.ini to the different one. ... 1) Make sure that Spotlight is not running ... 2) Go to your Spotlight on DB2 install directory on your Windows machine and see if you have a file named configUDB.ini.
Additional information can be located in 6.9.3 Release Notes Technical Documentation. ... Spotlight 6.9.3 version can be downloaded from here.
I just installed Spotlight on DB2 and launched it right away and got error: "Invalid plug-in id in spotlight console."
Spotlight on DB2 shows data but not activity, but Spotlight on UNIX shows both data and activity. ... All graphs seems to be frozen and don't show any movements. ... <p><br>Please set these 2 switches and wait for 15~30 seconds for Spotlight to refresh:</p> <p>db2 update monitor switches using BUFFERPOOL on global<br>db2 update dbm cfg using DFT_MON_BUFPOOL on</p> <p>Then...</p> <p>1)
1. Does Spotlight require a local system-admin level ID to run successfully? ... 1.Spotlight need local administrator or belong to "DB2ADMIN" or "DB2USER" user group. ... This privilege is for run DB2 client DLLs.
From Quest Central for DB2, a DBA tried to reorg a table, but the job never completed. ... The WLM startup job runs out of storage space due to many warning messages stating ICH70001I that were issued every 30 seconds.
User tried to launch Classic Spotlight on DB2 from Quest Central for DB2 v 5.0.1 and received the following error message: ... Please install the standalone Spotlight on DB2 v 6.2.
Error received when manually typing licensing key and message id: ... Copy and paste key and message id without any extra spaces or returns.
We have fixed DAS server, Control Center and QCDB2 are working fine. ... Spotlight connection also works fine. ... On database drilldown, we got error SQL30082N reason code 15 when we clicked on OK button and got same sql code but reason code 3.
As soon as user starts Spotlight he gets the following error message. ... Spotlight on DB2 for LUW 6.5.1.9 ... 7E418734 (user32.00007734) 7E418816 (user32.00007816) 7E4189CD (user32.000079CD) 7E4196C7 (user32.000086C7) 00490F58 (Spotlight.0008FF58) 0078333D (Spotlight.0038233D) 7C816FE7 (kernel32.00015FE7)
On Spotlight on DB2 v 6.7.0.14, user connected to a Database with 64 partitions, Shown client applications, drilldowned to detail, Clicked on Unit of Work-SQL and got internal error: The following internal error occurred: Interface not supported
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center