RE: Funky problem with SQL ALIAS

["John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>]

> 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 smsfiles/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