Category
Versión del producto
Tema
Subtema
Idioma
Cannot backup database when Spotlight is in use. (4222010)
Cannot backup database when Spotlight is in use. ... When user tries to backup the database with Spotlight in use and connected with the DB2ADMIN user, backup shows the following error: ... C:\Sutiles\lib>DB2 BACKUP DATABASE DBFIRN1 TO F:\Backups\ WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING SQL1035N The operation failed because the specified database can not connect to the requested mode.
SODB2 v 6.7.2 connects to a database with 4 nodes and got hang up (4230674)
User tried to connect from SODB2 v 6.7.2 to a database DB2 v 9.7.3 with 4 nodes and got hang up for a long time.
Any drill down give "The current license does not allow access to this functionality." (4284341)
After launching Spoltight, any drill down gave "The current license does not allow access to this functionality." RESOLUTION 1: Go to Help | About | View Change Product License and make sure there is commercial key present and not an expired trial key.<div></div><div>RESOLUTION 2: If believe to be licensed under Toad, the Toad license key must be Toad DBA Suite for DB2. Go to Toad and click on Help | Licensing to check.</div>
History browser, intermittently showing "no data" under client applications (4257579)
When viewing the History Browser and drilling down to Client Applications, "No Data" is intermittently shown after clicking the items on the left panel. ... WORKAROUND ... Right-click on the page and select "Restore Default Settings"
error: Unable toconnect to database ...also additional message:" Provider cannot be found. It may (4273909)
User launched Spotlight on DB2 from Toad for DB2 without creating of DB catalogs on DB2 client (DB2copy1). ... It does not use Toad for DB2 catalog. ... SPOTLIGHT for DB2 v 6.8.2 does not use Toad for DB2 v 5.0.3 catalog.
Information on Spotlight (4333309)
60 seconds is when Spotlight is on the background or minimized. ... Otherwise is 15 seconds.
cannot delete Database Alias (4339597)
Changed server and renamed the HOST name when, but when launching DB2 client configuration wizard it will not let delete the old host name and it uses that old host name to connect with error. ... It can connect with the new host name on Toad for DB2 but not on Spotlight because it still keeps the old host name configuration.
Unit of Work - SQL, font is large (4341795)
When in the Client Application Anaysis screen and they click on an application, then click on the Unit of Work-SQL tab, the app's SQL is displayed in a large monospaced font. ... Where can I change that to a legible font?
Columns are different in the Client Applications Service view when compared to v5 (4268705)
We had compared the columns showing on both Client Application screens of Spotlight classic and v 6.0.1.6. ... Prev UOW (sec) ... None ... STATUS: ... Enhancement request CR0230406 has been submitted to Development for consideration in a future release of Spotlight on DB2.
alarms setting have disappeared (4341929)
The correct step to prevent this to happen is to save the modified alarms/thresholds setting as a new template before exiting (after setting up alarms) Spotlight on DB2. ... Here are the steps: ... 1. click the 'File' menu, then 'Save As Template...'.
Spotlight active log warning shows 100% full (4244891)
The active log display is incorrect. ... The utilization alarm is always on. ... It isshowing 100%when there are many datasets to write into after one dataset is full hence it will not hit 100%. ... The LOGSECOND parameter in DB2 is set to -1 which means infinite logging.
Does Spotlight on DB2 have a custom counter alarm? (4279875)
Does Spotlight on DB2 have a custom counter alarm similar to Spotlight on SQL Server? <p>WORKAROUND: None</p><p>STATUS: Enhancement request number has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.</p> CR115456
Spotlight DB2 does not have the same DB2 catalogue as Toad DB2 (4285289)
Spotlight DB2 does not show the same DB2 catalogue info as Toad for DB2. ... Spotlight cannot use the Toad DB2 IBM client. ... A separate DB2 client must be installed. ... The DB2 catalogue from Toad can be exported via the Client Configuration Wizard (consult the Toad help for more info).
License Expired message (4283814)
Check if the license is valid. ... If not, license needs to be regenerated.
Spotlight on DB2 showing Incorrect Data on lock waiting drilldown (4282778)
In Spotlight on DB2 v 6.5.1, some applications show lock wait , however, when you click on locks it shows 'No Data'. ... Waiting for a fix in a future release of Spotlight on DB2. ... WORKAROUND:
Error: "Assertion failure (C:\Spotlight Console\MDK\2.0\Source\SpotlightVirtualControl.pas, line (4274494)
This error only happens on the first time. ... It will not recur. ... WORKAROUND: ... None
stored procedures ran by Spotlight (4339950)
What stored procedures does Spoltight run , where are they ? ... What is their overhead for the database ? ... The product uses one of the following 3 sets of stored procedures depending on version of monitored SQL Server:
DB2 HADR disconnect not showing as 'red' (4283397)
The HADR information shown in the DB2 instance page (Ctrl+I) does NOT display the state or status information in Red if they are 'Disconnected'. ... This is extremely important and should probably be on the home page under DB Information !
Is there a way to show the package SQL that's executing? (4278531)
An user connects to DB2 v 9.7 FP 4 on Linux Rehat v 5.5 from Spotlight on DB2 v 6.8.1 successful. ... On Client applications Unit of Work - SQL shows a Call procedure instead of SQL statement being executed.
When all my DB2 home page is green, the database name is showing yellow (4274189)
When all my DB2 home page is green, why the database name is showing yellow? ... ANSWER: ... The yellow color means some metric in the homepage or database instance drilldown meet the low threshold.
'PROVIDER CANNOT BE FOUND. IT MAY NOT BE PROPERLY INSTALLED.' (4278857)
User tried to connect to database from Spotlighton DB2 v 6.8.0.1.15 and got error 'PROVIDER CANNOT BE FOUND. ... STATUS ... Waiting for a fix with CR92803 on a future release of Spotlight on DB2.
Unable to open a connection (4268633)
User has many DB2 clients on client machine. ... Launched Spotlight on DB2 could not see all connections on other DB2 client.
Log space utilization - Is there any command to show used percentage? (4268803)
User does not install Spotlight at home, Is there any command to show used percentage of Log space utilization like Spotlight does? ... NO ... WORKAROUND: ... 1) Set a email notification on the log status field, Spotlight can send out email when log percentage large than a value.
Spotlight on DB2 for LUW 6.7.2.105 - Could not convert variant of type (Null) (4335394)
Spotlight on DB2 for LUW 6.7.2.105 ... The following internal error occurred: ... Could not convert variant of type (Null) into type (String) ... Source: 1F01420C (SoDB2_Console.0001320C) ... Call stack:
Connections are gone (4274009)
User has created 16 connection profiles on Spotlight on DB2. ... After 1 week all connections are gone.
Asociación de nuevos productos
- Herramientas de autoservicio
- Base de conocimientos
- Notificaciones y alertas
- Soporte de productos
- Descargas de software
- Documentación técnica
- Foros de usuarios
- Tutoriales en video
- Aviso de actualizaciones de páginas web (RSS)
- Comuníquese con nosotros
- Soporte Técnico
- Ver todos