Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / May 2005

Tip: Looking for answers? Try searching our database.

SAR file -- can this be imported and edited?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Raj - 30 May 2005 23:35 GMT
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 - 31 May 2005 03:01 GMT
> Please bear with me if this is not a very intelligent question!!
>
[quoted text clipped - 21 lines]
>
> Thanks in advance for your time!

Us eteh PUT_ROUTINE procedure. Note "special register flag"
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin
/r0004230.htm?resultof=%22%50%55%54%22%20%22%70%75%74%22%20


Cheers
Serge
Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Raj - 31 May 2005 17:06 GMT
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 - 31 May 2005 18:29 GMT
> Thanks.
>
[quoted text clipped - 23 lines]
>
> 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
Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.