DBT4000-4999

DBT Message ID Message Explanation User Response

DBT4000N

No value was specified for the option named option-name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

You must specify a value for the named option.

For an explanation of the syntax of the db2fedgentf command, use the following command: "db2fedgentf -h".

Call the db2fedgentf command again, specifying a value for the named option.

DBT4001N

Neither "-create" nor "-drop" was specified. It is mandatory to specify one of these options.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

You must specify exactly one of the "-create" or "-drop" options with the db2fedgentf command.

For an explanation of the syntax of the db2fedgentf command, use the following command: "db2fedgentf -h".

Call the db2fedgentf command again, specifying either "-create" or "-drop".

DBT4002N

An invalid option was specified: option-name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

The given option is not a valid option for the db2fedgentf command.

For an explanation of the syntax of the db2fedgentf command, use the following command: "db2fedgentf -h".

Call the db2fedgentf command again, specifying valid options.

DBT4003N

One of the following required options was missing: "-db", "-u", or "-p".

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

When you call the db2fedgentf command, you must specify a database name, a user name, and a password.

For an explanation of the syntax of the db2fedgentf command, use the following command: "db2fedgentf -h".

Call the db2fedgentf command again, specifying a database, a user name, and a password.

DBT4004N

One of the following required options was missing: "-stpn" or "-c".

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

When you call the db2fedgentf command to create a new table function for a given federated stored procedure, you must specify both of the following:

  • The name of the federated stored procedure using the "-stpn" option
  • The column name and type pairs of the signature of the federated stored procedure

For an explanation of the syntax of the db2fedgentf command, use the following command: "db2fedgentf -h".

Call the db2fedgentf command again, specifying the federated stored procedure name and the column name and type pairs of the signature of the stored procedure.

DBT4005N

The string value for the "-c" option is not valid. db2fedgentf could not parse the column name and type pairs specified in that string. The string that was passed to the db2fedgentf call is: column-name-type-pairs-list.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

When you call the db2fedgentf command to create a new table function for a given federated stored procedure, you must specify the column name and type pairs of the signature of the federated stored procedure.

The format of that string should be:


"<name1> <type1>, <name2> <type2>, ..."

For example:


"PID CHAR(10), PRICE DOUBLE, QTY INT"
  1. Review the signature of the federated stored procedure for which you want to create the table function.
  2. Review the format of the string you want to pass to the "-c" option of the db2fedgentf command.
  3. Call the db2fedgentf command again, passing the column name and type pairs from the federated stored procedure signature in a string of valid format to the "-c" option.

DBT4006N

db2fedgentf could not convert the SQL data type of the column named column-name to a JAVA data type. The SQL data type of the column is: SQL-data-type.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

The db2fedgentdf utility creates JAVA table functions. To accomplish this, the utility performs the following tasks: creates a JAVA file that contains the source for the new table function; compiles that generated JAVA file; and registers the new table function.

Because db2fedgentdf creates JAVA table functions, db2fedgentf must convert the SQL data types of the stored procedure result set columns to JAVA data types. In this case, there is no JAVA data type to which the named column can be converted.

No table function was created.

Modify the federated stored procedure to change the SQL data type of then named column to one that can be converted to a JAVA data type.

DBT4008N

db2fedgentf could not find the federated stored procedure called stored-procedure-name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

The message was returned because db2fedgentf could not find an entry in the catalog for the federated stored procedure specified with the "-stpn" option on the command line.

No table function was created.

Call db2fedgentf again, specifying a federated stored procedure that can be found in the catalog.

DBT4011N

The db2fedgentf utility failed to create the JAVA source file for the table function. File name: File-name. Reason: reason-code. Error string: Error-string.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

The db2fedgentdf utility creates JAVA table functions. To accomplish this, the utility performs the following tasks: creates a JAVA file that contains the source for the new table function; compiles that generated JAVA file; and registers the new table function.

