RE: Funky problem with SQL ALIAS

GA

Could multithreading on Java side be an issue?  Or SMP on the OS/400 side?
I guess what I'm getting at, is it possible that execution is not always
serial? 
If so, you might have a case where threadOne would create the view,
threadTwo steps in (is cycled in and has hold of CPU) and tries to create it
but fails as view already exists (this failure is monitored for), threadOne
drops the view and when threadTwo attempts to drop the view it think exists,
it fails.  
Since failure is not monitored on drop view path, you program bombs.
If this is the case, easy fix would be to monitor for drop view failure, but
I would think multithreading issues would raise their ugly head in other
ways then.

Reading back my email it all seems farfetched, but just trying to help...


Elvis

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of G Armour
Sent: Tuesday, December 09, 2003 9:54 AM
To: Midrange Systems Technical Discussion
Subject: RE: Funky problem with SQL ALIAS

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/
_______________________________________________
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.