Converse agora com nosso suporte
Chat com o suporte
Ferramentas de autoatendimento
Base de conhecimento
Minha conta
Notificações e alertas
Suporte a produtos
Downloads de software
Documentação técnica
Fóruns de usuário
Tutorial em vídeo
Feed RSS
Minha conta
Meus grupos
Minhas licenças
Meus produtos
Meu perfil
Minha solicitação de serviço
My Warranty Assets
Serviços
Consultando serviços
Serviços Educacionais
Serviços de suporte
Suporte ao Essentials
Prêmios e depoimentos
Introdução
Contrato de licença
Guia de suporte

What's new for Toad for DB2

Filtre para localizar atualizações para notas de versão, guias, artigos de conhecimento, software, patches, utilitários ou hot fixes (Escolha um produto diferente)

Subscribe no RSS


Subir

Notificações

Novo

Nada no momento

Revisado

Nada no momento

Subir

Patches

Novo

Nada no momento

Revisado

Nada no momento

Subir

Documentação

Novo

Nada no momento

Revisado

Nada no momento

Subir

Versões do software

Novo

Nada no momento

Revisado

Nada no momento

Subir

Artigos da Base de conhecimento

Novo
4209117 - Code Completion 'Include top 20 values of column data' which is taking a long while.

Problem with the code completion option: When in Options, Editor, Code Completion, General, box 'Include top 20 values of column data' is...

Criado: segunda-feira, 22 de agosto de 2022
4345222 - When assigning/changing database privileges not all options are visible in Toad for DB2

When trying to grant authorities to the GROUP, not all options are visible. They are listed but because they are deployed over the bigger area than...

Criado: segunda-feira, 22 de agosto de 2022
4311002 - Beta expiró y no acepta ingresar la licencia

Cuando se ejecuta la versión Beta que fue descargada de  ToadWorld.com  . Desde que se ejecuta el producto Beta indica que está expirado y ninguna...

Criado: quarta-feira, 24 de agosto de 2022
4308013 - Error durante instalacion "Failed to open archive file... Invalid Archive Signature."

Cuando se intenta instalar Toad el siguiente mensaje de error es recibido: "Failed to open archive file... Invalid Archive Signature."

Criado: quarta-feira, 24 de agosto de 2022
4234683 - Error descargando productos desde el link de soporte

Intentando descarga JProbe en Windows XP Professional SP 2 con Internet Explorer 6.0. No es capaz de descargar JProbe. Con un click en el link...

Criado: quarta-feira, 24 de agosto de 2022
4223945 - Error instalando/ desinstalando Toad y aplicaciones asociadas

Cuando se intenta instalar / desinstalar Toad, se presenta el siguiente error: Error 1316. A network error occurred while attempting to rad from...

Criado: quarta-feira, 24 de agosto de 2022
4226900 - Error al abrir Optimizer "Failed to create new tuning lab" or "Object reference not set to an instance of an object"

Toad for DB2 6.1 conecta y abre \tipo de SQL en el Editor.  Entonces selecciona el icono de 'tune' ajustar la sentencia de SQL, el optimizador...

Criado: quarta-feira, 24 de agosto de 2022
4313556 - Query Builder parser cambia el resto del codigo a rojo despues de encontrar un backslash como valor de parametro

