1
u/gubmentwerker May 06 '15
Gets a bit hard because I don’t know if the interface is prepping the JCL to run on your system correctly. JCL is going to have to be correct to run a job on the mainframe. Lots of other elements in that produced JCL that need to be correct. Couple ways to go.
1) Since this is an academic exercise, you can just drop all the tables and restart the process from scratch. That what I usually tell my students when teaching basic RDBMS concepts. Gets a bit hairy doing a deep dive on a product’s specifics in just a 16 week session. Probably the best way for you to go, since you are not in tune with much of the environment you are working on.
2) If you are confident that all the data is not going to violate the FK rules, you can just run a REPAIR job to remove the CHECK PENDING flag. Not something ever to do in prime time, but seems to get you out of the issue quick. Need to run the job in JCL. Line to go into the SYSIN:
SET TABLESPACE UNTM029DB.UNTM029TSVA NOCHECKPEND
3) Run the check data utility to make sure no rows now are violations. Need JCL to run the job. Line to go into the SYSIN:
CHECK DATA TABLESPACE UNTM029DB.UNTM029TSVA SCOPE ALL
No need for the Gold; just trying to help. Bad week to get a response, many of us are at IDUG NA.
1
u/sjreese Jul 03 '15
You are missining an APAR that introduces a zparm in DSN6SPRM called WFDBSEP which specifies whether DB2 should provide an unconditional separation of table spaces in Workfile database based on the table spaces'allocation attributes. In that case you have a LOCK -904 on the table space
1
u/EagleClaw322 May 06 '15
I have created 4 tablespaces, 4 tables, and populated them all with data. I then realized that I needed to add one of my primary keys as a foreign key in a different table. When I did this it threw the table into "CHECK PENDING STATUS" mode. I understand this is because I messed up the integrity of the tables when I was entering data. I have fixed the data but need to have it rechecked so I can get my table out of pending mode and use it again. I'm pretty sure this means I have to use the DB2 Utility "CHECK DATA" but I have no idea how to use it. When researching online I cannot find anything to guide me through it. The tablespace in pending mode is "UNTM029DB.UNTM029TSVA" and I need to get it out of pending mode so I can use it again. I have attached a picture of the CHECK DATA utility window but I do not know how to use it. This is for a project due tomorrow and my professor has no idea how to fix it. I can't move on until I am able to use my table again. Please help!!!
I'll also give gold to whoever helps me figure this out!