brainchime.com Latest Questions

Admin
Asked: 2024-10-05T18:42:14+05:30 In:

How to find which libraries were created by me on IBM i?

Hi, I have been asked to delete my unused libraries on an IBM i machine as an IBM i box cleanup drive and I don’t know the names of them that I created since they are huge in number and mainly were made by several processes or for several tests in the last 1 year.

Is there any way to find those libraries that are owned by me on the IBM i machine, so that then i delete the unused ones from the whole list of libraries on the IBM i?

as400

Related Questions

Leave an answer

Leave an answer

Browse
Browse

Choose from here the video type.

Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs".

1 Answer

  1. Admin
    This answer was edited.

    You can find the libraries created by you on the IBM i system by following these steps:

    • Run the DSPOBJD command to list out all libraries for all users on the IBM i machine and create an outfile in the qtemp library. 
      dspobjd obj(*allusr) objtype(*lib) output(*outfile)
outfile(qtemp/libsfile)
    • Now, you can query on the out file libsname created in the qtemp library and select the libraries for the specified user profile. 
      select odobnm from qtemp.libsfile where odcrtu = 'USERPRF'