DB2 Database Forum

Hi, I have a table where one of the columns is automatically generated as a substring of values of some other column. When i create a copy of that schema using sysproc.admin_copy_schema, the table goes in pending state, because the data in the table was inserted fully and the column was not automatically generated(i think this is the...

http://www.youtube.com/user/channeldb2 ....time to padlock my cube... ;-) -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

In the example that follows, I am receiving an incorrect result set in the View. I am looking to get the FULL result set from View_LY and Table_TY. Instead, this View is returning the Common (Equi) records and records on Table_TY only. Missing the records on View_LY only. Any known problems with FULL OUTER JOIN in DB2 or am I missing...

am unable to find out how to locate and update some of the configuration parameters for automated backup, ie, outside of the Control Center's Automation Maintenance Wizard. I am able to GET/UPDATE DB CFG for the parameters for automated backup, etc. That I understand. Where are the configuration parameters for options for the scheduling...

i'm relatively new to db2, and having a problem. running udb v8 in a windows platform trying to connect from a ibm vse box. after a clean compile and succesful package build i execute program bur566b which throws a sql error on the connect SQLCODE: -934 SQLSTATE: 58021. this seems to indicate a program...

Is there a way to select the text description of a set of fields in a table? I am looking for a result set like the following: fieldName | fieldDesc ------------------------------------------ RMCUST Customer Number RMADDR Customer Address RMMZIP Customer Zip

GM, I have couple of questions related to value compression feature in DB2 V8.2 Any method to get the list of tables enabled/not enabled for value compression in DB2 V8.2 ?. I think I can use db2look to generate the DDL but I would prefer to use any system catalog table if available. Any method to estimate the space savings in value...

Hi, I'm trying to use Microsoft Query to read data from DB2. However, I'm getting the following error message: SQL0206N "BLOB" is not valid in the context where it is used. SQLSTATE=42703. Do you know what this message mean? Thanks,

Hi All, Anyone has encountered problem with SQL that contains "parenthesis" () on AIX DB2 v8.2.3 e.g. select name, address from account where (flag = 0 and account_id = 1000) order by name SQL is in a java class and when the program executes to the SQL, it throws errors Failed in search:com.ibm.db2.jcc.b.SqlException: Invalid operation:...

Hi there, I need to extract huge amount of data from a DB2 dabase periodically. The extracted data needs to be exported to CSV format. I have thought of writing a Java piece of code to connect to DB2 using JDBC and then execute various queries. Is there any in-built functionality using which I can export the query resultset to CSV ? Thanks

I read that IBM DB2 Express-C database is FREE with no restrictions. What type of licensing policy does it have in case I want to bundle it with my .NET application (closed source)?

Hi! Is there any statement like INSERT IGNORE in MySQL in DB2 to ovewrite the existing record ? If yes can you please give a sample of this?

VAM SYSTEMS is a Business Consulting, IT Technology Solutions and Services company with operations in UAE, Qatar, USA, Singapore and India. VAM SYSTEMS are currently looking for J2EE Professionals for our Bahrain operations with the following skill set and terms and conditions: Skills: Strong development experience in J2EE with...

Hello, I'm not familar with DB2 under AS400. I want to read, which tables are in a database and which columns are in a selected table. Under DB2 for LUW I use the views SYSIBM.TABLES and SYSIBM.COLUMNS. Are these elements the same under DB2 for AS400? Thanks for help Best Regards

Hello, A DB2 v. 8 DMS tablespace ran full. Subsequently, almost all data in the tablespace has been deleted, but "LIST TABLESPACES SHOW DETAIL" keeps stating that the tablespace has 0 free pages. I've tried running a REORG on all remaining tables; that didn't help. Trying to create a table in the tablespace yields: bash-3.00$ db2 "create...

Which of the following occurs if an application ends abnormally during an active unit of work? a. The unit of work is committed. b. The unit of work is rolled back c. The unit of work remains active d. The unit of work moves to a pending state

Hi, I need to write a storred procedure(language sql) for multi row insert. How should I write the IN parameters in SP(when the input parameters are arrays)? How can I pass arrays(each representing columns) from my java code to this SP? Could anyone please give a sample code... Thanks in Advance, Praveen

Dear All, I have a database whose backup size (without compression) is 756Mb. The i emptied all data from the tables and took the backup which is again 756Mb. Can anyone guide me why this happen and how to correct it to bring database size to a reasonable size? Regard SaadAli

Hai, i would like to use dynamic sql for update records in the DB@ db. Means, the value to be updated will be send as concatenated string. Then based on the concatnation value i need to retrieve the records into cursor..then update the set.. how can i do that.. say for example, i would like to update the salary for all the employees in...

DB2 Viper 2 compatibility features http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707rielau/ It is very interesting and must be usefull. I want to know the plan when Viper 2 will be available.

Attempted to download the paper "Testing SOA applications with IBM Rational quality management solutions" Filled out the form (First and Last, Email), and was taken to the page for the download. However, the following message was where the link was supposed to be :-) Missing required fields. Business Contact Information: Company

Hello, Thankyou for helping me. Here we have two quires on same table , but FROM classs differs. But both quiries uses the same INDEX.I have provided the index details below.Is there any chances to improve performance. Please help me. Thank you. STATEMENET :1 ---------------------------

Does anyone else support SAP running onto of DB2 in an unix environment? The consultants we have in here are insisting on creating a different DB2INST owner/userid for each environment and server. They say....."In all the installations they have worked on, this is the way it has been done: different user ids for different...

I'm attempting to connect to a DB2 database using DBD::DB2 running on a Linux device. I'm getting the following error: ** connect: Unable to get database handle: DBI connect('p88flaq','ip88flaq',...) failed: SQL1042C An unexpected system error occurred. SQLSTATE=58004 at /usr/lib/perl5/site_perl/5.8.5/Oasis2/DBConn.pm line 2155 I've...

Hi, I am using db2 9 CLP. When the output of the select command is more than a page the messages scrolls out of the page. Is it possible to pause the messages so that they can be viewed one page at a time, ( just like 'set pause on' in Oracle sql prompt). I am unable to find any command options that correspons to this setting. Thanks....