Solved

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

Posted on 2010-08-21
1
825 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

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 …
Windows 10 is here and for most admins this means frustration and challenges getting that first working Windows 10 image. As in my previous sysprep articles, I've put together a simple help guide to get you through this process. The aim is to achiev…
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

705 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

11 Experts available now in Live!

Get 1:1 Help Now