We are attempting to connect to our DB2 9.1 database from another application. The application vendor has limited DB2 knowledge so we are looking for help. We are told a .NET or APP driver s...
Hi ,
we ran out of space and trying to find the optimal size that we need to set it to.
is there is any recommended size for DB2 9.5 database ? for an enterprise level database?
or do...
Hi Gurus,
I am new to db2 and seek for your help.
I am currently migrating Content Manager for Ondemand to a new version. It uses a small DB2 database. I do my backups using the followin...
Hi there
Any idea why this error happen?
Thanks
SQL1476N The current transaction was rolled back because of error "-289"
I am taking a database class and the instructor wants us to download iSeries Navigator.
Where can I download this from?
Is this the equivalent to Microsoft SQL Management Studio?
I have this DB2 sql that I think is correct but would love to get some confirmation:
I've put the sql code in the code section below for this question, i've tested this in my test database ...
I am trying to configure a db2 9.5 in a sun cluster 3.2 solaris 10 environment with two nodes ( server names are math1 and math2
When I try to start the db2 on the failover node math2 I am se...
I am using the DB2 Database What is the code for the YTD and PRIOR YTD......
I ahve the code for SQL database but unable to code it in DB2.....
can any please help me out....
ok so I have created a table that has a primary key of addressID. When I run a script to populate some data in there how do I show it to be autoincreminting?
Look at the INSERT INTO scrip...
Hello experts.
I am reasonably familiar with SQL Server, but a complete novice with DB2. I have a SQL statement that I have defined in TSQL. I tested it on SQL Server and it works fine. I w...
I am curious as to just WHAT the DB2 Wrapper is and what it is used for. We use DB2 as the DB engine for IBM Content Manager.
Hi,
i am getting error below datatype is integer
SQL0440N No authorized routine named "||" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884
SQL
SELECT
A.A...
Does IBM have a free version of their DB2 database server?
I know Microsoft has their "Express" editions that are free to download and install.
Mainly I would like to just play around wi...
I am taking a class that uses this really crappy IBM online interface for us to run sql scripts in. I'm trying to figure out how to run multiple statements in a single run... example
drop...
Hi there,
What query can i run on sysibm tables to see how many rows where inserted or updates
and at what time that insert or update happen to that table ?
And if possible which query did ...
I have a column in the number format as '123456756' , I have to convert in the time stamp format.
What is the code for it?
I am working with the DB2 database.
Hi Experts,
Below pasted is the part of an application snapshot.
I see that commit statements and internal commits. Whats the difference between them.
The application is running is slow...
I am trying to write a query from SSIS to pull data from DB2. I know that db2 does not like joins and I need to join into another table to pull the information by date. Below is an example of ...
hi
i am trying this getting the error below,
select rpad('test',10,'.') from sysibm.sysdummy1
SQL0440N No authorized routine named "RPAD" of type "FUNCTION" having
compatible arguments w...
I am looking forward to implement database partition at table level for one of the huge db in DB2 v9.5 for LUW. Can any one provide with steps or suggestions how can we implement?
I am new to DB2 and would like to know the function/syntax to get the previous day using a column that has date value in 'yyyy-mm-dd' stored in a column defined as varchar in DB2.
Hi Friends,
I have 5 million rows in DB2.Using Ascential Datastage, these rows are loaded to Sybase.
I recently joined as a tester to validate this load. How do i do it?
...
I have DB2 backup from AIX box as "B352AQM6.0.DB2.NODE0000.CATN0000.20090806112922.001"
and my problem is I have to restore it on Windows machine with DB29.5.
Please help me with procedure t...
Hi,
I am using the DB2 database. In my database the data in the time column is in the format '12345', I have to pull this data on the report and must show as HH:MM:SS.
what is the code for i...
Hi,
I've to connect my application to a database. My problem is this:
First, I connect my application to a remote database. This works fine. Then, I took a backup of the remote database, and...
