RE: Funky problem with SQL ALIAS

[G Armour <garmour400m@xxxxxxxxx>]

Yes.  My mistake by not copy/pasting the whole enchilada.  FWIW, I
corrected it in my post below.

Still, any ideas?

TIA, GA

--- "John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx> wrote:
> > drop   alias smsfiles/su300acd
>   SU300ACD in SRTFILES type *FILE not found.
> 
> Shouldn't this be:
> > drop   alias srtfiles/su300acd
>   SU300ACD in SRTFILES type *FILE not found.
> ??
> John Brandt
> iStudio400.com
> 
> -----Original Message-----
> From: G Armour [mailto:garmour400m@xxxxxxxxx]
> Sent: Monday, December 08, 2003 4:36 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Funky problem with SQL ALIAS
> 
> 
> Funky problem with SQL ALIAS.  Have been creating and dropping an ALIAS
> without problems in a java application for awhile now.  All of a sudden,
> the alias can be neither created ("already exists") nor dropped ("not
> found").  I tried the following in interactive SQL:
> 
> > create alias srtfiles/su300acd for srtfiles/su300(su300)
>   SU300ACD in SRTFILES type *FILE already exists.
> > drop   alias srtfiles/su300acd
>   SU300ACD in SRTFILES type *FILE not found.
> 
> I also tried doing this with a different alias name (everything else the
> same) and had no problems.
> 
> This is V5R2, with TL03161 permanently applied.  PTF group SF99502 (the
> DB2 group) shows the level at 7.  PTF group SF99519 (the HIPER group) is
> at level 62.  These are the only two PTF groups installed.
> 
> I searched the APARs, and came up empty handed, I think.  The only one
> that remotely comes close is SE12060, which is closed.  No reference to
> a
> PTF, though.  Would the fixing PTF be referenced in the APAR if there
> was
> one?
> 
> Finally, in case anyone needs more details about the Java app, below my
> sig is the log that shows how the CREATE/DROP was working, then all of a
> sudden, not working.  What is not shown is that there is a process
> between
> the CREATE & DROP.  I do not know Java, and I am speculating at this
> point
> that this is not a Java problem but a DB2 problem.
> 
> TIA, GA
> 
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> DROP ALIAS SRTFILES.SU300ACS
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> DROP ALIAS SRTFILES.SU300ACS
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> DROP ALIAS SRTFILES.SU300ACS
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> DROP ALIAS SRTFILES.SU300ACS
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> MiscProc: CreateAlias - java.sql.SQLException: [SQL0601] SU300ACD in
> SRTFILES type *FILE already exists.
> CimsAgent: AddChngDltMonitoring - returned an error of
> java.sql.SQLException: [SQL0204] SU300ACD in SRTFILES type *FILE not
> found.
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> MiscProc: CreateAlias - java.sql.SQLException: [SQL0601] SU300ACD in
> SRTFILES type *FILE already exists.
> CimsAgent: AddChngDltMonitoring - returned an error of
> java.sql.SQLException: [SQL0204] SU300ACD in SRTFILES type *FILE not
> found.
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> MiscProc: CreateAlias - java.sql.SQLException: [SQL0601] SU300ACD in
> SRTFILES type *FILE already exists.
> CimsAgent: AddChngDltMonitoring - returned an error of
> java.sql.SQLException: [SQL0204] SU300ACD in SRTFILES type *FILE not
> found.
> CREATE ALIAS SRTFILES.SU300ACS FOR SRTFILES.SU300(SU300)
> MiscProc: CreateAlias - java.sql.SQLException: [SQL0601] SU300ACD in
> SRTFILES type *FILE already exists.
> CimsAgent: AddChngDltMonitoring - returned an error of
> java.sql.SQLException: [SQL0204] SU300ACD in SRTFILES type *FILE not
> found.
> 
> 
> __________________________________
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.545 / Virus Database: 339 - Release Date: 11/27/03
>  
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/03
>  
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/