The current method is logon with our own id (which allows for auditing) and su to an id with proper authority to do work. ... The request is to incorporate the ability to switch users so that we can logon with our id and switch to an id with sysadm authority.
Spotlight shows this error every now and then. ... Disconnect and reconnect helps but after 2 -3 days issue recurs. ... WORKAROUND ... None
I have installed Spotlight on DB2 and Spotlight on Unix into the same installation directory, but when I try to connect with Spotlight on Unix I get an error message that I do not have a valid license.
In Client Application Analysis, Inbound address is empty and other columns showing 0 values. ... Revert or install Spotlight on DB2 6.8.2
This statement is generating errors with each call to the database. ... Spotlight functions, but the previous command is generating errors on each call. ... The error is SQL0423.
Message: ... The following internal error occurred: ... Attempting to commit an alarm log entry when the alarm log is closed (TSpotlightAlarmLog.Commit) ... ------------------------------------------------------------------------
Spotlight on DB2 is left running overnight monitoring the DB2 instance. ... db2diag.log eventually showed that this caused the transaction log to fill up. ... Error is similar to the following: ... The active log is full and is held by application handle "1167".
An error occurred while refreshing the table Stmt in connection name_of the connection ... An error occurred while refreshing the table tablespaceSMS in connection name_of the connection ... Table ... Error in SnapTableFunc.BuildResultSet SQL: -1326 Message: [IBM] [CLI Driver][BD2/AIX64] SQL1326N The file or directory path... cannot be accessed.
Can Spotlight on DB2 LUW 6.0.1 be used to diagnose a DB2 9.5 database. ... WORKAROUND: ... None ... Waiting for fix in a future release of Spotlight on DB2.
The drop down list for database alias is empty and it is not possible to fill this field manually. ... If we try to import catalog databases under View | Options | Spotlight on Db2 options | Import DB2 catalog no catalog databases are found.
When starting Spotlight for DB2 you may receive the following error: ... The following internal error occurred: ... 0042B3F6 (Spotlight.0002A3F6) ... Please reinstall Spotlight on a different folder location to fix this issue.
Click Ignore to ignore any further errors related to this table, or ... This is considered a Third party issue. ... A system error occurred. ... Some possible reasons for this error are: * The database manager is not installed correctly or the environment is not set up correctly. * On UNIX-based systems, db2iupdt may need to be run in order to update the DB2 instance to enable acquisition of a new system configuration or access to function associated with the installation or removal of certain product options, FixPaks, or modification levels.
Spotlight does not show disk information. ... The agent installed on a 64bit windows 2003 enterprise server but no service showed up in the control panel. ... Should this 32 bit agent work on a 64 bit server?
None ... STATUS ... Issue fixed in version 6.9.3.
None ... STATUS ... Issue fixed in version 6.9.3.
Where is the partition database information can be found on Spotlight for LUW (Linux Unix Windows) v 5.0. ... Partition Database information can be found on the Database icon of Spotlight for LUW 5.0 under column name NODE.
After a through review and testing done by the Spotlight DEV team, the following products have not been affected by the log4j 2 vulnerability issue. ... Spotlight on Oracle ... Spotlight on DB2
How to obtain/view license key from Spotlight? ... 2. Click 'View/change product license' option ... 4. For Spotlight on Oracle or Spotlight on DB2 product, select Modules tab. ... Select desired product name and click 'View/Change License' option
Are Toad products affected by the Log4j vulnerability CVE-2021-44228? <p><strong>Toad for Oracle:</strong><br>Toad for Oracle does not use Log4j. Therefore this vulnerability does not affect the product.<br>Toad for Oracle uses OraLDAPClntNN.dll (where NN is oracle version number like 12, 18, 19, etc)</p><p><br>It's unclear if Oracle LDAP client this uses Log4j, but believe this is not the case. </p><p>Some more information about the exploit:<br>"An attacker who can control log messages or log message parameters can execute arbitrary code loaded from LDAP servers when message lookup substitution is enabled"<br><br>Toad doesn't use any log message lookup substitution. The only messages we get from LDAP are numeric error codes, and Toad does not use any lookup substitution on them, or anything else.</p><p><br><strong>Toad Edge:</strong><br>Toad Edge doesn't use Log4j 2, but does use Log4 1.2.17<br><br>The range for this particular security vulnerability (CVE-2021-44228) is Log 4j 2.x to Log4j 2.15.0-rc1<br>Also, Toad Edge is not a server based application. The attack needs to happen over HTTP(S) requests.<br><br><br><strong>Unaffected products:</strong></p><p>Toad for Oracle</p><p>Toad for Oracle Editions</p><p>Toad for SQL Server</p><p>Toad for DB2</p><p>Toad for SAP</p><p>Toad for Data Point</p><p>Toad Intelligence Central</p><p>Toad Data Modeler</p><p>Toad Edge</p><p>SQL Navigator</p><p>SQL Optimizer for Oracle</p><p>SQL Optimizer for SQL Server</p><p>SQL Optimizer for DB2 LUW</p><p>SQL Optimizer for DB2 ZOS</p><p>SQL Optimizer for SAP</p><p>Benchmark Factory for Databases</p><p>Code Tester for Oracle</p><p>Toad DevOps Toolkit</p><p></p><p>Spotlight on Oracle</p><p>Spotlight on SAP</p><p>Spotlight on DB2 LUW</p><p></p>
When connect to DB2 from Spotlight on DB2 v 6.8.1 user got error: Unable to connect database name. ... Please install Spotlight on DB2 6.7.2 to use earlier version of IBM DB2 LUW'
------------------------------------------------------------------------ ... Enter correct User ID and password at login to Spotlight on DB2.
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.
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.
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>
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"
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center