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 we h...
http://www.experts-exchange.com/Database/DB2/Q_24774543.html
Zones:
DB2,
DatabasesDate Answered: 10/14/2009 Rating: 9.0 Views: 4
I have the need to display the age of people in a query.
I am comparing a BIRTHDATE field to "current date".
Would like to have the data presented as...
x Years, y Months, z Days
http://www.experts-exchange.com/Database/DB2/Q_23065828.html
Zones:
DB2Date Answered: 01/08/2008 Rating: 9.2 Views: 22
We have a number of nested SP and Functions in our app. Whenever we want to update the logic of a SP, it looks like you have to DROP it first, then CREATE it.
The problem I have is with a series...
http://www.experts-exchange.com/Database/DB2/Q_23071575.html
Zones:
DB2Date Answered: 09/17/2008 Rating: 9.0 Views: 0
I want to know that if I don't have a backup of my database and I want to restore the database to another machine using the files in my existing machine, what is the procedure? Can I just copy the ...
http://www.experts-exchange.com/Database/DB2/Q_23922227.html
Zones:
DB2Date Answered: 11/20/2008 Rating: 9.0 Views: 0
Where is the documentation on DB2 9.5 located? I want to learn the internals of it.
http://www.experts-exchange.com/Database/DB2/Q_23925761.html
Zones:
DB2Date Answered: 11/21/2008 Rating: 9.0 Views: 0
I want to make career in DB2. I am a .NET Developer. I want to know how to start with this. If I clear the DBA certification, who will give job to a fresher on DBA track. For developer certificatio...
http://www.experts-exchange.com/Database/DB2/Q_23927825.html
Zones:
DB2Date Answered: 11/23/2008 Rating: 8.5 Views: 0
I have a pretty simple DB2 stored procedure which accepts an integer as an input parameter. This parameter tells me how many rows to return. In my select statement, I can say 'FETCH FIRST 2 ROWS O...
http://www.experts-exchange.com/Database/DB2/Q_23961211.html
Zones:
DB2Date Answered: 12/08/2008 Rating: 9.0 Views: 21
Hello all,
I have gotten this far and now I am having problem building/registering the following UDF using the DB2 UDB Development Center. Anyone see something wrong with it? When I change the cod...
http://www.experts-exchange.com/Database/DB2/Q_23116051.html
Zones:
DB2Date Answered: 01/28/2008 Rating: 8.8 Views: 6
I want to use DB2 Express-C 9.5 as a backend with my .NET desktop applications. I am using this on a desktop application because I want to see how this RDBMS works and performs.
I have few quest...
http://www.experts-exchange.com/Database/DB2/Q_23868897.html
Zones:
DB2Date Answered: 11/02/2008 Rating: 8.9 Views: 0
I need to convert the Oracle Stored Procedure below to work within IBM DB2 Express 9.5-C.
This procedure accepts three parameters, outputs a query to a cursor, and updates the retrieved records ...
http://www.experts-exchange.com/Database/DB2/Q_23953275.html
Zones:
DB2Date Answered: 12/05/2008 Rating: 9.3 Views: 0
