Hi! I AM TRYING TO CREATE THE TABLES BUT I COULD NOT BECAUSE ITS GIVING ME SQLCODE = -666 ERROR,SAYING THAT A UTILITY IS IN PROGRESS.CAN ANY ONE HELP IN SOLVING THIS ERROR AND WHY DOES THIS ERROR HAPPEN
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Hello vimal nambiar and welcome to the forums,
Please note there is no attachment in either of your last posts. Also, please note that file attachments and screen captures should not be posted. File attachments cause problems because many forum members are not permitted to download attachments from the internet.
Screen captures are much better done using copy/paste and the "Code" tag at the top of the Reply panel.
You get the -666 error because some utility has not successfully ended. Have you talked with your dba(s)? They will be abe to determine what is needed to fix this.
From the post I guess Already an utility is running aganist the table you are trying to load . The case may be like you tried to load the table and the load job failed and you didn't terminate the utility that was running aganist your table . First you have to check and terminate the utility
If you have a third party tool like PLA on the command processer if you give
DU(utility name) displays the utitity running aganist a region and command
TU(utility name) will terminate the utility you like