Search found 9 matches

by srilata83
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...
by srilata83
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...
by srilata83
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

Hi,
My problem is solved now.
Actually the result of my query (i.e. No.of records in my table ) is out of range, it was crossing the limit ,so i was getting -802 error.
Now i modified the query as COUNT_BIG(*) and getting the actual result. :D

Thanks......
by srilata83
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...
by srilata83
Wed Aug 12, 2009 12:55 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: recreation of a db2 index
Replies: 3
Views: 6104

Thank you,Anand.But I heard like Its better to run RUNSTATs utility after altering the index.
by srilata83
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 ...
by srilata83
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...
by srilata83
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...
by srilata83
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?