Re: QBDSRV job locking files / libraries

[Pete Helgren <Pete@xxxxxxxxxx>]

Have you considered just ending the job?  Since these appear to be the 
only files in use by this recovery job I can't see a big downside.

Pete


Kirk Yates wrote:
> Job QDBSRV01 is running and has the following files / libraries
> locked:
>
>                              Work with Job Locks
>                                                             System:   SLCI5 
> Job:   QDBSRV01       User:   QSYS           Number:   729462               
>                                                                             
> Job status:   ACTIVE                                                        
>                                                                             
> Type options, press Enter.                                                  
>   5=Work with job member locks   8=Work with object locks                   
>                                                                             
>                              Object                      Member  ASP        
> Opt  Object      Library     Type       Lock     Status  Locks   Device     
>      APP002PF    PASTEMP     *FILE-PHY  *EXCL     HELD    NO                
>      APP002PF    PASWORK     *FILE-PHY  *EXCL     HELD    NO                
>      APP003PF    PASTEMP     *FILE-PHY  *EXCL     HELD    NO                
>      APP003PF    PASWORK     *FILE-PHY  *EXCL     HELD    NO                
>      PASTEMP     QSYS        *LIB       *SHRUPD   HELD                      
>                                         *SHRUPD   HELD                      
>      PASWORK     QSYS        *LIB       *SHRUPD   HELD                      
>                                         *SHRUPD   HELD                      
>      QADBERAP    QRECOVERY   *FILE-PHY  *SHRRD    HELD    YES               
>                                                                        More.
>
> Libraries PASTEMP and PASWORK are work libraries and I would like to
> delete them.  Files APP002PF and APP003PF were originally copied from
> another library.  Looking at these files in the original library, they
> each have 3 members, with 0 records in each member.
>
> The job that has the locks on the files and libraries seems to have
> been running since our last IPL (09/14/08, 19:36:47).
>
> This is a V5R4 system, TL08057 is the latest ptf package installed.
>
> Any ideas how to get this job to release the file / library locks?
> I've been looking at various PTFs related to QBDSRV jobs and we have
> all of them I've seen installed.
>
> My next thought is to take the system down to a restricted state, and
> then try to delete the libraries but that seems a little extreme and
> has to be done after normal work hours.
>
> Thanks for your help.
>