I am running a DB2 load utiliy (DSNUPROC), since the utility is holding exclusive lock on the table all the online screens which is accessing the table are abending.(Resource is Not availabe, SQL code -904).
Is there any way to avoid this exclusive lock. I want my online screens to access the DB2 table when the Utility is running. Is there any way to do this.....
Will unload utility also put exclusive lock on the table?