DB2 Database Forum

Hi. Anyone seen this error, when issuing db2jstrt? db2jstrt: 0403-006 Execute permission denied. Regards J. Overggard

Moin, nachdem wir uns von unserem alten Server (DB2 6.X) verabschiedet haben, haben wir die Version 8.1 auf einen neuen Server installiert. Die Performance ist aber schlechter wie auf unseren alten Rechner. An welchen Schrauben sollte man drehen, an welchen überhaupt nicht? Ingo

Moin, gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group abzufragen? Ich möchte in meiner Anwendung abfragen ob der eingeloggte User bestimmte Rechte auf der Datenbank hat. Kann man diese Rechte abfragen? In welcher Tabelle stehen diese? Ingo

Does DB2 have a select @@ identity equivalent. Karthik

I need snapshot like snapshot for table but for only one application or transaction. Is't possible on productive server? Andy

I need to add an additional String parameter to a Java SP (DB2 8.1 0 using DB2 Development Center - FP4). Everytime I do this I get the following error message when building:- "G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted library/function identification in the EXTERNAL NAME clause. LINE NUMBER=12. SQLSTATE=42878 ...

After incrementally increasing SORTHEAP (and the commensurate increase in SHEAPTHRES) and *slightly* reducing the bufferpool size, I find that my query is no longer taking advantage of async IO for reads. I discovered this message in the db2diag.log: ==================================== PID:80850(db2agntp (LIKAO) 0) ...

Hi All, Im having problems setting up the federated database. The commands Im using are as follows: CATALOG TCPIP NODE 'FSYS1' REMOTE <ip> SERVER <port> CREATE SERVER svr_docket TYPE DB2/LINUX VERSION 7.1.0 WRAPPER DRDA AUTHORIZATION usr1 PASSWORD "usr1pwd" OPTIONS (NODE 'feddb1', DBNAME 'docket' )

Hi All, Out of nowhere my udb system (v8) performance has went terrible. Its gotten about 10x worse, (some tests that used to take 2 seconds to run now take 20)... I'm not sure what happened. I did reorg/runstat/rebind on everything, no luck... I'm not sure what to do next...? Any recommendations on something to try to start narrowing...

I want to export all images from the DB2 sample database (sample) in different files. My export-statement: db2 "export to G:\images\emp_photo.del of del lobs to G:\images\ lobfile image modified by lobsinfile select * from emp_photo" Export works successfully but all images are concatenate in the file image.001

I have surprising performance results running a simple Java program which inserts 1000 rows into the following simple table: create table TestTable (id int not null, comments varchar(255) not null); With group commit, the test runs in 3 seconds (one commit after the loop) With auto commit, the test runs in 15 seconds (default JDBC...

Anybody can tell me if there is a difference between windows and linux scatter/gather io's? Anybody can describe the linux scatter principle? (os or db2 sorts block numbers before sending to the io adapter?) Why invent a new db2set variable DB2_SCATTERED_IO

Hi. Anyone seen this error, when issuing db2jstrt? db2jstrt: 0403-006 Execute permission denied. Regards J. Overggard

Good Morning! How to resolve problem as below: SQLCODE -497, Error: THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE We create many tables and delete, then we can't create new objects in database, because OBIDs doesn't freeing. It exist any PTF for this? regards Christopher S.

Hi all, I use replication between two 7.2 db2 udb. The kind of replication is 'update anywhere' and capture is stopping about every day beacause it is missing a log that is already archived. Capture can t read archived logs ? and why logs archived if capture has not read it again ? Thanks in advance for your help. Sandrine.

Hallo, does anyone know how to perform a CREATE TABLE TEST(NAME CHAR(40) NOT NULL, CHECK(NAME ???)); I want that i only can insert lower and upper chars. I tried it with the statement CHECK(NAME BETWEEN 'a' AND 'z') OR (NAME BETWEEN 'A' AND 'Z')

Is it possible to create a VIEW that is (directly or indirectly) based on a stored procedure?

I find dangling message queues keep accumulating on DB2 servers (V8.1, Solaris) after remote loading with "load client" command. Just wondering if there is a way to eliminate them. Otherwise the instance needs to be bounced (ipclean may need to run) or servers need to be rebooted. Any suggestions? Thanks,

hi, i know that db2 7.2 ee should not work on redhat 9 server because of the glibc2 threading problem. but i have 2 identical smp servers, the first one i (think) i had installed rh 7.2 first, then installed on it db2 7.2 (fp7) and afterwards upgraded the rh 7.2 to redhat 9 with latest kernel (2.4.20-20.9smp).

Is there a simple way of selecting the last backup timestamp of a database from a table? Something like select last_backup_timestamp from tablename where database_name='WHATEVER' Or am I forced to check the backup history with list history backup all for WHATEVER

Red Hat AS DB21085I Instance "md" uses "32" bits and DB2 code release "SQL08012" with level identifier "02030106". Informational tokens are "DB2 v8.1.0.16", "s030508", "MI00048", and FixPak "2". I am having various and sundry problems w/ my v8 DB not coming down cleanly after a db2stop - It leaves mem segments lying around.. I then...

Hi, We are facing problem accessing to DB2. Seems like database manager is down I tried starting it using db2start but it was neither showing any messages nor returning to command prompt after finishing start. I do not know actually if it was trying to start database or hanging somewhere

Hi, I have a table with 10M records and col A has a index created on it. The data on that table has the same value for col A on all 10M records. After that I insert diferent values for that column but my queries do not use the index I created for that column. Is there any way I can force the usage of the index or to ommit a value on the...

Hello, I noticed that lock escalations are logged in db2diag.log and lock escalation failures are written to the notification log. Is there a way to get DB2 to log basic details about lock timeouts as well? If not, I'd really like to see such a feature, perhaps controlled by a registry variable. Thanks,

Hi there... I have a stateless Session Bean issuing a select for a BLOB column. This bean is using a CachedRowSet. It seems to work for all other columns types other than a BLOB. Selecting a BLOB column, a SQLExcpetion when the CachedRowSet is populated. Anyone else run in to this situation? ENV: WSAD 5.0.1 running on WIN2K or RH9...