Immigration Financial Information Bangladesh Gateway General World Cup Entertainment Programing University and College Scholarship Job Interview Health Job

Wednesday, June 2, 2010

VECTOR- EDPRC problem

Problem:
When edprc was running , it didn't complete accurately as Transaction Log was full.

Solution:
1.First of all clear Transaction Log with the following command:
dump trunc veclive with truncate_only

2.Change the batch to be run with the following command:
Show scpUpd BAT E

3.Insert into SESSION_CUR Table the value for edprc.
insert into SESSION_CUR value (7)

4. delete from SESSION_DLY

5.Then run edprc

No comments :

Post a Comment