473,785 Members | 2,414 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SET SCHEMA command sometimes ignored?

aj
DB2 v8 FP5
Red Hat AS 2.1

We are encountering a strange error where the default schema name
that is specified w/ a SET SCHEMA command is being inconsistently
ignored, causing all table references to be prefixed with the
connecting username, and throwing many SQL -204 SQLSTATE 42704
exceptions.

There does not appear to be a pattern to this, except that heavy
DB usage makes it more frequent.

The connection comes from a pooling mechanism written in Java,
whereby each new connection added to the pool gets a SET SCHEMA
done against it. This pooling mechanism has worked flawlessly
for over a year against DB2 v7 - the behavior only started when
I upgraded to DB2 v8 FP5. I am not using the JDBC2
com.ibm.db2.jdb c.DB2PooledConn ection pooling, but rather the
com.ibm.db2.jcc .DB2Driver class.

A thread entitled "Default schema in db2cli.ini intermittantly ignored"
dated 2003-04-17 mentions the same behavior, but not really a resolution.

Anyone have any thoughts?
I have rebound the db2schema.bnd, db2ubind.lst and db2cli.lst packages.
This database was a clean migration from a v7 offline RESTORE.
db2dart and inspect check database comes up clean...

PS - whats the diff between SET SCHEMA and SET CURRENT SCHEMA?

TIA

aj
Nov 12 '05 #1
1 3866
AJ,

The difference between SET SCHEMA and SET CURRENT SCHEMA is the parser
token CURRENT. That's it. There is none. Same code. Just syntax
toleration. likely one is SQL Standard, the other DB2 SQL.

Now one major piece of work in V8 was the complete rework of the clients
to use DRDA. Possibly your Java code was unwittingly exploiting some
quirk in the V7 client behaviour that the V8 client doesn't possess
anymore. Pure guesswork.
I would be surprised if this would be solved within this group.
I would start revisiting your pooling code to ensure it's correct and
then open a PMR if needed.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1722
by: Sony Antony | last post by:
Hello: ( Please redirect me to the correct list if this is not where I m supposed to ask this question ) Our application essentially sends xml 'commands' to another system. These commands are essentially one xml element signifying which command it is ( 3 types of commands ) and a corresponding data required by that
1
1708
by: Andy | last post by:
Hello All! Is there any way to validate XML document agains schema, but at the same time ignore any attributes or elements that are not specified in schema? Example: <Customer> <LastName></LastName> <FirstName></FirstName>
2
1935
by: Zombie | last post by:
Hi all, I wish to create a namespace other than the default one. Let's say, the Schema looks like: ----------------------------------------------------------------------- <?xml version="1.0" encoding="UTF-8"?> <xs:schema xmlns:d="http://www.geodesy.org/dam" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xs:element name="River">
10
43224
by: wackyphill | last post by:
I know in SQL Server the terms Database and Catalog are used interchangably. But a table is also assigned a schema. As seen in the INFORMATION_SCHEMA.Tables View. I don't get what this schema qualifier is all about. Like if a table has a schema of dbo. Can someone explain the relationship the schema has and what it is? Thanks.
3
13125
by: N. Shamsundar | last post by:
In DB2 V8.1.5, if one uses SET SCHEMA to a schema other than the default schema, and subsequently issues a LIST TABLES command, it is still the tables in the default schema that are shown. Is this the way the SET SCHEMA command is supposed to work? N. Shamsundar University of Houston
1
1289
by: awebguynow | last post by:
I've seen the syntax in the J. Stephens/C. Russell book and believe the "alter table" would be: ALTER TABLE tbl FOREIGN KEY (column_list) REFERENCES tbl_name (column_list) the Syntax is really not a problem, and I'm pretty sure I won't be violating any FK contraints right off the bat. If so, I expect the
3
2174
by: Chris Lieb | last post by:
I am new to XML Schema and am running into a bit of a snag. I have defined an XML-based scripting language for an updater program that I am working on. I would like to make a schema for this language since malformed XML documents break the updater. (I did not have time to add good error-handling code, so run-time errors can abound if the document is malformed.) A sample doc might look something like this: <manifest>
3
2615
by: dkacher | last post by:
Hi - I'm looking for a way to generate a list of the fully-qualified paths to all of the leaf nodes in an XML Schema. The reason: I have a large schema for which I'm building a transform stylesheet; I need to be sure I've covered everything. With a list of the paths to all the leaves, I can check off my progress. Have you encountered a program that can generate such a list? Or any pointers about how to approach it? It seems that there...
2
10838
by: Amber | last post by:
On my DB2 UDB 8.2.7 database user User1 has been granted IMPLICIT_SCHEMA privilege, but when he issues "create schema test", the error message "SQL0552N, USER1 does not have the previliege to execute the operation create schema" was thrown. But if he issues "create table test.test(a int)", the operation can execute successfully. So how can I let users issue the create schema statement.
0
9646
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9483
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10157
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7504
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6742
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5386
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5514
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3658
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2887
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.