Search found 9 matches
- Thu Jun 17, 2010 12:16 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Check pending status in DB2
- Replies: 2
- Views: 6630
Check pending status in DB2
Hi, we are running some DB2 load utilty job to empty the DB2 (multiple) tables by loading with a dummy file.we are giving in the control card as follows ===> LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE creator.tablename1 NOCOPYPEND LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE creator.tablen...
- Mon Mar 15, 2010 2:57 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Code level mismatch
- Replies: 2
- Views: 5028
Code level mismatch
Hi, My DB2 system running on V9 compatibility mode, which is upgraded recenly . We are running a job, for which I am getting following error. IDBDB2CA- SSID XXXX ERROR, CODE LEVEL MISMATCH I suspected as my plan is running in older version, so i tried to bind the plan, but its also faling with an er...
- Fri Aug 21, 2009 10:19 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: -802 error for count(*) query for a DB2 table
- Replies: 4
- Views: 7284
- Thu Aug 20, 2009 4:21 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: -802 error for count(*) query for a DB2 table
- Replies: 4
- Views: 7284
-802 error for count(*) query for a DB2 table
Hi, I am trying to query a big table which contains huge data,I just tried to check the no of records of table, i have run the query for COUNT(*) in QMF, But i am not getting the result , i am getting an error -802 ,saying commit frequency must be greater than zero. Is there any way of getting the c...
- Wed Aug 12, 2009 12:55 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: recreation of a db2 index
- Replies: 3
- Views: 6104
- Tue Aug 11, 2009 3:38 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: recreation of a db2 index
- Replies: 3
- Views: 6104
recreation of a db2 index
Hi, I have to alter an index by adding two columns into it. My table contains data and according to the requiremnet the data must be preserved. So i am dropping the index and creating the index with two new columns. Is that enough?But do i need to do anything with data???? Please suggest me. Thanks ...
- Wed Apr 22, 2009 5:48 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Difference between Bind and Rebind
- Replies: 2
- Views: 8010
Difference between Bind and Rebind
Hi All, Can anyone tell me what is bind and rebind in DB2 ?As someone told me Bind has to done from the beginning so as to generate a new timestamp and it generally done when there is any changes made in cobol program. but when rebind has to done?can anyone tell me the scenario when we have to go fo...
- Thu Apr 09, 2009 4:05 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: resource unavailable..table is not accessible
- Replies: 4
- Views: 8522
resource unavailable..table is not accessible
Hi All. I have executed a select qury on the table,its giving -904 error, showing the resource unavailable. the resource its saying the related tablespace partion datasetname.now i checked for the datset on 3.4 on ispf its not available.I checked for the related tablespace and database and associate...
- Thu Apr 02, 2009 3:34 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: db2 catalog table for plan
- Replies: 2
- Views: 4415
db2 catalog table for plan
Hi, Can anyone tell me what is the db2 catalog table which contains the plan informations along with the table names?