DZIOVRLY (OGL Compiler) through a DB2 stored procedure

Balaji Krishnamurthy · New User Joined: 26 Feb 2008 Posts: 20 Location: chennai

Anyone tried executing DZIOVRLY (OGL Compiler) through a DB2 stored procedure?

Srihari Gonugunta · Posted: Wed Apr 09, 2008 11:47 am

Seems to be strange requirement. Can you please elaborate your requirement.

Balaji Krishnamurthy · New User Joined: 26 Feb 2008 Posts: 20 Location: chennai

I have found the solution.. But i would like to share my knowledge about this. DZIOVRLY is a utility in IBM mainframes which compiles an Overlay Generation Language (OGL). I need to call this utility inside a DB2 stored procedure and this stored procedure is executed through a trigger. I was facing some issues in executing the utility which was resolved finally. I woud like to tell the resolution, but if you are not clear about whatever i had explained till now, then that would be much more confusing

CICS Guy · Posted: Sat Apr 12, 2008 4:00 am

Like Dick would say,
Welcome to the forums,
and thanks for the additional information......

Balaji Krishnamurthy · New User Joined: 26 Feb 2008 Posts: 20 Location: chennai

Now i am running up into a new issue in executing DZIOVRLY through a triggered Stored Procedure. Can anyone help me out in resolving this? I will specify the issue once i get a valid reply to this post.

dick scherrer · Posted: Thu Apr 17, 2008 4:32 am

Hello,

Balaji Krishnamurthy · New User Joined: 26 Feb 2008 Posts: 20 Location: chennai

Hi dick,

thanks for your suggestions. I feel this forum is of great use to me.

Let me tell the first issue i faced which is resolved now.

DZIOVRLY utility needs a SYSPRINT and SYSIN file for it. SYSIN file contains the OGL to be compiled and SYSPRINT will show the compilation errors. Since, the utility is called inside a triggered DB2 stored procedure, we were dynamically allocating these files. But, the utility thowed an error. Finally we sorted out that when the trigger is invoked, a job runs in the DB2 sub-system (which is obvious) and a SYSPRINT and SYSIN is allocated by DB2 system for this job. We de-allocated these files and allocated our files before calling the utility and the utility passed without any errors.

Now, the issue is, we are trying to re-allocate the files (previously allocated by DB2 system and de-allocated by us) in order to have things back in place. We do no have the authority to allocate a files with the DB2 system HLQ (SYSxxxxx). Issue with SYSPRINT file is fixed. The DB2 system will automatically allocated another temporary file whenever needed. But, SYSIN file issue is pending. Need some help on this.

Balaji Krishnamurthy · New User Joined: 26 Feb 2008 Posts: 20 Location: chennai

i use a trigger initiated DB2 stored procedure, which calls 5 sub-programs. One of the program requires a user defined SYSIN file. The DB2 system in-turn creates a SYSIN file for its job in the address space. Now, i have to dynamically allocated my files to SYSIN before calling this particular sub-program.

Once i de-allocate the DB2 allocated SYSIN files, they are lost and i am not able to re-allocate them after executing this sub-porogram. i am trying out some way to allocate my files to SYSIN without de-allocating the DB2 allocated files.