SAR file -- can this be imported and edited?

[Raj]

Please bear with me if this is not a very intelligent question!!

I have few SAR files that stores some StoredProcedures. I am supposed
to use the "PUT ROUTINE" command to execute them in my DB2 UDB 8
Database.
But when I do this I get the following message.

LINE MESSAGES FOR P4014038.bnd
-------------------------------------------------------------------
SQL0061W The binder is in progress.
560 SQL0204N "DB2ADMIN.XYZ" is an undefined name.
SQLSTATE=42704
I found out that the SAR file by default uses DB2ADMIN as the schema,
while for some reason I had got rid of that in my DB.
I believe that is the reason why it says "DB2ADMIN.XYZ is an undefined
name."

Now the question is, Can I edit these SAR files and change the schema
names?

Can I import them to an application, change the settings and create the
SAR files again?

Thanks in advance for your time!

[Serge Rielau]

Raj wrote:

Please bear with me if this is not a very intelligent question!!

I have few SAR files that stores some StoredProcedures. I am supposed
to use the "PUT ROUTINE" command to execute them in my DB2 UDB 8
Database.
But when I do this I get the following message.

LINE MESSAGES FOR P4014038.bnd
-------------------------------------------------------------------
SQL0061W The binder is in progress.
560 SQL0204N "DB2ADMIN.XYZ" is an undefined name.
SQLSTATE=42704
I found out that the SAR file by default uses DB2ADMIN as the schema,
while for some reason I had got rid of that in my DB.
I believe that is the reason why it says "DB2ADMIN.XYZ is an undefined
name."

Now the question is, Can I edit these SAR files and change the schema
names?

Can I import them to an application, change the settings and create the
SAR files again?

Thanks in advance for your time!

Us eteh PUT_ROUTINE procedure. Note "special register flag"
http://publib.boulder.ibm.com/infoce...70%75%74%22%20

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Raj]

Thanks.

But when I tried that I got the following message.

Command:
put routine from xyz.sar OWNER Administrator USE REGISTERS

Error Message:
"SQL0443N Routine "SYSFUN.PUT_ROUTINE_SAR" (specific name "PUT_SAR")
has
returned an error SQLSTATE with diagnostic text "-20135, 55046, 1".
SQLSTATE=38000"

When I looked up sqlcode: -20135 and sqlstate: 55046 it says

1. The operating system of the target environment is not the same as
the operating system on which the SQL archive was created.
2. The database type and level of the target environment is not the
same as the database type and level on which the SQL archive was
created.
1) I am not sure which one has caused the problem. Is there anyway to
narrow down to the exact problem?
2) Is there any other way to manually run those procedures? reading the
SPs in the SAR file and manually running against the DB

Thanks!

[Serge Rielau]

Raj wrote:

Thanks.

But when I tried that I got the following message.

Command:
put routine from xyz.sar OWNER Administrator USE REGISTERS

Error Message:
"SQL0443N Routine "SYSFUN.PUT_ROUTINE_SAR" (specific name "PUT_SAR")
has
returned an error SQLSTATE with diagnostic text "-20135, 55046, 1".
SQLSTATE=38000"

When I looked up sqlcode: -20135 and sqlstate: 55046 it says

1. The operating system of the target environment is not the same as
the operating system on which the SQL archive was created.
2. The database type and level of the target environment is not the
same as the database type and level on which the SQL archive was
created.
1) I am not sure which one has caused the problem. Is there anyway to
narrow down to the exact problem?
2) Is there any other way to manually run those procedures? reading the
SPs in the SAR file and manually running against the DB

Thanks!

Which fixpack level are you on both systems and what are the systems?
GET and PUT ROUTIEN are meant to deploy from a development machine to a
production machine without a C-Compiler.
In DB2 V8.2 the only remaining reason to use GET and PUT is obfuscation
of the text.
Does anyting speak against just getting the text from SYSCAT.ROUTINES.TEXT ?

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab