Deja.Com Daily Digest: comp.databases.ibm-db2 1/1 (Auto reply) 
Author Message
 Deja.Com Daily Digest: comp.databases.ibm-db2 1/1 (Auto reply)

I will be out of the office on 01/16.
Please contact John Maenpaa, Robert Little, Bob Cohen for DB2 issues.

 Deja.com Daily Digest:
 comp.databases.ibm-db2

 Deja.com: Best way to buy a PC
  http://www.***.com/

Subject: Re: Global Temporary Tables

Hi,

Temporary tables are just like any other system temporary table. Maybe
some parameters surrounding your tablespaces are to blame?

Cheers
Serge

--
Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.***.com/

Subject: Re: Select after Create Table/View via ODBC result in unexpected ordered



Date: Wed, 10 Jan 2001 09:25:28 -0600
Organization: IBM Rochester
Lines: 10



NNTP-Posting-Host: lig32-226-235-87.us.lig-dial.ibm.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.rchland.ibm.com 979162532 30798 32.226.235.87 (10 Jan 2001 21:35:32 GMT)

NNTP-Posting-Date: 10 Jan 2001 21:35:32 GMT
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en,pdf

How did IBM respond?  Sure seems like  a defect in the Client Access Express
driver to me.

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries

(opinions stated are not necessarily those of my employer)

Subject: Re: To (IBM) DB2 gurus: Using DB2 for logging / tracing (ROLLBACK issue)

To my knowledge there is no autocommit logic on the OS/390.  Audit trails
are usually post processed form the the SMF log or DB2 log.  This is
usually the most cost effective way for performance and management of
audits as the logs can be made to contain all the imformation required and
do not have the overheads associated with a table.  The only issue with
using logs is the delay in information becoming available.  Typically this
is not generally a problem as one usually only uses the trails if
investigating an issue which should be an infrequent event.

There is a technique for maintaining more timely information using the
trace buffers such as is done by performance monitors (e.g. Omegamon).
THis can be accessed using IFI.

I hope this helps.

Peter

Subject: About installation DB2 UDB  V7.1(EE) on Solaris 7 ?

hi~all.

I installed DB2 UDB v7.1 trial s/w on solaris 7 via ibm site.

by the way, it was warning message as follows.

-----------------------------------------------------------------------
DBI1034W Missing prerequsite package.

Explanation: One of the following packages has been selected for
installation:
Transformer Stored Procedure Files Common Jar Files
Control Center
DB2 Query Patroller Client
DB2 Application Development Tools (ADT)
However, the installed Java RTE
fileset level is below 1.1.8
User Response: Upgrade Java RTE fileset to version
1.1.8 or higher.
-----------------------------------------------------------------------

then after installing, I knew it was not installed DB2 Instance &
Administration Server from summary report.

so it deinstalled via db2_deinstall utility, then reinstalled via
./db2setup.

finally, second installation is also not installed DB2 Instance &
Administration Server and is not made db2inst1,db2fenc1,db2as directory &
detailed setting (userid, group, etc).

what is problem?

I hope your answer.
thanks.

Subject: Re: OS/390, DB/2 and distributed processing

Hi David, I am afraid we do use SNA, and DB/2 Connect.  We are planning the move
to TCPIP sometime in 2nd half of 2001.  Our measurements show that CPU
utilization of DBxxDIST is quite high during the command execution.  The network
seems to be okay.  So the question is what is DBxxDIST actually doing and needs
so much CPU?

Thanks for your help,

Andreas Kokkinos

Quote:

> What product are you using to access DB2 390? IBM DB2 COnnect? What protocol
> are you using : SNA (yuk) or TCP/IP?


> > Hi to all, I have a question that is somewhat general, but hopefully
> > somebody can point me to the right direction.  We are a site running
> > OS/390, CICS, DB/2 and the works.  Right now, our people are trying to
> > setup Business Object on a PC so the user can run DB/2 queries through
> > distributed processing.  The performance was terrible, the machine was
> > locked up, until we lowered the DBxxDIST priority. The performance is
> > still lousy, a simple query takes more than 5 mins to complete, and we
> > are trying to find out why.
> > So, can anyone share any pointers as to where to look for possible
> > problems.  Any ideas will be greatly appreciated.

> > Thanks

> > Andreas Kokkinos

Subject: Re: Indexes performance slowdown



Quote:
> Hi,

> Obvious question first: Have you run runstats on the table?

