Is there a way in DB2 I can get the current date and time formatted.
In Oracle I could do the following
select to_char(sysdate,'yyyymmdd') from dual
returns

This subject was discussed on the thread http://db2forum.jp/viewtopic.php?t=1979
on "DB2 Forum Japan". Unfortunately it was written in Japanese.
But I thought it may be interesting for some other persons. So, I was
translated into English some of brief their discussions.

In Oracle I could do the following
select * from (select  FIRSTNAMES, FAMILYNAME from studt  where (FAMILYNAME

') order by FAMILYNAME asc ,FIRSTNAMES asc)

I am wondering, when I issue this sql:
SELECT
CASE
WHEN LOCATE('*',STRIP(SURRUSR)) <> 0 THEN REPLACE(SURRUSR,'*','%')

I am just confused because of the following scenario.
*   I have turned on the new 8.2 registry variables skipdeleted,
skipinserted, evaluncommitted to ON
*  I gave a select * from <>, it was waiting for a lock,  it needed an

I'm  new to DB2 scale out solution. I'm reading the documentation and
it seems to me that the
"Instance Owning Node" is a single point of failure. Can someone
confirm or deny this ?

This subject was discussed on the thread http://db2forum.jp/viewtopic.php?t=1979
on "DB2 Forum Japan". Unfortunately it was written in Japanese.
But I thought it may be interesting for some other persons. So, I
translated in English some of brief their discussions.

We have an DB2 server setup on AIX 5l with DB2 V8.1  UDB enterprise server
edition plus Fixpack 14.installed. On client side, we had DB2 Admin Client V8.
1 with Fixpack 5 install and everyhting worked fine during the past couple of
years. Today, I installed db2 Admin Client Fixpack ...

Is there any way to make my transcripts of the DB2 certifications
viewable for public ?
Right now only I can view my scores , but I am unable to give an
access to let others view my scores... Is there any thing similar to

I have previously worked on data warehouses running Informix XPS and
Netezza NPS. By design, there were no indexes on either presentation
layer database. Query performance was achieved through table
partitioning, parallel scans, etc.

If i import data into tables, import will write all warnings in
message file and will tell me why any exception row is rejected.
I wanted to get exception rows in seperate table which i assume i can
not do with import

Can a v9.1 fp2 Windows client connect to a v7.1 OS/390 server via a
v8.2 AIX ESE db2connect link? We can make and test a connection
through the client config utility but when we actually try to connect
through an application we get the SQL0805 indicating the need to bind

Does anyone have an idea what it takes to administer DB2 through
PowerShell?  I want to write some scripts to automate my common DB2
management tasks and I'd really like to be able to use PowerShell for
that scripting, but I can't find a way to run DB2 comands.

All,
I look after a system that needs to be online 24 hours.
The database is partitioned by range every year. It is also in
compressed format. When i had to compress it, i had to ask for a

I am attempting to create a query that calculates a time value from
GMT to  Pacific time. It is, of course, based on the calendar date
that I will  have to figure out whether or not daylight savings
applies (i.e. subtract