To connect to the DB2 Driver, from a  remote machine. Do we requier DB2
client.
Can't we connect by just having IBM DB2 driver which is just a single
file (db2cli.dll).

I'm trying to get more information on connect via .NET to UDB.
On <URL:http://www-128.ibm.com/developerworks/db2/zones/vstudio/> there
is a link "CBT: Fast path to DB2 UDB in a Visual Basic .NET
environment"

I want to design a Table with the following condition:
The table is used to store Department Information.
There are 3 types of Department- Dept A, Dept B and Dept C
The table structure is:

I have a scenario here where I need to restrict the Sydney users to access
only sydney related data, Melbourne users to access only melbourne data,
etc.
How do I implement this?

Is there any way I can specify a regex-like expression in the LIKE part
of a WHERE clause?
Something to the tune of:
'#+-#+'

I am attempting to write a query that will traverse the relationships
for tables in my database that will provide me the order in which I
need to perform delete operations to avoid running into foreign key
constraints. I have determined the delete order manually, but since the

    I have a web application with a table to store terms and
conditions of a Company.
This may some times run into many pages and some times it may be just a
few sentences. It is a character text field. I want to know which Data

I have heard and read this many times: "Partitions should only be used for
'very large' tables".
What actually determines whether a table is 'very large' or not?
I have tables containing 0.5 million rows, 8 million rows, 14 & 29 million

In DB2 load API
for struct db2LoadIn
I am setting following values ...
inputInfoStruct.piUseTablespace       = NULL;

If in a  scenario two database servers are to be clustered to access a
common database residing on SAN,
What shall be the guidelines for optimal performance of the servers?
Will keeping the indexes,logs and underlying data in different disks help

We are running DB2 on iSeries V5R2.
Using AQUA DATA STUDIO with a connection to our iSeries, I created a
view using SQL and I am trying to create an index on this view using
the code below.

I am trying to create a function which returns a scalar data. M
function tries to insert a row in a table as well.
/**
CREATE function getManufacturerId

We are converting a data warehouse to a Unicode database to get ready
for multilingual support.  If we will have 95% of our data in English
as we currently do, and less than 5% in other foreign languages
including Japanese, it appears as if we would be best off using

I want to do runstats within an open transaction to get best optimization
for current distribution but in the past I have recognized that runstats had
no effect on the next Statements within that transaction.
Is this behavior like it should be or could I expect the optimizer to use

Hi gurus, i have written a stored procedure in a file sampleproc.sql
DB2 V8.2 AIX V5.3
Is this first step correct?
If yes, what are the next steps?