Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Load error on missing resource that I can't identify

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Sat Aug 04, 2012 2:38 am    Post subject: DB2 Load error on missing resource that I can't identify
Reply with quote

I am getting this message:

DSNUGBAC - RESOURCE UNAVAILABLE

REASON 00C9008A
TYPE 00000240
NAME TAPIVP03

TAPIVP03 is defined as:

VALIDPROC TAPIVP03

in the table definition.

Where would it exist?
Back to top
View user's profile Send private message

don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Sat Aug 04, 2012 3:26 am    Post subject:
Reply with quote

I have never used one, or even seen one in the wild, but a VALIDPROC is a program. I suggest you ask your DBA where the TAPIVP03 load module lives.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Sat Aug 04, 2012 11:07 am    Post subject:
Reply with quote

Is your tablespace in RW ?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Aug 04, 2012 12:00 pm    Post subject:
Reply with quote

Coding Rules for Validation Procedures can be found here.

you will notice that this is a db2 vsn7 reference.

if you are working in an environment with WLM, who knows where the stuff is.

since these libraries are not 'accessable' to programmers,
follow Don's advise and talk to your DBA.

This has nothing to do with the Table Status.
If the Table Status was RW
(or anything else that would preclude access of the table)
the processing would not have made it to the invocation of the VALIDPROC,
as VALIDPROC's are exit routines to executing SQL.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Sat Aug 04, 2012 12:04 pm    Post subject:
Reply with quote

Thanks Dick for correcting my understanding

Apologies to all
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Sun Aug 05, 2012 1:35 am    Post subject: Reply to: DB2 Load error on missing resource that I can't id
Reply with quote

Thanks guys. Let me ask if I could live without this module by dropping and recreating the table? My problem is I am trying to recreate a database to use for testing on another machine. The table definitions and unloads are all I have.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Aug 05, 2012 2:16 am    Post subject:
Reply with quote

DSNUGBAC should have been accompanied with DSNT500I. Said that, I'll vote in for dropping and recreating the tables.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sun Aug 05, 2012 2:38 am    Post subject:
Reply with quote

DSNUGBAC is the module reporting the error - so, I imagine that it is there.

HLASM TAPIVP03 is a validation procedure that enabled
the business to implement ?
that went beyond the capabilities of Triggers and Restrictions.
most often EDITPROCs/VALIDPROCs are written,
because the implementation of business rules in the application code are
beyond the capabilities of application programmers - or it is just too hard
e.g. many many modules doing INSERTs/UPDATEs
and like triggers EDITPROCs/VALIDPROCs are invoked based on the action of the SQL on the table.

triggers are bypassed during loads. don't know about E/V-procs.

If the results of your testing on the other machine
are supposed to duplicate that of your existing machine,
you may not achieve your goal.

you can always find the HLASM source, port it to the new machine,
and create the VALIDPROC there,
but then you would have to drop/create/load your table.

sounds as if you are at the mercy of a very poor analysis and implementation plan.
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Mon Aug 06, 2012 8:57 pm    Post subject: Reply to: DB2 Load error on missing resource that I can't id
Reply with quote

I blame marketing for trying to rush something through, but that's another story. I was able to contact the person responsible for the original database and he told me TAPIVP03 was used to link to a statistics package and I didn't need it any more. So, thank you gentlemen and on to the next exciting "discovery".
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Aug 07, 2012 1:32 pm    Post subject:
Reply with quote

Thanks for the feedback. However, what is the next step you take to get out of this mess?
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Tue Aug 07, 2012 9:36 pm    Post subject: Reply to: DB2 Load error on missing resource that I can't id
Reply with quote

I dropped and redefined the tablespace and table without the VALIDPROC TAPIVP03 clause in the create table step.

Before doing this, I had to end the outstanding Load utility (it was still hanging from the error that started this problem).

-TERM UTIL(TEMP)
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Aug 07, 2012 10:28 pm    Post subject:
Reply with quote

welcome to the world of dba ojl (on-the-job-self-learning)
you have done well, good performance and
thx for continually getting back to us. learned a lot.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Aug 07, 2012 11:19 pm    Post subject:
Reply with quote

Yes, Thanks for the feedback, this helps. icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts How to find a CICS resource used in C... Arunkumar Chandrasekaran CICS 8 Thu Sep 29, 2016 1:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us