Query Builder parser no aplica correctamente el formato si un backslash esta como valor de parámetro ('\') en la consulta.  Cuando Query Builder...

Criado: quarta-feira, 24 de agosto de 2022
4317508 - Schema compare / Data compare indican que no hay licencia despues de actualizar a la 6.0

Schema compare / Data compare indican que no hay licencia despues de actualizar a la 6.0 y no estan disponibles en 6.0

Criado: quarta-feira, 24 de agosto de 2022
4316181 - "DB2 LUW" o "DB2 ZOS" conexiones no estan licenciadas

Después de intentar conectar a la base de datos el siguiente error es presentado: "DB2 LUW connections are not currently licenced."    O "DB2...

Criado: quarta-feira, 24 de agosto de 2022
4270191 - "1603 - Fatal error during installation" Error instalando Toad for DB2

"General error occurred return value is 1603" or "1603 - Fatal error during installation" mensaje de error presentado cuando se intenta instalar...

Criado: quarta-feira, 24 de agosto de 2022
4230276 - "Error 1603" or ".Net 3.5 SP1 and 4.0 required" durante la instalación de Toad Suite on WIndows 7.

Al ejecutar el Toad Data Point   DB2 5.6 Suite en Windows 7 o superior, la instalación no se completará y lanza un...

Criado: quarta-feira, 24 de agosto de 2022
4268302 - Error generado 'QPDSNAT - SYSTEM COMPLETION CODE=0E0 REASON CODE=00000028'

Usuario instaló componente para z/OS y luego inició la tarea de QPDSNAT manualmente y el error siguiente fue generado: 'QPDSNAT - SYSTEM...

Criado: quarta-feira, 24 de agosto de 2022
4278386 - Aviso de conversion de lenguaje 'Language conversion warnings and/or errors, rc=-2168'

Usuario intentó compilar  un procedimiento con el debug y  recibió el siguiente error: DSNTPSMP utility failure for SQL Procedure CBISPDA.GET_FWR...

Criado: quarta-feira, 24 de agosto de 2022
4306712 - Categoria 'Federated' falta en el explorador de base de datos en 10.5 base de datos Linux.

La categoria 'Federated' no esta siendo desplegada en el "Database Browser" o explorador de base de datos  federated 10.5 Linux. Si se conecta a...

Criado: quarta-feira, 24 de agosto de 2022
4273663 - Error rutina no autorizada 'SQL0440N No authorized routine named "SYSPROC.DBG_RUNSESSIONMANAGER" of type"'

Cuando el usuario intenta depurar  un 'Stored procedure' (procedimiento almacenado), el siguiente error se presenta: ERROR [42884] [IBM][DB2...

Criado: quarta-feira, 24 de agosto de 2022
4282844 - Proceso SQL0952N fue cancelado por interrupcion 'SQL0952N Processing was canceled due to an interrupt. SQLSTATE=57014'

Usando Toad for DB2 z/ OS, con el PLANS seleccionado en la ventana que aparece "the list chosen to display is more than 2500.  Do you want to...

Criado: quarta-feira, 24 de agosto de 2022
4247761 - Migracion de Objetos no se ejecutan en el orden correcto, crea indices antes de cargar datos

En v5.1 la opción de migrar para un tablespace, delete,  create load table, create indexes. cree, mesa de carga, crear índices. En v5.2 la...

Criado: quarta-feira, 24 de agosto de 2022
4245454 - Error "SQL0551N <username> does not have the required authorization" no tiene la autorización requerida, cuando usuario trata de depurar

Error "SQL0551N <username> does not have the required authorization"  no tiene la autorización requerida, cuando usuario trata de depurar...

Criado: quarta-feira, 24 de agosto de 2022
4246269 - Error "Unable to locate object in database" al intentar un Alter Tablespace en identificar reporte de excepciones

Después de identificar excepciones, para  accesar a la ventana de  'Space Exceptions for DB2 /LUW', si un 'table space' es escogido y luego un...

Criado: quarta-feira, 24 de agosto de 2022
4225875 - Catalogo de estadística no es presentado cuando se usa el asistente para migrar Tablespace

Cuando migro objectos de un "tablespace" en Toad for DB2, hay una opción para migrar el catálogo de estadística, pero el DDL creado no está en el...

Criado: quarta-feira, 24 de agosto de 2022
4282766 - Necesito ver BufferPools tab en Database Explore de Toad for DB2 z OS

Solicitud de mejora :   Necesito ver BufferPools tab en el explorador de la base de datos en Toad for DB2 z OS.   QCDB2 y Toad for DB2 LUW...

Criado: quarta-feira, 24 de agosto de 2022
4234367 - Ventana seleccion no aparece al momento de abrir Optimizer desde Toad. Como reestablecer al predeterminado.

Cuando se trata de abrir SQL optimizer desde Toad. Este no da la opcion de seleccionar la version de Optimizer que abrir. Por defecto, Toad abrira...

Criado: quarta-feira, 24 de agosto de 2022
4242325 - No capaz de ver datos en JSON

Hay datos en JSON en la base de de datos de DB2 10.5 que no pueden ser vistos.

Criado: quarta-feira, 24 de agosto de 2022
4246462 - Nada pasa cuando se clickea en el botón de "Schedule for automation"

En la ventana de automatización, nada pasa cuando  se utiliza el botón de "Schedule for automatiion" es usado. Se espera que esta ventana aparezca...

Criado: quarta-feira, 24 de agosto de 2022
4261234 - Object Explorer como encontrar el Owner del Schema

Cómo se puede encontrar el Owner de un Objeto?  Ingresando el nombre en la leyenda devuelve los objetos de la base de datos, pero no el Owner de...

Criado: quarta-feira, 24 de agosto de 2022
4248976 - Soporta el cliente de SQL Analisis de Toad for DB2 Windows 7

Soporta el cliente de SQL Analisis de Toad for DB2 Windows 7

Criado: quarta-feira, 24 de agosto de 2022
4335513 - ¿Dónde puedo encontrar el "License Number"/"Número de Licencia" en Toad for DB2?

¿Toad for DB2 muestra el número de licencia? ¿Es posible usar la Consola para encontrar el Número de Licencia?

Criado: quarta-feira, 24 de agosto de 2022
4273678 - ¿Dónde puedo ver threads ejecutandose desde Toad?

¿Dónde puedo ver threads ejecutandose desde Toad?

Criado: quarta-feira, 24 de agosto de 2022
4241784 - Donde puedo encontrar VPAT, Seccion 508 y accesibilidad de información a todos los productos

Donde puedo encontrar VPAT, Seccion 508 y accesibilidad de información a todos los productos?

Criado: quarta-feira, 24 de agosto de 2022
4310973 - Documentación para componente z/ OS 5.0 perdido. ¿Dónde está la documentación para el componente z/ OS?

¿Dónde está la documentación para el componente  z /OS? Dentro de la nota de la guia de instalación, menciona que z /OS puede ser encontrado en...

Criado: quarta-feira, 24 de agosto de 2022
4290965 - ¿Qué versiones de Toad todavía son compatibles?

¿Qué versiones de Toad todavía son compatibles? ¿Cómo puedo saber el final del ciclo de vida para las versiones particulares de...

Criado: quarta-feira, 24 de agosto de 2022
4258753 - Al alterar una tabla se usa un script "Drop" en lugar de un "Alter".

Al cambiar el nombre de una columna de PMT_RCVD_DT a PMT_RCVD_TS y el atributo de DATE A TIMESTAMO, el ddl deberia de de estar como el siguiente...

Criado: quarta-feira, 24 de agosto de 2022
4242866 - "Maximum number of trial keys reached" error al entrar la clave de prueba"

Al introducir mi clave de prueba me sale un "Maximum number of trial keys reached" error.

Criado: quarta-feira, 24 de agosto de 2022
4281596 - "SQL5005C system error" error generado cuando intenta conectar a DB2

Error aparece  cuando intenta  conectar a DB2  "SQL5005C system error" 

Criado: quarta-feira, 24 de agosto de 2022
4265807 - ¿Cómo puedo determinar qué versión .NET tengo instalado en el ordenador?

¿Cómo puedo determinar qué versión .NET tengo instalado en el ordenador?

Criado: quarta-feira, 24 de agosto de 2022
4290047 - El Instalador MSI da un error de privilegios en Windows 7.

El Instalador MSI da un error de privilegios en Windows 7. Da el siguiente error: Usted no tiene el privilegio de realizar la instalación. Por...

Criado: quarta-feira, 24 de agosto de 2022
4283527 - Error de Toad con instancia de DB2

Toad cae con instancia de DB2, cuando termina el cálculo de espacio. El log indica que Toad.exe esta generando un signo #11 y la instancia de DB2 cae.

Criado: quarta-feira, 24 de agosto de 2022
4308934 - El archivo de instalacion de Toad for DB2 LUW y z/OS tienen el mismo tamano. Es el mismo instalador ?

El archivo de instalacion de Toad for DB2 LUW y  z/OS tienen el mismo tamano. Es el mismo instalador ?

Criado: quarta-feira, 24 de agosto de 2022
4266136 - Error de instalacion de Toad:The installer was not able to complete successfully

Toad no puede continuar con la instalacion:  Cuando se intenta instalar Toad presenta el siguiente error :  El error ocurre con el archivo .exe...

Criado: quarta-feira, 24 de agosto de 2022
4307577 - La instalacion de Toad para SQL Server se detiene en la siguiente ventana: "Preparing configuration files, it may take..."

La instalacion de Toad para SQL Server se detiene o congela  en la ventana "Preparing configuration files, it may take several minutes."

Criado: quarta-feira, 24 de agosto de 2022
4325967 - Como transferir automaticamente la longitud de cada columna al asistente para exportar?

Cuando se intenta exportar usando el click derecho sobre la  grilla de datos, 'Export | Export Wizard '  podría ser posible tener la  longitud de...

Criado: quarta-feira, 24 de agosto de 2022
4232316 - ¿Toad for z/OS soporta autenticación PAM?

¿Toad for DB2 soporta autenticación PAM?  ( Como sistemas tipo Centrify )

Criado: quarta-feira, 24 de agosto de 2022
4233936 - Drop / Create Carga sentencia invalida

Cuando se altera una tabla al borrar una columna, la carga de la sentencia (el script) no refleja  este cambio.  Por ejemplo, todos los datos...

Criado: quarta-feira, 24 de agosto de 2022
4322521 - Exportando numeros a Excel escribe solamente texto en lugar de numeros

Exportando numeros a Excel escribe solamente texto en lugar de numeros

Criado: quarta-feira, 24 de agosto de 2022
4244764 - Conteos extras de 'Commit' y 'Rollback' agregados por Toad no se ven en el procesador de la linea de comandos.

Al ejecutar el siguiente enunciado , hay diferentes incrementos de 'Commit' y  'rollback', en Toad o en el procesador de la linea de comandos...

Criado: quarta-feira, 24 de agosto de 2022
4290597 - Comment télécharger un installateur commercial ? Besoin d’un installateur par FTP ou courrier

Comment télécharger un installateur commercial à partir du Portail de Support Quest ? Dans certaines situations, une erreur se produit...

Criado: quarta-feira, 24 de agosto de 2022
4290597 - Cómo descargar el instalador de la versión Comercial? Necesita el Instalador por FTP o correo

Cómo descargar la versión comercial del instalador  desde el portal de Quest Support    En algunas situaciones, se presenta un error durante la...

Criado: quarta-feira, 24 de agosto de 2022
4312401 - Como generar un reporte de Cardinalidad Indexada

Cuáles son los pasos en Toad para producir un reporte de Cardinalidad Indexada?

Criado: quarta-feira, 24 de agosto de 2022
4249922 - ¿Cómo migrar un subset de datos de una tabla a otra ?

Necesito migrar un pequeño número de filas basado en una consulta de un 'SELECT' ( SELECT FROM  X  WHERE id =111) desde una tabla en un subsistema...

Criado: quarta-feira, 24 de agosto de 2022
4308153 - Como prevenir que Toad solicite a cada usuario incluir la licencia?

Cómo prevenir que Toad pida a cada usuario que introduzca la licencia? Cómo implementar en silencio la licencia para que los usuarios de...

Criado: quarta-feira, 24 de agosto de 2022
4262154 - Como remover una conexion con categoria de color

En Toad for DB2 LUW y z OS,¿cómo puedo borrar la conexión con categoria de color? Tengo algunos colores que se muestran en la lista de categoria...

Criado: quarta-feira, 24 de agosto de 2022
4270725 - Comment effectuer une demande de clé de license pour un produit Quest?

Comment retrouver ses informations de licence ("Authorization Key/Clé d'autorisation" et "Site Message/Message de Site") pour un produit Quest?

Criado: quarta-feira, 24 de agosto de 2022
4317926 - Como solicitar una copia electronica de una factura para una nueva compra o renovacion de un contrato

Cómo solicitar una copia electronica de una factura para una nueva compra o de una renovación de un contrato de soporte

Criado: quarta-feira, 24 de agosto de 2022
4296232 - Como realizar una desinstalacion silenciosa desde 'Quest Installer' que maneja muchos productos Quest

Como realizar una desinstalacion silenciosa desde 'Quest Installer' que maneja muchos productos Quest

Criado: quarta-feira, 24 de agosto de 2022
4296071 - Cómo abrir o levantar Toad Data Point con una conexión ODBC a través de línea de comandos?

Cómo abrir o levantar  Toad Data Point (o cualquiera de los productos Toad Studio ) como ya se ha conectado a una conexión ODBC...

Criado: quarta-feira, 24 de agosto de 2022
4307274 - Como apagar el auto commit?

Cómo apagar el auto commit?

Criado: quarta-feira, 24 de agosto de 2022
4242593 - Generacion incorrecta de DDL para base de datos en UTF8

Cuando se crea una tabla en DB2 10.5  con una base de datos fixpack 5 en UTF8 por ejemplo: CREATE TABLE TEST.TEST_TABLE ( MYCOL VARCHAR(10...

Criado: quarta-feira, 24 de agosto de 2022
4227229 - No se puede guardar reporte en Toad en formato .tdr

Después de crear un nuevo reporte en Toad Data Report. guarda el reporte como archivo con extensión REPX en lugar de .TDR.  Por qué?

Criado: quarta-feira, 24 de agosto de 2022
4335532 - No son desplegados Triggers y Views

Explorando através de los objetos de DB2 la mayoría de los objetos pueden ser vistos sin problema, pero la lista de 'Triggers'  y 'Views...

Criado: quarta-feira, 24 de agosto de 2022
4307643 - Cuáles son los nombres de los ejecutables ( .EXE) de los productos de la familia de Toad

Cuáles son los nombres de algunos archivos ejecutables ( .EXE) de los productos de la familia de Toad, con el propósito de dar seguimiento para...

Criado: quarta-feira, 24 de agosto de 2022
4270658 - Que es un "License number" y como buscar el "license number" en Toad for Oracle. Error de numero de licencia invalido.

Cómo se puede buscar el número de licencia o "License number" en Toad for Oracle? Cuál es la diferencia entre "License number" y "License key" o...

Criado: quarta-feira, 24 de agosto de 2022
4289189 - Como crear una nueva conexion en Toad for DB2? Adonde crear la entrada del catalogo?

Como crear una nueva conexion en Toad for DB2?  Adonde crear la entrada del catalogo?

Criado: quarta-feira, 24 de agosto de 2022
4311321 - Error "No se puede ejecutar esta aplicación en el equipo" al instalar después de descargar.

Toad ha sido descargado desde el sitio web a una PC con Windows 8.x. Cuando se ejecuta, el siguiente error de Windows aparece: "No se puede...

Criado: quarta-feira, 24 de agosto de 2022
4310867 - Error "The process cannot access the file location\filename because it is being used by another process" Cuando se intenta guardar Database Map por una segunda vez

Cuando se intenta guardar Database Map por una segunda vez se representa el error siguiente: "The process cannot access the file location...

Criado: quarta-feira, 24 de agosto de 2022
4269339 - Error en package 'SQL0805N Package "DSNTEST.NULLID.SYSSH200.5359534C564C3031" was not found'

Usuario instaló Toad for DB2 Trial 4.6. Intentó conectar y recibió error siguiente:   'ERROR 'SQL0805N  Package "DSNTEST.NULLID.SYSSH200...

Criado: quarta-feira, 24 de agosto de 2022
4291012 - ¿Qué versión de Toad for Db2 soporta Z OS 7.1?

¿Qué versión de Toad for Db2 soporta Z OS 7.1?

Criado: quarta-feira, 24 de agosto de 2022
4312547 - ¿Qué versiones de Toad for DB2 para z / OS soportan DB2 para z/ OS 10 ?

¿Qué versiones de Toad for DB2 para z / OS soportan DB2 para z/ OS 10 ?

Criado: quarta-feira, 24 de agosto de 2022
4268296 - Con que se completa el nombre de Data Sharing Group?

PREGUNTA:  Con qué información adicional se completa el Data Sharing Group ?

Criado: quarta-feira, 24 de agosto de 2022
4230483 - Hay una linea de comando API disponible para Toad for DB2?

Hay una linea de comando API disponible para Toad for DB2? Si es asi, hay una linea de comandos de referencia para Toad for DB2

Criado: quarta-feira, 24 de agosto de 2022
4234945 - ¿Hay una versión msi de la instalación?

En la página de descarga del producto, el archivo de instalación es un exe. Sin embargo, algunas empresas no permiten descargas de archivos exe...

Criado: quarta-feira, 24 de agosto de 2022
4307334 - Licencia para Toad for DB2 no funciona. 'Error: This license key cannot be used for this product'

Licencia o llave de autorización para Toad for DB2 no está funcionando. Mensaje de error que se genera es el siguiente: 'Error: This license key...

Criado: quarta-feira, 24 de agosto de 2022
4261595 - Error en Licencia, cuando se trata de ingresar la llave de autorizacion: "Invalid license key

El usuario recibe mensaje  "Invalid key" o "Invalid Invalid License key or site message"  cuando intenta registrar la licencia en Toad for DB2.

Criado: quarta-feira, 24 de agosto de 2022
4289156 - Cuando Toad esta inactivo detras de otra ventana se presenta un error en Toad

Cuando Toad esta inactivo detras de otra ventana, se presenta un error en Toad, el error se logra apenas ver en el borde de la ventana que esta...

Criado: quarta-feira, 24 de agosto de 2022
4312775 - Al insertar la sentencia desde un copiar y pegar al 'data Grid' se tiene un formato incorrecto debido a una columna de datos bit.

Cuando se busca datos en el 'gird' para una tabla con un caracter en un columna de datos bit y luego copiar los datos para crear la sentencia...

Criado: quarta-feira, 24 de agosto de 2022
4278390 - Puede Toad for DB2 ser corrido junto con otra version diferente de Toad for DB2 ?

PREGUNTA: Puede Toad for DB2 ser ejecutado junto con otra version diferente de Toad for DB2 ?

Criado: quarta-feira, 24 de agosto de 2022
4246523 - Problemas comunes de conexiones en DB2

Cómo solucionar errores de conexión al conectarse a una base de datos DB2. Algunos problemas de conexión que pueden surgir ... Problema 1...

Criado: quarta-feira, 24 de agosto de 2022
4226020 - Comentarios debajo del cuerpo del procedimiento no son desplegados en el "Object Explorer"

Cuando se ejecuta un procedimiento como un script en el editor de Toad for DB2, si el DDL de este Procedure tiene comentarios abajo del cuerpo del...

Criado: quarta-feira, 24 de agosto de 2022
Revisado
4334636 - CryptographicException error when installing Toad into a Citrix virtualization environment,

When installing Toad into a Citrix virtualization environment, you might encounter the following Toad error message:  “CryptographicException. The...

Revisado: quarta-feira, 24 de agosto de 2022
4275447 - Creators (Schemas) are not showing when running select distinct(creator) from sysibm.systables

All of the creators (schemas) within the database should appear. Toad appears to be filtering the list. From another view of just the schemas...

Revisado: quarta-feira, 24 de agosto de 2022
4279063 - Creating federation objects, where are they?

QUESTION: Where do I find objects of federation database?

Revisado: quarta-feira, 24 de agosto de 2022
4286097 - Creating a catalogue gave the error 'SQL10007N Message "-1390" could not be retrieved.

Using the Client Configuration Wizard to create on single client caused the error: 'SQL10007N Message "-1390" could not be retrieved. Reason code...

Revisado: quarta-feira, 24 de agosto de 2022
4252426 - Create/alter bufferpool error

Create/alter bufferpool error with following settings: Number of Block Pages = Null Block Size = Null Automatic = False Wrong number of...

Revisado: quarta-feira, 24 de agosto de 2022
4288843 - Create Database Script with wrong Storage Groups

When creating a database using the database script in Toad for DB2 version 7.4, it removes part of the path thus creating in the wrong storage group.

Revisado: quarta-feira, 24 de agosto de 2022
4238926 - CREATE DATABASE with AUTOMATIC STORAGE NO -- Toad shows AUTOMATIC STORAGE YES on Script Tab and E

CREATE DATABASE with AUTOMATIC STORAGE NO -- Toad shows AUTOMATIC STORAGE YES on Script Tab and Extract DDL

Revisado: quarta-feira, 24 de agosto de 2022
4273858 - Could not get temporary password email from Quest supportlink

User forgot password to login Quest supportlink so he clicked on 'Forgot password'  link. A temp password was sent via email, but user has not yet...

Revisado: quarta-feira, 24 de agosto de 2022
4284987 - Copying and Pasting data in Database Explorer

Revisado: quarta-feira, 24 de agosto de 2022
4310355 - Copy contents of results grid with headers fails with error "Exception: System.NullReferenceExcep

Run a query. Highlight home cell of results grid to select all rows then Edit | Copy Select "rows with headers" and failure occurs...

Revisado: quarta-feira, 24 de agosto de 2022
4290324 - Conversion error during import into table with hidden column.

When there is a table with hidden column it is not possible to import data into it using Import Wizard. Conversion error appears at the end of the...

Revisado: quarta-feira, 24 de agosto de 2022
4274321 - Connection, Installing LUW cannot create a catalog entry

Thanks for sharing the key. I tried to install Toad for DB2 LUW Xpert Edition. But cannot create a catalog entry and see a weird error:  Gave...

Revisado: quarta-feira, 24 de agosto de 2022
4331864 - Connection window does not show up in Schema Compare

From menu Tools | Compare |Schema Compare,  the Connection window does not show up in Schema Compare.

Revisado: quarta-feira, 24 de agosto de 2022
4290547 - Connection screen shows "DB2 Client at version 0.0. Please install DB2 Client"

When attempting to connect to a DB2 instance, the connection displays "DB2 Client at version 0.0. Please install DB2 Client".

Revisado: quarta-feira, 24 de agosto de 2022
4317603 - Connection Manager filter deactivated after connecting to a database

In the Connection Manager, enter a value (like a database name) in the "Type to filter list" field. This limits the connections shown to those...

Revisado: quarta-feira, 24 de agosto de 2022
4254370 - Connection issues with Toad for DB2 Beta or Freeware version.

Inputting the licensed key generated by Quest Support Admin generates the message: Database Error: DB2 ZOS connections are not currently...

Revisado: quarta-feira, 24 de agosto de 2022
4243372 - Connection Error: System.IO.FileNotFoundException - File or assembly name DB2AdminWrapper, or one

Upon trying to log into the user's DB2 database via Toad they receive an error stating System.IO.FileNotFoundException - File or assembly name...

Revisado: quarta-feira, 24 de agosto de 2022
4297096 - Connection Error: "The type initializer for 'IBM.Data.DB2.DB2Connection' threw an exception. Or

Upon trying to log into the user's DB2 database via Toad, the following error message is received: "The type initializer for 'IBM.Data.DB2...

Revisado: quarta-feira, 24 de agosto de 2022
4283275 - Connection error: "object reference not set to an instance of an object."

Customer had DB2 client v 8.2 installed before Toad for DB2. After install Toad he tried to connect to database and got error: "object reference...

Revisado: quarta-feira, 24 de agosto de 2022
4279243 - Connection error: ERROR [08001] [IBM] SQL1336N The remote host "<server_name>" was not found. SQLSTATE=08001.

Unable to connect to the database with port number. The following error message appears: ERROR [08001] [IBM] SQL1336N The remote host "<server...

Revisado: quarta-feira, 24 de agosto de 2022
4239111 - Connecting to a subsystem running DB2 in compatibility mode is not supported

Receiving the following error in Toad for DB2: "Connecting to a subsystem running DB2 in compatibility mode is not supported"

Revisado: quarta-feira, 24 de agosto de 2022
4334497 - Configure the Debugger Session Manager (DB2UDSMD) not using the default port 4553

It is possible to configure the Debugger so it does not use the default port? Data Studio supports setting the port any value.

Revisado: quarta-feira, 24 de agosto de 2022
4241448 - Compression Analysis fails with error SQL0952N on large table

Getting error SQL0952N when trying to do a Compression Analysis for large tables. 

Revisado: quarta-feira, 24 de agosto de 2022
4279952 - Compiling a Z/OS procedure gives the error: "ERROR [22001] [IBM][DB2] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large..."

When I try to compile a Z/OS procedure in Toad, I get the following error. I can compile using DB2 native tool but not Toad. ERROR [22001] [IBM...

Revisado: quarta-feira, 24 de agosto de 2022
4248072 - Compare Schema object fails to show target only objects

When comparing schema in 2 separate databases (i.e. dev to test) target only objects are not shown in the Review Comparison Report.

Revisado: quarta-feira, 24 de agosto de 2022
4210269 - Compare Result Sets Fails when Decimal datatype is used - System.NotImplementedException

When comparing Result Sets of a query the operation fails with System.NotImplementedException

Revisado: quarta-feira, 24 de agosto de 2022
4296195 - Compare Object is slow when connecting to the Target db, and "Object reference not set to an instance of an object" error is also received.

When trying to compare an object from 1 database to another, it is extremely slow when trying to connect to the Target database, and then when...

Revisado: quarta-feira, 24 de agosto de 2022
4246324 - Compare Object, Migrate Object, and Schema Compare features create files on the machine to sto

When using the Compare Object, Migrate Object, or Schema Compare feature, if migrating data, Toad creates a script that stores the data in files...

Revisado: quarta-feira, 24 de agosto de 2022
4241385 - Compare Object fails when comparing Nicknames with specification only indexes, error "Params can't be null"

Compare Object fails when comparing Nicknames with specification only indexes fail with the error "Params can't be null" Stack Trace: at Quest...

Revisado: quarta-feira, 24 de agosto de 2022
4238163 - Compare Object freezes if run with "Format Object Body Before Comparing" option selected

When doing a Compare Object, with the "Format Object Body Before Comparing" option selected, it hangs and does not complete.

Revisado: quarta-feira, 24 de agosto de 2022
4253498 - comments between CREATE and BEGIN disappeared

Revisado: quarta-feira, 24 de agosto de 2022
4231909 - Comments after the FROM clause causes the error, "SQL0198N"

Revisado: quarta-feira, 24 de agosto de 2022
4322655 - Columns with datatype of DATE does not export when exporting to an Excel Instance

When exporting to an Excel Instance, if you try to export data from a column with DATE datatype, all the values in column are null on the spreadsheet.

Revisado: quarta-feira, 24 de agosto de 2022
4234500 - Columns do not appear in ER Diagrams or SQL Query Builder

Column names do not appear in ER Diagrams or SQL Query Builder after they have been dragged and dropped into the diagram window. Also the...

Revisado: quarta-feira, 24 de agosto de 2022
4221652 - Column filter on Table Data tab does not return all rows.

Revisado: quarta-feira, 24 de agosto de 2022
4283423 - Column Change not processing using Toad for DB2 v 4.5 alter table

User used Toad for DB2 v 4.5.1 to alter a table on DB2 v 9.7, changed NOT NULL to NULL column then genrated a script and excuted it. It shown...

Revisado: quarta-feira, 24 de agosto de 2022
4318374 - Column "position" is no longer available in tables or views in Object Explorer

The column "position", that contains the number of the row, is not available for Tables or Views. The position column is only available for...

Revisado: quarta-feira, 24 de agosto de 2022
4283692 - CLI error if there is a space between the Host variable and the colon

Toad throws a DB2 CLI error if there is a space between the Host variable and the colon (:).

Revisado: quarta-feira, 24 de agosto de 2022
4296330 - Checking the 'A single new table' option in the Import Wizard creates the table but does not impo

In the 'Select Target' window of the Import Wizard, 'A single new table' is checked and a new table name is entered; however, when the process is...

Revisado: quarta-feira, 24 de agosto de 2022
4240040 - Changing tablespace properties isn't reflected in the alter script

When changing a tablespace in the Alter Tablespace window to Universal Tablespaces properties, some of the changes (DSSIZE) aren't reflected in the...

Revisado: quarta-feira, 24 de agosto de 2022
4238515 - Changes to the connection manager in Toad for DB2 6.0

This article contains a video that discusses the changes that were made to the connection manager in Toad for DB2 6.0.

Revisado: quarta-feira, 24 de agosto de 2022
4311446 - Changes in User Interface (UI) in Toad for DB2 LUW and z/OS 6.0

This video walks through the changes in User Interface (UI) for both Toad for DB2 LUW and z/OS

Revisado: quarta-feira, 24 de agosto de 2022
4282920 - Change packageset from default from NULLID.SYSSH200 to NULLIDR1.SYSSH200

How do I change the package set in TOAD to use a different one?  It uses the NULLID.SYSSH200 and I want to try NULLIDR1.SYSSH200 and NULLIDRA...

Revisado: quarta-feira, 24 de agosto de 2022
4274639 - Centralizing DB2 cataloges in default DB2 client

Currently Toad creates and uses TOADCnn as DB2 client. User wants to have Toad for DB2 using either TOADCnn or default DB2 client. If possible...

Revisado: quarta-feira, 24 de agosto de 2022
4275688 - Catalog | Export Profile error: “Profile export failed: SQL5062N An invalid pointer was passed within the sqlfupd structure to Configuration Services.

Unable or cannot export Catalog for connections. Receiving the error below.  Doing this via the DB2 Command Line Processor (CLP) also receives the...

Revisado: quarta-feira, 24 de agosto de 2022
4274093 - Cant install update even if I am logged in as an administrator

It is not possible to install the update package even if I am logged in as an administrator.

Revisado: quarta-feira, 24 de agosto de 2022
4273874 - Cannot  enter timestamp on Taken At Time to restore a tablespace

User tried to restore a tablespace which was backed up on tape (TMS) by Tivoli weekly. On restore options from Toad for DB2, user wanted to enter...

Revisado: quarta-feira, 24 de agosto de 2022
4226126 - Cannot use deploy, bind or rebind packages in database.

Revisado: quarta-feira, 24 de agosto de 2022
4314613 - Cannot sort Timestamp fields in Data Grid.

When clicking on the column header of  Timestamp columns, column is not sorted.    In previous versions of Toad (v2.5), this sorting capability...

Revisado: quarta-feira, 24 de agosto de 2022
4335475 - Cannot see the scripts of the tables

Cannot see the scripts of the tables. Steps to reproduce the problem: 1.Go to the Schema Browser 2.Select a table 3.On the right hand panel...

Revisado: quarta-feira, 24 de agosto de 2022
4330563 - Cannot see list of application for database version 9.1

When selecting a database in the Object or Database Explorer and then the Applications tab in the Object Details panel,it is not possible to see...

Revisado: quarta-feira, 24 de agosto de 2022
4227148 - Cannot perform a Runstats when selecting multiple tablespaces.

Not able to create the following runstats statement on multiple tablespaces. Forced to work on each tablespace individually to create the runstat...

Revisado: quarta-feira, 24 de agosto de 2022
4228405 - Cannot launch Toad after improper shut down. Receievs a Toad is not responding error.

While working in Toad on what seemed to be a long running query, Toad freezed.  The process was still running with high CPU in Task Manager.  Then...

Revisado: quarta-feira, 24 de agosto de 2022
4327887 - Cannot launch Spotlight on DB2 from Toad for DB2

Spotlight on DB2 does not seem to be able to be launched from Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4272275 - Cannot insert license key: "The necessary MySQL Files are not installed."

After installing Toad for DB2 5.0 and trying to open it, Toad pops-up a window requesting for the Authorization Key and Site Message, despite that...

Revisado: quarta-feira, 24 de agosto de 2022
4347285 - Cannot find the option "Schema Compare "

Cannot find the option "Schema Compare ". According the help this option should be in Tools | Compare but it is not listed there.

Revisado: quarta-feira, 24 de agosto de 2022
4231715 - Cannot find Toad Data Point trial that supports IBM DB2 64bit client.

The currently available Toad Data Point trial download from the Quest Software page does not support use with IBM DB2 64bit client. Doad Toad Data...

Revisado: quarta-feira, 24 de agosto de 2022
4283373 - Cannot estimate index size

Revisado: quarta-feira, 24 de agosto de 2022
4232308 - Cannot download since Support Portal keeps asking to login and/or register as a user, even when already logged in.

On the Support Portal, when trying to download an installer, the Support pages keeps prompting to register as a user. But the user has already...

Revisado: quarta-feira, 24 de agosto de 2022
4333595 - Cannot create explain plan tables

Revisado: quarta-feira, 24 de agosto de 2022
4335224 - Cannot connect to the database after the computer disk was replaced

Cannot connect to the database after the computer disk was replaced. It is possible to connect to the database with other tools and from other...

Revisado: quarta-feira, 24 de agosto de 2022
4231923 - Cannot add, delete, or modify catalog entries in DB2 client

Revisado: quarta-feira, 24 de agosto de 2022
4234964 - Cannot access IBM DB2 native tools after installing Toad for DB2 2.0 with previous install of DB2

After installing Toad for DB2 2.0 an error is given when trying to launch other IBM DB2 tools (i.e. Client Configuration Assistant, Control Center...

Revisado: quarta-feira, 24 de agosto de 2022
4329397 - Cancelling a running query does not work

Steps to reproduce the issue: 1) Change database rows limit option of 1000 to apply to the editor (Tools | Options |Database | General...

Revisado: quarta-feira, 24 de agosto de 2022
4226333 - Can't login to Toad. What is the Toad password? Where do I get my login credentials? What is my user name and password?

Cannot or unable to login. What is the Toad password? Where do I get my login credentials? What is my username and password? The account is...

Revisado: quarta-feira, 24 de agosto de 2022
4330120 - Can't install Toad_for_DB2_2019_Full.exe: installer complains that the product requires .Net 4.7.1 but this version is already installed.

Cannot install Toad for DB2. The installer complains that the product requires .Net 4.7.1 but this version is already installed.

Revisado: quarta-feira, 24 de agosto de 2022
4241981 - Can you copy the Settings.xml file to different machines?

Can you copy the Toad for DB2 'Settings.xml' file to different machines?

Revisado: quarta-feira, 24 de agosto de 2022
4307888 - Can we turn OFF format SQL option from Toad for DB2?

During debugger process (F7), Toad formated SQL statement, made hard to follow. So can user turn off format SQL option?

Revisado: quarta-feira, 24 de agosto de 2022
4235871 - Can Toad show comments that are both outside and inside the SQL body, along with the exact statement that was used to create the procedure?

When creating a procedure that has comment statements both outside and inside the SQL body, can Toad show those comments along with the exact...

Revisado: quarta-feira, 24 de agosto de 2022
4297490 - Can TOAD for DB2 handle proxy connections via SSH/SSL/VPN?

Can TOAD for DB2 handle proxy connections via SSH/SSL/VPN?

Revisado: quarta-feira, 24 de agosto de 2022
4289514 - Can Toad for DB2 compare different kinds of databases i.e. DB2, Oracle, SQL Server?

Can Toad for DB2 compare different types of databases i.e. DB2, Oracle, SQL Server?

Revisado: quarta-feira, 24 de agosto de 2022
4313513 - Can Toad for Data Analysis be installed alongside other Toad products?

Can Toad for Data Analysis be installed alongside other Toad products?

Revisado: quarta-feira, 24 de agosto de 2022
4232286 - Can the edit feature of the data grid be disabled?

Can the edit feature of the data grid be disabled? It is a risk to use it in a production environment.

Revisado: quarta-feira, 24 de agosto de 2022
4276010 - Install error "An error occurred while retrieving information used to install on this computer"

When the install nears completion and approaches the registration product, it generates the below message: "An error occurred while retrieving...

Revisado: quarta-feira, 24 de agosto de 2022
4273814 - Insert statement is taking up a large amount of memory on workstation

A SQL statement with select, insert command was issued from Toad for DB2. It selected data from  multiple tables, each of them containing several...

Revisado: quarta-feira, 24 de agosto de 2022
4241971 - Indexes show as different, due to PRIQTY and SECQTY values, even with "Ignore PRIQTY & SECQTY" option selected

While comparing objects, if the "Ignore PRIQTY & SECQTY" option is selected, indexes still show as different due to differences in their PRIQTY and...

Revisado: quarta-feira, 24 de agosto de 2022
4227346 - Indexes missing for the Space Calculator tool

Revisado: quarta-feira, 24 de agosto de 2022
4244350 - Incorrect user is defined when doing an advanced alter

When doing an advanced alter, the alter script which is generated is owned by the instance user, rather than the user which it was generated with...

Revisado: quarta-feira, 24 de agosto de 2022
4269712 - Incorrect statement generated for ALTER INDEX include column

In v5.6, the wrong type of SQL statement is generated when altering an index Include column. This should be done with an Alter Index statement...

Revisado: quarta-feira, 24 de agosto de 2022
4242179 - Incorrect storage group shown when comparison report is sent to editor

When doing an Object Compare to compare databases, one of the Transformational Rules that is changed is for the Target’s Storage Group.  Lets say...

Revisado: quarta-feira, 24 de agosto de 2022
4283884 - Incorrect script is displayed in the script tab of Explorer

When a procedure without dimension is created Toad for DB2 generates the script for the procedure/function with the default dimension.

Revisado: quarta-feira, 24 de agosto de 2022
4225678 - Incorrect schema migration scripts created or aborts if chose to run now.

When trying to migrate databases with Toad for DB2 3.0.0. I can create scripts for the migration but cannot use the Execute Scripts Now option. If...

Revisado: quarta-feira, 24 de agosto de 2022
4243326 - Incorrect Rebind syntax and Runstats order

Revisado: quarta-feira, 24 de agosto de 2022
4216434 - Incorrect result when there are unpaired quote-marks in a comment within the query

These are the queries: with t1(EML) as -- Bad comment '' (with unbalanced quote)  ( values 'a@b.c' , 'd@e.f' , 'f@h.i...

Revisado: quarta-feira, 24 de agosto de 2022
4282927 - Incorrect partitioned indices

User displayed DDL of table with 4 partition tablespaces from Toad for DB2 v 4.7. It shown without indexes below: CREATE TABLE "ZWBPMT"."M_NPF_FC...

Revisado: quarta-feira, 24 de agosto de 2022
4244996 - Incorrect number of rows retrieved

Revisado: quarta-feira, 24 de agosto de 2022
4241523 - When using REBUILD View, the CREATE VIEW script is generated without aliases on the columns

When using the"Rebuild View" option for an INVALID view that has aliases on columns, the CREATE VIEW script is generated without aliases on the...

Revisado: quarta-feira, 24 de agosto de 2022
4335489 - When Updating a Column a very complicated SQL is generated and executed

After updating one field in a table, once the field data is overwritten and the refresh button clicked, a complex sql statement is generated and...

Revisado: quarta-feira, 24 de agosto de 2022
4268908 - When trying to save the output from the grid window, the Save As... dialog freezes.

When trying to save the output from the grid window, the Save As... dialog freezes. This issue started in Toad for DB2 v7.1.

Revisado: quarta-feira, 24 de agosto de 2022
4249354 - When trying to execute DROP PACKAGE statement generated by Toad 5.6, there's an error message 'SQL01

When trying to execute DROP PACKAGE statement generated by Toad 5.6, there's an error message 'SQL0199N'. Toad 5.6 generates script as follows...

Revisado: quarta-feira, 24 de agosto de 2022
4237679 - When trying to connect, the connection screen just blinks and nothing else happens

After clicking the Connect button, the connection screen just flashes and nothing else happens.  The connection window is still there and can be...

Revisado: quarta-feira, 24 de agosto de 2022
4238347 - When trying to Alter existing Stored Procedure a Create or Replace DDL is generated instead

When trying to ALTER an existing Stored Procedure, Toad generates complete CREATE PROCEDURE DDL instead of a simple ALTER statement.

Revisado: quarta-feira, 24 de agosto de 2022
4268471 - When Toad SQL Analysis support DB2 v 9.7?

Revisado: quarta-feira, 24 de agosto de 2022
4228531 - INTERNAL: Error, "Configuration system failed to initalize" when starting Toad for DB2

When launching Toad for DB2 after a successful install, the following stack error occurs: System.Configuration.ConfigurationErrorsException...

Revisado: quarta-feira, 24 de agosto de 2022
4274215 - Long startup time and hanging during the closing of the application.

Long startup time and hanging during the closing of the application.

Revisado: quarta-feira, 24 de agosto de 2022
4266318 - LONG VARCHAR error while comparing two databases

When doing a table compare and sending to Editor, it generates an Incorrect Syntax error near ‘VARCHAR’ This happens in the Reviews Comparison...

Revisado: quarta-feira, 24 de agosto de 2022
4322246 - LONG IN in specified partitioned table.

When a table is dropped  and then  altered (e.g.adding comment).  LONG IN is  specified on a partitioned table instead of using correct COMMENT ON...

Revisado: quarta-feira, 24 de agosto de 2022
4295437 - Login password with special characters generates error: "System.ArgumentException Invalid argumen

When I connect or login to my database using a password that has special characters in it, I get the error: Exception: System...

Revisado: quarta-feira, 24 de agosto de 2022
4273218 - Log4j Vulnerability CVE-2021-44228

Are Toad products affected by the Log4j vulnerability CVE-2021-44228?

Revisado: quarta-feira, 24 de agosto de 2022
4278725 - Locks were not released after error -803

User opened Editor typed a insert command to execute, he got an error -803 then Toad just kept exclusive locks. He said Quest Central for DB2...

Revisado: quarta-feira, 24 de agosto de 2022
4268620 - Locksize blockinsert not being displayed properly

The user defines a  table with Locksize blockinsert , however, the script (DDL of table)  displays Locksize is Row.

Revisado: quarta-feira, 24 de agosto de 2022
4269376 - List of available basic functionalities to manage DB2 for z/OS subsystems

The installation guides says that WITHOUT installing the Toad for IBM DB2 z/OS components Toad still provides some basic functionality to manage...

Revisado: quarta-feira, 24 de agosto de 2022
4248946 - Link provided in error message does not offer Primary Interop Assemblies for my Office version

Getting a message in the product saying that Primary Interop Assemblies (PIA) need to be installed.  However, when going to the link, there are no...

Revisado: quarta-feira, 24 de agosto de 2022
4250683 - License key is not deleting when I use the "Delete License" option in the Help | Licensing window

When I delete my license key in the Help | Licensing window, it does not actually delete.  When I go back into the window the license key is still...

Revisado: quarta-feira, 24 de agosto de 2022
4238831 - License key is not deleting when using the "Delete License" option in the Help | Licensing window

If customer has prior Toad installed with a commercial key, installing the version above will add another entry in productlicenses.xml file with...

Revisado: quarta-feira, 24 de agosto de 2022
4278979 - Launching Toad for Data Analyst gives error "Absolute Path Information is required."

Double-clicked on Toad Data Point to launch it and get the error: 'Absolute Path Information is required' Toad doesn't launch

Revisado: quarta-feira, 24 de agosto de 2022
4261683 - Kaspersky Virus pop-up with Toad For DB2 ZOS 5.0.3.

Revisado: quarta-feira, 24 de agosto de 2022
4332906 - Job manager problem

The scheduled tasks execute some times but not all the times

Revisado: quarta-feira, 24 de agosto de 2022
4325855 - It's not possible to change primary key name in a table via "alter table" when using the Database

It's not possible to change primary key name in a table via "alter table" when using the Database Browser.

Revisado: quarta-feira, 24 de agosto de 2022
4321053 - It is possible to integrate Toad For DB2 with a Microfocus XDB database?

It is possible to integrate Toad For DB2 with a Microfocus XDB database?

Revisado: quarta-feira, 24 de agosto de 2022
4301996 - It is necessary to uninstall version 5.6 in order to intall the 5.6.1 patch?

It is necessary to uninstall version 5.6 in order to intall the 5.6.1 patch? If so, Are the user settings missing in the upgrade?

Revisado: quarta-feira, 24 de agosto de 2022
4273777 - It does not seem to handle dependencies correctly when altering DB objects.

User tested on Toad for DB2 v 4.6 on database DB2 v 9.7. Changed size of primary key column of a table which has many dependent objects. Script...

Revisado: quarta-feira, 24 de agosto de 2022
4321974 - Issues with Toad for DB2 Beta or Freeware version.

Experiencing issue(s) when using Toad for DB2 Beta or Freeware version.

Revisado: quarta-feira, 24 de agosto de 2022
4237751 - Is Toad for DB2 4.0 supported in a Windows Vista 64-bit environment?

Is Toad for DB2 4.0 supported in a Windows Vista 64-bit environment?

Revisado: quarta-feira, 24 de agosto de 2022
4244818 - Is there an installer for TOAD DBA suite for DB2 LUW 5.0.3?

Revisado: quarta-feira, 24 de agosto de 2022
4240027 - Is there an installation (.exe or .msi) that comes without a trial license that is automatically applied after installation?

Is there an installation (.exe or .msi) that comes without a trial license that is automatically applied after installation?

Revisado: quarta-feira, 24 de agosto de 2022
4238655 - Is there an annual fee to keep license key legal or continue working?

Is there an annual fee to keep license key legal or continue working?

Revisado: quarta-feira, 24 de agosto de 2022
4283108 - Is there a ZOS health check feature in Toad ZOS?

Is there a feature in Toad ZOS (or SQL queries from Toad ZOS) that can run against a DB2 catalog to determine the health of a DB2 objects?  For...

Revisado: quarta-feira, 24 de agosto de 2022
4225129 - Is there a way to run Toad on a Macintosh?

I would like to run Toad for Oracle on a Macintosh platform.

Revisado: quarta-feira, 24 de agosto de 2022
4250458 - Is there a way to prevent user from accessing Toad directly from desktop with use of middle server?

Toad is currently being used from the desktop and connecting to an IBM Mainframe to access DB2 tables. Is it possible to prevent users from...

Revisado: quarta-feira, 24 de agosto de 2022
4308801 - Is there a way to generate runstats without including 'SAMPLE', but keeping 'TABLE (ALL)'?

In the Object Explorer, when generating a script for runstats on a tablespace, the statements created use 'TABLE (ALL) SAMPLE 25'.  Is there a...

Revisado: quarta-feira, 24 de agosto de 2022
4318447 - Is there a way to connect Toad for Oracle with DB2 database?

Is there a way to connect Toad for Oracle with DB2 database?

Revisado: quarta-feira, 24 de agosto de 2022
4246306 - Is there a way to commit inserts after every X records inserted?

When inserting records, is there a way to have Toad commit the records after every X amount of records?

Revisado: quarta-feira, 24 de agosto de 2022
4244256 - When launched for the first time, the toolbar icons are jumbled or smashed together

The first time Toad is launched, a Configuration Window is displayed.  During this time, the toolbar is jumbled.  When this window is canceled the...

Revisado: quarta-feira, 24 de agosto de 2022
4283293 - When I tried to unzip a Toad DB2 4.0.0.880 suite zip file that I downloaded, it asked me for a pa

I downloaded the zip file for  a Toad for DB2 4.0.0.880 suite  from SupportLink and when I try to extract the zip file, it  asked for a password...

Revisado: quarta-feira, 24 de agosto de 2022
4279171 - When I entered my license key (or authorization key) the "OK" button is still grayed out.

User unable to register TOAD for DB2.

Revisado: quarta-feira, 24 de agosto de 2022
4241863 - When extracting a DDL for a View, Toad for DB2 truncates the DDL.

When extracting a DDL for a View, Toad for DB2 truncates the DDL.

Revisado: quarta-feira, 24 de agosto de 2022
4235899 - When cursor hovers over an icon Toad did not show icon name.

When cursor hovers over an icon Toad did not show icon name.

Revisado: quarta-feira, 24 de agosto de 2022
4238614 - When creating a MQ Table with a staging table, the staging table is not included in script

When creating a MQT (Materialized Query Table) with a staging table, the staging table is not being created because the create statement is not...

Revisado: quarta-feira, 24 de agosto de 2022
4305204 - When connecting Toad for DB2 freeware edition to z/OS server getting message: "DB2 z/OS connectio

When connecting Toad for DB2 freeware edition to z/OS server getting message: "DB2 z/OS connections are not licensed."

Revisado: quarta-feira, 24 de agosto de 2022
4273957 - When clicking on the X in the top right, it closes all of SQL Analysis.

When using SQL Analysis, if user opens an "Analyze Collection", a second TAB opens on the bottom left, and a separate sub- "X", or "close window...

Revisado: quarta-feira, 24 de agosto de 2022
4249649 - When altering an index, the script that is created is not complete

When altering an index, the script that is created is missing some of the components is should have. The First Problem is that the script...

Revisado: quarta-feira, 24 de agosto de 2022
4225665 - When a tablespace has more than one container on a DB2 PureScale, the Space Calculator in Toad for DB2 shows wrong total MB value

Having a 4 member PureScale cluster with 4 GPFS (shared) filesystems: /ds/dr/ts01, /ds/dr/ts02, /ds/dr/ts03, & /ds/dr/ts04 equates to a TOTAL of 4...

Revisado: quarta-feira, 24 de agosto de 2022
4283094 - When a query is running how do I determine how long it has been running?

ENHANCEMENT REQUEST: User ran a transaction on sql builder or on Editor he has 2 questions: 1. When a query is running how do I determine how...

Revisado: quarta-feira, 24 de agosto de 2022
4307784 - What's new in version 6.1

What's new in version 6.1

Revisado: quarta-feira, 24 de agosto de 2022
4272626 - What's new in Toad for DB2 7.4.x

What's new in Toad for DB2 7.4.x

Revisado: quarta-feira, 24 de agosto de 2022
4253601 - What's new in Toad for DB2 7.1.x?

This article contains some new features released with version 7.1.x. 

Revisado: quarta-feira, 24 de agosto de 2022
4247889 - What's new in Toad for DB2 6.5?

This article contains some new features released with version 6.5. 

Revisado: quarta-feira, 24 de agosto de 2022
4261017 - What version of Toad will be bundled with DB2 client version 10?

What version of Toad will be bundled with DB2 client version 10?

Revisado: quarta-feira, 24 de agosto de 2022
4225107 - What version of Toad supports configuration with Team Foundation 2012?

What version of Toad supports version control configuration with Team Foundation 2012?

Revisado: quarta-feira, 24 de agosto de 2022
4332488 - What version of Toad for DB2 support DB2 for LUW 10.1?

Revisado: quarta-feira, 24 de agosto de 2022
4245713 - What Toad for DB2 version supports Windows 7 and IE8?

What Toad for DB2 version supports Windows 7 and IE8?

Revisado: quarta-feira, 24 de agosto de 2022
4284501 - What to do when I cannot download TOAD for Oracle from the FTP or HTTP link?

When you click on the FTP or HTTP link from http://support.quest.com/ nothing happens.

Revisado: quarta-feira, 24 de agosto de 2022
4275211 - “Knowledge Expert", Is this no longer part of the suite?

Revisado: quarta-feira, 24 de agosto de 2022
4268382 -  Is there any way we can install the 32 bit agent on a 64 bit system?

According to the TOAD DB2 LUW agent documentation, Database Server Requirements for Managed Databases The agent supports the following DB2...

Revisado: quarta-feira, 24 de agosto de 2022
4269271 -  <span id="TITLE">Got hung up during migrate objects from DB2 v8.2 FP13 to DB2 v 9.7</span></p

User tried to migrate data from db2 v 8.1.13 to DB2 v9.7 and got hung up at query for tablespace. User could run export/import the table...

Revisado: quarta-feira, 24 de agosto de 2022
4221455 - [IBM][DB2/LINUXX8664] SQL1092N failed because the user ID does not have the authority to perform

IBM.Data.DB2.DB2Exception: ERROR [] [IBM][DB2/LINUXX8664] SQL1092N  The requested command or operation failed because the user ID does not have...

Revisado: quarta-feira, 24 de agosto de 2022
4239051 - [EMEA] Showing the GRANTs for a role (or extract DDL) DATA ACCESS right is shown as CREATETAB

Showing the GRANTs for a role (or extract DDL) DATA ACCESS right is shown as CREATETAB right. so the CREATAB right might be duplicated and the...

Revisado: quarta-feira, 24 de agosto de 2022
4333924 - Wrong trackmod generated

Generating DDL for a tablespace shows the attribute TRACKMOD as YES when in fact it should be TRACKMOD = NO as it is stored in the DB2 catalog...

Revisado: quarta-feira, 24 de agosto de 2022
4309984 - Wrong syntax for partitioned tables after extended alter

When changing a column of a Table, which needs drop Recreate, the wrong DDL is generated and the Rows of the Second Partition can not be reloaded...

Revisado: quarta-feira, 24 de agosto de 2022
4334135 - Wrong result when comparing objects including privileges

Revisado: quarta-feira, 24 de agosto de 2022
4246010 - Would like way to globally change tablespace paths in compare wizard

When doing a compare, if I want to change the paths for my tablespaces in the transformation rules I have to do them one at a time.  I would like...

Revisado: quarta-feira, 24 de agosto de 2022
4335698 - Would it be possible to disable the Query Builder in Toad?

Revisado: quarta-feira, 24 de agosto de 2022
4243739 - With a UTF-8 database, CODEUNITS32 is not correct with create table script. The values are 4x higher than they should be.

With a UTF-8 database, CODEUNITS32 is not correct with create table script. The values are 4x higher than they should be. If you create a...

Revisado: quarta-feira, 24 de agosto de 2022
4339649 - Window to create schema displays and behaves incorectly

If you right click on Schemas and select Create Schema the first character of the Name field in the Create Schema window is not displayed even...

Revisado: quarta-feira, 24 de agosto de 2022
4229483 - How to disable code completion.

How to disable code completion.

Revisado: quarta-feira, 24 de agosto de 2022
4239274 - How to deploy license key with silent install using registry files

Is it possible to deploy the license key using registry files when installing silently?

Revisado: quarta-feira, 24 de agosto de 2022
4235796 - How to delete the historical data of the SQL Analysis Collection job

Is it possible to delete historical SQL Analysis collection data from within the Toad SQL Analysis for DB2 module?

Revisado: quarta-feira, 24 de agosto de 2022
4278760 - How to define (register) and save the LDAP catalogs? Can we export/import these catalogs?

QUESTION: How to define (register) and save the LDAP catalogs? Can we export/import those catalogs?

Revisado: quarta-feira, 24 de agosto de 2022
4319973 - How to customize Settings, Connections and Licenses for Toad for DB2 MSI?

How to customize Settings, Connections and Licenses for Toad for DB2 MSI? Is a customized silent installation possible?

Revisado: quarta-feira, 24 de agosto de 2022
4220652 - Error at startup of Optimizer: "This application has failed to start because Synu.dll was not fou

Error at startup of Optimizer as standalone or within Toad: "This application has failed to start because Synu.dll was not found. Re-installing...

Revisado: quarta-feira, 24 de agosto de 2022
4278847 - Error altering a partitioned index: "Indexed has collection of partitions but its type is not def

User alters a partitioned index, and script generated  the following  error:   "Indexed has collection of partitions but its type is not defined...

Revisado: quarta-feira, 24 de agosto de 2022
4227942 - Error altering a Storage Group: "Invalid Volume Specification"

A Storage Group is altered and volumes are added. Show Script option shows below error and alter script is not generated:  "Invalid Volume...

Revisado: quarta-feira, 24 de agosto de 2022
4317416 - Error after importing connections from DB2 Connect: "System.Reflection.ReflectionTypeLoadExceptio

After importing  all connections from  DB2 Connection, the following error occurs.   Issue persists even after deleting all connections and...

Revisado: quarta-feira, 24 de agosto de 2022
4317245 - Error : 'Index and length must refer to a location within the string. Parameter name: length'

When trying to update a record through Toad For DB2 version 4.0, and then trying to display it in a datagrid getting this error: 'Index and...

Revisado: quarta-feira, 24 de agosto de 2022
4242245 - Error 42704 occurs when exporting data from a Global Temp Table into a text file

When exporting data from a Global Temp Table into a text file, the following error may occur: ERROR [42704] IBM [DB2 | AIX64] SQL 0204N] "Session...

Revisado: quarta-feira, 24 de agosto de 2022
4283233 - Error 1402 during installation of Toad for DB2

User unable to install Toad for DB2 v.4.5. The installation process consistently fails with the following error message: 'Error 1402. Could not...

Revisado: quarta-feira, 24 de agosto de 2022
4278949 - Error 'Object reference not set to an instance of an object' on executing any SQL statement

User tried either to import any SQL file or to execute a SQL statement on Toad Editor and got error: 'Object reference not set to an instance of...

Revisado: quarta-feira, 24 de agosto de 2022
4236574 - Error 'Object reference not set to an instance of an object error on column' when adding a column

When adding a column to a table error Object reference not set to an instance of an object error on column may occur.

Revisado: quarta-feira, 24 de agosto de 2022
4235123 - Error 'Exception of type 'System.OutOfMemoryException' was thrown' when retrieving large data set

When retrieving a large data set from the Database Browser, the error 'Exception of type 'System.OutOfMemoryException' was thrown' may occur.

Revisado: quarta-feira, 24 de agosto de 2022
4230504 - Error 'Explain plan not available for this statement'

User tried to explain plan from Toad for DB2 v 4.7 with any SQL statement (like Select * from syscat.packages) and got error 'Explain plan not...

Revisado: quarta-feira, 24 de agosto de 2022
4335154 - Error 'An error occurred while initializing the Profile Registry. The return value is "-202905976

During a  Toad for DB2 installation, the install fails with a failure in creating DB2 global registry. The following error appears in the...

Revisado: quarta-feira, 24 de agosto de 2022
4307661 - Error "Value does not match the type of column" when trying to import into a temporal table that has hidden system generated columns.

Using Toad Import Wizard to load data into a temporal table that has hidden system generated columns. Even after opting to skip these columns in...

Revisado: quarta-feira, 24 de agosto de 2022
4276122 - Error "System.Xml.Schema.XmlSchemaException" when making a connection, after making some settings

Made some settings changes but when closing and re-launching Toad, the following error comes up for any connection attempted...

Revisado: quarta-feira, 24 de agosto de 2022
4246504 - Error "System IO.IO Exception. The file exists." when a scheduled task is run or during Toad startup

The following error(s) is displayed when scheduled automated jobs attempt to run OR or during Toad startup or launch. System.IO.IOException The...

Revisado: quarta-feira, 24 de agosto de 2022
4242727 - Error "SQL30082N Security processing failed with reason 17 (unsupported function)" when connecting.

When connecting to a DB2 database in Toad, the following error message is displayed: "SQL30082N Security processing failed with reason 17...

Revisado: quarta-feira, 24 de agosto de 2022
4229654 - Error "SQL1005N The database alias "XXXX" already exists in either the local database directory or system database directory."

When trying to create two instances in DB2 with the same name, the following message appears: "SQL1005N  The database alias "MYDB2" already...

Revisado: quarta-feira, 24 de agosto de 2022
4292043 - Error "SQC03040E - ScAdmin - Unable to locate a DB2 instance entry matching port number (52118

User attempts to run SQL Analysis but gets the error "SQC03040E - ScAdmin - Unable to locate a DB2 instance entry matching port number (52118) in...

Revisado: quarta-feira, 24 de agosto de 2022
4292521 - Error "Socket error 10061 connection refused" trying to FTP files to z/OS Mainframe.

User tries to install Quest IBM DB2 z/OS Component. One of the steps requires FTP of files to z/OS Mainframe. While trying to upload the files...

Revisado: quarta-feira, 24 de agosto de 2022
4310536 - Error "Quest.Toad.SQLRecall.SQLRecallItemExtensions" when executing a SQL Script in Editor

The following error occurs when executng a SQL script in the Editor window: NullReferenceException message : at Quest.Toad.SQLRecall...

Revisado: quarta-feira, 24 de agosto de 2022
4309599 - Error "Object reference not set to an instance of an object" when running 6.2 Suite installer

On attempting to upgrade from 6.1 to 6.2, the following error occurs on installation, using the Suite installer: "Object reference not set to an...

Revisado: quarta-feira, 24 de agosto de 2022
4310288 - Error "Index was outside the Bounds of the Array" when exporting from the Data Grid

Get the error "Index was outside the Bounds of the Array" when exporting using Export | Export Wizard from the the Data Grid.

Revisado: quarta-feira, 24 de agosto de 2022
4296221 - Error "Input string was not in a correct format" when launching TOAD for DB2.

When user double clicked on the TOAD for DB2 icon, the message "Input string was not in a correct format" was generated. When the user tried to...

Revisado: quarta-feira, 24 de agosto de 2022
4308678 - Error "Failed to connect to database" when sending query to Optimizer

When sending query from Toad to Optimizer, the following error occurs: "Failed to connect to database. [IBM] [CLI Driver] SQL1031N The database...

Revisado: quarta-feira, 24 de agosto de 2022
4310495 - Error "DB2ODBC.DLL could not be found" when trying to create a DSN from the ODBC

I get an error saying the "DB2ODBC.DLL could not be found" when trying to create a DSN from the ODBC Administrator.  I get the error after I have...

Revisado: quarta-feira, 24 de agosto de 2022
4309814 - Error "Control does not support transparent background colors" after changing background color for Editor

Change background color to Transparent is throwing an error when Editor window is opened 1. Launch Toad 2. Go to Tools | Options | Editor...

Revisado: quarta-feira, 24 de agosto de 2022
4297622 - Error "CCA3000C An internal error has occured. Reason code "49"." when importing connections f

User launches Toad and tries to import connection information from another DB2 Copy or DB2 Client and gets the following error: CCA3000C An...

Revisado: quarta-feira, 24 de agosto de 2022
4247557 - Erroneous number of row count in Analyze Table Partitioning

The row count in 'Analyze Table Partitioning', after clicking on "Refresh Graph",  shows an erroneous row count number. The value is added...

Revisado: quarta-feira, 24 de agosto de 2022
4348677 - Entering a commercial key into Toad for DB2 still shows as a trial version

When the user enters a commercial key into Toad for DB2, it still shows as the trial version.

Revisado: quarta-feira, 24 de agosto de 2022
4332458 - Entering Default value into a new table column without having the DEFAULT clause in table script.

Entering a  Default value into new column without DEFAULT clause in table. Is it possible to add a NOT NULL column to a table and enter a default...

Revisado: quarta-feira, 24 de agosto de 2022
4279118 - Enhancment to allow automation to export results and provide the option to appen

Enhancment request  to allow automation to export results and provide the option to append to an existing file ( CSV), currently have the options...

Revisado: quarta-feira, 24 de agosto de 2022
4242785 - Enhancements in the Object Compare tool in Toad for DB2 6.0 (Schema Compare missing)

This article contains a video that introduces some enhancements that were made to the Object Compare tool in Toad for DB2 6.0.

Revisado: quarta-feira, 24 de agosto de 2022
4284612 - Enhancement to support user specific connection string values

Is it possible to add specific values to connection string?

Revisado: quarta-feira, 24 de agosto de 2022
4283425 - Enhancement request:  Add ability to alter/drop user mapping

In Quest Central, a right mouse click of a User Mapping presents a menu permitting Alter... Drop... Create Like... Migrate... Compare... In TOAD...

Revisado: quarta-feira, 24 de agosto de 2022
4268683 - Enhancement request: Would like to see reports on Compare object scroll together like they do

User has reported that Tools | compare | Schema compare in the 3 pane window where it shows source script and target script side by side, he can...

Revisado: quarta-feira, 24 de agosto de 2022
4279127 - ENHANCEMENT REQUEST: Toad would open SAS Data Sets

ENHANCEMENT REQUEST: User wants to use Toad for DB2 openning SAS datasets with file type SAS7BDAT  

Revisado: quarta-feira, 24 de agosto de 2022
4269347 - ENHANCEMENT REQUEST: Needed connection staying with already connected database

ENHANCEMENT REQUEST: when launching Toad they have an internal password that resets every hour and it cont. to disconnect Toad User said...

Revisado: quarta-feira, 24 de agosto de 2022
4273409 - Enhancement Request: For "Coded Character Set Identifier" within the ALTER dialogue.

It is not possible to change the CCSID of DB2 z/OS tablespace within the ALTER dialogue. "This is a useful add"  Imagining change the CCSID of...

Revisado: quarta-feira, 24 de agosto de 2022
4274130 - ENHANCEMENT REQUEST: Clone Permissions feature

Quest Central for DB2 has Clone Permissions feature, however, Toad for DB2 isn't available

Revisado: quarta-feira, 24 de agosto de 2022
4268394 - ENHANCEMENT REQUEST: Comparing Table Privileges

Revisado: quarta-feira, 24 de agosto de 2022
4330773 - Enhancement Request to sort the Datasets in partition order

Revisado: quarta-feira, 24 de agosto de 2022
4297898 - Enhancement request to display the actual Optimization Class used when using SQL Analysis to t

User would like to know the actual Optimization Class used in DB2 when using SQL Analysis to tune a SQL statement. This parmeter has a huge...

Revisado: quarta-feira, 24 de agosto de 2022
4315214 - Enhancement request that Toad has the ability to use the explain tables to store explain informat

When having a problem that needs to be reported to IBM I found that explain information is not dumped into the explain tables, but can be saved to...

Revisado: quarta-feira, 24 de agosto de 2022
4282907 - Enhancement Request -- Compare Object -- User wants more filter/ ignore choices

User wanted to have options to ignore tablespaces or index spaces. Schema compare has options on how to handle tablespace differences, but compare...

Revisado: quarta-feira, 24 de agosto de 2022
4284223 - Enhancement Request - Enable filter feature for connection manager and group execute

Customer has 100s of databases and find it really difficult to locate the databases they want when there is a long list. Other areas of Toad have...

Revisado: quarta-feira, 24 de agosto de 2022
4268935 - How to create an event monitor

Revisado: quarta-feira, 24 de agosto de 2022
4266298 - How to create a dynamic filename for a scheduled export action? How to add / change the filename?

How to create a dynamic file name for a scheduled Export action or Execute Script action?   How to add / change the filename to have the Date...

Revisado: quarta-feira, 24 de agosto de 2022
4305823 - How to copy contents of SQL Recall pane from one PC to another

Toad has been installed on a different PC or laptop and would like to migrate the contents of the SQL Recall pane from old PC. How can this be done?

Revisado: quarta-feira, 24 de agosto de 2022
4304356 - How to connect to a local database with Toad for DB2.

How to connect to a local database with Toad for DB2.

Revisado: quarta-feira, 24 de agosto de 2022
4332355 - How to configure Toad for DB2 client connections?

Revisado: quarta-feira, 24 de agosto de 2022
4317922 - How to Completely Uninstall Toad Product Line

How to completely uninstall all products in the Toad Product Line.   

Revisado: quarta-feira, 24 de agosto de 2022
4222738 - How to compare objects in Schema Compare using DDL files?

Revisado: quarta-feira, 24 de agosto de 2022
4261094 - How to compare DDL in a file to live DB objects in Toad for DB2

How to compare DDL in a file to live DB objects in Toad for DB2 LUW?

Revisado: quarta-feira, 24 de agosto de 2022
4330533 - How to check the system requirements for the latest's versions of Toad for DB2?

How to check the system requirements for the latest's versions of Toad for DB2? What Operating Systems are supported? Is there any .NET...

Revisado: quarta-feira, 24 de agosto de 2022
4318885 - How to check if the userid which runs Toad belongs to DB2ADMNS and DB2USERS groups? Toad does not get populated with DB2 catalog entries.

There are cataloged DB2 connections under the DB2 Command Line Processor. The command "list database directory" show entries. How to check if the...

Revisado: quarta-feira, 24 de agosto de 2022
4332405 - How to change the scale to display the data entire value in Toad for DB2 ?

For decimal type data, Toad for DB2 only display the data with a scale value of 6. How to change the scale to display the data entire value...

Revisado: quarta-feira, 24 de agosto de 2022
4284388 - How to change the Result Sets tab number under the Editor?

The Result Sets that comes up after a query is ran in the Editor defaults to 5.  Can the tab number be changed?

Revisado: quarta-feira, 24 de agosto de 2022
4278081 - How to change edition of Toad products

How to change edition of Toad products e.g. from Base to Developer Suite, or from Xpert to Professional.

Revisado: quarta-feira, 24 de agosto de 2022
4332380 - How to change database user password from Toad from DB2?

How to change database user password from Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4214131 - What privilege is needed to view the Database | Applications window?

New user set up in the DB2 database, try to go into the Database Objects Explorer to view Database | Applications, get a message saying do not have...

Revisado: quarta-feira, 24 de agosto de 2022
4231668 - What port does Toad use to connect/communicate with DB2?

What port does Toad use to connect/communicate with DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4334000 - What license includes the DB ADMIN module?

What license includes the DB ADMIN module?

Revisado: quarta-feira, 24 de agosto de 2022
4333996 - What license it is needed to be able to compare schemes?

What license it is needed to be able to compare schemes?

Revisado: quarta-feira, 24 de agosto de 2022
4269715 - What kind of Db2 clients can be used with Toad for DB2 v6.3

As the Db2 client is no longer distributed with the Toad for DB2, what kind of Db2 client should we use?

Revisado: quarta-feira, 24 de agosto de 2022
4327274 - What is the SITE MESSAGE for trial version of TOAD?

I have downloaded the TOAD on DB2 / TOAD for SQL Server / TOAD for Oracle, and applied a trial license from TIMS. I still need a Site Message...

Revisado: quarta-feira, 24 de agosto de 2022
4242217 - What is the set up to use LDAP for Toad for DB2?

What is the set up to use LDAP for Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4307495 - What is the ECCN (Export Control Classification Numbers) for Toad?

What is the ECCN (Export Control Classification Numbers) for Toad?

Revisado: quarta-feira, 24 de agosto de 2022
4231999 - What is the difference between the Xpert and Base edition?

What is the difference between the Xpert and Base edition? What features are enabled for different editions/versions of Toad for DB2?  How can...

Revisado: quarta-feira, 24 de agosto de 2022
4239296 - What is new in Toad for DB2 Suites 6.2.

This article discusses what the new features are in Toad for DB2 Suites 6.2.

Revisado: quarta-feira, 24 de agosto de 2022
4238077 - What functionality goes with which license key type?

What functionality goes with each of the following license key types?  What is the difference between them? Base Edition Professional...

Revisado: quarta-feira, 24 de agosto de 2022
4270679 - What does the Quest Central Key for DB2 include when moving over to Toad for DB2 4.5 and above?

What does the Quest Central Key for DB2 include when moving over to Toad for DB2 4.5 and above?

Revisado: quarta-feira, 24 de agosto de 2022
4228284 - What can I use in Toad to help tune the database?

What can I use in Toad to help tune the database? Will Toad give me recommendations on what I can do help my database?

Revisado: quarta-feira, 24 de agosto de 2022
4309094 - Visualizing a query in Query Builder removes calculated 'NULL AS' columns

In the Query Builder, when visualizing a query, all the calculated fields with NULL disappear. e.g. Paste a SQL statement into the the Query tab...

Revisado: quarta-feira, 24 de agosto de 2022
4278159 - Views in Schema compare.

It is impossible to  see differences on views after a schema compare is run. In the Resultpane under Table Referenced the names of views can be...

Revisado: quarta-feira, 24 de agosto de 2022
4239479 - Viewing data grid returns an "Input string was not in a correct format" error

When viewing the data grid, either in the Editor or Database Explorer, it returns an "Input string was not in a correct format" error.  This seems...

Revisado: quarta-feira, 24 de agosto de 2022
4265912 - VIDEO - Overview of the new dashboard features in Toad for DB2

This video provides an overview of the new dashboard features in Toad for DB2 from Quest Software. 

Revisado: quarta-feira, 24 de agosto de 2022
4310340 - Version Control System setup with Team Server Foundation error "TF31002: Unable to connect to this Team Foundation Server"

Trying setup of Version Control to Team Foundation Server 1. Provider = Team Foundation Server 2. Server = https:// servername/ tfs 3. Check...

Revisado: quarta-feira, 24 de agosto de 2022
4283449 - Version control icons were grayed out. How does Toad connect to CVS?

Version control icons were grayed out. How does Toad connect to CVS?

Revisado: quarta-feira, 24 de agosto de 2022
4246890 - Version 3.0.0.993 places locks when selecting data from DB2 tables.

TOAD for DB2 places locks when selecting data from DB2 tables. It also places table locks when selecting a table in the schema browser. The...

Revisado: quarta-feira, 24 de agosto de 2022
4333488 - Varying errors appear when trying to connect to the database

Varying errors appear when trying to connect to the database. Toad was working fine and suddenly it is not possible to connect to the database...

Revisado: quarta-feira, 24 de agosto de 2022
4244240 - Values in the Database Allocation in Summary Dashboard are incorrect

The Database Allocation results, in the Summary Dashboard, are not correct. The final tally came in at 105%. It should not go beyond 100...

Revisado: quarta-feira, 24 de agosto de 2022
4223157 - Utilities | Runstats option to refresh statistics from the current stats.

Using Quest Central the table name | Utilities | Collect Statistics option allows to generate a refresh of the QCDB2 statistics from the current...

Revisado: quarta-feira, 24 de agosto de 2022
4229624 - Using the Delete key in the filter field of Connection Manager deletes connection and not filter text

The Delete key in filter field of Connection Manger wants to delete the connection and not the text within the filter field. Which ever...

Revisado: quarta-feira, 24 de agosto de 2022
4274044 - Using SQL Analysis with Toad for DB2 V5.0

Revisado: quarta-feira, 24 de agosto de 2022
4312454 - Using DB2 to connect an offsite client, needs to be encrypted

Our database connection requires encrypted connect to the server.

Revisado: quarta-feira, 24 de agosto de 2022
4260976 - Using Debug an SQL procedure returns “Compiled successfully”; however, the SQL procedure is dropped

Using Debug an SQL procedure returns “Compiled successfully”; however, the SQL procedure is dropped.

Revisado: quarta-feira, 24 de agosto de 2022
4278780 - Using Compare and Sync features, sequences have the same current value, but are being flagged as

When using the Compare and Sync feature,two sequencesbeing comparedare flagged as different even though the current value of the sequence is the...

Revisado: quarta-feira, 24 de agosto de 2022
4309263 - User Requirements, Permissions and Restrictions for Running Toad against LUW and z/OS databases

The following describes the requirements, permissions and restrictions for users who launch and run Toad

Revisado: quarta-feira, 24 de agosto de 2022
4292741 - User is unable to create explain plan table to DB2 version 9.

User is unable to create explain plan table to DB2 version 9.

Revisado: quarta-feira, 24 de agosto de 2022
4277771 - Use temporary tables for tables with identity colums generated by default

When there is an identity-column in a key which generats by default. The schema compare should be able to generate a temporary table for data...

Revisado: quarta-feira, 24 de agosto de 2022
4229127 - Updating one specific column gives a -151 updating key column error.

When using Toad 4.7 (and previous versions) to do updates to tables on the data grid, there is an issue with a particular table. When trying to...

Revisado: quarta-feira, 24 de agosto de 2022
4225884 - Updating one specific column gives a -151 error.

When trying to update one specific column (date) on a specific row, the update produced a -151 issue, updating the key column of the table even...

Revisado: quarta-feira, 24 de agosto de 2022
4282900 - Unnecessary drop recreate of table when altering primary key sequence

ENHANCEMENT REQUEST: There are two tables having identical columns however, the primary indexes have different column order. Using Toad for DB2...

Revisado: quarta-feira, 24 de agosto de 2022
4290413 - Uninstalling Toad for DB2 4.7 and above does not remove registry entries in WOW6432Node

In Windows 64-bit, uninstalling Toad for DB2 4.7 and above does not remove registry entries in HKEY_LOCAL_MACHINE | SOFTWARE | WOW6432Node | IBM...

Revisado: quarta-feira, 24 de agosto de 2022
4314014 - Uninstall of DB2 and Data Point using MSI/Silent Suppress Reboot.

We ran the following command to initiate the uninstall of Toad for DB2: msiexec /x "C:\install\Toad DB2 2016\ToadforDB2_6.2.0.315_x86_En.msi" /l...

Revisado: quarta-feira, 24 de agosto de 2022
4269332 - Uninstall, not removing older version, product codes need to be requested

Where can the product codes be found to generate install packages? 

Revisado: quarta-feira, 24 de agosto de 2022
4246399 - Unicode characters are displaying as squares in the data grid

Multi-Byte Data characters are not displayed correctly.

Revisado: quarta-feira, 24 de agosto de 2022
4273635 - Unexpected results during Schema Compare.  SQLObject_CursorType and SQLOject_RowType does not

User found 2 comment lines on results during  Schema Compare below and questioned why they were  there. /*-- Variable ‘SQLObject_CursorType’ does...

Revisado: quarta-feira, 24 de agosto de 2022
4332381 - Unchecking autocommit button and closing Toad hangs

To reproduce the issue, please do the following: 1. When opening the object explorer and having data in some tables 2. Clicking the data tab...

Revisado: quarta-feira, 24 de agosto de 2022
4290089 - Unable to Run Statement with Bind Variables in RTRIM Function

In attempting to run a SQL being developed in the Toad Editor, an error is received using the RTRIM statement with a Bind variable in it.   ERROR...

Revisado: quarta-feira, 24 de agosto de 2022
4238838 - Unable to run a CLI/ODBC trace on a Toad for DB2 instance

Unable to generate a CLI/ODBC trace on a Toad for DB2 instance. When following the steps below to enable a trace, no data is generated...

Revisado: quarta-feira, 24 de agosto de 2022
4325801 - Unable to remove Toad for DB2 from MS Windows vista 64 bit ("Internal Error x, Action y").

Toad for DB2 was installed on a Microsoft Windows Vista 64bit version.   When starting Toad for DB2 the following Message appears: DB21085I...

Revisado: quarta-feira, 24 de agosto de 2022
4326786 - Unable to open real time stadistic in Toad for DB2

Unable to open real time stadistic in Toad for DB2 for z/OS Getting error: New exception: 12/6/2018 2:51:12 PM System.ObjectDisposedException...

Revisado: quarta-feira, 24 de agosto de 2022
4227670 - Is there a Toad for DB2 z/os edition that includes Toad Data Modeler?

Is there a Toad for DB2 z/os product edition that includes Toad Data Modeler?

Revisado: quarta-feira, 24 de agosto de 2022
4238090 - Is there a government version?

Documentation is mentioning a Commercial version of the product.  Does that mean that there is a Government version of the product?

Revisado: quarta-feira, 24 de agosto de 2022
4290433 - Is there a 64-bit Toad for DB2 installer?

Is there a 64-bit Toad for DB2 installer?

Revisado: quarta-feira, 24 de agosto de 2022
4274440 - Is the default behavior of Toad to open new threads for every database interaction or can it be can it be configured?

Is the default behavior of Toad to open new threads for every database interaction or can it be configured?

Revisado: quarta-feira, 24 de agosto de 2022
4268443 - Is Secure File Transfer Protocol (SFTP) available for private/public key authentication?

If the User/Password login is disabled for security reasons, is there a way to configure the TOAD .NET products to use private/public key...

Revisado: quarta-feira, 24 de agosto de 2022
4236774 - Is it possible to transfer data from a DB2 database to a SQL Server database using Toad?

Is it possible to transfer data from a DB2 database to a SQL Server database using Toad for DB2 and Toad for SQL Server respectively?

Revisado: quarta-feira, 24 de agosto de 2022
4227209 - Is it possible to to create a template for SORT Work Datasets in DB2?

DB2 allows to manually supply temporary work data sets, if prefered not to use SORTDEVT and SORTNUM. In that case, it would be nice if Toad allow...

Revisado: quarta-feira, 24 de agosto de 2022
4308004 - Is it possible to schedule a Schema Compare with automation?

Revisado: quarta-feira, 24 de agosto de 2022
4243550 - Is it possible to reorder columns when altering a view?

Is it possible to edit the column order when using the 'Alter View | Columns ' option, the same way as can be done in the 'Alter Table | Columns...

Revisado: quarta-feira, 24 de agosto de 2022
4239564 - Is it possible to re-open unsaved files automatically in Toad for DB2?

Is it possible to restore unsaved files when starting Toad - in a similar way to the Automatic Document Recovery, but that could be used without...

Revisado: quarta-feira, 24 de agosto de 2022
4325886 - Is it possible to have an advanced alter ( e.g rename column and remove column) professional lice

Is it possible to have an advanced alter ( e.g rename column and remove column) in Toad for DB2 v3.0 under a professional license? If not, what...

Revisado: quarta-feira, 24 de agosto de 2022
4236655 - Is it possible to have a user defined Application Data directory location?

Is it possible to have a user defined Application Data directory location, or the ability to move this directory to a different location? At...

Revisado: quarta-feira, 24 de agosto de 2022
4325182 - Is it possible to fetch a certain number of rows and not the whole table, or all remaining rows?

When running a "Select * from table_name" or just going to the data tab in the Object Explorer, the default for Toad is to initially fetch 1000...

Revisado: quarta-feira, 24 de agosto de 2022
4292082 - In Toad for DB2, how do I delete connection catalog entries?

In Toad for DB2, how do I delete connection catalog entries?

Revisado: quarta-feira, 24 de agosto de 2022
4274029 - In schema compare, the wizard says it generated the synchronization script, but the window is bla

In schema compare, the wizard says it generated the synchronization script, but the window is blank.  The window should contain the DDL for...

Revisado: quarta-feira, 24 de agosto de 2022
4261104 - In Object Explorer, clicking on Proc and select Extract DDL performance issue in 6.1

In Object Explorer, right click on Proc and select Extract DDL. This worked in previous version. In version 6.1, there can be a delay up to 30...

Revisado: quarta-feira, 24 de agosto de 2022
4273925 - In data compare - Message : 'The given key was not present in the dictionary'

After selecting table columns, at  Select synchonize options, If user checks the "Use IMPORT command for tables with identity or XML columns" box...

Revisado: quarta-feira, 24 de agosto de 2022
4308347 - Importing Profile gave error "SQL5005N: Unable to init API env"

When I use the Import Profile feature to import my DB2 catalogue, I get the error: "SQL5005N: Unable to init API env"

Revisado: quarta-feira, 24 de agosto de 2022
4237911 - Import DB2 Connections in Toad. Errors: "SQL5005N: Unable to init API" and "'DB21018E A System error occurred. The command line processor could not continue processing' then appears."

When exporting the connections from DB2 client v4.6, using the 'Backup' option, and importing them into v4.7, the following error appears...

Revisado: quarta-feira, 24 de agosto de 2022
4295704 - Import a table immediately gets the error: "Specified argument was out of the range of valid values."

Import Table Error: Toad for DB2 6.2.0.315 System.ArgumentOutOfRangeException Specified argument was out of the range of valid values...

Revisado: quarta-feira, 24 de agosto de 2022
4232516 - If I am licensed for one on Toad for DB2, can I put Toad on VMware and have more than one users u

If Toad for DB2 is put on an VMware environment, can more than one user use Toad even if the license only states one.

Revisado: quarta-feira, 24 de agosto de 2022
4283231 - If .NET 3.5 was required, why is .NET V2 folder machine.config being used?

If .NET 3.5 was required for Toad for DB2 v4.5, why is.NET V2 folder machine.configbeing used?

Revisado: quarta-feira, 24 de agosto de 2022
4270670 - IDAA Timestamps via AQT/DB2 Connect, "Specified argument was out of the range of valid values".

When using IDAA Timestamps via AQT/DB2  when connecting generated error: Specified argument was out of the range of valid values.

Revisado: quarta-feira, 24 de agosto de 2022
4227179 - IBM.Data.DB2.DB2Exception: ERROR [42703] [IBM][DB2/AIX64] "SC.DBPARTITIONNUM" is not valid in the context where it is used.

Trying to create a TABLESPACE , one gets the error: IBM.Data.DB2.DB2Exception: ERROR [42703] [IBM][DB2/AIX64] "SC.DBPARTITIONNUM" is not valid...

Revisado: quarta-feira, 24 de agosto de 2022
4333502 - IBM DB2 10.1 fixpack 3 doesn't generate sql-script for procedures anymore

Since installing fixpack 3 for IBM DB2 10.1 fixpack 3, Toad for DB2 5.5.0.480 doesn't generate sql-script for procedures.

Revisado: quarta-feira, 24 de agosto de 2022
4290559 - I get the error: "Error 1934. User installations are disabled via policy on the machine" when

I get the error: "Error 1934. User installations are disabled via policy on the machine" when I install Toad for DB2 via the Command Prompt or...

Revisado: quarta-feira, 24 de agosto de 2022
4285046 - I can't find 'Application' tab in 'Viewer Database' pane.

Revisado: quarta-feira, 24 de agosto de 2022
4257227 - How to zero out or clear the recent file list?

How to zero out or clear the recent file list?  Sometimes, when the recent file list contains a file that is located in a slow network drive...

Revisado: quarta-feira, 24 de agosto de 2022
4246285 - How to use the Toad for DB2 Histogram

Revisado: quarta-feira, 24 de agosto de 2022
4238791 - How to use the Space Prediction feature added in Toad for DB2 6.0

This article includes a video that demonstrates how to use the Space Prediction feature that was added in Toad for DB2 6.0.

Revisado: quarta-feira, 24 de agosto de 2022
4311551 - How to use Space Prediction functionality of Space Management

Toad for DB2 has many features that allow you to view the health of your database objects and maintain these objects. This video will demonstrate...

Revisado: quarta-feira, 24 de agosto de 2022
4309269 - How to use Space Management's advanced features

Toad for DB2 has many features that allow you to view the health of your database objects and maintain those objects. This video will demonstrate...

Revisado: quarta-feira, 24 de agosto de 2022
4326641 - How to upload a file into the Service Request

Trying to upload a zip file, screenshot, video, docx into the Service Request and this one is larger than expected?

Revisado: quarta-feira, 24 de agosto de 2022
4307672 - How to update table data in Database Browser | Views | Data?

How to update table data in Database Browser | Views tab | Data tab? The buttons to update table data in this screen are grayed out.

Revisado: quarta-feira, 24 de agosto de 2022
4253629 - How to uninstall Toad for DB2.

How to uninstall Toad for DB2.

Revisado: quarta-feira, 24 de agosto de 2022
4242107 - How to undo "Do not prompt me again" options on popups

Earlier, I checked the Do not prompt me again option on a pop up and no I want to undo it. Is there a way to get the pop up back?

Revisado: quarta-feira, 24 de agosto de 2022
4249755 - How to un-install the Quest Installer

How can the Quest Installer be un-intalled from a machine?

Revisado: quarta-feira, 24 de agosto de 2022
4296177 - How to transfer or move a license key from one computer to another computer?

How to transfer or move a license key from one computer to another computer?

Revisado: quarta-feira, 24 de agosto de 2022
4313443 - How to tell if the install has a IBM DB2 32bit client or 64bit client.

How to tell if the current install of Toad for DB2 was installed with a 32 bit DB2 client or a 64bit DB2 client?

Revisado: quarta-feira, 24 de agosto de 2022
4303592 - How to stop users from saving passwords?

How to stop users from saving passwords?

Revisado: quarta-feira, 24 de agosto de 2022
4252911 - How to stop Toad for going to toadsoft.com when launching.

Revisado: quarta-feira, 24 de agosto de 2022
4273670 - How to stop SQL execution on error?

Simple question.  I set my SQL editor to continue on error by using the pop-up window which included a checkbox to "Do not show this window again...

Revisado: quarta-feira, 24 de agosto de 2022
4295292 - How to start and stop the Execution Trace feature?

Revisado: quarta-feira, 24 de agosto de 2022
4351035 - How to setup the debugger in Toad for DB2

How do I setup the debugger feature in Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4245743 - How to set options for all tablespaces when copying multiple tablespaces at once

When copying multiple tablespaces is there a way to specify one of the options for all of tablespaces, instead of having to individually select...

Revisado: quarta-feira, 24 de agosto de 2022
4223017 - How to send query results to text format display?

Query results are going to grid and can only copy one grid at a time. Would like results to go to free text format.  Is there a way to do that?

Revisado: quarta-feira, 24 de agosto de 2022
4311797 - How to select a sql statement for tuning from the Dynamic Statement Cache (DSC)

How do you access the new Dynamic Statement Cache (DSC) feature and select a sql statement for tuning?

Revisado: quarta-feira, 24 de agosto de 2022
4308838 - How to save a SQL script from the editor directly to a project in Project Manager

There are several SQL scripts that are run frequently and would like to be able to access these from the Project Manager. Is it possible to save a...

Revisado: quarta-feira, 24 de agosto de 2022
4261720 - How to run a Data Report periodically?

How can one run an existing Data Report periodically?

Revisado: quarta-feira, 24 de agosto de 2022
4307200 - How to restore an LUW database

How to restore an LUW database

Revisado: quarta-feira, 24 de agosto de 2022
4346612 - How to request for a general walk-through or product demonstration for Toad products?

How to request for a walk-through or product demo for Toad products?

Revisado: quarta-feira, 24 de agosto de 2022
4254298 - How to remove the Connection Category Color from the connection window?

On the new connection window, at bottom, where you can create a category and assign a color. I’m looking for where I can delete a category that I...

Revisado: quarta-feira, 24 de agosto de 2022
4238884 - How to remove registry entries that are created by Toad for DB2 install

I had some problems with my machine and some Toad for DB2 related uninstall entries were destroyed from the registry. I tried to manually delete...

Revisado: quarta-feira, 24 de agosto de 2022
4274249 - How to remove old SQL Analysis Respoitories?

QUESTION: How to remove old SQL Analysis Respoitory?

Revisado: quarta-feira, 24 de agosto de 2022
4311473 - How to recover tablespace from a Quiesce point?

Revisado: quarta-feira, 24 de agosto de 2022
4303526 - How to Rebind Plans/packages at the database level.

Is there a way for Toad to identify all dependent Plans/Packages of all tables under a database, and then to Rebind the identified Plans/Packages?

Revisado: quarta-feira, 24 de agosto de 2022
4278361 - PL/SQL code marked as invalid

Even if the PL/SQL code can be successfully executed against the Db2 database when DB2_COMPATIBILITY_VECTOR is set to ORA, in Editor the code is...

Revisado: quarta-feira, 24 de agosto de 2022
4334608 - Bad behaviour of Supr button when altering the length of a column with the Alter Table wizard

When pressing supr button  to remove the lenght to the column to enter a new one, the complete column table is deleted. This should not happen as...

Revisado: quarta-feira, 24 de agosto de 2022
4239452 - BACKUP Tablespace script fails when encountering #SYNC statement

When generating a script in Toad to backup two tablespaces using TSM, the script (please see attachment) generates three distinct BACKUP...

Revisado: quarta-feira, 24 de agosto de 2022
4333316 - Background Processes window missing

Cannot find the "Background Processes" window. Selecting View | "Background Processes" does not help either.

Revisado: quarta-feira, 24 de agosto de 2022
4224912 - Availability of Quest Central reports and charts in Toad, such as Maintain Statistics, Validate S

Availability of Quest Central reports and charts in Toad, such as Maintain Statistics, Validate Statistics, View Growth and Batch Analysis.

Revisado: quarta-feira, 24 de agosto de 2022
4261710 - Automation, "The specified path c:\program files\Microsoft Visual Studio 9.0\Common7\IDE was not

I am using Toad for SQL and I am creating an automation with different steps. When I add a FTP activity, the exclamation mark shows up and says...

Revisado: quarta-feira, 24 de agosto de 2022
4278772 - Automation of triggering a Toad API that compares 2 databases without using GUI

We are in need of triggering a toadAPI that compares two DB2 databasesand generates theDDL of the differences. We need to be able to automate this...

Revisado: quarta-feira, 24 de agosto de 2022
4308080 - Automation FTP activity fails with "error FTP_1 The path is not of a legal form"

Automation script is run but fails on the FTP action:  "error FTP_1   The path is not of a legal form"

Revisado: quarta-feira, 24 de agosto de 2022
4223768 - Automation job does not generate email when job fails and "Email on Error" is set to True sett

User is running an automation job with "Email on Error" set to True setting.  Toad is not generating an email when job fails and log file...

Revisado: quarta-feira, 24 de agosto de 2022
4274629 - Automation - Creating an Archive: Need the option to be able to have the system append the dat

Automation - Creating an archive file user needs the option to be able to have the system append the date / time to the file name. Sê attachment.

Revisado: quarta-feira, 24 de agosto de 2022
4332347 - Auto-Resize attribute for tablespaces is not displayed correctly

In the Object Explorer, the Auto-Resize attribute for tablespaces is not displayed correctly. 1. Go to View | Object Explorer 2. Choose...

Revisado: quarta-feira, 24 de agosto de 2022
4289355 - How to purchase or buy Toad? How to acquire a Commercial license key for Toad?

How to purchase or buy Toad, SQL Optimizer, or SQL Navigator products? How to acquire a Commercial license key? How to get a price quote?

Revisado: quarta-feira, 24 de agosto de 2022
4295003 - How to prevent access to “Check for updates on startup”

How to prevent access to the option “Check for updates on startup” in the Environment | General Options section.  

Revisado: quarta-feira, 24 de agosto de 2022
4261716 - How to monitor Dynamic SQL Statements that are being submitted by the Users/Applications?

How can Dynamic SQL Statements that are being submitted by the Users/Applications against the DB2 Subsystem be monitored? Is it possible to view...

Revisado: quarta-feira, 24 de agosto de 2022
4268699 - How to migrate Auto-Replace Editor templates between versions?

Is possible migrate Auto-Replace Editor templates between version of Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4265514 - How to list db2 bp processes in Toad for DB2

I cannot find where to list the batch processes running in DB2.  Toad for DB2 only list client connections and an event monitor.

Revisado: quarta-feira, 24 de agosto de 2022
4273643 - How to list all connections on connection manager?

User has imported the configure file from DB2 client but it did not list all databases on connection manager. He has to add individually database...

Revisado: quarta-feira, 24 de agosto de 2022
4295430 - How to launch IBM DB2 Control Center in Toad? How to ingtrate it with Toad for DB2?

How to launch or start IBM DB2 Control Center in Toad?  How to integrate it with Toad for DB2?  Is IBM Data Studio or IBM DB2 Control Center needed...

Revisado: quarta-feira, 24 de agosto de 2022
4236366 - How to install to All Users in Windows 7 via command line?

How can I install to All Users in Windows 7 via command line?  The GUI installation works just fine.

Revisado: quarta-feira, 24 de agosto de 2022
4309224 - How to increase the font size for Connection Manager and Database Explorer

Currently, It's possible to change the font type and size for the Editor. However, it's not possible to change the font size in the Connection...

Revisado: quarta-feira, 24 de agosto de 2022
4319570 - How to get Users to show in the Object List or Database Explorer

When viewing the list of objects in the Object List or Database Explorer, Users is not listed.

Revisado: quarta-feira, 24 de agosto de 2022
4253385 - How to get the Object Explorer to open when connecting to a database?

How do to get Toad to open the database Object Explorer when a connection is open?

Revisado: quarta-feira, 24 de agosto de 2022
4289899 - How to get the colored Editor tabs (the full tab) to work in version 5.5? This used to be available in version 5.1.

How to get the colored Editor tabs (the full tab is colored) to work in version 5.5?  This feature is available in version 5.1.

Revisado: quarta-feira, 24 de agosto de 2022
4318613 - How to get recommendations of virtual indexes for SQL?

I have been trying to migrate from Quest Central for DB2 to Toad for DB2 and I cant find the recommend virtual indexes option in the explain tool...

Revisado: quarta-feira, 24 de agosto de 2022
4234860 - How to get assistance with issues regarding ToadWorld.com.

Revisado: quarta-feira, 24 de agosto de 2022
4241142 - How to generate image copy and Runstas of all tablespaces at the database level?

Would like to know if Toad can generate utility commands at the database level. For example, how to generate image copy of all tablespaces in a...

Revisado: quarta-feira, 24 de agosto de 2022
4274534 - How to generate a report to show object names that show as different in the Schema Compare result

The report in print preview only summarizes the total number of differences by category.   While this is useful, it was expected a second page...

Revisado: quarta-feira, 24 de agosto de 2022
4301592 - How to find out who is using what license key in order to deactivate the user from the license? How to track the license keys?

How to find out who is using what license key in order to deactivate the user from the license. How to track the license keys?  Does Toad have...

Revisado: quarta-feira, 24 de agosto de 2022
4242032 - How to extract grants for multiple groups or users?

Revisado: quarta-feira, 24 de agosto de 2022
4241415 - How to export the Real Time Statistics information?

Is there a process to report or export the data shown on the Schema Browser | Database | Real Time Statistics tab of the database view?  It appears...

Revisado: quarta-feira, 24 de agosto de 2022
4278825 - How to export multiple SQL results to multiple tabs in Excel using automation

Need to use automation to run multiple SQL's and export each result set to a different tab in the same Excel file.  What is the best way to go...

Revisado: quarta-feira, 24 de agosto de 2022
4262167 - How to export grid output to Excel?

On some  windows like the Index Cardinality under Space Exceptions for DB2/LUW, there is no option to export the grid output to Excel.

Revisado: quarta-feira, 24 de agosto de 2022
4242157 - How to export IBM DB2 Client connection catalog?

How to export IBM DB2 Client connection catalog?

Revisado: quarta-feira, 24 de agosto de 2022
4320528 - How to export a client catalog entry from IBM DB2 Client?

How to import existing client catalogue info from my IBM DB2 Client and use it in Toad to connect.  How do I export this information to be able to...

Revisado: quarta-feira, 24 de agosto de 2022
4260473 - How to export .ter file to graphic format, .jpg or .png

I have created database diagram for my schema using Toad. It was done and fine. While saving by default, it is .ter format, not accepting no...

Revisado: quarta-feira, 24 de agosto de 2022
4318529 - How to enable real time stadistic on AIX server ?

How to enable real time stadistic  (RTS)  on AIX server ?  Is there a way to enable it ?

Revisado: quarta-feira, 24 de agosto de 2022
4302872 - How to download Quest Management Suite for DB2

I purchased Quest Management Suite for DB2 but don't know where to find it.

Revisado: quarta-feira, 24 de agosto de 2022
4279419 - How to do client side silent installation for Toad SQLAnalysis for DB2

How to do client side silent installation for Toad SQLAnalysis for DB2

Revisado: quarta-feira, 24 de agosto de 2022
4220053 - How to display table and column dependencies for views?

User would like to see table and column name dependencies for a view in a report format. He would like to see the details for each source table...

Revisado: quarta-feira, 24 de agosto de 2022
4335484 - How to disable internet browser access from within Toad

How to disable internet browser access from within Toad

Revisado: quarta-feira, 24 de agosto de 2022
4329487 - Is it possible to do a reconnect to database after hibernation?

Is it possible to do a reconnect to database after hibernation?

Revisado: quarta-feira, 24 de agosto de 2022
4238878 - Is it possible to define and deploy company wide default user settings?

When packaging Toad for DB2 6.0 is it possible to define and deploy company wide default settings? Some of the files in the user application...

Revisado: quarta-feira, 24 de agosto de 2022
4329482 - Is it possible to connect with DB2/ODBC using different DSN (Data source Name) versions at the sa

Is it possible to connect with DB2/ODBC using different DSN (Data source Name) versions at the same time?

Revisado: quarta-feira, 24 de agosto de 2022
4312814 - Is it possible to compare z/OS objects with LUW schemas or objects?

If an attempt is made to try a comparison between LUW and z/OS objects, Toad displays a message stating: Server  servername  - DB2_UDB is not...

Revisado: quarta-feira, 24 de agosto de 2022
4310157 - Is it possible to combine optimization and SQL statement to get explain plan?

Is it possible to put optimization and SQL together and get the explain plan? i.e. "set current query optimization = 7; select count(*) from...

Revisado: quarta-feira, 24 de agosto de 2022
4244541 - Is it possible to compare a database object to an .sql file?

Revisado: quarta-feira, 24 de agosto de 2022
4239227 - Is it possible to change an existing users DB2 database password using the GUI in Toad?

Is it possible to change an existing users DB2 database password using the GUI in Toad?

Revisado: quarta-feira, 24 de agosto de 2022
4229155 - Invalid specification message noting issue with charater data length when specifying system defau

When trying to create or alter a table Toad gives the message: "Invalid Specification - When specifying a system default value of SESSION USER...

Revisado: quarta-feira, 24 de agosto de 2022
4308041 - firewall ports requirements for QCAgent on Solaris

Revisado: quarta-feira, 24 de agosto de 2022
4289815 - filters for views, schema name should be allowed

Can't filter views with schema name.

Revisado: quarta-feira, 24 de agosto de 2022
4248127 - Filter Indexes, getting error: ERROR [42702] [IBM][DB2/AIX64] SQL0203N A reference to column

Using the additional fileds in the Filter Indexes window, getting the error: ERROR [42702] [IBM][DB2/AIX64] SQL0203N A reference to column...

Revisado: quarta-feira, 24 de agosto de 2022
4295313 - Federated Database: Add support for Nicknames with Intellisense.

DB2 Federated Databases: no support for Nicknames with Intellisense.

Revisado: quarta-feira, 24 de agosto de 2022
4334805 - Failed to configure per-machine MSI package

Revisado: quarta-feira, 24 de agosto de 2022
4265394 - Extracting DDL missing some partition parameters on  partition by range tablespace

User created a 'Materialized Query Tables' MQT table on  partition by rangetablespace . Toad for DB2 v 4.7 did not show  partition parameters...

Revisado: quarta-feira, 24 de agosto de 2022
4268259 - Extract DDL with many connection entries crashes Toad.

Using Toad for DB2 version 4.5.0.797 LUW - Extract DDL crashes Toad when user has many connections (approximately 1300)  defined to Toad client...

Revisado: quarta-feira, 24 de agosto de 2022
4222698 - Extract DDL of store procedure using GET STACKED DIAGNOSTICS command truncates the code.

Extract DDL of a store procedure using GET STACKED DIAGNOSTICS command truncates the code

Revisado: quarta-feira, 24 de agosto de 2022
4225577 - Extract DDL does not include "CALLED ON NULL INPUT" and "INHERIT SPECIAL REGISTERS" in procedu

Extract DDL does not include "CALLED ON NULL INPUT" and "INHERIT SPECIAL REGISTERS" when the procedure DDL is extracted, even though it was...

Revisado: quarta-feira, 24 de agosto de 2022
4321954 - Exporting numbers with German OS localisation settings result in decimal points in the csv-fil

When having German language settings and exporting numerical data (decimal (10,3)) to a csv-file. (Even when the separator is a ';'), the decimal...

Revisado: quarta-feira, 24 de agosto de 2022
4237724 - Export Wizard takes a very long time (over 30 minutes) to export to a csv file

In v6.5 the Export Wizard takes a very long time (over 30 minutes) to export to a csv file, where the CLP command takes one second to export the...

Revisado: quarta-feira, 24 de agosto de 2022
4318775 - Export Wizard is grayed out in Tools | Export dropdown menu

When selecting Tools | Export in the menu bar, Export Wizard is grayed out.

Revisado: quarta-feira, 24 de agosto de 2022
4261475 - Export wizard does not generate file when using variables in SQL statement.

Export wizard does not generate file when using variables in SQL statement. Example: select * from sales where year=@date_year No error is...

Revisado: quarta-feira, 24 de agosto de 2022
4241828 - Export to Excel File button greyed out

When viewing table data, the Export to Excel file button is greyed out. The other 3 one-click export buttons are active.

Revisado: quarta-feira, 24 de agosto de 2022
4246170 - Export profile does not create and does not inform user if path entered does not exist

When trying to export a profile, from the connection window, if an invalid file location is entered, the user is not prompted to let you know the...

Revisado: quarta-feira, 24 de agosto de 2022
4307930 - Explorer | Tree view | Subsystem | ‘Dynamic Statement’ tab error: "ERROR [07001] [IBM] CLI0100E Wrong number of parameters. SQLSTATE=07001"

Object or Database Explorer | Tree view | Subsystem | ‘Dynamic Statement’ tab error: "ERROR [07001] [IBM] CLI0100E Wrong number of parameters...

Revisado: quarta-feira, 24 de agosto de 2022
4274832 - Explain Plan window shows Table/Index Object as "table name.table name"

In Explain Plan window, if a user hovers over a table/index object with mouse, the pop-up display shows the object name as 'table name.table name...

Revisado: quarta-feira, 24 de agosto de 2022
4246917 - Explain tables are not valid when optimizing a statement created in Toad for DB2 in SQL Optimi

After creating a statement in Toad for DB2 and then launching SQL Optimizer to optimize it, the following error message is displayed: "Invalid...

Revisado: quarta-feira, 24 de agosto de 2022
4328048 - Explain plan not available for this statement

Visual explain do not work in Toad when DB2_COMPATIBILITY_VECTOR=ORA or DB2_DEFERRED_PREPARE_SEMANTICS=YES. Example: Explain Plan is not working...

Revisado: quarta-feira, 24 de agosto de 2022
4323803 - Explain plan loses preferences or cannot be saved

In the editor type some SQL and then click the Explain Plan tab in the result pane. Use the tree view (right click, view plan,  as tree plan...

Revisado: quarta-feira, 24 de agosto de 2022
4243845 - Explain Plan SQL in packages error: Plan is not available.

Revisado: quarta-feira, 24 de agosto de 2022
4222765 - Explain Plan does not capture new SQL entered in Editor and does not re-execute correctly.

When running an explain plan either by highlighting the SQL and selecting the Explain toolbar icon, or highlighting the SQL and clicking the...

Revisado: quarta-feira, 24 de agosto de 2022
4229873 - Executed DCL statement are not reflected in the Grants tab in the Object Explorer

Opening a table from the object explorer and selecting the grant tab, it displays x number of grantee's. However after running a DCL statement to...

Revisado: quarta-feira, 24 de agosto de 2022
4243276 - Exception error when altering a tablespace by trying to add a new stripe set

When altering a tablespace and pressing the New Stripe Set button, the following error message appears: Exception: System.ArgumentException...

Revisado: quarta-feira, 24 de agosto de 2022
4241780 - Exception error appears when clicking the File menu in a Citrix environment

In a Citrix environment, when clicking the File menu, the following exception error appears: 'System.NullReferenceException Object reference...

Revisado: quarta-feira, 24 de agosto de 2022
4260299 - Exception error 'The System Configuration could not be initiated' appears when starting Toad

When starting up Toad for DB2, the following error appears immediately and Toad is unable to startup - before even connecting to the database...

Revisado: quarta-feira, 24 de agosto de 2022
4320136 - Exception - System.TypeLoadException - Could not load type 'System.Security.Claims.ClaimsIdentity' from assembly

The below error message occurs following clicking Connect within the Create New Connection screen: "System.TypeLoadException Could not load...

Revisado: quarta-feira, 24 de agosto de 2022
4270389 - Exception after  LDAP has been enabled

Toad returning an exception when ldap is enable and the local cataloged connections are not imported. Toad should be able handle this, because...

Revisado: quarta-feira, 24 de agosto de 2022
4247712 - Excel macro sheets are not able to run macros

Trying to use Automation to execute a macro from an xlsm. It will skip actually executing it and just ends the process. It just skips over it...

Revisado: quarta-feira, 24 de agosto de 2022
4279410 - Errors: "ERROR - no error information available" and "SQL10007N Message "-1390" could not be retrieved. Reason code: "6"."

After installing Toad and importing a database profile, Toad is able to connect to DB2 backend when connecting for the first time. However, when...

Revisado: quarta-feira, 24 de agosto de 2022
4224590 - Errors when starting Toad: "Exception has been thrown by the target of an invocation" and "Invalid window handle".

The following errors occurs at startup / launch of Toad: Error 1: System.Reflection.TargetInvocationException: Exception has been thrown by the...

Revisado: quarta-feira, 24 de agosto de 2022
4234617 - Error; "Unknown type found during storing data. Type: IBM.Data.DB2Types.DB2Decimal" when performing a data compare

When using Data Compare feature in Toad for DB2, the following error message occurs in the results window: "Unknown type found during storing...

Revisado: quarta-feira, 24 de agosto de 2022
4320238 - Error:System.Xml.XmlException: ' ', hexadecimal value 0x18, is an invalid character

In  Toad for DB2 v 4.0, after connecting to a production database  that is large and busy,  an error: "System.Xml.XmlException: ' ', hexadecimal...

Revisado: quarta-feira, 24 de agosto de 2022
4278137 - Error: When there is a Zoomtext of Aisquared as a Screen Magnifier installed.

When there is a Zoomtext of Aisquared as a Screen Magnifier installed. An error is returned when this software is not disabled. However when the...

Revisado: quarta-feira, 24 de agosto de 2022
4273307 - ERROR: SQL0104N An unexpected token Pages was found following identifier.

The script which is generated by Toad for the database is not working. Generated: PAGESIZE 4096 Pages but Pages is not a valid DB2 Syntax. Try...

Revisado: quarta-feira, 24 de agosto de 2022
4278741 - Error: Out of memory- Unable to stop process or to close Toad

User got error: Out of memory when he tried to cancel a process or closed Toad.

Revisado: quarta-feira, 24 de agosto de 2022
4317136 - Error: DB2 Database Error Procedure debugging error

When executing "Complie SQL Procedure With Debug" in Toad for DB2 4.5, some procedures makes error and stop debugging. ======= error messages...

Revisado: quarta-feira, 24 de agosto de 2022
4283165 - Error: 'SQC70323W: Statement parse failed (rc=70015)'

When runninga collection SQL from Toad SQL Analysis, the following error appears: SQC70323W: Statement parse failed (rc=70015) for SELECT...

Revisado: quarta-feira, 24 de agosto de 2022
4268653 - Error: 'SQL0199N The use of the reserved word "FROM" following "" is not valid'

Using Toad for DB2 v 4.5.1.917, on Query Builder: 1. Create a new calculated field 2. Use builder to write a sub string function 3. Toad writes...

Revisado: quarta-feira, 24 de agosto de 2022
4245602 - Error: 'SQL0104N An unexpected token "2,0" was found following "" ' when editing a date record

When trying to edit and update a date record, the following error appears: 'DB2 Database Error: ERROR [42601] [IBM][DB2] SQL0104N An unexpected...

Revisado: quarta-feira, 24 de agosto de 2022
4242264 - Error: 'Template repository is not installed on server. Please install QUEST.QCTEMPLATE_REPO200',

When trying to create a foreign key constraint on a table in a z/OS database, the following error appears: 'Template repository is not installed...

Revisado: quarta-feira, 24 de agosto de 2022
4241969 - Error: 'SQL20183N The table is not compatible with the specified table partitioning operation' wh

When altering an existing table to make it partitioned, the following error appears when executing the script: 'SQL20183N The table is not...

Revisado: quarta-feira, 24 de agosto de 2022
4239198 - Error: 'System.IO.IOException - The file cannot be accessed by the system.' when opening a .tas file from a Sharepoint location

When opening attached Toad Automation Script (.tas file) from a SharePoint location the following error appears: "System.IO.IOException - The file...

Revisado: quarta-feira, 24 de agosto de 2022
4273793 - Error: 'Plan is not available'

User clicked on explain plan on Editor window and got error: 'Plan is not available'

Revisado: quarta-feira, 24 de agosto de 2022
4238631 - Error: 'Error 0x800704c7: Failed to launch elevated child process' during Toad for DB2 zOS installation

When installing Toad for DB2 with a user that has admin rights, the following error appears: 'Error 0x800704c7: Failed to launch elevated child...

Revisado: quarta-feira, 24 de agosto de 2022
4283366 - Error: "Value was either too large or too small for an Int64".

Alter a table from the context menu in the object explorer. After select "alter table..." from the context menu of this table toad fails with this...

Revisado: quarta-feira, 24 de agosto de 2022
4247148 - ERROR: "Utility command failure: REORG TABLESPACE XXX.XXX Return code = 8"

When using the Reorg feature located on Tablespaces | right click a tablespace | Utilities | Reorg The following error is received:

Revisado: quarta-feira, 24 de agosto de 2022
4278697 - Error: "Too many trial keys entered"

Error received after entering a licensing key to extended expiration date. "No more trial keys."

Revisado: quarta-feira, 24 de agosto de 2022
4333239 - Error: "TBSpaceAuth" when migrating tables with the Migration Wizard.

Getting error "TBSpaceAuth" when migrating tables with the Migration Wizard.

Revisado: quarta-feira, 24 de agosto de 2022
4269038 - Error: "System.IO.IOException, The network path was not found"

I've  installed Toad for DB2. It worked well then suddenly it got an error : System.IO.IOException, The network path was not found.

Revisado: quarta-feira, 24 de agosto de 2022
4265869 - Error: "System.InvalidOperationException" when trying to select a menu option.

Error received when trying to select a menu option such a SQL Editor menu option: "System.InvalidOperationException"

Revisado: quarta-feira, 24 de agosto de 2022
4268406 - Error: "SQL30081N Communication error has been detected" when connecting

Tried to connect from Toad to a local database and got error "SQL30081N Communication error has been detected". ERROR [08001] [IBM] SQL30081N...

Revisado: quarta-feira, 24 de agosto de 2022
4333781 - Error: "invalid cast" when changing a table column from integer to varchar.

Getting the error below  when changing a table column from integer to varchar: ERROR[42846][IBM][DB2/AIX64] SQL0461N Avalue with date type...

Revisado: quarta-feira, 24 de agosto de 2022
4273937 - Error: "First or second server wasn't set" while adding a catalog

User cataloged a DB2 9.1 database with authentication=client and used Toad for DB2 v 4.5.1, right click on a table, then click on Extract DDL an...

Revisado: quarta-feira, 24 de agosto de 2022
4325603 - Error: "Exception: System.NullReferenceException" when altering GROUP Privileges to a package

When adding GROUP privileges to a package getting the following error...

Revisado: quarta-feira, 24 de agosto de 2022
4234987 - Error: "Exception in debugger: String was not recognized as a valid DateTime" when running proced

Error received when entering DateTime parameter during debugging: "Exception in debugger: String was not recognized as a valid DateTime."

Revisado: quarta-feira, 24 de agosto de 2022
4275102 - Editor, Right click generates System.NullReferenceException, Object reference not set to an instance

In the editor, user loads SQL script and highlights section. Right clicking for context menu will return an exception. System...

Revisado: quarta-feira, 24 de agosto de 2022
4261285 - Editor, DB2 Database ErrorERROR [076006] [IBM] CLI0102E Invalid conversion. SQLSTATE=07006

In Object Explorer, user right clicks on Stored Proc and selects Execute, it opens editor window, prompts for input and runs procedure, works...

Revisado: quarta-feira, 24 de agosto de 2022
4275593 - Editor not running query when cursor is on commented lines.

Revisado: quarta-feira, 24 de agosto de 2022
4237860 - Editor hangs after 'This object is not code' error message appears

In Toad for DB2 6.3, when you type a query such as 'select * from user.table', then click in the very left column in the Editor, by the line...

Revisado: quarta-feira, 24 de agosto de 2022
4274760 - Editor Check Syntax option is flagging functions as identifiers, "identifier might conflict"

Editor Check Syntax option is flagging functions such as Hour, Year, etc as identifiers.  The following parser message appears also when...

Revisado: quarta-feira, 24 de agosto de 2022
4227032 - Editor Code Completion displays incorrect procedure names list.

Editor Code Completion displays incorrect procedure names list.  It is listing what appears to be procedure specified names instead of actual names.

Revisado: quarta-feira, 24 de agosto de 2022
4285170 - Editing Catalog Statistics

Revisado: quarta-feira, 24 de agosto de 2022
4238854 - Duration Time for a completed sql statement shows incorrectly as 00:00:00

When executing several select statements in the Editor by pressing F9, and Script Result Grouping is set to 'One Tab per Query', the 4 tabs show...

Revisado: quarta-feira, 24 de agosto de 2022
4318818 - Drop statement is not included in the Rebuild Trigger script

In v5.6, when rebuilding a trigger in the Explorer, there is not a drop statement at the beginning of the script that is created.  It is just a...

Revisado: quarta-feira, 24 de agosto de 2022
4301348 - Do you have the function "Space Growth Forecast" on Toad for DB2?

ENHANCEMENT REQUEST: User  wanted to have a Space Growth Forecast in Toad for DB2 the same report in Quest Central for DB2.

Revisado: quarta-feira, 24 de agosto de 2022
4337845 - Download of product shows corrupt or invalid - "The signature of SOSSE_Client....msi is corrupt or invalid"

Trying to download the software and getting an error "The signature of product_install_file is corrupt or invalid"

Revisado: quarta-feira, 24 de agosto de 2022
4270495 - Download, Denial - Cannot download commercial executable of Toad (or another product)

Unable to download commercial installer for latest version.  After logging into Support Portal and trying to download Toad (or another product...

Revisado: quarta-feira, 24 de agosto de 2022
4239241 - Downloaded installer file name is in alphanumeric string (name shows letters & numbers and no EXE).

After downloading, the installer file's name is an alphanumeric string, instead of what was listed on the website, and when the file is launched...

Revisado: quarta-feira, 24 de agosto de 2022
4335157 - Does Toad support SET SERVEROUTPUT command?

Revisado: quarta-feira, 24 de agosto de 2022
4332793 - Does Toad support Atlassian Bitbucket?

Is it possible to integrate Bitbucket Source Control in Toad to check in/out objects?

Revisado: quarta-feira, 24 de agosto de 2022
4274821 - Does Toad have a version that is supported on Mac?

Does Toad support the Apple Mac platform?

Revisado: quarta-feira, 24 de agosto de 2022
4334621 - Does Toad For DB2 ZOS support AS/400?

Does Toad For DB2 ZOS support AS/400?

Revisado: quarta-feira, 24 de agosto de 2022
4333960 - Does Toad For DB2 z/OS support the "New Function Mode" of DB2 z/OS?

Does Toad For DB2 z/OS support the   "New Function Mode" of DB2 z/OS?

Revisado: quarta-feira, 24 de agosto de 2022
4250392 - Does Toad for DB2 z/OS Dev Suite with DB Admin Module have backup/restore capabilities?

Does Toad for DB2 z/OS Dev Suite with DB Admin Module have backup/restore capabilities?

Revisado: quarta-feira, 24 de agosto de 2022
4335049 - Does Toad for DB2 support Windows 2016?

Does Toad for DB2 support Windows 2016? If not, when this will be supported?

Revisado: quarta-feira, 24 de agosto de 2022
4333797 - Does Toad for DB2 support Windows 10?

Does Toad for DB2 LUW or zOS support Windows 10?

Revisado: quarta-feira, 24 de agosto de 2022
4269386 - Does Toad for DB2 V4.5.2 have PL/SQL Editor for debugging in DB2 v9.7?

Does Toad for DB2 V4.5.2. have the PL/SQL Editor/Debugger for DB2 V9.7?

Revisado: quarta-feira, 24 de agosto de 2022
4212596 - Does Toad for DB2 supports Windows 8?

Revisado: quarta-feira, 24 de agosto de 2022
4321190 - Does Toad for DB2 support Mac?

Is it possible to use Toad for DB2 in a Mac environment?

Revisado: quarta-feira, 24 de agosto de 2022
4278226 - Does Toad for DB2 support Log Reader feature?

Does Toad for DB2 support Log Reader (Rolls back transactions in the transaction log without the need to restore from a backup)?

Revisado: quarta-feira, 24 de agosto de 2022
4249731 - Does Toad for DB2 support Java Store Procedure?

Does toad for DB2 support Java Store Procedure?

Revisado: quarta-feira, 24 de agosto de 2022
4332986 - Does Toad for DB2 support DB2 11 and 11.1 version?

Does Toad for DB2 support DB2 11 and 11.1 version?

Revisado: quarta-feira, 24 de agosto de 2022
4314181 - Does Toad for DB2 include DB2 client ?

Does Toad for DB2 include  DB2 client ?

Revisado: quarta-feira, 24 de agosto de 2022
4282915 - Does TOAD for DB2 support DB2 Cobra?

Does TOAD for DB2 support DB2 Cobra or DB2 v 9.7 LUW?

Revisado: quarta-feira, 24 de agosto de 2022
4234900 - Does TOAD for DB2 software use JAVA?

Revisado: quarta-feira, 24 de agosto de 2022
4226830 - Does Toad for DB2 Support AS400?

Does Toad for DB2 version 1.0.3 support the AS400 environment?

Revisado: quarta-feira, 24 de agosto de 2022
4265497 - Does Toad for DB2 come with a license for DB2 Connect Personal Edition?

Does Toad for DB2 come with a license for "DB2 Connect Personal Edition"?

Revisado: quarta-feira, 24 de agosto de 2022
4259180 - Does Toad for DB2 have a SQL Tracker Tool?

Revisado: quarta-feira, 24 de agosto de 2022
4283375 - How to backup and restore tablespaces from the Utilities tab?

Toad does not provide any options under Utilities tab of tablespaces for Backup and Restore.    

Revisado: quarta-feira, 24 de agosto de 2022
4290541 - How to access and use the Export Wizard?

How to access and use the Export Wizard?

Revisado: quarta-feira, 24 de agosto de 2022
4279588 - How to access and use the Import Wizard?

How to access and use the Import Wizard?

Revisado: quarta-feira, 24 de agosto de 2022
4314198 - How much does Toad cost?

I'd like an idea of how much Toad costs. How do I find out?

Revisado: quarta-feira, 24 de agosto de 2022
4289375 - How many PC's, computers, devices, can I install / use Toad on for a single user license key?

How many PC's, computers, devices, can I install / use Toad on for a single user license key?

Revisado: quarta-feira, 24 de agosto de 2022
4279058 - How does Toad connect to the database? Does it use the odbc driver on the pc?

How does Toad connect to the database? Does it use the odbc driver on the pc?

Revisado: quarta-feira, 24 de agosto de 2022
4234250 - How do you set you configure your catalogue with the Client Configuration Wizard to DB2 for LUW D

How do you set you configure your catalogue with the Client Configuration Wizard to DB2 for LUW Databases?

Revisado: quarta-feira, 24 de agosto de 2022
4225960 - How do you set you configure your catalogue with the Client Configuration Wizard to a DB2 Connect

How do you set you configure your catalogue with the Client Configuration Wizard to a DB2 Connect Gateway?

Revisado: quarta-feira, 24 de agosto de 2022
4225904 - How do you find error messages in Knowledge Xpert?

I am working with KXpert but I can't find the error message info. Previously there was a list of Ora/PLSQL/TNS errors that I could search through...

Revisado: quarta-feira, 24 de agosto de 2022
4234120 - How do you create an automated job?

How do you use the automation feature?

Revisado: quarta-feira, 24 de agosto de 2022
4268521 - Does not show all the indexes from the target schema that are not in the source

User compares 2 tables. A.TEST_Table has 1 primary index and the other B.TEST_Table has more than 20 indexes. 1. If compare A.TEST_Table   to B...

Revisado: quarta-feira, 24 de agosto de 2022
4250733 - Does not show Tablespaces that are dependent on a Stogroup

In the Object Explorer, in the Dependencies tab, it does not show the Tablespaces that are dependent on a Stogroup.

Revisado: quarta-feira, 24 de agosto de 2022
4248757 - Does not automatically connect when launching Spotlight or SQL Optimizer

When launching Spotlight on DB2 or SQL Optimizer for DB2 from Toad for DB2 the database connected in Toad does not automatically connect in...

Revisado: quarta-feira, 24 de agosto de 2022
4319670 - Does exist a 64 bit version of Toad for DB2?

There are many programs that demands a Toad for DB2 64 bit version. Does exist any version 64 bit?

Revisado: quarta-feira, 24 de agosto de 2022
4241422 - Do z/OS components need to be upgraded when install new version of Toad for DB2?

When upgrading to a new version of Toad for DB2, do any of the database objects need to be updated for z/OS Components?

Revisado: quarta-feira, 24 de agosto de 2022
4284670 - Display problems in database explorer after last windows update

The names are not correctly displayed. It looks like you can see only aprox. 80% of the height of the characters and happens in every tab.

Revisado: quarta-feira, 24 de agosto de 2022
4268204 - Display of several database data not working.

Not all of the databases are displayed in Toad for DB2 version 6.3. This behaviour is different than in version 6.2.

Revisado: quarta-feira, 24 de agosto de 2022
4265706 - Displaying aliases for Tables and Table creators with filters

I want to be able to see the aliases that exist for a table or a table creator. Currently, I can only specify the alias schema which is not...

Revisado: quarta-feira, 24 de agosto de 2022
4310407 - Demonstrating Toad for DB2's Compare Object feature

This video will demonstrate Toad for DB2's Object Compare feature.

Revisado: quarta-feira, 24 de agosto de 2022
4294347 - Spring Framework - CVE-2022-22965 vulnerability

Toad products are not impacted by the Spring Framework Java related security issue - CVE-2022-22965

Revisado: quarta-feira, 24 de agosto de 2022
4334432 - Space Management option is shown as "not Licensed"

Space Management option is shown as "not Licensed"

Revisado: quarta-feira, 24 de agosto de 2022
4310057 - Space Management menu does nothing when connected to z/os subsystem

When right clicking a Table or Tablespace in the Object Explorer there is a 'Space Management' menu. However, it does not seem to do anything.

Revisado: quarta-feira, 24 de agosto de 2022
4313685 - Space Calculator tab has different value between version V.6.0 and V.6.2.

The Space Calculator tab display different value between version V.6.0 and V.6.2 in Tablespace Allocation Pie Chart.

Revisado: quarta-feira, 24 de agosto de 2022
4229123 - Space Calculator tab does not show correct Tablespace allocation numbers.

Space Calculator tab does not show correct Tablespace allocation numbers.

Revisado: quarta-feira, 24 de agosto de 2022
4241185 - Slow on code completion for 4 tables join

Selected join after a "Where" clause takes about 10 to 30 secs.for the code completion to display the columns.

Revisado: quarta-feira, 24 de agosto de 2022
4283207 - Slow initial Toad for DB2 starts up with LDAP

User installed Toad for DB2 v 4.6.2 and started it up - it takes a long time to initialize and become available. (40 seconds). Not only launch...

Revisado: quarta-feira, 24 de agosto de 2022
4273680 - Site Message case sensitivity

Is Site Message parameter cases sensitive.

Revisado: quarta-feira, 24 de agosto de 2022
4244643 - Unable to launch SQL Analysis on French Windows Operating System

On a French / European language Windows machine (other than English), when trying to launch SQL Analysis, the following message appears: The...

Revisado: quarta-feira, 24 de agosto de 2022
4312624 - Unable to FTP scripts to zOS platform

zOS Platform requires a secure FTP connection. The FTP to zOS for scripts will not work unless it's a secure connection. Systems programmer...

Revisado: quarta-feira, 24 de agosto de 2022
4328035 - Unable to display DECFLOAT column data if value's precision is &gt;=30

There is new datatype 'DECFLOAT' in IBM DB2 9.7. Toad can display DECFLOAT column data if the values's precision is under 29. If the precision is...

Revisado: quarta-feira, 24 de agosto de 2022
4261875 - Unable to connect to DB2 after upgrading to version 3.6 or above

Upgrading from Toad Data Point version 3.5 to 3.6 and migrating settings. There is a default DB2 Client installed - version 9.7. However, on...

Revisado: quarta-feira, 24 de agosto de 2022
4254238 - Unable to catalog databases, getting error "...MSVCR100.dll is missing"

Follow the wizard to catalog database but is not able to, nothing is added,gets a blank configuration screen at the end of the  configuration...

Revisado: quarta-feira, 24 de agosto de 2022
4236926 - Unable to cancel running query from Toad

In Toad for DB2 v6.2.0.315, there is a problem when trying to cancel a running query, where the query does not cancel, and you have to end the...

Revisado: quarta-feira, 24 de agosto de 2022
4232340 - Unable to Alter dataset template

Revisado: quarta-feira, 24 de agosto de 2022
4285545 - Un-pinned Connection Manager does not close upon connection to database

The Connection Manager set to unpinned does not close when it is slide out.  Clicking outside of the Connection Manger doesn't help unless there is...

Revisado: quarta-feira, 24 de agosto de 2022
4278606 - Tune SQL Button Grayed-Out in SQL Analysis for DB2 LUW

After running a successful SQL Analysis collection,  however, user couldn't send the SQL to the SQL Optimizer (the button is grayed-out.    If...

Revisado: quarta-feira, 24 de agosto de 2022
4241407 - Trying to connect with using just a DB2 driver gets "Load DB2 client library error"

When trying to connect with just a DB2 driver, but no client, users are not able to connect. They receive an error that says "Load DB2 client...

Revisado: quarta-feira, 24 de agosto de 2022
4232119 - Troubleshooting issues with export taking too long.

When trying to export a dataset of about 300k records to an instance of Excel. It took about 17 minutes to complete, which is a very long time...

Revisado: quarta-feira, 24 de agosto de 2022
4273724 - Trouble with Import Wizard: "Input array is longer than number columns in this table"

  When using the import wizard, I  add a file (*.CVS), selected  comma delimited file format, and select Next.   An error appeared:   "Input...

Revisado: quarta-feira, 24 de agosto de 2022
4273711 - Tried to do an advance alter, expected an export on script

User has  altered a table and changed tablespace name then expected to see  export/import on script but it was not there. Â

Revisado: quarta-feira, 24 de agosto de 2022
4308378 - Tools | Reports | Data Reports. Unable to write a SQL statement to 'call' a SQL file.

Tools | Reports | Data Reports | click ‘Next’ | text area to write a SQL statement.  Unable to or cannot write a SQL statement to 'call' a SQL...

Revisado: quarta-feira, 24 de agosto de 2022
4302197 - Tools | DB2 Command Window menu option error: "Item has already been added. Key in dictionary: 'd

When I go to Tools  | DB2 Command Window menu option, I get the error: Exception: System.ArgumentException Message : Item has already been...

Revisado: quarta-feira, 24 de agosto de 2022
4301624 - Tools | Monitor | 'Spotlight on DB2' is grayed out or disabled.

Tools | Monitor | 'Spotlight on DB2' menu item is grayed out. Tools | Quest Tools | 'Spotlight on DB2' is also grayed out or not enabled.

Revisado: quarta-feira, 24 de agosto de 2022
4296320 - Tools | Compare | “DB/DBM Parameters Compare” | the Compare button is grayed-out.

Tools | Compare | “DB/DBM Parameters Compare” | the Compare button is grayed-out.  When logged-in to both the LUW DB2 database instances that will...

Revisado: quarta-feira, 24 de agosto de 2022
4289783 - Toad truncates or deletes characters from the DDL create statement.

Toad chops off or removes characters from the DDL create script. Below is an example, it truncates "SET" to "T" in the following DDL. It happens...

Revisado: quarta-feira, 24 de agosto de 2022
4333066 - Toad tries to drop tables with restrict on drop option and that cannot be done direclty

Toad tries to drop tables with restrict on drop option and that cannot be done direclty as you get an "SQL0672N Operation DROP not allowed on...

Revisado: quarta-feira, 24 de agosto de 2022
4301711 - Toad takes a long time to launch

Revisado: quarta-feira, 24 de agosto de 2022
4237805 - Toad sets db2codepage as 1208 (UTF8) by default

The database has a codepage setting of 1252, but when opening the CLP, or the Editor from Toad, it always defaults to 1208, which can cause some...

Revisado: quarta-feira, 24 de agosto de 2022
4310479 - Toad scheduler does not work unless the user is logged in

Revisado: quarta-feira, 24 de agosto de 2022
4278495 - Toad returns different result for the select when arithmetic operation is used against the FLOAT

Toad is returning different result for the select when arithmetic operation is used against the FLOAT type column. Is this somewhere configurable...

Revisado: quarta-feira, 24 de agosto de 2022
4335569 - Toad no longer has the ability to store two license keys

Revisado: quarta-feira, 24 de agosto de 2022
4268281 - Toad is unable to generate a script to migrate a database (with dependents).

When selecting a database (all of its dependents) Script generates a list of objects for migration, however, the script is missing the CREATE...

Revisado: quarta-feira, 24 de agosto de 2022
4310949 - Toad is flagging function REGEXP_LIKE as a syntax error "The XML was improperly formatted. Please escape it if necessary"

Function REGEXP_LIKE was introduced in DB2 11.1. When using it in a sql statement, Toad is flagging it as an error: Example: SELECT NAME...

Revisado: quarta-feira, 24 de agosto de 2022
4227355 - Toad is not generating a correct script when altering a table to drop a column

When altering a DB2 table in Toad to drop a column, Toad generates a script utilizing the Unload tool. However, Toad generates the script so that...

Revisado: quarta-feira, 24 de agosto de 2022
4283787 - Toad is always trying to drop table when addind a column with not null.

Toad is always trying to drop table when adding a column with not null. The issue is that when an alter table is performed, Toad is creating the...

Revisado: quarta-feira, 24 de agosto de 2022
4241367 - Toad is adding an extra revoke of package syntax to the package script when Rebinding a package.

When rebinding a package, Toad is adding an extra revoke of package syntax of users to the package script. 

Revisado: quarta-feira, 24 de agosto de 2022
4330480 - Toad hangs after choosing "Cancel already running query" option

Toad offers different options when the connection to the database is lost and reopened and there were active queries running on this connection...

Revisado: quarta-feira, 24 de agosto de 2022
4283163 - Toad generates statement without read, write, or no access option in it

Performing Reorg using Toad for DB2 presents an option to allow read, write, or no access to the tables during a reorg. The option doesnt get...

Revisado: quarta-feira, 24 de agosto de 2022
4273138 - Toad freezes other background operations when running a query.

When running a long query in the Editor, Toad freezes other operations until the particular queryfinishes.

Revisado: quarta-feira, 24 de agosto de 2022
4329194 - TOAD for DB2: problem with data import

While trying import in Toad for DB2, the import does not perform the complete process.

Revisado: quarta-feira, 24 de agosto de 2022
4274949 - Toad for DB2 z/OS Use of SYSDUMMY1 Table

Revisado: quarta-feira, 24 de agosto de 2022
4247918 - Toad for DB2 Z/OS is missing the Utilities tab from the DB Explorer and Object Explorer

Toad for DB2 Z/OS is missing the Utilities tab from the DB Explorer and Object Explorer.

Revisado: quarta-feira, 24 de agosto de 2022
4239941 - Toad for DB2 z/OS does not show data set information for DB2 for zOS V12

Since the migration to DB2 z/OS V12 (Function Level is 100 now), data set information is no longer shown. With DB2 for z/OS V11 this worked fine.

Revisado: quarta-feira, 24 de agosto de 2022
4238075 - Toad For DB2 ZOS ENF: Show SQLs from Package shows no data and error 'Index was outside of the ar

No SQL data is shown in the SQL tab, when you go to: Package tab | SQL | Error; no SQLs shown 'Index was outside of the array' This is an error...

Revisado: quarta-feira, 24 de agosto de 2022
4311343 - Toad for Db2 password save disabled

Is it possible, if the installation is done with prohibited password, to enable it again without a software reinstall?

Revisado: quarta-feira, 24 de agosto de 2022
4290362 - Toad for DB2 receives the Error rc=0003 when launching or starting SQL Optimizer.

Toad for DB2 gets, Error (rc=0003), when tries to launch or start SQL Optimizer. 

Revisado: quarta-feira, 24 de agosto de 2022
4278195 - Toad for DB2 takes long time to start.

Start of Toad for DB2 takes a long time. This slow startup occurs every single time Toad for DB2 is started.

Revisado: quarta-feira, 24 de agosto de 2022
4265801 - Toad for DB2 shows trial key every time it starts after registering commercial key.

Registered my Toad for DB2 with a commercial key but every time I start it, it shows a trial key.

Revisado: quarta-feira, 24 de agosto de 2022
4254655 - Toad for DB2 patch version 5.6.1.2957

Toad for DB2 patch version 5.6.1.2957

Revisado: quarta-feira, 24 de agosto de 2022
4296941 - Toad for DB2 Installation/ Database Connection Requirements

What are the requirements to install and connect to Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4284798 - Toad for DB2 incorrectly generates Revoke scripts

Revisado: quarta-feira, 24 de agosto de 2022
4283715 - Toad for DB2 Explain does not show correct result

Toad for DB2 V7.0 and V7.1 does not show correct access path when running execute explain plan.

Revisado: quarta-feira, 24 de agosto de 2022
4283217 - Toad for DB2 is locking up whenever they try to launch

Revisado: quarta-feira, 24 de agosto de 2022
4269414 - Toad for DB2 IBM System i support

Doe Toad for DB2 supports Db2 on IBM System i?

Revisado: quarta-feira, 24 de agosto de 2022
4239400 - Toad for DB2 locks sys tables when used with autocommit off.

Toad for DB2 locks sys tables when used with autocommit off.

Revisado: quarta-feira, 24 de agosto de 2022
4236595 - Toad for DB2 installer disappeared after clicking next button

Toad for DB2 installer disappeared after clicking next button.

Revisado: quarta-feira, 24 de agosto de 2022
4236388 - Toad for DB2 installation error - Prerequisite software not installed.

When installing Toad for DB2, all the prerequisite software are not installed.

Revisado: quarta-feira, 24 de agosto de 2022
4316879 - Toad for DB2 Error Message - ObjectDisposedException

When closing Toad for DB2 V.6.0 and it often display the below error message window.

Revisado: quarta-feira, 24 de agosto de 2022
4290221 - Toad for DB2 error when connecting to database: SQL30082N Security processing failed with reason 17

Toad for DB2 error connecting to database. Since getting the account re-established on the server, the following error is now received: ERROR...

Revisado: quarta-feira, 24 de agosto de 2022
4283159 - Toad for DB2 doesn't show all user-defined Function names when switching from Quest Central

Quest Central for DB2 shows all user-defined Function names, however, Toad for DB2 does not showthis.

Revisado: quarta-feira, 24 de agosto de 2022
4251327 - Toad for DB2 does not correctly set the DB2 Client Properties

Toad for DB2 fills max 8 characters to the DB2 Client Property DB2ClientUser. The field in the database is defined as 128 characters long.

Revisado: quarta-feira, 24 de agosto de 2022
4238665 - Toad for DB2 doesn't show comments correctly and amends procedure code, when using a database in Oracle compatibility mode.

When Toad compiles the procedure, it misinterprets the comment depending on the location of the comment. Once you compile it and open the code in...

Revisado: quarta-feira, 24 de agosto de 2022
4325506 - TOAD for DB2 2.5 places Locks

TOAD for DB2 places Locks when selecting data from DB/2 tables, as well as places table locks when selecting a table in the schema browser. Is...

Revisado: quarta-feira, 24 de agosto de 2022
4308518 - Toad for DB2 4.7. Database Diagram. Not Null columns are unchecked by default. They are backwa

Tools Menu | Database Diagram | drag some tables in the Diagram window | the Not Null columns are un-checked by default. They are backwards from...

Revisado: quarta-feira, 24 de agosto de 2022
4289137 - Toad for DB2 "System.OutOfMemoryException - Out of Memory" error during script run.

Toad for DB2 Out of Memory error during execution of query statement, code, or script.  Toad hangs or freezes, and a box with red 'X' appears or...

Revisado: quarta-feira, 24 de agosto de 2022
4270569 - Toad for DB2 6.0 and newer, DB2 client requirements. Error: "Toad did not find a default DB2 client"

On launch of Toad for DB2, the error "Toad did not find a default DB2 client" is given. Toad will continue to open after clicking OK to this...

Revisado: quarta-feira, 24 de agosto de 2022
4263602 - Toad for DB2 5.2 Hotfix

Revisado: quarta-feira, 24 de agosto de 2022
4273125 - Toad FileOpen Button does not appear after clicking

Clicking the "FileOpen" Button in the Menubar to open any file (be it SQL or TAS) does not work - the file open dialog does not show up, only the...

Revisado: quarta-feira, 24 de agosto de 2022
4232445 - Toad error or crash during installation: "Quest Installer setup failed. Examine setup log for details."

Toad installation error message: "Quest Installer setup failed. Examine setup log for details." or from the Windows Event Viewer: EventType...

Revisado: quarta-feira, 24 de agosto de 2022
4314366 - Toad does not generate DEFAULTIF clause on Alter table.

Trying to alter a null column to not-null column. Toad doesn't generate the nessesary DEFAULTIF clause instead it generates NULLIF clause.

Revisado: quarta-feira, 24 de agosto de 2022
4227344 - Toad does not Free Plans

When trying to free a Plan, by right-clicking on it in Toad's Object Explorer, and clicking on the "Free Plan..." option, one may see the "FREE...

Revisado: quarta-feira, 24 de agosto de 2022
4325135 - Toad DB2 data provider is no longer available

Toad DB2 data provider is no longer available in the data link properties provider list.

Revisado: quarta-feira, 24 de agosto de 2022
4285529 - Toad DB2 LUW 5.2 does not display any invalid objects data in the Object Explorer.

Toad DB2 LUW doesn't show the list of invalid objects on a database from the Object Explorer | Database | Invalid Objects.

Revisado: quarta-feira, 24 de agosto de 2022
4273157 - Toad DB2 returns error when using Sql Optimizer.

When accessing Sql Optimizer via Toad for DB2 an error is returned. See below: " Invalid plan table{s} definition; it may not match with current...

Revisado: quarta-feira, 24 de agosto de 2022
4269299 - TOAD DB2 has problem with special characters from password

When Db2 LUW uses passwords starting with "=" a System.AgregateException error occurs when trying to generate DDL in Toad Explorer.

Revisado: quarta-feira, 24 de agosto de 2022
4236849 - Toad DB2 uninstall error: An error occurred while creating the instance "TOADB30".

Toad DB2 uninstall error: An error occurred while creating the instance "TOADB30".   The return code is "1950". Create the instance manually...

Revisado: quarta-feira, 24 de agosto de 2022
4289351 - Toad Data Modeler with a Toad DBA Suite for DB2 LUW 6.0 license key thinks it's a Trial license.

Toad Data Modeler activated with a Toad DBA Suite for DB2 LUW 6.0 license key thinks or shows up as a Trial license.

Revisado: quarta-feira, 24 de agosto de 2022
4269967 - Toad Data Modeler free promotion program.

Does Toad Data Modeler come free with my purchase of Toad?

Revisado: quarta-feira, 24 de agosto de 2022
4317491 - Toad Data Modeler error : 'Error loading library 'DB2CLI.DLL'

When trying to establish a connection to the mainframe via Toad Data Modeler, getting the following error :'Error loading library 'DB2CLI.DLL'

Revisado: quarta-feira, 24 de agosto de 2022
4243824 - Toad crashes when performing a schema compare

Toad crashes when performing a schema compare: ERROR [58004] [IBM][DB2/NT64] SQL0901N  The SQL statement failed because of a non-severe system...

Revisado: quarta-feira, 24 de agosto de 2022
4243848 - Toad crashes after clicking on the Application tab

The following error appears when going to Object Explorer | Databases | Application Tab 'Toad for DB2 no longer works A problem has prevented...

Revisado: quarta-feira, 24 de agosto de 2022
4269189 - Toad allows to create new indexes having the same criteria with existing system index.

When a table is created with a primary key, so a system index  is created, if a new index is then built with the same criteria as  the system...

Revisado: quarta-feira, 24 de agosto de 2022
4296437 - Toad accepts half a license key and causes "DB2 LUW connections are not currently licensed."

When I connect to my database I get the error:     "DB2 LUW connections are not currently licensed." I did not buy Toad for ZOS.

Revisado: quarta-feira, 24 de agosto de 2022
4272823 - Timestamp values of temp tables are wrongly displayed in Toad V5.6

Example: COLUMN_1 of TOAD.TEMP_TABLE in DB2D displays value as "2014-09-10-09.17.54.775734189001".  Toad 5.6 displays the same COLUMN_1 value as...

Revisado: quarta-feira, 24 de agosto de 2022
4238766 - Threads do not close after Migrate Object is done running

Toad does not close all DB2 threads after using the Migrate Object tool. Each use of this tool is causing one thread to remain open. So, if the...

Revisado: quarta-feira, 24 de agosto de 2022
4241538 - There are users that are not showing in the Users list

After creating a user, they are not showing in the Object Explore's list of Users.  They are showing in the Schema list instead.

Revisado: quarta-feira, 24 de agosto de 2022
4251243 - There are no INDEX IN clauses being generated at the range level in DDLs for range partitioned

There are no INDEX IN clauses being generated at the range level in DDLs for range partitioned tables.

Revisado: quarta-feira, 24 de agosto de 2022
4238578 - The Space Calculator window is displaying incorrect information for PureScale Clusters

The Space Calculator window (Space Management | Calculate Space) is displaying incorrect information for PureScale Clusters.

Revisado: quarta-feira, 24 de agosto de 2022
4273947 - The socket object used by MailBee was unexpectedly closed.

Revisado: quarta-feira, 24 de agosto de 2022
4235452 - The Reorg utility option is not available on a Materialized Query (MQ) table in the Object Explorer

I am trying to run a DB2 reorg utility for an Materialized Query (MQ) table because I turned compression on the table. Thus to implement it I must...

Revisado: quarta-feira, 24 de agosto de 2022
4258202 - The option to Extract DDL is greyed out

When right clicking on a table or procedure the option for Extract DDL is greyed out.

Revisado: quarta-feira, 24 de agosto de 2022
4307702 - The installation of Toad for DB2 needs to support Windows 7 environments (32-bit and 64-bit)

The installation of Toad for DB2 needs to support Windows 7 environments (32-bit and 64-bit)

Revisado: quarta-feira, 24 de agosto de 2022
4273809 - The grid column widths are not as wide as the data that is contained within,  Is there any opt

 Viewing the columns tab in the Database Explorer, the grid column widths are not as wide as the data that is contained within.  In version 4.0...

Revisado: quarta-feira, 24 de agosto de 2022
4333922 - The generated script of an alter table doesn't put the new column in quotes

Steps to reproduce the issue: Go to Schema Browser. Select a table R-click and select 'Alter table' Create a new column All the columns in...

Revisado: quarta-feira, 24 de agosto de 2022
4248556 - The entry "COMMIT ON RETURN YES" missing from the script.

Create a store procedure with the script below: CREATE PROCEDURE RKENNEY.TEST ( ) LANGUAGE SQL DETERMINISTIC COMMIT ON RETURN YES NO EXTERNAL...

Revisado: quarta-feira, 24 de agosto de 2022
4241942 - The Date filter is sorting date columns as character, out of order

Run a query to run data in the data grid. Then click on a date columns and the filter button displays the values as though the date values are...

Revisado: quarta-feira, 24 de agosto de 2022
4332777 - The connection screen just flashes and nothing else happens

 After clicking the Connect button, the connection screen just flashes and nothing else happens. The connection window is still there and can be...

Revisado: quarta-feira, 24 de agosto de 2022
4239948 - The AUTOCOMMIT OFF option is ignored in the Editor

There is an issue with the AutoCommit option in the Editor not working when it is set from On to Off, and it seems that the AutoCommit option is...

Revisado: quarta-feira, 24 de agosto de 2022
4278834 - The Runstats Utility script is not generated correctly when distribution option is selected

From  DB Browser of Toad for DB2, select multiple tables and right click to  select Utilities.   Select Runstats  object options  | distribution...

Revisado: quarta-feira, 24 de agosto de 2022
4283687 - TEST: invalid database ddl

The script which is generated by Toad for the database is not working. Generated is: PAGESIZE 4096 Pages but Pages is not a valid DB2 Syntax...

Revisado: quarta-feira, 24 de agosto de 2022
4262086 - Tablespaces, generating extra space while generating runstats script

Toad is generating extra space while generating runstats script (Tablespace | Utilities | Runstats). This is causing the script generate errors. 

Revisado: quarta-feira, 24 de agosto de 2022
4268289 - Tablespace status - can it be displayed on the Extra Column list

ENHANCEMENT REQUEST: On the display of all tablespaces (Extra columns list)  please do 1. Add tablespace status 2. Replace Bufferpool ID by...

Revisado: quarta-feira, 24 de agosto de 2022
4316620 - Tables with both identity and without identity and Preserve Data Method set to 'Use Temporary

When altering a SMS tablespace to add new data files, the tablespace has to be recreated. If the tablespace contains tables with both identity and...

Revisado: quarta-feira, 24 de agosto de 2022
4250492 - Tablespace Dependencies not showing indexes for range partitioned table

When I view the Dependencies tab for Tablespaces in the Database Explorer, it does not list the indexes that are set up on range partitioned tables.

Revisado: quarta-feira, 24 de agosto de 2022
4235982 - Tablespace Definition is not generated in tablespace DDL

In TOAD 4.6, if you extract DDL from tablespace, with drop statement included, the unique index will not be generated. In TOAD 4.7, if you do...

Revisado: quarta-feira, 24 de agosto de 2022
4278953 - Table schema is different with index schema after compare object.

The schema on the table name on which an index is to be created not being updated based on the transformation rules entered during the object...

Revisado: quarta-feira, 24 de agosto de 2022
4268488 - Table showing Status as Normal but it is not accessable

Revisado: quarta-feira, 24 de agosto de 2022
4273962 - Table information will not refresh

After making a modification to a table or a tablespace the detail information will not refresh.

Revisado: quarta-feira, 24 de agosto de 2022
4243693 - Table import error: Failed to enable constraints

Revisado: quarta-feira, 24 de agosto de 2022
4268422 - Table Filter list issue

Revisado: quarta-feira, 24 de agosto de 2022
4238626 - Table creation script, or Generate SQL script does not include indexes of tables

In Toad for DB2, when you have a table that has an index, from Object Explorer, if you right-click the table | Generate SQL | Create Script | To...

Revisado: quarta-feira, 24 de agosto de 2022
4297766 - System.Xml.Schema.XmlSchemaException error on startup

Everytime Toad starts, an XML error  message is displayed on startup System.Xml.Schema.XmlSchemaException The 'http://www.quest.com/2010/15/01...

Revisado: quarta-feira, 24 de agosto de 2022
4308372 - System.FormatException Error "Input string was not in a correct format" on launching Toad

The following error occurs on launching Toad: System.TypeInitializationException The type initializer for 'Quest.Toad.DB2.DB2ConnectionControl...

Revisado: quarta-feira, 24 de agosto de 2022
4284752 - System.InvalidCastException in Database explorer.

When trying to right click on name column in tables branch of Database explorer the System.InvalidCastException appeared.

Revisado: quarta-feira, 24 de agosto de 2022
4278718 - System.IO.DirectoryNotFoundException when exporting large result sets (~20K rows) to Excel

Rreported error:"Exception: System.IO.DirectoryNotFoundException" when exporting large result sets (~20K rows) to Excel. System.IO...

Revisado: quarta-feira, 24 de agosto de 2022
4334528 - Synonyms are not recreated when altering a table and changing the position of a column

Steps to reproduce the problem: 1] Alter a table (that has a synonym defined on it) changing the position of the last column.   2] Check the...

Revisado: quarta-feira, 24 de agosto de 2022
4243864 - SyncPoints generated with duplicate numbers

When trying to generate a Creation Script for more than one table in the editor, the SyncPoints are generated for each table separately. It...

Revisado: quarta-feira, 24 de agosto de 2022
4306510 - Sync script for Object Compare (Schema) is doing a DROP TABLE instead of ALTER TABLE where the only difference is in the COMPRESS clause of the table

When doing an Object Compare of a full Schema, some tables are showing as being different only in terms of the COMPRESS clause i.e. one table...

Revisado: quarta-feira, 24 de agosto de 2022
4270041 - Support Portal, Why was the Downloads section removed from the product’s landing page?

Why was the Downloads section removed from the product’s landing page?   Where can one now download the product within the  Support Portal?

Revisado: quarta-feira, 24 de agosto de 2022
4309604 - Support for Toad for Hadoop - How to report an issue

How to report an issue with Toad for Hadoop

Revisado: quarta-feira, 24 de agosto de 2022
4242585 - Support for Partitioned Indexes

Is there Partitioned Index support for DB2 LUW databases in Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4316900 - Support for multibyte characters

The multibyte (Korean) characters is broken if language code set is English. However, if using terminal server then there is no issue even if the...

Revisado: quarta-feira, 24 de agosto de 2022
4240891 - Summary Dashboard only opens for connection it was open with the first time

When launching the Summary Dashboard, it defaults to the first connection opened when Summary Dashboard was first used. It will not open the...

Revisado: quarta-feira, 24 de agosto de 2022
4229720 - Summary values for PureScale containers are incorrect in Space Calculator

Summary values for PureScale containers are incorrect in the Space Manager. For example: Having a 4 member PureScale cluster with 4 GPFS (shared...

Revisado: quarta-feira, 24 de agosto de 2022
4279198 - Stored Procedure output not displaying

User executed a store procedure on Toad for DB2 v 4.7 and got empty result sets. However, on Quest Central for DB2 v 5.0 it returned data. The...

Revisado: quarta-feira, 24 de agosto de 2022
4291336 - How do I save (export) my connections from one Toad for DB2 install and migrate (import) them int

How do I save (export) my connections from one Toad for DB2 install and migrate (import) them into another?

Revisado: quarta-feira, 24 de agosto de 2022
4316916 - How do I get a trial license key extension?

How do I get a trial license key extension?

Revisado: quarta-feira, 24 de agosto de 2022
4250787 - How do I get a Quest product's CD shipped to me?

Revisado: quarta-feira, 24 de agosto de 2022
4282837 - How do I change the port?

Revisado: quarta-feira, 24 de agosto de 2022
4241837 - How do I change the layout and settings configuration?

How do I change the layout and settings configuration? It set this when I launched the product for the first time, but now I want to change it.

Revisado: quarta-feira, 24 de agosto de 2022
4310077 - How do I change or edit my connection's properties such as username or password?

How do I change or edit my connection's properties such as username or password?

Revisado: quarta-feira, 24 de agosto de 2022
4274599 - How do I cancel the running TAS file ?

When manually running a TAS file via Toad, how do I cancel the running TAS file ?  

Revisado: quarta-feira, 24 de agosto de 2022
4228961 - How do enable debugger when a procedure's debug mode is set to 'DISALLOW'?

When trying to debug a stored procedure, Toad allows compile with debug, and to set parameters, but before it an debug, it give the error...

Revisado: quarta-feira, 24 de agosto de 2022
4225583 - How can the same query be run in different environments? Can the editor's connect be changed?

How can the same query be run in different environments? Can the editor's connection be changed to another connection?

Revisado: quarta-feira, 24 de agosto de 2022
4308974 - How and where to download a trial version of Quest Products?

How and where to download a trial version of Quest Products?

Revisado: quarta-feira, 24 de agosto de 2022
4238034 - Hostname and Port fields are not populated from Data Server Driver Congiguration Wizard

The hostname and port are not being copied from the Data Server Driver Configuration Wizard to the Connection window when selecting DSN Collection...

Revisado: quarta-feira, 24 de agosto de 2022
4278561 - Hanging the uninstallation of Toad for DB2 4.7.2

User could not install Toad for DB2. He got hung up for a long time.

Revisado: quarta-feira, 24 de agosto de 2022
4275249 - GUI/View, Generating erratic OutOfRange Exceptions on the BarItem menus when clicking around in Toad

Users may get OutOfRange exceptions on the BarItem menus when clicking around in Toad 6.0. The error cannot be reproduced consistently but it...

Revisado: quarta-feira, 24 de agosto de 2022
4231525 - Group Execute hangs when trying to make a second database connection

Group Execute hangs when trying to make a second database connection. Example: After launching Toad for DB2 but not connecting to any databases...

Revisado: quarta-feira, 24 de agosto de 2022
4209588 - Group Execute mode does not honour / apply the option " Number of Rows to fetch initially "

Editor | Window | Group Execute does not honour the option "Number of Rows to fetch initially" set in Tools|Options|Database|General. It performs a...

Revisado: quarta-feira, 24 de agosto de 2022
4237276 - Global Isolation Level configuration

Revisado: quarta-feira, 24 de agosto de 2022
4329980 - Getting “Server name not found” message when using automation to write to Sharepoint

There are several automation tasks in a  Windows 7 computer . One of them saves some Excels  to SharePoint for the users to check the...

Revisado: quarta-feira, 24 de agosto de 2022
4282831 - getting system no exceptions

Revisado: quarta-feira, 24 de agosto de 2022
4245599 - Getting SQL0206N error when doing a schema compare

Revisado: quarta-feira, 24 de agosto de 2022
4242034 - Getting SQL0440N error when trying to create a database DLL

Revisado: quarta-feira, 24 de agosto de 2022
4270523 - Getting pop up error: "Cannot open clipboard: Access is denied."

Received pop up error that says, "Cannot open clipboard: Access is denied.", in the following scenarios. The error also happens intermittently or...

Revisado: quarta-feira, 24 de agosto de 2022
4335251 - Getting message 'sorting grid data' when making changes in the grid.

Getting message 'sorting grid data' when making changes in the grid. After that happens the only option is to kill Toad. Steps to reproduce the...

Revisado: quarta-feira, 24 de agosto de 2022
4333457 - Getting error when trying to connect: "System.EntryPointNotFoundException Unable to find an entry point named 'SQLFreeConnAttribsADONET' in DLL 'db2app64.dll'"

Getting the error below when trying to connect to the database:  System.EntryPointNotFoundException Unable to find an entry point named...

Revisado: quarta-feira, 24 de agosto de 2022
4283457 - Getting Error SQLSTATE=07001 when executing query with parameters

1. Go to Tools | Options | Database | General |  "Numbers of rows to initially fetch in data tab" is set to 1000, checkbox "Apply to editor" is...

Revisado: quarta-feira, 24 de agosto de 2022
4324413 - Getting error 'SQL0104N' at Database Explorer when using Toad for DB2

Getting error 'SQL0104N' in the Database Explorer when using Toad for DB2

Revisado: quarta-feira, 24 de agosto de 2022
4333958 - Getting error "The license key is missing a specific product option. Some product functionality..." when entering the license key.

The license doesn't work. Getting error "The license key is missing a specific product option. Some product functionality.." when entering it...

Revisado: quarta-feira, 24 de agosto de 2022
4333432 - Getting error "ERROR[54005]"when trying to compare tables where key to compare contains five columns

Getting error "ERROR [54005] [IBM][DB2] SORT CANNOT BE EXECUTED BECAUSE THE SORT KEY LENGTH IS GREATER THAN 16000 BYTES" when trying to compare...

Revisado: quarta-feira, 24 de agosto de 2022
4333690 - Getting error "DragDrop registration did not succeed" when starting up Toad Data Point

Getting error below when starting up Toad Data Point:  "DragDrop registration did not succeed" and "ActiveX control '8856f961-340-11d0-a96b...

Revisado: quarta-feira, 24 de agosto de 2022
4268846 - Getting error "DB2 javit-rc=9505" after Toad for DB2 was installed

DB2 development application client was working well until the new version of Toad for DB2 3.1.1.488 was installed. I am now getting the error...

Revisado: quarta-feira, 24 de agosto de 2022
4333037 - Getting error "Applicate impostazioni di compatibilità" every time after closing Toad

Getting the error below when closing Toad:

Revisado: quarta-feira, 24 de agosto de 2022
4250214 - Getting DSNU060I and DSNU012I errors running Utilities

While executing the utilities (Runstats, Copy, etc.), the following error message is displayed after executing the utility. DSNU060I...

Revisado: quarta-feira, 24 de agosto de 2022
4283489 - Getting an error :'The SQL statement failed because of a non-severe system error.'

User tried to extract DDL of tables and got error: 'The SQL statement failed because of a non-severe system error.'

Revisado: quarta-feira, 24 de agosto de 2022
4232240 - Getting an "END-OF-STATEMENT" error when running a script with F9 (green arrow icon)

When running a script in SQL Editor using F9 or the green arrow icon: "ERROR [42601][IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token...

Revisado: quarta-feira, 24 de agosto de 2022
4301193 - Getting a “License has expired” error when trying activate Toad with license key.

Getting a “License has expired” error when trying activate Toad with license key. License key is a Term License Key.

Revisado: quarta-feira, 24 de agosto de 2022
4241770 - Getting a message logging into Supportlink saying my username and password could not be authentic

When trying to log into Supportlink, I get a message saying that my username and password could not be authenticated.

Revisado: quarta-feira, 24 de agosto de 2022
4237928 - Getting a message saying I need to install Microsoft Office Primary Interop Assemblies when tryin

When I am trying to export to excel, I keep getting a message saying I need to install Microsoft Office Primary Interop Assemblies, but I already...

Revisado: quarta-feira, 24 de agosto de 2022
4266132 - Getting "You must enter a valid license and site message in order to continue" error when entering a valid license key.

When entering a valid license key into the installer, it thinks the key is invalid.  The following message is given. "You must enter a valid...

Revisado: quarta-feira, 24 de agosto de 2022
4320534 - Getting "Toad did not find a default 64 bit DB2 client..." or DB2 SQL1598N "licensing error" when connecting.

Encounter error on launch and connection.  Issue 1: On first launch of Toad the following message will be prompted:     "Toad did not find a...

Revisado: quarta-feira, 24 de agosto de 2022
4332894 - Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values

Getting "SQLSTATE 01003 message" for each row if max/min generate NULL values

Revisado: quarta-feira, 24 de agosto de 2022
4245737 - Getting "SQL1390N: Unable to init API env" error when trying to connect

When trying to connect the error "SQL1390N: Unable to init API env" is received.

Revisado: quarta-feira, 24 de agosto de 2022
4284660 - Getting "Invalid authorization key" when registering SQL Optimizer DB2 with my Toad key.

I bought Toad for DB2 with SQL Optimizer. When I launch SQL Optimizer for DB2 it gave me an error message "Authorization key has expired" I...

Revisado: quarta-feira, 24 de agosto de 2022
4245061 - Getting ".NET Runtime Optimization Service encountered a problem" error during optimization po

During the optimization portion of the installation, I get a ".NET Runtime Optimization Service encountered a problem" error message.  It seems to...

Revisado: quarta-feira, 24 de agosto de 2022
4244241 - Get SQL1531N error launching SQL Optimizer from Toad

Get the following message when trying to launch SQL Optimizer for DB2 LUW from Toad for DB2 LUW. Failed to connect to database. [IBM][CLI...

Revisado: quarta-feira, 24 de agosto de 2022
4240914 - Get Password Missing error (SQL30082N) when trying to generate script

The following error is received in any window where a script is being generated. Error: "ERROR [08001] [IBM] SQL30082N Security processing...

Revisado: quarta-feira, 24 de agosto de 2022
4238787 - Get multiple "...errors have occurred during extraction of query..." messages during extraction o

When doing an object compare, on the schema level, I get the following error message repeatedly in the Monitor Comparison Process portion.  The...

Revisado: quarta-feira, 24 de agosto de 2022
4241746 - Get message saying maintenance is expired when downloading.

Unable to download installer for latest version.  When trying to download, the following message is returned. "Our records show that your...

Revisado: quarta-feira, 24 de agosto de 2022
4316390 - Are there performance tuning and session browser features in Toad for DB2? How to monitor applications?

Are there performance tuning and session browser features in Toad for DB2? How to monitor applications?

Revisado: quarta-feira, 24 de agosto de 2022
4295950 - Are the saved Project Manager files interchangeable between Toad for Oracle and Toad Data Point?

Are the saved Project Manager files interchangeable between Toad for Oracle and Toad Data Point?  Can the project manager file be shared between...

Revisado: quarta-feira, 24 de agosto de 2022
4275758 - Are licenses defined by seat or by User?

Are licenses defined by seat or by User?

Revisado: quarta-feira, 24 de agosto de 2022
4265920 - Application error: "Invalid URI: Invalid port specified."

Revisado: quarta-feira, 24 de agosto de 2022
4236411 - Another version of this product is already installed.

Revisado: quarta-feira, 24 de agosto de 2022
4261567 - Analysing data results into deadlock.

When trying to analyse data in SQL Analyse, no available data reported on deadlocks. This is an issue with sql analyse and not within toad.

Revisado: quarta-feira, 24 de agosto de 2022
4273990 - An MS Access option for export is not available in the drop-down list in the export wizard.

An MS Access option for export is not available in the drop-down list in the export wizard even if the MS Access Engine is installed.

Revisado: quarta-feira, 24 de agosto de 2022
4250127 - An extra dot is being included in compare tool sync script for template definitions

When creating a sync script, from the object compare tool, template definitions have an extra dot in them and it is causing an execution error to...

Revisado: quarta-feira, 24 de agosto de 2022
4248916 - Altering a Segmented Tablespace to Partition Tablespace

Is it possible to be able to alter a segmented tablespace to a partition, or a universal tablespace?

Revisado: quarta-feira, 24 de agosto de 2022
4308899 - Alter view window does not display the query when the view was created with "Create or Replace V

When creating a view based off of CREATE OR REPLACE VIEW syntax, the objects gets created and the ddl can be extracted. But when trying to use...

Revisado: quarta-feira, 24 de agosto de 2022
4268952 - Altered tablespace to maxsize causing all containers were recreated

 User alters the maxsize for a tablespace.  The script that gets generated is dropping most of the containers and recreating them.  

Revisado: quarta-feira, 24 de agosto de 2022
4242716 - ALTER TABLESPACE from SMS storage to AUTOMATIC storage results in a DROP with no CREATE of dep

Changing the tablespace from SMS storage to Automatic results in a script that DROPs the tablespace and then CREATEs the tablespace but does not...

Revisado: quarta-feira, 24 de agosto de 2022
4273401 - Alter table partition Graph.

While refreshing the partition's graph Toad reports wrong record count for each partition. The problem is that the data boundaries are always...

Revisado: quarta-feira, 24 de agosto de 2022
4225750 - Alter Table script does not include Audit and Statistics Profile commands when rebuilding table.

Table has the following characteristics: AUDIT POLICY and STATISTICS PROFILE. When a table change requires a drop and recreate of the table the...

Revisado: quarta-feira, 24 de agosto de 2022
4223463 - Alter Table script contains SET CURRENT SQLID command.

Any time an alter to an entity is done (tables, tables spaces, etc), the SET CURRENT SQLID commands are created in alter script using the ID of...

Revisado: quarta-feira, 24 de agosto de 2022
4247694 - Alter table does not generating permissions correctly

Attempting to move a table to a different tablespace. User alters the table and specifies the new tablespace and index space. Toad generates...

Revisado: quarta-feira, 24 de agosto de 2022
4268104 - Alter Sequence Fails.

When alter a sequence is used (i.g. Min Value set to 200) the script generation fails because Max Value is "out of range" DDL is: CREATE...

Revisado: quarta-feira, 24 de agosto de 2022
4316760 - Alter Nickname feature only works with federated LUW to LUW connections. It doesn't work with any other federated connection

When it has been created a connection between a LUW to LUW federated server, the columns section on Alter Nickname windows allows you to modify...

Revisado: quarta-feira, 24 de agosto de 2022
4226198 - Alter of Table with Foreign Key Causes Check Pending state

Revisado: quarta-feira, 24 de agosto de 2022
4334598 - Alter Index DOE (z/OS): Unnecessary statement in script

Alter Index DOE (z/OS): Unnecessary statement in script.The same work is done twice.

Revisado: quarta-feira, 24 de agosto de 2022
4268696 - Alter from schema compare not recreating permissions

User had schema compare options  "Ignore permission differences" then proceeded to have the target to match the source. The resulting DDLdid not...

Revisado: quarta-feira, 24 de agosto de 2022
4244013 - Alter column is not generated correctly

When attempting to alter a table column and add 'For bit data', set from False to True, the generated script doesn't include this change.

Revisado: quarta-feira, 24 de agosto de 2022
4306939 - All Workload names are blank in Object Explorer | Workloads

All Workload names are blank in Object Explorer | Workloads, so unable to view or alter workloads.

Revisado: quarta-feira, 24 de agosto de 2022
4308089 - INTERNAL - TOAD.EXE Crashed Production DB2 Instance

TOAD for DB2 6.3. In the TABLES window  of the Object Explorer with a TABLE selected, I clicked the INDEXES tab, then selected the first index to...

Revisado: quarta-feira, 24 de agosto de 2022
4333490 - Why is Agent installation required?

Is it mandatory to have the agent installed?

Revisado: quarta-feira, 24 de agosto de 2022
4312823 - Why does Export Wizard executes the query for a second time?

Attempting to use Export Data Wizard or 'One Click Export' to export a query result runs the query for a second time. Why does wizard run my...

Revisado: quarta-feira, 24 de agosto de 2022
4238977 - Why are some of the selections grayed out in the right click menu for the Object Explorer and say

Why are some of the selections grayed out in the right click menu for the Object Explorer and say "Not Licensed"?

Revisado: quarta-feira, 24 de agosto de 2022
4266025 - Who to contact to renew Support Maintenance Contract?

Who to contact to renew a Support Maintenance Contract?

Revisado: quarta-feira, 24 de agosto de 2022
4261066 - Which Window's system files the products must update?<br/>  

QUESTION: Which Window's system files the products must update?

Revisado: quarta-feira, 24 de agosto de 2022
4303251 - Which version(s) of DB2 are supported?

Which are the supported version(s) of DB2 that can be use with Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4268231 - Which version was the 'first release' that can be installed on Windows 7?

Which version was the 'first release' that can be installed on Windows 7?  What version of Toad for DB2 supports Windows 7?  

Revisado: quarta-feira, 24 de agosto de 2022
4274180 - Which kind of client Toad for DB2 uses for connections to databases?

Which kind of client Toad for DB2 uses for connections to databases? Is it .NET provider or CLP?

Revisado: quarta-feira, 24 de agosto de 2022
4247602 - Which DB2 client version can be used with Toad for DB2?

Which DB2 client version can be used with Toad for DB2 6.5?

Revisado: quarta-feira, 24 de agosto de 2022
4268668 - Where to find Toad for DB2 Beta version?

Where to find and download Toad for DB2 Beta version?

Revisado: quarta-feira, 24 de agosto de 2022
4278821 - Where to download Toad for DB2 beta release?

Where is the link to download Toad for DB2 beta release?

Revisado: quarta-feira, 24 de agosto de 2022
4290442 - Where is the Toad for DB2 LUW or ZOS 64-bit installer on Support Link?

Where is the Toad for DB2 LUW or ZOS 64-bit installer on Support Link? Where to download a 64-bit Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4295360 - Where is the error log for Toad for DB2?

Where is the error log for Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4209969 - Where is the connection information stored for Toad for DB2?

Where is the connection information stored for Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4257258 - Where is the "Show Explained Statement History" feature in Toad for DB2?

In DB2's Control Center, there is an option for "Show Explained Statement History", is there a similar feature in Toad for DB2?

Revisado: quarta-feira, 24 de agosto de 2022
4268772 - Where is productlicenses.xml in Toad v 5.0?

Revisado: quarta-feira, 24 de agosto de 2022
4278504 - Where is debug to be activated?

Revisado: quarta-feira, 24 de agosto de 2022
4241543 - Where can SQL Optimizer be downloaded from after upgrading to DBA Suite?

If upgrading from the base edition to DBA Suite, where can SQL Optimizer be downloaded from?  When trying to download it as standalone, a message...

Revisado: quarta-feira, 24 de agosto de 2022
4334197 - Where can I find the article "Short Overview of DB2 Connect" by Craig Mullins that was previously at ToadWorld?

There was an excellent article "Short Overview of DB2 Connect" by Craig Mullins at toadworld; https://blog.toadworld.com/2015/02/24/a-short...

Revisado: quarta-feira, 24 de agosto de 2022
4324564 - When will be the DB2 10.5 supported by Toad?

When will be the DB2 10.5 supported by Toad?

Revisado: quarta-feira, 24 de agosto de 2022
4225570 - Parser error "Incorrect syntax near 'OR' " when using CREATE OR REPLACE VIEW syntax.

Is there a Toad for DB2 limitation with CREATE OR REPLACE VIEW and the parser? Toad gives a parser error message "Incorrect syntax near 'OR' ".

Revisado: quarta-feira, 24 de agosto de 2022
4318634 - Parameters are not updating in DB Parameters tab

When looking at the DB Parameters tab, the DB CFG parameters mon_rtn_data and mon_rtn_execlist are not updating.  These parameters were added in...

Revisado: quarta-feira, 24 de agosto de 2022
4278208 - Package nullid.SQLC2J25 is rebounded by the user connecting go the database

When the user connects to the database via Toad for DB2, Toad rebinds package nullid.SQLC2J25 with the owner same as the user which is connecting...

Revisado: quarta-feira, 24 de agosto de 2022
4251111 - Order of triggers in table script are not the same that they were created

Table DDL was generated and includes multiple triggers on it.  The order that the triggers were listed was not the same order that the triggers...

Revisado: quarta-feira, 24 de agosto de 2022
4283253 - Option to save setting defaults for Utilities | Runstats.

User running Runstats on Toad for DB2 over and over again, and needs to have all options to be saved so that they can be used every time. That is...

Revisado: quarta-feira, 24 de agosto de 2022
4274513 - Option for compare schema to use export/import, instead of inserting into a temp table

There is an option for altering tables that allows me to  use the export/import feature to alter  a table, but I can not find an option to do the...

Revisado: quarta-feira, 24 de agosto de 2022
4266286 - Optimizing, Toad SQL Tuning for DB2 z/OS is not installed

Revisado: quarta-feira, 24 de agosto de 2022
4261053 - On the grid Timestamps are no longer displaying as timestamps, but as dates

When looking at data on the grid Timestamps are no longer displaying as timestamps, but as dates.  Is there anoption for displaying a timestamp...

Revisado: quarta-feira, 24 de agosto de 2022
4283228 - On MIGRATE of an object (table) it did not build the permissions

User migrated an object and used the transformation rules. Clicked on Preserve permissions on the customize panel. Then filled out the...

Revisado: quarta-feira, 24 de agosto de 2022
4216598 - On a silent installation of TOAD for DB2 - can one disable the "checkNewVersion" option

Here is an article related to TOAD for Oracle. The idea is to have something like method 1 in the article above. Looking for method to...

Revisado: quarta-feira, 24 de agosto de 2022
4296829 - ODBC applications cannot connect to the database once Toad for DB2 2.0 is installed

Installing Toad for DB2 2.0 prevents other applications that require ODBC from successfully connecting to the database. The user receives these...

Revisado: quarta-feira, 24 de agosto de 2022
4233613 - Object search takes a very long time to return results

Revisado: quarta-feira, 24 de agosto de 2022
4283038 - Object reference not set to an instance of an object

Connection problem: Customer recently got new laptop. He installed DB2 client and Toad for DB2. Got error when trying to connect DB2 database...

Revisado: quarta-feira, 24 de agosto de 2022
4269511 - Object migration script does not use the same Alter Table commands as in the previous versions.

From DB explorer of Toad for DB2 version 4.5, user right clicks on a database object and selects Migrate option to migrate table changes between...

Revisado: quarta-feira, 24 de agosto de 2022
4250882 - Object Explorer is grayed out and shows "Not Licensed"

The Object Explorer is grayed out in the menu and notes "Not Licensed" next to it.

Revisado: quarta-feira, 24 de agosto de 2022
4307194 - Object Compare (Schema Compare) is not showing target only objects

When doing an 'Object Compare' on a schema between two databases, results returned are incorrect and don't match with the results returned when...

Revisado: quarta-feira, 24 de agosto de 2022
4238870 - Numbers not imported from Excel file when using 'Text' cell formatting

When importing numeric characters in an Excel file (with the cells formatted as 'Text'), the numbers are not imported into the table. They also do...

Revisado: quarta-feira, 24 de agosto de 2022
4268719 - Null display as blank sometime

Revisado: quarta-feira, 24 de agosto de 2022
4278630 - Not showing event monitors

Revisado: quarta-feira, 24 de agosto de 2022
4335416 - Not possible to install a DB2 V9.5 Client Fixpack when Toad for DB2 v4.0.1 is installed

It is not possible to install a DB2 V9.5 Client Fixpack (e.g. FP1  or the current FP3a) when Toad v4.0.1 is installed.

Revisado: quarta-feira, 24 de agosto de 2022
4279280 - Not possible to export table as xml file

Not possible to export a result as an XML file. It is blocked by license.

Revisado: quarta-feira, 24 de agosto de 2022
4334619 - Not all Explain statements are highlighted

When processing more than one SQL statement  using function "Execute Explain Plan" only the first one will be highlighted. When moving from the...

Revisado: quarta-feira, 24 de agosto de 2022
4318687 - Not able to enter all of license key. The key has letters in it and I can only type numbers.

I am not able to enter my whole license key in the authorization window. The license key I was given has letters and numbers in it, but I am only...

Revisado: quarta-feira, 24 de agosto de 2022
4268451 - Not able to download a correct installation file from Support Portal (problem with certificate)

It was not possible to download a correct installation file from Support Portal. Browser announcing problem with the signature, damaged or invalid. 

Revisado: quarta-feira, 24 de agosto de 2022
4237829 - Not able to disable getting Email Digests through Toad World's settings window

Setting the values to 'Not Subscribed' on the Settings Email Digests tab in Toad World does not work.  Once they are set, if you go back to the...

Revisado: quarta-feira, 24 de agosto de 2022
4248986 - No space is being shown when viewing tablespaces for partioned table indexes

There seems to be some inconsistency when viewing space for partitioned table.  When viewing the tablespaces, in the Object Explorer, which contain...

Revisado: quarta-feira, 24 de agosto de 2022
4274101 - No Index created with Create Like Command

When created a table that like an existing table with primary index, missing primary key.

Revisado: quarta-feira, 24 de agosto de 2022
4272934 - No execution plan for MERGE statement.

The Explain plan under Toad is not shown when a MERGE statement is used. No error message is returned.   For example see below: MERGE INTO...

Revisado: quarta-feira, 24 de agosto de 2022
4238998 - No expression based index in compare

There are some expression based indexes in dev and want to bring them to next stage using compare feature of Toad. Is this new index supported?

Revisado: quarta-feira, 24 de agosto de 2022
4247450 - No data migration generated in a Compare

Would like to compare two implemented DDL versions in a test environment (without data contents) and in the production system (with data content...

Revisado: quarta-feira, 24 de agosto de 2022
4240237 - No data appears in create procedure Template

When trying to load a template of an existing 'create procedure' template, no data shows up in the template file. Only simple statements appear...

Revisado: quarta-feira, 24 de agosto de 2022
4230101 - New catalog entries created in DB2 client via Toad are not recognized in Command Line and visa versa

New database cataloged by the TOAD is not recognized by DB2 Command Line (CLP). And the database cataloged by DB2 CLP is not recognized by the TOAD...

Revisado: quarta-feira, 24 de agosto de 2022
4283484 - Needed a history of growth rate in database tablespaces

User used to use space management to genegrate a history report of tablespaces growth from Quest Central for DB2. Now converting to Toad  for...

Revisado: quarta-feira, 24 de agosto de 2022
4273822 - Needing ability to copy all script outputs

Revisado: quarta-feira, 24 de agosto de 2022
4268612 - Needed a DB2 catalog poster

Revisado: quarta-feira, 24 de agosto de 2022
4314134 - Need to know if Toad4DB2 supports SSH/TLS connections

We are in the midst of implementing TLS for all database connectivity and need to know iif it's supported by Toad4DB2? If so how to configure it

Revisado: quarta-feira, 24 de agosto de 2022
4265222 - Need to create and reference Microsoft Access &amp; Excel data objects

There are daily reports that I need to create and reference Microsoft Access & Excel data objects. Currently, I have to bring the data into our...

Revisado: quarta-feira, 24 de agosto de 2022
4246377 - Need to change the site message

Would like to get site message changed to something else.

Revisado: quarta-feira, 24 de agosto de 2022
4283517 - Need new key in order to activate Toad SQL Analysis.

User hasa license for Quest SQL Analysis for DB2 LUW. User tries to use Toad for DB2 v 4.5.1 but can not active Toad SQL Analysis.

Revisado: quarta-feira, 24 de agosto de 2022
4279189 - Need an option of a default output file type IFX recognized by LOAD dialog in Toad

User requested to have an option to save a default output file type for Export or Load like default on export/import file of 'migrate object...

Revisado: quarta-feira, 24 de agosto de 2022
4240509 - Multiple files in TEMP directory created by Toad but not deleted after it's closed

When opening the Data tab for any table in the Object Explorer, a temp file is created in the directory: C:\Users\username\AppData\Local\Temp...

Revisado: quarta-feira, 24 de agosto de 2022
4282794 - MQT's not refreshed

Revisado: quarta-feira, 24 de agosto de 2022
4229275 - Modifying the Object Explorer order causes the asterisk to disappear in the schema list

An asterisk will not appear in schema drop-down list (filter area) if 'Tables' are not the first tab or item in the list of the Object Explorer.

Revisado: quarta-feira, 24 de agosto de 2022
4322482 - Missing Utilities submenu in Database browser for tablespaces and indexes.

Looking in the Database browser for tablespaces and indexes, for the Utilities submenu  with the following  entries: for the tab 'Tablespace...

Revisado: quarta-feira, 24 de agosto de 2022
4283205 - Missing Load script on migrate object

Revisado: quarta-feira, 24 de agosto de 2022
4268714 - Missing duration and execution on SQL Recall

User compared SQL Recall display between Toad 4.0 and 4.6 and found the Toad v 4.6.2 was missing duration and execution columns.

Revisado: quarta-feira, 24 de agosto de 2022
4268659 - Missing DEFAULT value on DDL generation.

When user extracts DDL tables with TOAD for DB2 v4.5 often the DEFAULT value is missing. On the following example, the default value is missing...

Revisado: quarta-feira, 24 de agosto de 2022
4321813 - Missing Advanced menu after upgrading Toad and Compare tools cannot be located.

In previous versions of Toad, there was an Advanced menu which has the options to compare data, schema and server. After upgrading Toad, the...

Revisado: quarta-feira, 24 de agosto de 2022
4319247 - Missing Advanced menu after upgrading Toad and Compare tools cannot be located.

In previous versions of Toad, there was an Advanced menu which has the options to compare data, schema and server. After upgrading Toad, the...

Revisado: quarta-feira, 24 de agosto de 2022
4268964 - Alias type objects cannot be modeled

User connected a database from Toad for DB2 , dragged an alias into Query Builder panel unsuccessful due to error: ' Alias type objects cannot be...

Revisado: quarta-feira, 24 de agosto de 2022
4309583 - After upgrading from 6.2 to 6.3 auto-connect connections are failing

Multiple connections are set up to auto connect on startup. Since upgrading to 6.3 the following error can occur on one or more connections...

Revisado: quarta-feira, 24 de agosto de 2022
4313219 - Advanced resize does not allow more than one resize at a time and button is missing

In previous versions, it used to be possible to go into advanced resize within ALTER tablespace and highlight a set of files and resize them with...

Revisado: quarta-feira, 24 de agosto de 2022
4278733 - Advanced Resize of DMS tablespaces does not reflect of changes in Calculate Space even when Refre

User altered a DMS tablespace | selected Advance Resize | Edited Size | executed successful. When coming back on Space Management, Calculate Space...

Revisado: quarta-feira, 24 de agosto de 2022
4235092 - Add a new DB2 Catalog entry in Toad's Client Config Wizard gives 0 0 message and does not create the entry. Also gives the error: Unable to init API env.

For manually adding a new single catalog entry, the Client Configuration Wizard just gives the error:     ' ' 0 0     If trying to Import a...

Revisado: quarta-feira, 24 de agosto de 2022
4242505 - Get a message saying Toad DB2/DBA license is needed when altering a table

The following message is returned when trying to alter a table. -- The extended alter feature requires a Toad DB2/DBA License. -- Please...

Revisado: quarta-feira, 24 de agosto de 2022
4242080 - Get a FileNotFoundException when attempting to launch

Revisado: quarta-feira, 24 de agosto de 2022
4274050 - Get 'The return code is 1950 create the instance manually using the command DB2ICRT.' during inst

User tried to install Toad for DB2 v 4.5.1 on window XP SP3. Almost to the end of installation he got error: The return code is 1950 create the...

Revisado: quarta-feira, 24 de agosto de 2022
4244983 - Get 'SQL30082N: USERNAME AND/OR PASSWORD INVALID' error when trying to connect with password containing semicolon

When trying to connect, using a password that contains a semicolon (;), the below error is received. Able to connect with the same password...

Revisado: quarta-feira, 24 de agosto de 2022
4242367 - Get 'startIndex cannot be larger than length of string' error trying to import a connection st

When trying to import a connection string through the connection manager I get the following error. Exception: System...

Revisado: quarta-feira, 24 de agosto de 2022
4238790 - Get "Unable to locate object in database" when trying to alter tablespace in Space Calculator window

While in the Space Calculator (Space Management | Calculate Space) window, if a tablespace is right clicked on in the top left corner and Alter is...

Revisado: quarta-feira, 24 de agosto de 2022
4244409 - Get "Toad discovered that the IBM Data Server driver installation is corrupted..." launching

Get the following message when launching. "Toad discovered that the IBM Data Server driver installation is corrupted DSD installer may...

Revisado: quarta-feira, 24 de agosto de 2022
4249224 - Get "This License key can not be used for this product" message when entering license key and site message.

After entering the license key and site message in the Licensing window, the following message is displayed and the Continue button is not...

Revisado: quarta-feira, 24 de agosto de 2022
4238751 - Get "The specified node already configured for another host" error adding a new catalog entry

When adding a new catalog entry, after entering the Node and Instance name, when the Next button is clicked a red exclamation point appears next...

Revisado: quarta-feira, 24 de agosto de 2022
4242072 - Get "The phone number and name you have supplied exists in our database" message registering for

I get the following message when trying to register for Supportlink. "We are unable to process your registration for Supportlink. The phone...

Revisado: quarta-feira, 24 de agosto de 2022
4225095 - Get "Sequence contains no matching element Stack" when running Compare Object tool

Following error occurs when running the Compare Object tool. "System.InvalidOperationException Sequence contains no matching element Stack Trace...

Revisado: quarta-feira, 24 de agosto de 2022
4249080 - Get "Object reference is not set or something among those lines" error changing delimiter value

If a search is done, in the Options window, to find the Script Statement Delimiter option prior to it being changed, the following error is...

Revisado: quarta-feira, 24 de agosto de 2022
4241742 - Get "Index was outside the bounds of the array" error refreshing Database Explorer after creat

After creating a procedure in the Database Explorer, when I refresh it, I get an "Index was outside the bounds of the array" error.

Revisado: quarta-feira, 24 de agosto de 2022
4244688 - Get "Failed connectin to..." error during Multi DB Query task in automation

When running a Multi DB Query in an automation script, it is not connecting to all database connections included in the task.  Sometimes there is...

Revisado: quarta-feira, 24 de agosto de 2022
4239421 - Get "'ERROR [08001] [IBM] SQL30082N Security processing failed with reason "24"" trying to connect

The following error is received when trying to connect to a database. "'ERROR [08001] [IBM] SQL30082N   Security processing failed with reason...

Revisado: quarta-feira, 24 de agosto de 2022
4238021 - Get "...we temporarily cannot process your request..." message downloading

The following message is received when trying to download an installer. Unable to Process Your Request Sorry for the inconvenience, we...

Revisado: quarta-feira, 24 de agosto de 2022
4335176 - Generated always as Identity attribute is not handled correctly in case of changes of a table

The original table is CREATE TABLE Test (  PK  INTEGER     NOT NULL    GENERATED ALWAYS    AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE...

Revisado: quarta-feira, 24 de agosto de 2022
4314335 - Generate report in Compare feature within Toad does not provide all the objects that are different.

Generate report in Compare feature within Toad does not provide all the objects that are different.

Revisado: quarta-feira, 24 de agosto de 2022
4279170 - Generate a script for renaming a table with references objects

User tried to rename a table which had many referential constraints, Toad gave him error SQL0750N: SQL0750N  The source table cannot be renamed...

Revisado: quarta-feira, 24 de agosto de 2022
4269689 - Font 'Courier New' does not support style 'Regular'.<br/> Font 'Courier New' does not suppor

Opening the connection configuration wizard returning the error System.ArgumentException Font 'Courier New' does not support style 'Regular'.  

Revisado: quarta-feira, 24 de agosto de 2022
4284248 - Delete rows from grid window does not work

In Toad for DB2 version 7.1 when try to edit rows in data grid, the error appears: Waiting for posting updates to finish. Is someone holding a...

Revisado: quarta-feira, 24 de agosto de 2022
4335106 - Debugger fails to execute

When trying to debug a particular sql stored procedure the session terminates with the following message:   DB2 Debugger: 2007-09-17 11:20:10...

Revisado: quarta-feira, 24 de agosto de 2022
4241739 - Debug is not releasing connection to database after session is done.

Running a debug using Toad DB2 Xpert and when it finishes it does not release the connection to the database.   Have to reboot pc to get the...

Revisado: quarta-feira, 24 de agosto de 2022
4333942 - DB2 z/OS 10 Defered Alter/ Should be supported by TOAD

DB2 z/OS 10 Defered Alter/ Should be supported by TOAD

Revisado: quarta-feira, 24 de agosto de 2022
4284095 - DB2 V12

Does Toad for Db2 support Db2 on z/OS version 12?

Revisado: quarta-feira, 24 de agosto de 2022
4211298 - DB2 v11 for z/OS Support with Toad

What version of Toad for DB2 will support DB2 11 z/OS (zOs) ?

Revisado: quarta-feira, 24 de agosto de 2022
4274271 - DB2 Parameters tab shows the same values for different nodes

DB2 Parameters tab shows the same values for different nodes (in tabbed view). E.g. DATABASE_MEMORY and LOGPATH. Side-by-side view display...

Revisado: quarta-feira, 24 de agosto de 2022
4314089 - DB2 DBA Suite license display expired Benchmark Factory key

We have a question about their Toad for DB2 DBA Suite license key and the components. Apparently, we are looking to download the various...

Revisado: quarta-feira, 24 de agosto de 2022
4236617 - DB2 default client message appears when uninstalling Toad for DB2 trial version

When attempting to uninstall Toad for DB2 v4.0 Trial Version, the following error message  appears: 'The DB2 Copy ToadE40 in Quest Software...

Revisado: quarta-feira, 24 de agosto de 2022
4268572 - DB2 crashed after reorg table, index and runstats

User has performed reorg on tables and indexes, and also runstats in sequential order. and while performing runstats database crashed. After...

Revisado: quarta-feira, 24 de agosto de 2022
4274544 - DB2 - LUW Session Locking Problem

Toad sessions are blocking each other. The client sessions are set to autocommit. The sessions are running updates by executing dynamic update...

Revisado: quarta-feira, 24 de agosto de 2022
4248411 - DB parameter screen fails to load with error [08001] [IBM] SQL30082N

Toad error out when trying to view Database Browser | Database | DB parameters  for a 10.1 LUW.  Below is the error: IBM.Data.DB2.DB2Exception...

Revisado: quarta-feira, 24 de agosto de 2022
4236890 - DB Parameters tab is not showing certain parameters flagged as 'Automatic'

The Database | DB Parameters tab is not showing certain parameters flagged as 'Automatic', when compared to checking this via command line.

Revisado: quarta-feira, 24 de agosto de 2022
4229536 - DB Admin functionality is grayed out. Requirements for full access to DB2 z/OS Functionality.

Toad for DB2, with DB Admin module, has been set up but the Bind options for packages are grayed out. How are these options enabled? What is...

Revisado: quarta-feira, 24 de agosto de 2022
4242511 - Dates before the year 1900 do not appear correctly in an Excel data export

When exporting timestamp data to Excel, with a date that contains a year before 1900, the data is not shown correctly in Excel. The year date...

Revisado: quarta-feira, 24 de agosto de 2022
4335470 - Date import problem

Revisado: quarta-feira, 24 de agosto de 2022
4225679 - Date format is incorrect after exporting to csv format.

Revisado: quarta-feira, 24 de agosto de 2022
4221829 - Database | Utilities tab will continue to refresh even after leaving the window.

Database | Utilities tab will continue to refresh even after leaving the window. If another tab or window is opened, Toad continues to run the...

Revisado: quarta-feira, 24 de agosto de 2022
4241757 - Database | Applications menu does not show all applications

In the Database | Applications menu, there should be all applications listed as a result of the command "LIST APPLICATIONS SHOW DETAIL", however...

Revisado: quarta-feira, 24 de agosto de 2022
4273594 - Database name list shows empty on "Create a New Connection" panel even after Import Profile.

After installation of Toad for DB2, user got many connection profiles imported to ToadC47 db2 client.  However, File | New | Connection | click on...

Revisado: quarta-feira, 24 de agosto de 2022
4230301 - Database Explorer does not automatically open new tabs for subsequent connections using File menu

A new database explorer tab for each new connections is not being created using the File | New | Connection, menu option from the main menu. The...

Revisado: quarta-feira, 24 de agosto de 2022
4276248 - Database error during SP calling

When user tries to Execute Procedure using Object Explorer he/she fills in the values for input parameters and press OK then the error appears...

Revisado: quarta-feira, 24 de agosto de 2022
4274751 - Database Diagram is not showing all relationships between the tables.

Database Diagram is not showing all relationships between the tables. A table is added to Database Diagram having two Foreign Key constraints...

Revisado: quarta-feira, 24 de agosto de 2022
4226157 - Database Browser Data tab is read-only, not able to edit data or insert records.

When in the Database Browser the Data tab is read only, leaving it not possible to edit the data or insert/delete any records from the icons...

Revisado: quarta-feira, 24 de agosto de 2022
4278590 - Data missing in plan_table after explain

After Explain is run in Toad for DB2, the data from explain cannot be found after the explain finished. I would like to keep this data there.

Revisado: quarta-feira, 24 de agosto de 2022
4308920 - Data migration no longer produces files with IXF and DEL extensions

1. With the Load Utility unchecked in Preserve Data Method, a schema migration generates EXPORT scripts and the exported file is of type .IXF. The...

Revisado: quarta-feira, 24 de agosto de 2022
4246451 - Data is not included in the script created when using the "Migrate Object" feature

When trying to use "Migrate Object" feature to migrate a table and its data, the table and indexes migrate fine, but the data is not migrated...

Revisado: quarta-feira, 24 de agosto de 2022
4261206 - Data Grid results, the current number of rows being selected may exceed available memory.

In the Editor, the user executes and returns thousands of records Data grid is returned.  User clicks on top left corner of Data Grid to select...

Revisado: quarta-feira, 24 de agosto de 2022
4268645 - Data compare: 'Object reference not set to an instance of an object.'

User has compared data using Toad for DB2 v 4.7.1 on 2 databases - Linux machine. At Synchonize Wizard to make target like source, then select...

Revisado: quarta-feira, 24 de agosto de 2022
4274554 - Data Compare does not list table names.

Revisado: quarta-feira, 24 de agosto de 2022
4273608 - Data Compare - 'SQL0952N Processing was cancelled due to an interrupt'

Comparing 2 big tables (> 7million rows) on the same database. The compare stops with: SQL0952N Processing was cancelled due to an interrupt...

Revisado: quarta-feira, 24 de agosto de 2022
4306978 - Dashboard widgets are not populating even though monitor switches are turned on in the database

Widgets on the Summary dashboard and on custom dashboards are not populating with data. The Database tab, "Monitor" shows all the monitor switches...

Revisado: quarta-feira, 24 de agosto de 2022
4244227 - Dashboard is running same statement multiple times causing perfomance issues.

When the Dashboard is launched, in the Background Processes window, it shows 4 processes running that are seemingly the same process. It took a...

Revisado: quarta-feira, 24 de agosto de 2022
4283732 - Migration to PDF does not show correct format.

The PDF generated by Object Migration Tool does not return the correct format. some text names are overlayed with others. Â

Revisado: quarta-feira, 24 de agosto de 2022
4317300 - Migration script generates 2 unnecessary steps

Migrating tables including the data from one database to another database. 2 separate scrips are created - 1st script to export the data from the...

Revisado: quarta-feira, 24 de agosto de 2022
4272831 - Migration of settings from Toad for DB2 5.6 to 6.0

The migration of user settings in Toad for DB2 is dependent on a previous version (e.g. 5.6) being installed on the workstation where Toad for DB2...

Revisado: quarta-feira, 24 de agosto de 2022
4269331 - Migration got hang up

User tried to migrate data from db2 v 8.1 FP13 to DB2 v9.7 and got hang up at query for tablespace. See attachment . User could run export/import...

Revisado: quarta-feira, 24 de agosto de 2022
4258520 - Migrated Data generate incorrect parameters for tablespaces script

Migrated Data is generating incorrect parameters for tablespaces. The script is being created with the key work "RESUME NO" regardless of...

Revisado: quarta-feira, 24 de agosto de 2022
4330727 - Migrate Object, Compare Object and Extract DDL options are not available

After licensing Toad for DB2 the following options are disabled: Migrate Object Compare Object Extract DDL

Revisado: quarta-feira, 24 de agosto de 2022
4306029 - Migrate is creating indexes before load utility

Did a migrate for a table. The script that was generated unloaded data, dropped the table, created the table, created the indexes, then loaded the...

Revisado: quarta-feira, 24 de agosto de 2022
4283304 - Migrate a tablespace does not recreate primary index

Using Toad for DB2 v 4.6.0, tried to migrate the tablespaces and dependant objects and it did not pick up the primary index. Toad for DB2 v4.5.2...

Revisado: quarta-feira, 24 de agosto de 2022
4249214 - Message says trial key will expire soon, but not able to open even though not expired yet

Launching a trial version and get a message saying that the trial key will expire in x number of days.  It gives the option to enter a new key or...

Revisado: quarta-feira, 24 de agosto de 2022
4308588 - Message "The access plan tables need to be installed. Would you like to run the install scripts..." when clicking the Explain tab in the Editor

When running an explain plan, the following message is displayed: "The access plan tables need to be installed. Would you like to run the install...

Revisado: quarta-feira, 24 de agosto de 2022
4309209 - Message "no changes detected" when adding 'Select' privilege for User or Group, using 'Edit Table Privileges'.

When trying to grant a table privilege to a group/user via "Edit Table Privileges", a user/group is added, and grant Select  access is checked. On...

Revisado: quarta-feira, 24 de agosto de 2022
4273423 - Message "Our records indicate that you are no longer current on maintenance.." even if the maintenance is valid.

The error message starting with "Our records indicate that you are no longer current on maintenance.." appears after trying to download the...

Revisado: quarta-feira, 24 de agosto de 2022
4311821 - Menu text and icons are blurry, very small, and/or truncated

When using a super high-resolution display, it causes display issues.  Some of these issues are... 1) Some print is too small to read. 2...

Revisado: quarta-feira, 24 de agosto de 2022
4269693 - Memory leak in Toad leading to 'Out of Memory' error

Revisado: quarta-feira, 24 de agosto de 2022
4229384 - Memory issues when moving data using an insert select statement.

Toad for DB2's memory usage is oddly high. When trying to use an insert select statement in the editor to move data from one table to another...

Revisado: quarta-feira, 24 de agosto de 2022
4268672 - shows partion stored procedure code

Revisado: quarta-feira, 24 de agosto de 2022
4240441 - Set default isolation level for Z/OS connections

Revisado: quarta-feira, 24 de agosto de 2022
4246701 - Selecting statements in different parts of a script

Is it possible to select statements in different places of a script and execute the selected statements? Currently you can only select serial...

Revisado: quarta-feira, 24 de agosto de 2022
4231565 - Selecting email icon in Report Manager does not email report right away

After generating a report using Report manager, clicking email icon prompts to save the report instead of just e-mail the report. Expecting the...

Revisado: quarta-feira, 24 de agosto de 2022
4284321 - Select to debug causes error: "The required IBM z/OS debugging procedures are not installed on th

I am using Toad DB2 to connect to a ZOS. In the Database Browser, when I right-click and selects Debug, I get the error: The required IBM Z/OS...

Revisado: quarta-feira, 24 de agosto de 2022
4223225 - Select statements using TIMESTAMP_FORMAT function do not return any data.

User running a Select using TIMESTAMP_FORMAT function as such: SELECT * FROM <tablename> WHERE <columnname> = TIMESTAMP_FORMAT('2010-03-21 07:13...

Revisado: quarta-feira, 24 de agosto de 2022
4317550 - Select all the indexes 1 by 1

Under v6.2 under Runstats table, an option is needed to select all the indexes at once.  Currently, you need to choose them 1 by 1.

Revisado: quarta-feira, 24 de agosto de 2022
4273326 - select * from table results in lock which cannot be released

Select * from table results in lock which cannot be released. Tools | Options | Database | General: - Number = 1000 - Apply to editor is...

Revisado: quarta-feira, 24 de agosto de 2022
4242784 - Intellisense window is disappearing right after it appears

In the editor, the intellisense (code completion) window disappears immediately after it pops up. It is not possible to use because it is not there...

Revisado: quarta-feira, 24 de agosto de 2022
4274293 - Installation, "Insufficient Disk Space Error: this installation package failed due to insufficient disk space, returned error code [0x80070643]

Unable to install product suite.  When trying to perform the installation via Bundle installer, getting the insufficient disk error.  The issue...

Revisado: quarta-feira, 24 de agosto de 2022
4270711 - Installation, Unable to install product, "HTTPs Error: This package download process are interrupted, error code [0x80072EFE] or [0x80072EFF] or [0x80070642] or [0x80070EFD]

Unable to install product suite.  When trying to perform the installation via Bundle installer, getting the Https error.  The issue happens on the...

Revisado: quarta-feira, 24 de agosto de 2022
4225784 - Installation is stuck or hangs at "Preparing configuration files..." phase.

When trying to install Toad for DB2, it has a window saying, "Preparing configuration files, it may take several minutes.".  But after waiting...

Revisado: quarta-feira, 24 de agosto de 2022
4313562 - Installation fails with error "Microsoft .NET Framework 4.7.1= > Failed with error"

Toad attempts to install Microsoft .NET 4.7.1 as a pre-requisite for the products. According to the registry: HKEY_LOCAL_MACHINE\SOFTWARE...

Revisado: quarta-feira, 24 de agosto de 2022
4270513 - Installation errors: "This package installation failed..." or "RegisterComplete returned error code..."

Unable to install product suite.  When trying to perform the installation via Bundle installer, getting the [8007051B] or [0x80070002] or...

Revisado: quarta-feira, 24 de agosto de 2022
4325944 - Startup Window Location positioned at negative coordinates on screen when Windows is maximised.

After having Toad open in a maximized state, closing the application, and then regardless of logging out of Windows account, loading Toad, the...

Revisado: quarta-feira, 24 de agosto de 2022
4291813 - SQL0973N Not enough storage is available in the APP_CTL_HEAP_SZ heap to process the statement.

User connects to DB2 database and runs a query such as select * from table. Toad returns the message "SQL0973N Not enough storage is available in...

Revisado: quarta-feira, 24 de agosto de 2022
4283480 - SQL1460N The environment variable "SOCKS_NS" required for SOCKS server name resolution is not defined or not valid

User tried to connect to DB2 ZOS and got error: SQL1460N The environment variable "SOCKS_NS" required for SOCKS server name resolution...

Revisado: quarta-feira, 24 de agosto de 2022
4234698 - SQL1092N permissions error and "Unable to read table space parts" error when using schema compare

When performing a schema repair between two db2 databases I receive errors SQL 1092n permissions error and an "unable to read table space parts...

Revisado: quarta-feira, 24 de agosto de 2022
4333953 - SQL0199N returned when trying to export result from WITH statement

When trying to export a result set or a query with an "WITH" statement the error SQL0199N is returned (see Attachment). When using the Import...

Revisado: quarta-feira, 24 de agosto de 2022
4320316 - SQL0440N error while executing object comparaison

When executing the object comparison in Toad for DB2 6.2 with an IBM 9.1.1 database, the following error occurs: "ApplicationException ERROR...

Revisado: quarta-feira, 24 de agosto de 2022
4252278 - SQL0401N The data types of the operands for the operation "=" are not compatible

When connected to a Chinese database, accessing objects like tables or views from database explorer throws the following error: ERROR [42818...

Revisado: quarta-feira, 24 de agosto de 2022
4332408 - SQL0007N ERROR when doing an advanced connect (Isolation level: UR and Lock timeout: NOT WAIT) w

When doing an advanced connect (Isolation level: UR and Lock timeout: NOT WAIT) with the connection manager with a SQL DELIMITER changed at...

Revisado: quarta-feira, 24 de agosto de 2022
4274139 - SQL0104N An unexpected token "CONNECT" was found following "Name ='XXX".  Expected tokens may

User clicked on explain plan tab of Toad for DB2 forSQL statement: Select * from emp9 where Name = 'XXX'  CONNECT BY PRIOR  empid = mgrid and...

Revisado: quarta-feira, 24 de agosto de 2022
4242030 - SQL Statement terminator still using default value after it is changed

After changing the SQL Statement terminator to a personal value (i.e. '#'), the scripts generated in Toad still show the default ';' as the script...

Revisado: quarta-feira, 24 de agosto de 2022
4221218 - SQL Optimizer for DB2 LUW. Unable to populate the Compare tab with SQL queries.

SQL Optimizer for DB2 LUW. Unable to populate or fill the Compare tab with SQL statements or queries. How to enter SQL statements in the Compare tab?

Revisado: quarta-feira, 24 de agosto de 2022
4244259 - SQL code missing in stored procedures

After migrating from v4.0 to v4.7, when viewing stored procedures, it's only possible to see DISPLAY and other statements, but not the SQL code in...

Revisado: quarta-feira, 24 de agosto de 2022
4269489 - Ability to use High Performance Unload utility, instead of EXPORT utility

Is it possible to use the High Performance Unload utility, instead of the EXPORT utility?

Revisado: quarta-feira, 24 de agosto de 2022
4242142 - Ability to use SORTDEVT & SORTNUM keywords or SORTWKnn and STnnWKmm datasets for Migrate Object

When using the Migrate Object feature, can SORTDEVT & SORTNUM keywords be used?.  Also can SORTWKnn or STnnWKmm datasets be used to specify as...

Revisado: quarta-feira, 24 de agosto de 2022
4250871 - Ability to Export and Import table data using .ixf files

Does Toad for DB2 have the ability to export and import table data using .ixf files?

Revisado: quarta-feira, 24 de agosto de 2022
4316461 - Ability to disable "Save Password" option on connection window

We want to disable the "Save Password" option in Toad for DB2. Is this possible to do?

Revisado: quarta-feira, 24 de agosto de 2022
4308900 - Ability to connect all sessions in a group at once.

I have set up a group of connections. I'd like to be able to: Connect all sessions in the group at once Connect all sessions in the group at...

Revisado: quarta-feira, 24 de agosto de 2022
4313521 - Ability to add space exceptions at the tablespace level

Currently, space exceptions report shows at the table level. Is there a way to add exceptions at the tablespace level?

Revisado: quarta-feira, 24 de agosto de 2022
4226180 - A feature is missing from the toolbar/menu or is not accessible. Where is the multiple db query feature?

How can a query be run in multiple databases?  When trying to access Tools | Query Multiple Databases, the option is not listed or is grayed out...

Revisado: quarta-feira, 24 de agosto de 2022
4262357 - <span id="title">Launching Toad for DB2 and connecting to database via command line</span>

How to launch Toad for DB2 and connecting to the database with specific credentials through command line?

Revisado: quarta-feira, 24 de agosto de 2022
4283018 - <font size="2">Runstats syntax is incorrect for several indexes on MQT table</font>

User tried to run statistics for indexes of MQT table, Toad for DB2 v 4.7 generated wrong syntax below: RUNSTATS ON TABLE "AGGR_PERSON_PGM...

Revisado: quarta-feira, 24 de agosto de 2022
4269232 - <font size="2">Unable to turn off "no row movement in views"</font>

User has used Toad for DB2 v 4.7 to do schema compare and found unable to turn off "no row movement in views"

Revisado: quarta-feira, 24 de agosto de 2022
4268398 - <font size="2">Suggestion to customize Automation Screen Sizing</font>

When  user has worked with Automation on Toad for DB2 and resize the screen so he can see all of the options. When  exits automation those...

Revisado: quarta-feira, 24 de agosto de 2022
4268390 - <font color="#008080" face="Courier New" size="2"><font color="#008080" face="Courier New" siz

Using Toad for DB2 v 4.7 user tried to do schema compare and got missing warning message. On Toad for DB2 v 4.0 the warning message was...

Revisado: quarta-feira, 24 de agosto de 2022
4268388 - 6 Digits Fractional Seconds Limitation

In the data grid it is possible to see timestamp(12) only with 6 digits precision (2015-12-03-13.42.22.608484) and not with 12 digits precision...

Revisado: quarta-feira, 24 de agosto de 2022
4326830 - -- comment is not effective when the comment is 4 characters or shorter.

-- comment is not effective when the comment is 4 characters or shorter.

Revisado: quarta-feira, 24 de agosto de 2022
4278425 - 'Toad 4.6.0.5.7.3 has encountered a problem and needs to close'

User installed Toad for DB2 silently on 120 machines and some of them got error: 'Toad 4.6.0.5.7.3 has encountered a problem and needs to close'

Revisado: quarta-feira, 24 de agosto de 2022
4235831 - 'This application requires admin privileges to install' when double-clicking MSI installer as an Admin user

When double-clicking the MSI installer in Windows as an admin user, the following error appears: 'This application requires admin privileges to...

Revisado: quarta-feira, 24 de agosto de 2022
4274655 - 'The operating system cannot run . (Exception from HRESULT: 0x800700B6)'

User just installed Toad for DB2 v 4.7 and tried to create new connection. On client configuration wizard, user entered operating system, host...

Revisado: quarta-feira, 24 de agosto de 2022
4248592 - 'The Explain table does not have the proper definition or is missing. SQLSTATE=01546' when trying

When trying to use Explain Plan for a sql in Toad for DB2 v3.1, the message: 'The Explain table does not have the proper definition or is missing...

Revisado: quarta-feira, 24 de agosto de 2022
4268679 - 'The exception unknown software exception (0xe0434f4d) occurred in the application at location

User launched Toad for DB2 4.0.0.556 and got error: 'The exception unknown software exception (0xe0434f4d) occurred in the application at location...

Revisado: quarta-feira, 24 de agosto de 2022
4242481 - 'Task Scheduler failed to start instance...Additional Data: Error Value: 2147942402' when running a job from an old version of Toad for DB2

When manually running a job created from an older version of Toad (e.g. v5.x) in v6.3, the following error appears: 'Task Scheduler failed to...

Revisado: quarta-feira, 24 de agosto de 2022
4310140 - 'Syntax Checker' icon is disabled

Opened a sql file and tried the 'Syntax checker' but it's not enabled (grayed out)

Revisado: quarta-feira, 24 de agosto de 2022
4283523 - 'System.InvalidOperationException: Invalid operation. The connection is closed.'

Customer just installed Toad for DB2 v 4.7 for trial. When connecting to his database he got error after clicking on connect a message: 'System...

Revisado: quarta-feira, 24 de agosto de 2022
4283100 - 'SQL3168W The PC/IXF column specified to be loaded into database column "&lt;name&gt;" is not

Needed to make the following changes to a table:   * Remove 2 columns,   * Change datatype (smallint --> decimal(5.2) on 5 columns,   * Add...

Revisado: quarta-feira, 24 de agosto de 2022
4283056 - 'SQL3326N The column list following the table name in the Action String parameter is invalid.'

From Toad for DB2 v 4.5.1.917, altered a table, move a column to a different position, a script was executed and failed in the import with error...

Revisado: quarta-feira, 24 de agosto de 2022
4278478 - 'SQL10007N Message "-1390" could not be retrieved. Reason code "6".'

User uninstalls IBM Data Studio, IBM Runtime Client and re-install TOAD for DB2 64bit. While importing profile or even create or manually creating...

Revisado: quarta-feira, 24 de agosto de 2022
4274568 - 'SQL1159 Initialization error with DB2 .NET Data Provider, reason code 3,'

User installed Toad on a new PC with Windows 7. Everything went fine until he intalled the DB2 Client seperatly and then created another DB2...

Revisado: quarta-feira, 24 de agosto de 2022
4273685 - 'SQL1038C An I/O error occurred while accessing the node directory' when trying to catalog a database

When trying to catalog database on Toad for DB2 on Citrix machine, the following error occurs:  'SQL1038C An I/O error occurred while accessing...

Revisado: quarta-feira, 24 de agosto de 2022
4283300 - 'SQL0104N An unexpected token "OPTIONS" was found following "UPDATE COMMAND "'

User executed command 'UPDATE COMMAND OPTIONS USING C OFF' from Toad Editor and got error: 'SQL0104N An unexpected token "OPTIONS" was found...

Revisado: quarta-feira, 24 de agosto de 2022
4283240 - 'SQL0525N  The SQL statement cannot be executed because it was in error<br/> at bind  time f

User used Toad for DB2 v 4.6 to import data and got following message: IMPORT FROM  'C:\Users\JChung\AppData\Roaming\Quest Software\Toad for...

Revisado: quarta-feira, 24 de agosto de 2022
4279092 - 'SQL0420N Invalid character found in a character string argument of the function'

User tried to  insert a row following statement: insert into VRAP.RCIT_RVRS_DUP_REF (CLM_GID,EXTL_SRC_CD,NABP_ID,DSPN_DT,NEW_REFIL_CD,INSRT_DT...

Revisado: quarta-feira, 24 de agosto de 2022
4278817 - 'SQL Analysis agent (Dispatcher) generated a software exception. Reason code: 0x6'

User ran a SQL collection and got an error: SQL Analysis agent (Dispatcher) generated a software exception. Reason code: 0x6

Revisado: quarta-feira, 24 de agosto de 2022
4278575 - 'SQL0440N  No authorized routine named "SYSPROC.DSNTPSMP" of type "" having compatible argumen

User used Toad for DB2 v 4.7 to create a stored procedures, and got error : 'SQL0440N  No authorized routine named "SYSPROC.DSNTPSMP" of type...

Revisado: quarta-feira, 24 de agosto de 2022
4268903 - 'SQL0551N "syscat.variables" does not have the required authorization'

  After an upgrade to version 9.7 the Schema compare fails with an SQL0551N on "syscat.variables". SQL0551N "SYSCAT.VARIABLES" does not have the...

Revisado: quarta-feira, 24 de agosto de 2022
4268499 - 'SQL0104N An unexpected token "APREUSE" was found following "ANY".'

When user rebinds an existing package the script correctly reads from the syscat.package for the options to be used BUT errors on the rebind...

Revisado: quarta-feira, 24 de agosto de 2022
4283142 - 'SQC70012E: DB2 statement INSERT INTO QUEST.SC_STATISTICS failed in UdbExecute'

User tried to do SQL Collection with Toad for DB2  and got status 'incomplete'. Error was found on supportbundle file: 'SQC70012E: DB2 statement...

Revisado: quarta-feira, 24 de agosto de 2022
4309730 - 'Security Administration' is missing from the list of Authorities displayed for Groups

In the Database Explorer, click on a User name. "Security Administration" is among the list of Authorities displayed. Next click on a group name...

Revisado: quarta-feira, 24 de agosto de 2022
4278693 - 'QCC20004E: QcClient - Error launching agent 'ScAdmin@1' (rc=5)'

User had installed Quest Agent on one server machine then installed Toad agent for SQL Analysis 5.1 on different folder. When tried to do SQL...

Revisado: quarta-feira, 24 de agosto de 2022
4274615 - 'QL0204N "NULLID.SQLC2H20" is an undefined name.'

The problem is when trying to export data from a DB2 database to C:\Temp, I get the following error: "DB21034E  The command was processed as an...

Revisado: quarta-feira, 24 de agosto de 2022
4274034 - 'QCC20000I: QcServer - Launch server initialization failed (rc=67)'

User brought up Toad Agent from server machine and got error: 'QCC20000I: QcServer - Launch server initialization failed (rc=67)'

Revisado: quarta-feira, 24 de agosto de 2022
4268687 - 'No changes detected' message appears when trying to Alter Tablespace

When trying to alter a partitioning tablespace, the following message appears: No changes detected. This occurs when: 1. Selecting all...

Revisado: quarta-feira, 24 de agosto de 2022
4283478 - 'Message : startIndex cannot be larger than length of string'

User has used Toad Editor and got error 'startIndex cannot be larger than length of string' when it happened on code completion: If user...

Revisado: quarta-feira, 24 de agosto de 2022
4235765 - 'Managed By' attribute for Identify Exception Report

Revisado: quarta-feira, 24 de agosto de 2022
4239890 - 'Length cannot be less than zero' error when trying to connect to DB2

After an installation of Toad for DB2, the following error appears when trying to connect to the database: 'Length cannot be less than zero...

Revisado: quarta-feira, 24 de agosto de 2022
4278544 - 'Index was outside the bounds of the array.'

User selects an entry in Connection Manager | Properties |Connect and got error: Exception: System.IndexOutOfRangeException Message  : Index was...

Revisado: quarta-feira, 24 de agosto de 2022
4268898 - 'Index was outside the bounds of the array' caused by auto-connection

User sometimes got error 'Index was outside the bounds of the array' when launched Toad for DB2 with auto-connection. It only happened on the...

Revisado: quarta-feira, 24 de agosto de 2022
4273757 - 'FOR BIT DATA' attribute is not generated correctly in Toad for DB2 4.6

Toad for DB2 4.6 and 4.6.2 doesn't generate the DDL correctly. Both column type LONG VARCHAR with 'FOR BIT DATA'.  1. Command db2look shown...

Revisado: quarta-feira, 24 de agosto de 2022
4306070 - 'Extract DDL' for a 'Before Insert' trigger does not include the full SQL for recreating the trigger.

In the Object Explorer, right-click a 'Before Insert' Trigger | Extract DDL does not generate the full create trigger script. i.e It doesn't...

Revisado: quarta-feira, 24 de agosto de 2022
4252546 - 'Extract DDL' option is disabled or grayed-out and shows as, 'Not Licensed'.

The "Extract DDL" option, when right-clicking on an object, is disabled or grayed-out and indicates "(Not Licensed)".

Revisado: quarta-feira, 24 de agosto de 2022
4241700 - 'ERROR [53090]' when trying to connect to DB2 databases where DB2_IMPLICIT_UNICODE=YES

When trying to connect with Toad to a DB2 database of SAP, which has this configuration: 'DB2_IMPLICIT_UNICODE=YES', the following error appears...

Revisado: quarta-feira, 24 de agosto de 2022
4283000 - 'Error opening the ScCNTRepo result file (/udbarch/questagent/produdbade1l/tmp/OU'

A Linux machine has many standby databases in cluster environment. User has only one database DBWASPA is active and others are inactive...

Revisado: quarta-feira, 24 de agosto de 2022
4240054 - 'Create as new table' creates the table in the wrong database

When trying to export a result set with the export wizard, creating the results into a new table, Toad tries to create it on the default DB2...

Revisado: quarta-feira, 24 de agosto de 2022
4308008 - 'Control + Shift + Home' and 'Control + Shift + End' to highlight texts not working

'Ctrl + Shift + Arrow Keys', 'Ctrl + Shift + Home' and 'Ctrl + Shift + End' to highlight text in the Editor is not working.

Revisado: quarta-feira, 24 de agosto de 2022
4311506 - 'Client Requirements' link in 'Create New Connection' window does not take user to release notes

When Toad is first installed and a new connection is being set up, Toad will test to see if there is a DB2 client installed. If no client is found...

Revisado: quarta-feira, 24 de agosto de 2022
4282786 - 'Compile SQL Procedure with Debug' option is not enabled or grayed-out and shows 'Not Licensed'.

User can alter a procedure, but cannot use the "Compile SQL Procedure with Debug".  The option is grayed out and shows "(Not Licensed)".

Revisado: quarta-feira, 24 de agosto de 2022
4269112 - 'Command execution fails. Unable to route command to DB2 CLP Process.'

User tried to catalog a database from Toad for DB2 v 4.7 the configuration wizard executed catalog command and got error: 'Command execution...

Revisado: quarta-feira, 24 de agosto de 2022
4235804 - 'Class not registered' error appears when running an Explain Plan

When running the Explain Plan in Toad, the following error appears: 'System.Runtime.InteropServices.COMException Class not registered (exception...

Revisado: quarta-feira, 24 de agosto de 2022
4278432 - 'Attempted to read or write protected memory. This is often an indication that other memory is

After connection to a database, start the editor. Type SELECT and a space, and error comes up below...

Revisado: quarta-feira, 24 de agosto de 2022
4268085 - 'Attempted to read or write protected memory.'

User typed on Editor a SQL statement on Toad for DB2 v 4.7 and got error 'Invalid pointer' . Also on exception trace.log file shown 'Attempted to...

Revisado: quarta-feira, 24 de agosto de 2022
4268877 - '<font size="1">SQL1822N Unexpected error code "1786" received from data source.</font><font s

Customer tried to create a nickname and got error: ERROR [560BD][IBM][DB2/LINUXX8664]SQL1822N Unexpected error code "1786" received from data...

Revisado: quarta-feira, 24 de agosto de 2022
4329396 - '"DB2 Database Error: ERROR [58005] [IBM][DB2.NET] SQL0902" An unexpected exception has occurred

When running a SQL query on an UTF-8 Database containing Korean characters, the following error appears: DB2 Database Error: ERROR [58005] [IBM...

Revisado: quarta-feira, 24 de agosto de 2022
4332808 - #SET TERMINATOR command is not accepted by Toad

--#SET TERMINATOR is a SPUFI specific command to override the SQL terminator character that is specified on the CURRENT SPUFI DEFAULTS panel. The...

Revisado: quarta-feira, 24 de agosto de 2022
4269217 - "Where clause" would apply to Query builder columns filter and not to a 'Global where clause'<

User selected SQL statement in an Editor window and select Send it to Query Builder , there 'Where clause'  was created as a 'Global Where Clause...

Revisado: quarta-feira, 24 de agosto de 2022
4234023 - "Toad.exe - Fatal error CLR error: 80004005..."

After installing Toad and trying to launch the application, I get the error: Toad.exe - Fatal error CLR error: 80004005 The program will now...

Revisado: quarta-feira, 24 de agosto de 2022
4234011 - "This type of SQL statement is not supported" when optimizing a valid SQL statement.

When trying to optimize a statement, a "This type of SQL statement is not supported" error is given. The query runs w/o problems. From Toad...

Revisado: quarta-feira, 24 de agosto de 2022
4234086 - "The extended alter feature requires a Toad DB2/DBA License" message when trying to alter column.

Using the Alter Table window to drop a column, I get the following message when I click on Show Script: -- The extended alter feature requires...

Revisado: quarta-feira, 24 de agosto de 2022
4283437 - "System.IndexOutOfRangeException: Column INDCARD doesn't exist"

User lists all tables for a schema, hightlight some of them, right click | Space Management | Identify Exception An error comes up "System...

Revisado: quarta-feira, 24 de agosto de 2022
4334084 - "SQL0461N A value with data type "SYSIBM.XML" cannot be CAST to type "SYSIBM.VARCHAR". SQLSTATE=4

When trying tochange a table column from type XML to VARCHAR(20000), Toadgenerates the insert below: Insert (into temptable) with CAST(RESULT AS...

Revisado: quarta-feira, 24 de agosto de 2022
4305655 - "SQL30082N missing password" error when running a scheduled automation task

Error "SQL30082N missing password " occurs when executing task through Job Manager. Automation script runs manually OK.

Revisado: quarta-feira, 24 de agosto de 2022
4277289 - "Quest SQL Optimizer for DB2 UDB Authentication" windows when attempting to optimize (Tune) a sta

Error received prompting users to input a license key when attempting to optimize (tune) a statement from the Editor Window or launch the "SQL...

Revisado: quarta-feira, 24 de agosto de 2022
4310493 - "No growth history found" displayed for tablespace usage

Revisado: quarta-feira, 24 de agosto de 2022
4306080 - "Need more information to connect" window highlights the NAME field instead of the PASSWORD field

When the "Show connection dialog on startup" is NOT checked and a connection is double-clicked, where the password has not been stored, Toad 6.2...

Revisado: quarta-feira, 24 de agosto de 2022
4278638 - "Invalid URI: The hostname could not be parsed" when clicking Database Explorer's table tab

User connected to database from Toad for DB2. When the user clicked on the Database Explorer's Table tab, it listed only one table (there are...

Revisado: quarta-feira, 24 de agosto de 2022
4282810 - "Failed reading actions from C:#quest_toad_instPluginsCorecommon.actions.pck"

Tried to launch Toad for DB2 after entering license key an error shown up: Failed reading actions from C:#quest_toad_instPluginsCorecommon.actions...

Revisado: quarta-feira, 24 de agosto de 2022
4329697 - "ERROR [08001] [IBM] SQL30081N A communication error has been detected." when connecting to DB2

Receiving an ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication...

Revisado: quarta-feira, 24 de agosto de 2022
4258409 - "Error [42968] IBM [SQL8002N - Connect processing failed; a valid product license was not found].

When trying to connect to a DB2 Database the following error is received: "Error [42968] IBM [SQL8002N - Connect processing failed; a valid...

Revisado: quarta-feira, 24 de agosto de 2022
4332331 - "Error posting changes" when updating integer column in data-grid

When updating an integer column in the data-grid and getting an "Error posting changes": "Index and length must refer to a location within the...

Revisado: quarta-feira, 24 de agosto de 2022
4313982 - "Error 1704. An installation for &lt;program name&gt; is currently suspended..." when installing

When installing the Quest application, the following error is displayed: "Error 1704. An installation for <program name> is currently...

Revisado: quarta-feira, 24 de agosto de 2022
4272323 - "ERROR - no error information available" when trying to connect

On a new installation of Toad for DB2 LUW 5.6, the following error appears when trying to connect: "ERROR - no error information available...

Revisado: quarta-feira, 24 de agosto de 2022
4268592 - "EDW5P1: 3212 errors have occurred during extraction of query 'query name' "

User did compare object for a large number of tables, it took long time to respond and alsodisplayed the followingerror: EDW5P1: 3212 errors have...

Revisado: quarta-feira, 24 de agosto de 2022
4274154 - "DB2 Z/OS connections are not currently licensed" error after revoking DBADM privileges.

User with DBADM permission can initially connect to DB2 database. Later if these permissions are revoked, the user cannot connected and the error...

Revisado: quarta-feira, 24 de agosto de 2022
4231852 - "Configuration parameter token specified is invalid" when trying to set DB Parameter AUTO_REVAL.

When working in a database details window | DB Parameters tab, the AUTO_REVAL "Deferred" setting cannot be set. Click on the drop down for that...

Revisado: quarta-feira, 24 de agosto de 2022
4278830 - "Bufferedgraphicscontext cannot be disposed of because a buffer operation is currently in progres

I get the following error when I select space management | exeception identify for a large group of tables. 'Bufferedgraphicscontext cannot be...

Revisado: quarta-feira, 24 de agosto de 2022
4242361 - Script Tab of a Table is very slow to generate the DDL

In the Database Explorer, the Script tab of a table is very slow to generate the DDL.

Revisado: quarta-feira, 24 de agosto de 2022
4283177 - Schema Compare with 800 tables took a long time to complete

When using the schema compare in 4.6.2 version it takes 2 + Hours to complete, do the exact same schema compare on version 4.0.1.92 1t takes 5...

Revisado: quarta-feira, 24 de agosto de 2022
4228315 - Schema Compare will not detect different trigger SQL, SQL body of trigger is truncated

The compare tool in Toad for DB2 5.2, will not detect any differences between two triggers in two identical tables in two different schemas. Toad...

Revisado: quarta-feira, 24 de agosto de 2022
4265805 - Schema Compare Sync wizard creates a duplicate connection

Revisado: quarta-feira, 24 de agosto de 2022
4284295 - Schema Compare on ZOS is finding and comparing tables not owned by the compared schemas.

Running  Schema Compare on a ZOS server and  the result shows other tables that do not exist in those schemas.

Revisado: quarta-feira, 24 de agosto de 2022
4220306 - Schema compare producing invalid synchronization script.

Running the Schema Compare shows an invalid synchronization script. The RI (Referential Integrity) constraints are not being recreated, tables not...

Revisado: quarta-feira, 24 de agosto de 2022
4324797 - Schema Compare is Missing after the upgrade

Revisado: quarta-feira, 24 de agosto de 2022
4269240 - Schema compare generating bad ddl

User was comparing schema WF57PU (test) to schema WF57PP (prod). (DDL on attachments) A new column was added to the end of WF57PP.STG_APPL_AG...

Revisado: quarta-feira, 24 de agosto de 2022
4240446 - Schema Compare generates and old and new Primary Key clause

Revisado: quarta-feira, 24 de agosto de 2022
4278713 - Schema Compare flags a difference for CCSID UNICODE on a table

Enhancement Request: DB2 LUW: Schema Compare flags a difference for CCSID UNICODE on a table. Enhancement request to ignore the CCSID UNICODE...

Revisado: quarta-feira, 24 de agosto de 2022
4331872 - Schema Compare default values difference not recognized

When trying to compare 2 schemas (Tools | Compare | Compare schema) with exactly the same table but default value is different, the result shows...

Revisado: quarta-feira, 24 de agosto de 2022
4227522 - Schema compare does not generate apply DDL for DISTRIBUT BY HASH parameters

There is a difference on  DISTRIBUT BY HASH parameters of two tables. Ran schema compare on Toad for DB2 v 4.6.0 . It came up blank on the apply...

Revisado: quarta-feira, 24 de agosto de 2022
4295023 - Schema Compare - needs 'ignore compression option'

User needs 'ignore compression' option on schema compare. This option is applied to tables and indexes. See attachment, where compression...

Revisado: quarta-feira, 24 de agosto de 2022
4283170 - schema compare - not ignoring permissions

Revisado: quarta-feira, 24 de agosto de 2022
4278811 - Schema compare - Constraint shown both target source schema names

User did a schema compare ALTSDDB and ALTSTDB, Toad found differences on constraint and generated DDL with mixed schema names. For example...

Revisado: quarta-feira, 24 de agosto de 2022
4238487 - Schema Compare Alter statement incorrect

After running a Schema Compare, the created alter script contains a DROP and CREATE statement in it, rather than an ALTER statement.

Revisado: quarta-feira, 24 de agosto de 2022
4215234 - Schema compare - did not build ALTER

Revisado: quarta-feira, 24 de agosto de 2022
4279082 - Scheduled job got error 'Could not start'

User had 200 Scheduled tasks on Toad for DB2 v 4.6 however, after upgrading Toad v 4.7, user uninstalls Toad v 4.6 Whenever, submit a job he...

Revisado: quarta-feira, 24 de agosto de 2022
4296075 - Runstats | 'Show Script' button | does not show all scripts for multiple Tablespaces selected.

Tablespaces | Runstats | 'Show Script' button | does not show all scripts when multiple Tablespaces are selected or highlighted.  It only shows or...

Revisado: quarta-feira, 24 de agosto de 2022
4283104 - Runstats was generated missing space

Ran a compare object tables with partition range script generated a missing space between INDEXES and a double quote See below: RUNSTATS ON...

Revisado: quarta-feira, 24 de agosto de 2022
4279145 - Rollback active or lock waiting are not displayed by Toad for DB2

Toad is not able to show some statuses for e.g. rollback active or lock waiting in Applications tab.

Revisado: quarta-feira, 24 de agosto de 2022
4274184 - Restarting where Automated TAS Files was broken.

Revisado: quarta-feira, 24 de agosto de 2022
4274106 - Requesting runstats and backup to be done after reorg a table

ENHANCEMENT REQUEST: Requesting runstats and backup to be done after reorg a table

Revisado: quarta-feira, 24 de agosto de 2022
4278634 - Requested always to see tablespace and indexspace on Define transformation rules

User compared objects and found that source table on SMS tablespace then Define transformation rules screen didn't show Indexspace. User...

Revisado: quarta-feira, 24 de agosto de 2022
4223171 - Reorg Tablespace does not generate Runstats correct statement for all tablespaces.

When multiple Tablespaces are selected for Reorganization, generated script creates correct Run Statistics statement properly for the first...

Revisado: quarta-feira, 24 de agosto de 2022
4258540 - REORG feature in Toad should not be using SORTDATA

Revisado: quarta-feira, 24 de agosto de 2022
4214019 - Reorg cleanup overheads, is there an option?

Is there a  "cleanup overheads" as an option within the DB2 reorg? If not, can it be added?

Revisado: quarta-feira, 24 de agosto de 2022
4306929 - Rename Table function does not update alias names

Revisado: quarta-feira, 24 de agosto de 2022
4214318 - Remove 'Check for updates on startup'

Everytime Toad starts it checks for updates

Revisado: quarta-feira, 24 de agosto de 2022
4261664 - Refund for Support Maintenance Fee

I can no longer use this product and would like a refund for the annual support fee that I just paid for.  Can you please tell me how to proceed?

Revisado: quarta-feira, 24 de agosto de 2022
4239464 - Receive 'ERROR [42601]...An unexpected token "/*" was found following ""...' when running a query

When running a query in DB2 Z/oS mainframe the following error is received: ERROR [42601] [IBM][CLI Driver][DB2] SQL0104N An unexpected token...

Revisado: quarta-feira, 24 de agosto de 2022
4269203 - Rebuild Indexes but missing runtats

User  was rebuilding 9 indexes and the drop / creates generate correctly. However, it is not generating runstats to run. Is there any option for...

Revisado: quarta-feira, 24 de agosto de 2022
4247701 - Rebind package issue due to Toad adding quotation.

Revisado: quarta-feira, 24 de agosto de 2022
4274696 - Range partition displayed FALSE for a partitioned table

I altered a table through Toad which set up range partitioning on a table.  I had to make another alteration to the table and the table was...

Revisado: quarta-feira, 24 de agosto de 2022
4237403 - Random Errors: 'Object reference not set to an instance of an object' and 'Index was out of range'.

During the use of Toad, the following error appears for some users randomly: "Object reference not set to an instance of an object"  and "Index...

Revisado: quarta-feira, 24 de agosto de 2022
4253273 - Question: Which option to stop a running script with error?

User ran a script with many SQL statements. It continued to run to the end even one SQL got error. So Which option to stop a running script with...

Revisado: quarta-feira, 24 de agosto de 2022
4268542 - quest.conf gets empty whenever restart Toad Agent.

Revisado: quarta-feira, 24 de agosto de 2022
4265765 - Quest Support Portal and Akamai Download Manager problems

Revisado: quarta-feira, 24 de agosto de 2022
4274703 - Quest SQL Optimizer for DB2 LUW can't be launched from Toad for DB2 v 4

From Toad for DB2, clicked on Tools | Quest Tools| SQL Optimizer Two errors came up: 1. Failed to launch Quest SQL Optimizer for DB2 LUW...

Revisado: quarta-feira, 24 de agosto de 2022
4329636 - Query duration and execution time is missing in the editor

The query duration and the execution time information is missing in version 7.4. In previous versions of Toad for DB2, that information was shown...

Revisado: quarta-feira, 24 de agosto de 2022
4269076 - Query Builder generated SQL wrong statement

Revisado: quarta-feira, 24 de agosto de 2022
4268676 - Query Builder does not allow to switch databases.

User is unable to switch to another connected database when hes in the Query Builder Tab. Switching to another connected database works in version...

Revisado: quarta-feira, 24 de agosto de 2022
4314503 - Queries only retrieving the first 1000 rows

Queries only retrieve the first 1000 rows and I want to see all the rows.

Revisado: quarta-feira, 24 de agosto de 2022
4237989 - Provide statistical Analysis of SQL statements and RUNSTATS commands to implement those recommendations?

Does Toad for DB2 and/or SQL Optimizer for DB2 provide statistical Analysis of SQL statements and provide recommended RUNSTATS commands to...

Revisado: quarta-feira, 24 de agosto de 2022
4309031 - Properties for default WLM service Class SYSDEFAULTSUBCLASS are incorrect

The wrong Properties are shown for some of the default WLM Service Classes. Expand Service Classes | System Objects. The 7 default Service Classes...

Revisado: quarta-feira, 24 de agosto de 2022
4274455 - Prompted to upgrade to v5.0.1 - which client to download

Revisado: quarta-feira, 24 de agosto de 2022
4333964 - Profiling table with tsd 9999 12 31 % results in System.IO.EndOfStreamException

When selecting in Toad for DB2 V6.0 the profiling tag for a result set that contains a date/tsd with 9999-12-31, an error is received: System.IO...

Revisado: quarta-feira, 24 de agosto de 2022
4283010 - Product becomes unresponsive with 'Error creating window handle.'

Recently upgraded from TOAD for DB2 4.6 to TOAD for DB2 4.7. I am running the product on Windows XP with 2.99 gig of RAM. Since the upgrade...

Revisado: quarta-feira, 24 de agosto de 2022
4237894 - Procedures get dropped and recreated in Object Compare even though they are equal

When using Object Compare, even though procedures are considered equal by the compare, they still get dropped and created in the DDL script. 

Revisado: quarta-feira, 24 de agosto de 2022
4278789 - Problem with reading LDAP cataloged databases

Toad for DB2 v6.3 64-bit is not able to load database cataloged in LDAP.

Revisado: quarta-feira, 24 de agosto de 2022
4273488 - Problem with saving settings after upgrade

After upgrading from Toad for DB2 version 6.1 to  6.2 it is not possible to save changed settings - for example, it is not possible to use Apply...

Revisado: quarta-feira, 24 de agosto de 2022
4269371 - Problem Updating Liscence Code on Toad v 5.0 - Windows 7

Revisado: quarta-feira, 24 de agosto de 2022
4333248 - Problem renaming column

Revisado: quarta-feira, 24 de agosto de 2022
4317019 - Problem in granting roles

There is a problem in granting roles. After double clicking a table on the object palette window, it generates the DDL, but the GRANT statement is...

Revisado: quarta-feira, 24 de agosto de 2022
4296770 - Problem importing catalog

Toad for DB2 is no able to import the catalog of other DB2 Instances when there is  more than one DB2 Instance with one Softwarelevel. Only the...

Revisado: quarta-feira, 24 de agosto de 2022
4268079 - Problem displaying threads - Subsystem viewer

Revisado: quarta-feira, 24 de agosto de 2022
4242174 - PRIQTY and SECQTY are being displayed and compared when “Ignore PRIQTY & SECQTY” option is checked

In Object Compare, the “Ignore PRIQTY & SECQTY” option is checked in the compare’s advanced options, but it still displays these and highlights...

Revisado: quarta-feira, 24 de agosto de 2022
4320042 - Printing ER diagram to a plotter

We have an HP plotter. I wish to print a 6 table ER diagram to the plotter. Toad recognizes the plotter however it does not allow me to print...

Revisado: quarta-feira, 24 de agosto de 2022
4262064 - Predicate Text Values are missing in Explain Plans of queries.

Predicate Text values are missing in Explain plans. They are present in version 4.5 and not present in version 5.3.

Revisado: quarta-feira, 24 de agosto de 2022
4274204 - Error: "SQL1027N node directory cannot be found" upon launching TOAD.

After installing and launching Toad for DB2, the New Connection dialog window appears and the SQL1027N error message appears in the connection...

Revisado: quarta-feira, 24 de agosto de 2022
4231960 - Error, "Utility command failure: LOAD DATA" when altering a table to lower the column size

When altering a DB2 table in Toad to change a column size of a column to a lower number, say from 75 to 50, Toad generates a script utilizing the...

Revisado: quarta-feira, 24 de agosto de 2022
4232314 - Error, "SQL0206N "SN.FS_TOTAL_SIZE" is not valid in the context where it is used" clicking on details tab for space usage

The following error occurs everytime a user goes to Space Usage | Details in the Database Viewer: ERROR [42703] [IBM][DB2/AIX64] SQL0206N  "SN...

Revisado: quarta-feira, 24 de agosto de 2022
4229777 - Error, "Object reference not set to an instance of an object" when clicking on the Applications tab in the Object Explorer

When choosing Database in the Object Explorer and then clicking on the Application tab on the right side, no information is given with the...

Revisado: quarta-feira, 24 de agosto de 2022
4227134 - Error, "Object reference not set to an instance of an object" when using the Rebuild Indexes tool

Using the Rebuild Indexes tool in the Object Explorer and the following error appears: System.NullReferenceException Object reference not set to...

Revisado: quarta-feira, 24 de agosto de 2022
4225630 - Error, "Couldn't load assembly ToadDB2.dll" when connecting to DB2 in Toad for DB2

When connecting to a DB2 database in Toad, the following exception error occurrs: Quest.Toad.Exceptions.BaseException: Couldn't load assembly...

Revisado: quarta-feira, 24 de agosto de 2022
4303028 - ERROR [560BC] [IBM][DB2/NT] SQL0443N  Routine "SYSPROC.DB_PARTITIONS" (specific name "DB_PARTI

The following error occurs when clicking icon to alter a table space ERROR [560BC] [IBM][DB2/NT] SQL0443N  Routine "SYSPROC.DB_PARTITIONS...

Revisado: quarta-feira, 24 de agosto de 2022
4275957 - ERROR [42968] [IBM] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968.

Connecting to a LUW database with Toad for DB2 is proper.  However, when trying to connect to a z/OS database with Toad for DB2 returns: Database...

Revisado: quarta-feira, 24 de agosto de 2022
4221474 - ERROR [51002] [IBM][DB2] SQL0805N Package "ASMNETDB2x.NULLID.SYSSH200.XxXxXx" was not found

Attempting to connect to a new BD2 for z/OS subsystem database one may see the error:       ERROR [51002] [IBM][DB2] SQL0805N  Package...

Revisado: quarta-feira, 24 de agosto de 2022
4285943 - ERROR [42704] [IBM][DB2/<OS>] SQL0204N "SYSIBMADM.ENV_CF_SYS_RESOURCES" is an undefined name.

When going to the Capacity Tool/Space Management using a DB2 LUW database v9.x, Toad will create an script and send it to the Editor with the...

Revisado: quarta-feira, 24 de agosto de 2022
4253394 - ERROR [42724] [IBM] SQL1109N The specified DLL "GSKit Error: 202"

When trying to connect to a DB2 database, getting the following error: ERROR [42724] [IBM] SQL1109N  The specified DLL "GSKit Error: 202" could...

Revisado: quarta-feira, 24 de agosto de 2022
4278295 - Error with different DataBase (DB) name with giving DB name during connection

User connected to database MPALT01 from Toad for DB2 v 5.0. User got an error: "SQL30061N The database alias or database name "LENA960 " was not...

Revisado: quarta-feira, 24 de agosto de 2022
4222488 - Error when using CALL PROC on a procedure with bind variables: "DB2 Database Error: ERROR [428

Customer using the CALL PROC command in Editor to run a procedure with bind variables as follows.  He is prompted to enter the bind variable...

Revisado: quarta-feira, 24 de agosto de 2022
4235821 - Error when opening Tools | Automation window 'The type initializer for 'Quest.Toad.Workflow.Activities.SendEmailActivity' threw an exception.'

When opening the Tools | Automation menu in v7.1.2, the following error appears: 'System.TypeInitializationException The type initializer for...

Revisado: quarta-feira, 24 de agosto de 2022
4240503 - Error when installing Toad for DB2: "Microsoft .NET Framework is not installed"

Error received during installation "Microsoft .NET Framework is not installed".

Revisado: quarta-feira, 24 de agosto de 2022
4284913 - Error when connecting: "ERROR [42968] [IBM] SQL8002N Connect processing failed; a valid product l

When I try to connect to my DB2 database using Toad for DB2 I get the following error: "ERROR [42968] [IBM] SQL8002N Connect processing...

Revisado: quarta-feira, 24 de agosto de 2022
4270866 - Error when attempting to connect to DB2 database: "Error:Security Processing Failed with reason 1

When attempting to connect to a DB2 database, the following error may occur: "Error:Security Processing Failed with reason 17 - unsupported...

Revisado: quarta-feira, 24 de agosto de 2022
4239115 - Error viewing table properties: "There are no context policies"

An error occurs while viewing the properties of the table in Toad for DB2 3.0.1: 'ERROR [58005][IBM][DB2.NET] SQL0902 An unexpected exception...

Revisado: quarta-feira, 24 de agosto de 2022
4273370 - Error using Schema Migration Wizard: "ERROR [57014] [IBM][DB2] SQL0952N Processing was cancelled

An error message appears when trying to define filter settings during migration in DB2 ZOS. This also includes using the filter 'include...

Revisado: quarta-feira, 24 de agosto de 2022
4224233 - Error using Load command to load cursor: ERROR [42601] [IBM][DB2/AIX64] SQL0104N

Following error occurs when using LOAD FROM ... OF CURSOR command in Editor to load a cursor: Load From C1 of Cursor Replace into <tablename...

Revisado: quarta-feira, 24 de agosto de 2022
4222868 - Error using "Send to Query Builder" option of Editor window when using table alias names: "Query

The following error occurs when using the "Send to Query Builder" option of Editor window on a query statement that includes table alias names...

Revisado: quarta-feira, 24 de agosto de 2022
4265173 - Error uninstalling application: "Internal Error 2721. Action 133137"

The following error occurs when trying to uninstall Toad for DB2: Internal Error 2721. Action 133137 Note: When trying to connect to any...

Revisado: quarta-feira, 24 de agosto de 2022
4268691 - Error selecting Space Management | Calculate Space option for a table: "Index was out of range. M

In Toad, right-clicking on table name  and selecting  Space Management | Calculate Space option results in the  following  error: Exception...

Revisado: quarta-feira, 24 de agosto de 2022
4240860 - Error opening Object Explorer: "System.ArgumentNullException. Value cannot be null."

When object visibility for explorer is all set to not visible, opening the object explorer in treelist view generates the following error: System...

Revisado: quarta-feira, 24 de agosto de 2022
4307493 - Error opening an .XPN file and viewing the right-click menu option of Explain Plan: "Quest.Toad.E

User opens a large .xpn file via File | Open File menu in Toad or he double clicks on the file outside of Toad which is then is opened with Toad...

Revisado: quarta-feira, 24 de agosto de 2022
4283447 - Error message: 'baseRow doesn't belong to this XRTable'

After a schema compare successful, click on table, select a table from here either click on Print icon or File | Print always get error: 'baseRow...

Revisado: quarta-feira, 24 de agosto de 2022
4226307 - Error message indicating trial license key has expired.

Error message indicating trial license key has expired as a trial key is entered into Knowledge Xpert or the trial period is passed.

Revisado: quarta-feira, 24 de agosto de 2022
4333458 - Error installing Toad: "An error occurred while initializing the Profile Registry."

When trying to install Toad for Db2 2.5.0.912 the following Registry error appears : 'An error occurred while initializing the Profile Registry...

Revisado: quarta-feira, 24 de agosto de 2022
4283535 - Error installing Toad for DB2: "Latest Microsoft .NET Framework is required by this applicatio

When installing Toad for DB2, the following message appears: Latest Microsoft .NET Framework is required by this application.  Immediately...

Revisado: quarta-feira, 24 de agosto de 2022
4283172 - Error installing Toad, while initializing profile registry: "unable to install/get error occurred

User has  installed many versions of Toad for DB2 Z/OS from 2.5 to 3.1.0.474 successful for free trial. When  installing the commercial version 3...

Revisado: quarta-feira, 24 de agosto de 2022
4242446 - Error initiating the installer executable: "Windows cannot access the specified device, path or f

The installer executable was downloaded from Supportlink. The user is an Admin user on the computer.  Double clicking on the executable...

Revisado: quarta-feira, 24 de agosto de 2022
4227928 - Error in Migrate Object wizard: "Object reference not set to an instance of an object"

  The following error occurs at the last pane of Migrate Object wizard when attempting to generate script: "Object reference not set to an...

Revisado: quarta-feira, 24 de agosto de 2022
4226671 - Error in Alter Table | Show Script for partitioned table using no tablespace names: "Quest.Compar

User adds a few partitioned columns to a partitioned table having no tablespace names specified using Alter Table window.  The following error...

Revisado: quarta-feira, 24 de agosto de 2022
4237917 - Error entering license key: "DB2 ZOS connections are not currently licensed".

Inputting the licensed key generated by Quest Support Admin generates the message: Database Error: DB2 ZOS connections are not currently licensed

Revisado: quarta-feira, 24 de agosto de 2022
4289253 - Error during Toad for Data Analysts installation: "An error occurred while creating the instance

When I try to install Toad for Data Analysts (TDA), I get the error below. I don't have any DB2 clients installed. An error occurred while...

Revisado: quarta-feira, 24 de agosto de 2022
4260882 - Error during installation: Could not find a part of the path 'C:\Program Files (x86)\IBM\SQLLIB\BIN\netf40'..

The following error occurs during installation:   "Could not find the a part of the path: C:\Program Files\IBM\ SQLLIB\BIN\netf20\specific." or...

Revisado: quarta-feira, 24 de agosto de 2022
4302071 - Error during Compare and Sync: Object reference not set to an instance of an object.

Error during Compare and Generate Sync Script: Object reference not set to an instance of an object. Exception: System.NullReferenceException...

Revisado: quarta-feira, 24 de agosto de 2022
4244883 - Error detected viewing SQL Script when copying tablespace

When right clicking on a Tablespace and selecting Utilities | Copy, in the Dependencies tab, when the SQL Script section is selected in the Copy...

Revisado: quarta-feira, 24 de agosto de 2022
4279036 - Error connecting to database: "Could not load file or assembly 'IBM.Data.DB2.9.5.2'"

A trial version of Toad for DB2 v4.0 was installed on user's desktop. It worked fine until  trial edition of  Toad for DB2 v 4.5 installed. User...

Revisado: quarta-feira, 24 de agosto de 2022
4330314 - Can not connect to an AIX server, getting "ERROR [] [IBM] SQL5048N"

I try to connect to our DB, I keep getting the following error: ERROR [] [IBM] SQL5048N The release level of the database client is not...

Revisado: quarta-feira, 24 de agosto de 2022
4304077 - Calendar tool, which includes the 'Clear' button, is no longer available when editing a date.<

When editing a column in the Data Grid, in previous versions of Toad, I was able to set the field to a specific date or to Null using the drop...

Revisado: quarta-feira, 24 de agosto de 2022
4311954 - Bit data column is not formatted correctly with Generate Test Data

Generating Test Data against a table with a column defined as CHARACTER FOR BIT DATA  produces an insert statement with incorrectly formatted...

Revisado: quarta-feira, 24 de agosto de 2022
4156088 - Getting a "System.OverflowException" error while altering a tablespace secondary quantity allocat

Getting a System.OverflowException error while altering a tablespace secondary quantity allocation. Also, Toad shows a negative sec qty value on...

Revisado: sábado, 20 de agosto de 2022
4159908 - Settings lost when upgrading from version 5.6

After upgrading from version 5.6 to version 6 and all user settings (Connections etc) have been lost. Is it possible to recover them?

Revisado: sábado, 20 de agosto de 2022
4187472 - Sinonym Views Problem in Database Browser | Dependences

When selecting a table in Database Browser | Dependences and expanding UsedBy | Synonyms there is a difference in the outut between Toad For DB2...

Revisado: sábado, 20 de agosto de 2022
4154723 - Toad cannot access to sharepoint folders

Toad does not work with Sharepoint sites (When sharepoint folder is added to Windows Explorer favorites, within Toad you cannot access the content)

Revisado: sábado, 20 de agosto de 2022
4056899 - Toad for Db2 failure with generate DDL for table related CLOB UTF 8 Database with CODEUNIT32

The script generated by Toad for Db2 is wrong for table related CLOB UTF-8 Database with CODEUNIT32. For example   1.Create the table below...

Revisado: sábado, 20 de agosto de 2022
4135631 - Error: "1 The given key was not present in the dictionary"

During an explain plan session an error : "1 The given key was not present in the dictionary" is returned.

Revisado: sábado, 20 de agosto de 2022
4106252 - Error: 'Failed reading actions from C:\Program Files\Quest Software\Toad for DB2 zOS\Plugins\Core

When trying to install Toad For DB2 ZOS, the following error appears: Quest.Toad.Exceptions.BaseException Failed reading actions from C...

Revisado: sábado, 20 de agosto de 2022
4149103 - Export/import using ixf fails in dpf environment

Making a change on a table resulting in generating export/import commands is using ixf format for data. In DPF (database partitioning feature) IXF...

Revisado: sábado, 20 de agosto de 2022
Subir

Vida útil do produto

Novo

Nada no momento

Revisado

Nada no momento