I was wondering if anybody has any insite into HIS 2000/SNA connectivty
problems. I work at a hospital with about 650 workstations. We run an
Ecplisys TDS console with SNA 4.0 SP4 or HIS 2000 SP1. Our backend
environment is an IBM MVS DB2 system. In most cases when our DB2 system

Folks,
 I have been DB2 DBA for about 6 years, but in development environment.
 I know how to created, maintain, tune database. Because of the development
 environment all the data was considered volatile and can be re-created so I

i made an attempt to restore a online backup made with include logs option.
But when i rollforward the db, i can't pout it online because it always ned
log file. I tried the option to rollforward to end of logs and to point in
time.

Given the DDL:
CREATE TABLE JOHNTEST.TASK_LIST (
    TASK                BIGINT GENERATED BY DEFAULT AS IDENTITY
        (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,

I am using the following sql statement
SELECT rtrim(rtrim(coalesce(substr(char(v.creationdate),1,4) || '-' ||
substr(char(v.creationdate),6,2) || '-' ||
substr(char(v.creationdate),9,2) || ' ' ||

I know no one will probably answer this...  It looks like IBM started
including Libeay32.dll in the DB2 Client.  Of course, this has put us
in DLL hell.  It is conflicting with Paymentech credit card processing
software.  Anyone dealt with this situation before?

I get SQL30090 reason 18 by trying to do an insert in a federated table and
an update in a local table in one transaction
Do I have to change some settings to get done or ist this not possible by
definition?

Please suggest me tools or links , documents which would detail about
the conversion of Mysql DB to DB2 .

- I have a database, which i want to backup, not only the data, but
also the indexes and views/procedures associated with it. Is the
backup/restore operations (Through the DB2 Control Center) sufficient ?
- And what happens if I later on add an index, and then restore the old

our system lost its only active log.  I get an I/O error
when connecting, referencing the log file and sql error 1036C
sqlstate 58030.  (Its version 7.1)
Is there any way to get the database to create a new log, without

Hello, I'm trying to cast a decimal colunm to char, but I'm getting bad
results like:
00000106.83
00000025.71

What are the various tasks which can be done to avoid the error message
" file System full" ?
Thanks,
Vj.

sqlcode -901 sqlstate 58004
i get this error when i do the following
1. strqm       (works ok)
2. f12         (ok still)

Under the /home/db2inst1/sqllib/db2dump folder, I have lot of files
created.  Below is a snapshot of the contents:
-rw-rw-rw-   1 db2inst1 db2grp1     3583 Nov 03 2004  a86516.000
-rw-rw-rw-   1 db2inst1 db2grp1     3583 Oct 29 2004  a88738.000

Since I work mainly on Oracle, I got the problem regarding DB2 user.
I create new 'DB User' from Control Center. How do I set the password
for this new user? Or, the only way to do this is to create a new OS
user with the same username? If so, can I still connect as this new