Solved

Can't Delete AS400 LIB Because of File/Member Error

Posted on 2010-08-21
1
835 Views
Last Modified: 2013-12-06
I am trying to do a data refresh. I have removed all the locks on the LIB I need to delete.

I have issued the following command to delete the LIB:  DLTLIB TESTDTA

It started running for about 25mins. Then it just gave the error message below.

Can someone please help me get past this error? I assume I need to enter some command for that table. I'm not an AS400 expert so I will need some guidance.

Thanks!
8-21-2010-8-26-32-AM.jpg
0
Comment
Question by:matrix0511
1 Comment
 
LVL 13

Accepted Solution

by:
_b_h earned 500 total points
ID: 33491902

Get a list of what's left in the library:
WRKOBJ OBJ(TESTDTA/*ALL)

Look in your job log to see why the file cannot be deleted:
DSPJOBLOG
Press F10 to see lower level messages, and page up to see more details.

Use Display Database Relations (DSPDBR) command to see if there are logical files (logical views) over the physical file (table):
DSPDBR TESTDTA/F470371
This will list logical files that may need to be deleted.

Post back!
Barry
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As the title indicates, I have done this before. It chills me everytime I update the OS on my phone, (http://www.experts-exchange.com/articles/18084/Upgrading-to-Android-5-0-Lollipop.html) because one time I did this and I essentially had a bricked …
In a recent article here at Experts Exchange (http://www.experts-exchange.com/articles/18880/PaperPort-14-in-Windows-10-A-First-Look.html), I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now