Search results for query: *

Thank you, Dave! PARALLEL was an excellent suggestion!! Regards, Nancy

After running an index analysis it was suggesting to add a fifth column into an existing four-column index. The base table has over 500 million rows so I'm hesitated to drop the old index then create the new index. Is there an efficient way to alter the existing index to include the fifth...

Mufasa was right. If you need to do more in this stored procedure plus returning a result set, you need to use a REF CURSOR. Just be sure the REF CURSOR is in IN OUT mode and it must be the very last parameter. Regards, Nancy

DB2 Tech Support kindly pointed me to this link: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp ?topic=/com.ibm.db2.udb.apdv.java.doc/doc/t0010264.htm Which basically said starting from DB2 V9, one no longer has the option to create a 32bit instance on a 64bit operating system...

We have a 32bit application which requires 32bit JDK. The default instance created by db2icrt is 64bit on 64bit AIX. What is the hidden parameter to create a 32bit client instance in this case? Thanks in advance! Regards, Nancy

No, I finally had to resolve to making duplicated copies of import data files into Oracle specific directory and placed them together with batch command and SQL*Loader control files. Regards, Nancy

How did the third party software connect to the database: ODBC, OLE, JDBC, XML or their own wired in protocol? If you think they are using ODBC, you can turn on ODBC trace on the bad and on the good machine then compare the connection string of the two. Regards, Nancy (Never trust anything that...

I posted it here because after more testing, we found INSERT/SELECT type of SQL queries went through the connections fine after the lost SQL Server came back up again. But all the stored procedure calls were "put on hold" as if the connections were hanged. This is definitely something that...

Hi! My application retries the last SQL query when a conncetion went down then came backup again. This worked well with standalone SQL Server 2000. But in a SQL Sever 2000 clustering, if one of the nodes went out then came back up again, the dead connection attribute SQL_ATTR_CONNECTION_DEAD was...

Hi! My application retries the last SQL query when a conncetion went down then came backup again. This worked well with standalone SQL Server 2000. But in a SQL Sever 2000 clustering, if one of the nodes went out then came back up again, the dead connection attribute SQL_ATTR_CONNECTION_DEAD...

Hi! We have a new Windows Server 2003 on Intel Itanium. All the existing 32bit compiled for 64bit ODBC applications failed at connect. I have been trying to use Microsoft ODBC Test Unicode tool to test and received the same Driver Manager not been able to find the DSN or load the driver...

Oh! Yah! I can pass the file name with the environment variable when calling sqlldr! [2thumbsup] Thank you very much for this reminder, Dan! Regards, Nancy

Not sure if I understand it correctly: Did you mean something like : 1) placing the control file and data file in the same %GOLDPATH% directory 2) in the script/batch file, first cd to %GOLDPATH%, then invoke sqlldr from there? That was my last alternative. I was hoping to keep Oracle specific...

Hi! I will like to replace the hardcoded data file path by an environment variable in my SQL*Loader control file, something like: LOAD DATA INFILE "%GOLDPATH%\GoldData.txt" or LOAD DATA INFILE %GOLDPATH%"\GoldData.txt" or LOAD DATA INFILE %GOLDPATH%\GoldData.txt But I got the same...

DB2 has development client and admin client. Please make sure you have download the correct patch for the existing client. It sounded like you got the patch for a different client product. Regards, Nancy

We ran ours as fenced process too. We changed the Java UDF into C++ external function and everything is fine now. CPU usage is back to normal and we gained 2 times better performance under normal load and 6 times better performance under heavy multithreaded load tests. This is not...

Thank you very much, Dagon! Regards, Nancy

Dagon, I totally agreed with you. Now, is there a way to do select and base on the select result to invoke a DB2 SQL script from command line? Any scripting language such as REXX or DOS command that will allow such a thing? What I want to achieve is this: -- pseude code... DB2 CONNECT TO $mydb...

Hi! With Oracle, I can use @mysql.sql to invoke another sql script from current sql script. How do I do that on DB2? Thanks in advance! Regards, Nancy

Hi! I have several string functions written in JAVA to do substring and indexing which is not available in DB2 SQL. Now when I monitor the DB2 Server CPU usage, I noticed db2fmp(java) is taking up more than 60% of CPU on a 4-CPU AIX server. The DB2 Server is using JDK 1.3.1. Questions: 1)...