The reason this message was returned is indicated by the reason code:

1

db2fedgentf could not allocate a file handle for the JAVA source file.

2

db2fedgentf could not write the table function source to the JAVA source file.

3

db2fedgentf could not open a file handle for the JAVA source file. Refer to the error string for more information.

4

db2fedgentf could not write the table function source code to the JAVA source file. Refer to the error string for more information.

No table function was created.

Respond to this message according to the reason code:

1

Restart db2fedgentf.

2

If the maximum number of file handles has been allocated, close some of the open handles, and then restart db2fedgentf.

3 and 4

Respond according to the contents of the error string. For example, if db2fedgentf does not have the necessary file access permissions, work with your system administrator to grant db2fedgentf the required permission.

DBT4012N

The db2fedgentf utility failed to compile the JAVA source file for the table function. File name: File-name. Reason: reason-code.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

The db2fedgentdf utility creates JAVA table functions. To accomplish this, the utility performs the following tasks: creates a JAVA file that contains the source for the new table function; compiles that generated JAVA file; and registers the new table function.

The reason this message was returned is indicated by the reason code:

1

db2fedgentf could not determine the current path in which to create the JAVA source file.

2

db2fedgentf could not determine the database product install path.

3

db2fedgentf could not delete the existing version of the class file.

4

db2fedgentf could not copy the class file to the destination: <DB2-INSTALL-PATH>/function

No table function was created.

Respond to this message according to the reason code:

1

Verify that db2fedgentf has the necessary access authorization for the current directory.

2

Investigate whether there are any errors with the current installation of DB2 database.

3

Manually delete the existing version of the class file from: <DB2-INSTALL-PATH>/function

4

Verify that db2fedgentf has the required access authorization for the following directory: <DB2-INSTALL-PATH>/function. If necessary, work with your system administrator to grant db2fedgentf access to that directory.

DBT4014I

db2fedgentf successfully dropped the table function called table-function-name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

You do not need to respond to this message.

DBT4016N

db2fedgentf could not drop the table function called table-function-name because there are multiple table functions with the same name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

This message is returned when db2fedgentf cannot uniquely identify the table function to drop. This can happen when there are multiple table functions with the same name.

No table function was dropped.

Use -tfsn option with db2fedgentf instead of the -tfn option to drop the table function. The specific name of the table function is unique.

DBT4017N

The following error occurred while db2fedgentf was creating the table function. SQLSTATE: sqlstate; SQLCODE: sqlcode; message text: message-text.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

While creating a new table function, db2fedgentf encountered the given SQL error.

No table function was created.
  1. Refer to the details of the SQLCODE.
  2. Respond to the SQL error.
  3. Call db2fedgentf again.

DBT4018N

db2fedgentf encountered an internal error while creating the table function. The command that db2fedgentf was running is: command. The value that was returned from that command is: return-code. Diagnostic information is in the file called file-name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

To perform its tasks, the db2fedgentf utility executes multiple database commands and invokes the JAVA compiler 'javac' to compile the JAVA file for the table function. The db2fedgentf utility will get JDK path by reading DBM configuration parameter JDK_PATH. This message is returned when one of those tasks encountered an error.

No table function was dropped or created.
  1. Review the diagnostic information in the named file.
  2. Check DBM configuration parameter JDK_PATH and ensure it is set correctly.
  3. Respond to the errors in the diagnostic information.
  4. Rerun the db2fedgentf command.

DBT4022N

The table function to drop was not specified. Both of the following options were missing: "-tfn", and "-tfsn".

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

When you call the db2fedgentf command to drop a table function for a given federated stored procedure, you must identify the table function using one of the following options:

  • The table function name using the "-tfn" option
  • The table function specific name using "-tfsn" option

For an explanation of the syntax of the db2fedgentf command, use the following command: "db2fedgentf -h".

Call the db2fedgentf command again, specifying the table function using either the table function name or the table function specific name.