> Cheers
> Serge
> --
> Visit the DB2 UDB and DB2 Connect Online Support site at:
> http://www.***.com/

Sure I did, even if the REORGCHK didn't say it was necessary, neither
for table nor for index.

Sent via Deja.com
http://www.***.com/

Subject: Re: Create table with jdbc

I found the problem. It seems as if I had set the columns too large. I
had two with VARCHAR (4000). When I changed them to (255) it worked
without nameing the tablespace. I really don't understand how large I
should have set it. I increased the prefetch size to 128K but it didn't
work anyway...

/Jonas



- Show quoted text -

Quote:
> Hi,

> I have both a temporary and a regular tablespace managed by system
with
> a prefetch size of 16, extent size of 32, and overhead of 24.100. I
can
> not even create the table if I name the tablespace, I get the error:
> SQL0670N  The row length of the table exceeded a limit of "4005"
> bytes.

> (Regular table space "USERSPACE1".)  SQLSTATE=54010

> What does that mean? I have not had any problems creating tables
> before. I would be very thankful for help in this matter!

> I am using DB2 version 6.1

> Regards

> Jonas



> > The CREATE TABLE statement is failing because the table requires a
> > tablespace with a 16K page size.  Can you create regular and system
> > temporary tablespaces with a 16K page size and try again?  You can
> also
> > GRANT the use of a tablespace to DB2ADMIN (and REVOKE the use of
other
> > tablespaces) - see the SQL Reference manual.


> > > Hi,

> > > I am trying to create a table from java using a jdbc connection.
> What I
> > > am wondering is if it is possible to create a table without
> mentioning
> > > the tablespace.
> > > i.e is there a way to set a default tablespace to a user. So if I
> > > create a table with e.g. the user db2admin, DB2 will understand
that
> > > the tablespace users will be used?

> > > When I try now I get the error:

> > > COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT]
SQL0286N  A
> > > default table space could not be found  with a pagesize of at
> > > least "16384" that authorization ID "DB2ADMIN" is authorized to
use.
> > > SQLSTATE=42727

> > > Very thankful for help!

> > > Regards

> > > Jonas

> > > Sent via Deja.com
> > > http://www.***.com/

> Sent via Deja.com
> http://www.***.com/

Sent via Deja.com
http://www.***.com/

Subject: Re: Variation in performance


Quote:

> Hi all,
>   We are running DB2UDB 5.2 on solaris. We are experiencing performance
> issues for the last several days. The main thing is we are not able to
> reproduce the problem. One day it seems to be very fine and the next
> day it sucks. Without doing anychanges to the database it will be good
> in the next days again it sucks. we dont know what to do with this. we
> tried all the options. Please help me in this

> Thanks for all your help in advance.

>  Also can I run a reorg & runstats on SYSIBM   SYSINDEXES

Hi Sujin.

First the last :-)
You can run a reorg&runstats on SYSIBM SYSINDEXES, but why?
Performance of DB/2 is difficult. You have to be familiar with
some DB/2 internals. Best case you know someone with excellent
knowledge in DB/2.
You must balance all "switches" (options) in case of your
kind of using to get best performance.
The only thing I can tell "out of the hand" is: enough RAM
to hold all important data, rigth-sized bufferpools and a good timing
for i/o cleaners and logging, seperate all parts of the database
on different hdisks (logging, indexes, tables, ..).
I think its allways better to ask for a really good person
for help. There so many ways.

regards
Frank

Subject: Quotes in SQL data

Hi All,

I'm using ODBC over DB2 on NT.

In my SQL statements the data may contain single quotes.
I can escape a single quote by prefixing it with another single quote,
for example:
INSERT INTO TEMP (col1) VALUES ('I''m busy');

However, is there a way of doing this without me having to do the
escape ?

Many thanks,
Nigel Robbins

Sent via Deja.com
http://www.***.com/

Subject: Re: Create table with jdbc

   Jonas, read the error message very literally... it was not telling you
that there was anything wrong with your tablespace.  It was telling you
that you've exceeded some table length limitation (in other words, the
total length of all columns in the table).

- Show quoted text -

Quote:

> I found the problem. It seems as if I had set the columns too large. I
> had two with VARCHAR (4000). When I changed them to (255) it worked
> without nameing the tablespace. I really don't understand how large I
> should have set it. I increased the prefetch size to 128K but it didn't
> work anyway...

> /Jonas



