DB2 for Linux, UNIX, and Windows | Forum profile

I fixed the nmake problem but I still get the following message: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20204N The user defined function or procedure "U000591.TWO_RESULT_SETS" was unable to map to a single Java method. LINE NUMBER=10. SQLSTATE=46008

So situation is following: I want to connect to *DB2*(on *AIX*) on the remote computer. As it is known the server is runed and the port is opened (I test port), but I cant connect to them by client app, there are some connection errors, than I check an existance of db2 command on server, but it dose not work, following error was occured: SQL10007N Message "-1390" could not be retrieved. Reason code: "3" The matter is, that...

At the DB2 ExpressC download page for Windows x64, this is the second download file: DB2 9.7 Add-Ins for Microsoft Visual Studio db2exc_vsai_970_WIN_x86.zip (29 M)

Hi I am running a DB2 v9.7 Enterprise edition database on Windows 2003 server Our application heavily uses DB2 SQL PL Stored Procedures for all processing. The following is a strage behaviour happening on the DB We execute a stored procedure which processes almost 3 million records (expected to complete in 10 mins) Sometimes , in our test env. when it runs for more than 15 mins , we cancel the execution by pressing Control+C DB2 does the...

What query did you run?

1) Yes 2) Yes (Thanks for formating my query)

Heres the code that im calling that causes the error ArrayList vendors = new ArrayList(); ArrayList problems = new ArrayList(); DataTable tbl = DbProviderFactories.GetFactoryClasses(); foreach (DataRow row in tbl.Rows) { string providerClass = (string)row[2]; try { DbProviderFactories.GetFactory(providerClass); // will throw exception if not configured properly vendors.Add(CreateProvider((string)row[0], row[1] as string, providerClass)); }...

1) Is there a way to determine whether the current user is considered to have the SYSADM privilege? Yes, as William mentioned you can use the SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID table function 2) As part of (1), is there a way to determine the list of users/groups who have the SYSADM privilege? The SYSADM group is controlled by the sysadm_group dbm cfg parameter, members of this group are considered SYSADM. 3) The documentation reports...

You may not have created an instance as part of the install or as a post installation step. To confirm, run <db2 install path>/instance/db2ilist That will let you know if you created one or not. If not, you will need to create one with <db2 install path>/instance/db2icrt. Check the install docs for more information on this step. Hope it helps! Pete

未命名.JPG (47.7 KB)