DBT4023N

db2fedgentf could not drop the table function with specific name specific-name because that table function was not created using db2fedgentf.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures. You can use the db2fedgentf utility to drop only those table functions that were created using the db2fedgentf utility.

This message was returned because the specified table function was not created using db2fedgentf.

No table function was dropped.

Use other methods, such as the DROP statement, to drop the table function.

DBT4024N

db2fedgentf could not create a table function for the specified procedure procedure-name because there are multiple procedures with the same name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

This message is returned when db2fedgentf cannot uniquely identify the procedure. This can happen when there are multiple procedures with the same name.

No table function was created.

Use both -stpn and -stpc to determine a unique procedure.

DBT4025N

db2fedgentf could not create a table function for the specified procedure, because a table function has already been created for that procedure. The specific name of the existing table function is: schema-name. specific-name

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

When using db2fedgentf, you can create only one table function for each federated stored procedure.

No table function was created.

Drop the existing table function for the specified procedure and run db2fedgentf again.

DBT4026I

The db2fedgentf utility successfully created the table function named table-function-name that you can use to access result sets that are returned from the federated stored procedure named federated-stored-procedure.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

This message is returned when the db2fedgentf utility successfully creates a table function.

Use the new table function to access result sets that are returned from the federated stored procedure.

DBT4027N

The db2fedgentf command failed because the utility encountered an error while allocating an environment handle.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

The db2fedgentdf utility creates Java table functions. To accomplish this, the utility must perform a variety of database tasks. This message is returned when the db2fedgentf utility encounters an internal DB2 database error while performing those tasks. Specifically, this message is returned when the db2fedgentf utility fails to allocate an environment handle.

Run the db2fedgentf utility again:

  1. Review available diagnostic information, such as the db2diag log, to determine why the db2fedgentf utility was unable to allocate an environment handle.
  2. Resolve the problem or problems that caused the failure. For example, if the root cause of the handle allocation error was insufficient system memory, reconfigure the system to make more memory available.
  3. Rerun the db2fedgentf command.

If the problem persists, perform the following steps:

  1. Collect the following diagnostic information:
    • db2diag logs
  2. Contact IBM support.

DBT4028N

The db2fedgentf command failed because the db2fedgentf utility could not determine the directory under which the Software Developer's Kit (SDK) for Java is installed from the database manager configuration parameter JDK_PATH.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

To perform its tasks, the db2fedgentf utility executes multiple database commands and invokes the Java compiler 'javac' to compile the Java file for the table function. The db2fedgentf utility determines where the Java SDK installed by reading the JDK_PATH configuration parameter.

This message is returned when the db2fedgentf utility cannot determine the location of the Java SDK from the JDK_PATH configuration parameter for some reason, such as because the configuration parameter is NULL.
  1. Set the JDK_PATH database manager configuration parameter to the directory under which the Java SDK is installed.
  2. Run db2fedgentf again.

DBT4029W

The db2fedgentf successfully created the table function, but failed to delete the Java source file: Java-source-file-name.

You can use the db2fedgentf utility to create or drop table functions that access result sets from federated stored procedures.

The db2fedgentdf utility creates Java table functions. To accomplish this, the utility performs the following tasks:

  • Creates a Java file that contains the source for the new table function
  • Compiles that generated Java file
  • Registers the new table function
  • Deletes the generated Java source file

This message is returned when the db2fedgentf utility was supposed to delete the generated Java source file, but the utility failed to delete the file.

Optional: You can delete the generated Java source file manually.

Because the db2fedgentf utility always generates Java source files with unique names, choosing not to delete the generated source file that the utility failed to delete will not cause problems with future db2fedgentf use. However, it is recommended that you review any available diagnostic information (such as the db2diag log files or operating system diagnostic files) to determine why the utility failed to delete the file. The root cause of this failure to delete the Java source file by the db2fedgentf utility might also cause problems with other activities.