DB2udb.com

Hi community,
the log files in SQLOGDIR have -rw—— as permissions. How can I
change the permissions to -rw-r—-, also for newly created logfiles?
Thanks in advance,
Axel.

Source:SQLOGDIR permissions in AIX

In DB2 for LUW not directly. To do things like condition handling inside
of a trigger push the logic into a stored procedure and CALL that.
The SQL Procedure has the full power of SQL PL at its disposal.
Cheers
Serge

Source:Re: How to check SQLCODE in trigger

I have a query in Oracle like this:
Select 1 from dual
where
(1,1) IN ( (1,1), (2,1) )
and want to convert it to DB2.
I tried this query:
Select 1 from sysibm.sysdummy1
where
(1,1) IN ( (1,1), (2,1) )
I replaced "," with SPACE and ";" but got error.
It will be appreciated to help me to solve this problem.

Source:Problem with IN predicate

Nyt on maamme tiedotusmonopoleissa tullut tavaksi vedättää esiin sellaisia
tietoja, että riisin- ja viljanhinnan nousu johtuisi siitä, että niitä
käytetään eläinrehuina lihantuotantoon.. .Haloo kuka on nähnyt "riisirehua"?
Veikkaan että kyseessä on maailman harvinaisin sbesiaalirehupussukka, jota

Source:Re: ADVICE NEEDED: Removing Inner Tie Rod Ends - TWO QUESTIONS

Hi!
Yes, I tried that and the script complained that there is no
SYSPROC.EXPLAIN_GET_MSG2 function, which led me to conclusion that
Databse Instance was not migrated, but running db2imirgr sayed that it
cannot migrate the instance since it already is migrated. Go figure.
Now I’m wandering in the dark.

Source:Re: db2exfmt and missing function EXPLAIN_FORMAT_STATS

Hi All,
We are testing one of our component with JDBC + DB2 using db2jcc
driver. We afced a strange issue.
Scenario is like this.
1. We insert 1 record to a table having IDENTITY column as the primary
key and retrieve the newly inserted identity value using
getGeneratedKeys() API of JDBC 3.0. It works fine

Source:DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generated field

Helpful folks,
We recently upgraded DB2 V7 to V8 on Windows 2003 Enterprise Edition.
The plan is to migrate to V9 as soon as possible. In anticipation of
that migration, IT management has decided that all our user desktop
workstations (a few hundred) should be upgraded to the V9 runtime
client before we migrate the server to V9. This upgrade process will

Source:V9 runtime client setup problems

This has become a performance tuning thread, but I’d use a cursor load
instead, great speed, no space usage..

Source:Re: Any suggestion on how to speed up large batch inserts?

Hi!
when I run db2exfmt on DB2 9.1 I get this output:
DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp.
1991, 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Explain Table Format Tool

Connecting to the Database as user EMGSYS.
Connect to Database Successful.

Source:db2exfmt and missing function EXPLAIN_FORMAT_STATS

Scav wrote:
Common misconception. An instance is *NOT* a server. It is an
*environment*. It is an environment under which applications may run DB2
applications. It just so happens that one of the biggest and most
pervasive DB2 applications might just be the DB2 server itself.
This environment tells applications where to load DB2 libraries (DLLs on

Source:Re: V9 runtime client setup problems