> > Hi,

> > I have both a temporary and a regular tablespace managed by system
> with
> > a prefetch size of 16, extent size of 32, and overhead of 24.100. I
> can
> > not even create the table if I name the tablespace, I get the error:
> > SQL0670N  The row length of the table exceeded a limit of "4005"
> > bytes.

> > (Regular table space "USERSPACE1".)  SQLSTATE=54010

> > What does that mean? I have not had any problems creating tables
> > before. I would be very thankful for help in this matter!

> > I am using DB2 version 6.1

> > Regards

> > Jonas



> > > The CREATE TABLE statement is failing because the table requires a
> > > tablespace with a 16K page size.  Can you create regular and system
> > > temporary tablespaces with a 16K page size and try again?  You can
> > also
> > > GRANT the use of a tablespace to DB2ADMIN (and REVOKE the use of
> other
> > > tablespaces) - see the SQL Reference manual.


> > > > Hi,

> > > > I am trying to create a table from java using a jdbc connection.
> > What I
> > > > am wondering is if it is possible to create a table without
> > mentioning
> > > > the tablespace.
> > > > i.e is there a way to set a default tablespace to a user. So if I
> > > > create a table with e.g. the user db2admin, DB2 will understand
> that
> > > > the tablespace users will be used?

> > > > When I try now I get the error:

> > > > COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT]
> SQL0286N  A
> > > > default table space could not be found  with a pagesize of at
> > > > least "16384" that authorization ID "DB2ADMIN" is authorized to
> use.
> > > > SQLSTATE=42727

> > > > Very thankful for help!

> > > > Regards

> > > > Jonas

> > > > Sent via Deja.com
> > > > http://www.***.com/

> > Sent via Deja.com
> > http://www.***.com/

> Sent via Deja.com
> http://www.***.com/

--
Larry Menard
IBM Workstation Database (DB2) Performance Team
Defender of Geese and of all things Natural

Subject: 7.1 PDE for Linux - time limited?

Hi,

IBM offers a 7.1 PDE for Linux which "is not a limited-time evaluation
copy"
on their web site for development, evaluation etc. The version I
downloaded,
however, starts counting down the days after I set it up (it says it
will run
for 90 days; I tweaked my system date, and it really stops working after
that
period). Did I miss anything?

BTW, the archive I downloaded from IBM's site is called linuxpecmn.tar
(78,069,760 bytes).

Thanks,

Christoph

--

A debugged program is one for which you have not yet found the
conditions
that make it fail.                                         -- Jerry
Ogdin

--
Posted from moutvdom01.kundenserver.de [195.20.224.200]
via Mailgate.ORG Server - http://www.***.com/

Subject: Record count question from an amateur.

Is there any way to find out how many records a query will return without
first returning the results?  We're using Java (SDK 1.3) and DB/2 v7.1.

Subject: Re: Indexes performance slowdown

Hi,

Yes, that will do it. Can you move the function onto the hostvariable
using it's inverse (if there is one).

If this is for some reason impossible (which it shouldn't) you could use
a generated column based on hex(idx) and create an index on that one.
This way db2 will route to the index.

Cheers
Serge

--
Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.***.com/

Subject: Re: Quotes in SQL data

Hi,

Not in a constant. You could pass the string via parameter marker or
hostvariable, though.

Cheers
Serge

--
Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.***.com/

 _____________________________________________________________
 Deja.com: Before you buy.
  http://www.***.com/
 * To modify or remove your subscription, go to
  http://www.***.com/
 * Read this forum at
  http://www.***.com/

 Sent via Deja.com http://www.***.com/
 Before you buy.



Sun, 06 Jul 2003 04:41:08 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Deja.Com Daily Digest: comp.databases.ibm-db2 1/1 (Auto reply)

2. Deja.Com Daily Digest: comp.databases.ibm-db2 1/1 (Auto reply)

3. Deja.Com Daily Digest: comp.databases.ibm-db2 1/1 (Auto reply)

4. Deja.Com Daily Digest: comp.databases.ibm-db2 1/1 (Auto reply)

5. Deja.Com Daily Digest: comp.databases.ibm-db2 2/2 (Auto reply)

6. Deja.Com Daily Digest: comp.databases.ibm-db2 2/2 (Auto reply)

7. Deja.Com Daily Digest: comp.databases.ibm-db2 1/1 (Auto reply)


 
Powered by phpBB® Forum Software