364,036 Members | 5377 Browsing Online

Community for Developers & IT Professionals

DB2 Database Questions and Answers

newest replies last post views AllAnswersInsights

Ask a Question

Please read me first

1 reply 3,738 views Question by docdiesel in db2 | Mar 25 '09 | last reply: Maidenz08

How to establish a DB2 connection in while loop using Shell script

1 reply 142 views Question by vikyalex4 in db2 | 3 Days Ago | last reply: jonathanw

Count table in DB2

answer this 68 views Question by zulkifb in db2 | 3 Days Ago | last reply: zulkifb

How to retrieve alerts/information from a db of alerts that happened between 7

2 replies 118 views Question by akimalik10 in db2 | 2 Weeks Ago | last reply: akimalik10

is an undefined name. SQLSTATE=42704

7 replies 212 views Question by rennet17 in db2 | 3 Weeks Ago | last reply: Rabbit

DB2 v 9.1 to Teradata

answer this 99 views Question by Upisipati in db2 | 4 Weeks Ago | last reply: Upisipati

connect asp.net and db2

answer this 170 views Question by degfhi in db2 | Apr 8 '12 | last reply: degfhi

sql 1390c error while installing DB2 8.1 on windows 7

answer this 186 views Question by niroopa in db2 | Apr 1 '12 | last reply: niroopa

REPLACE in packages vs plans

answer this 190 views Question by c ruof in db2 | Mar 30 '12 | last reply: c ruof

DB2 Error: "MODIFIES SQL DATA" clause has not been specified

1 reply 166 views Question by Rasmita Nayak in db2 | Mar 27 '12 | last reply: Rabbit

How to get out of "BACKUP PENDING. SQLSTATE=57019 on DB2" State

answer this 336 views Question by Raymond Batkin in db2 | Mar 23 '12 | last reply: Raymond Batkin

backup db2 logarchmeth1 tsm

changing schema name after database restore

answer this 157 views Question by Amit Asnani in db2 | Mar 22 '12 | last reply: Amit Asnani

Replication between 2 As/400 db2 databases

answer this 173 views Question by ahmet kilivan in db2 | Mar 21 '12 | last reply: ahmet kilivan

DB2 v9.0 (Enterprise) vendor code

answer this 158 views Question by Raymond Batkin in db2 | Mar 20 '12 | last reply: Raymond Batkin

not able to run query from jmeter

answer this 168 views Question by chella Durai in db2 | Mar 13 '12 | last reply: chella Durai

Convert varchar to time

1 reply 227 views Question by amitaon in db2 | Mar 7 '12 | last reply: r035198x

How to get list of all table names in db2

2 replies 525 views Question by jags ahir in db2 | Mar 6 '12 | last reply: Latha V

Tablespace level issue

answer this 164 views Question by Latha V in db2 | Mar 6 '12 | last reply: Latha V

how to reorg table that's in pending state ?

1 reply 301 views Question by Gwen in db2 | Mar 5 '12 | last reply: rajneesh verma

How to insert only PNG & jpeg image in DB2

answer this 234 views Question by NiteeshBhargava in db2 | Mar 1 '12 | last reply: NiteeshBhargava

How to change the primary key for already existing table?

2 replies 13,269 views Question by sajithamol in db2 | Mar 1 '12 | last reply: JD07

Want to have a key field in 2nd PF in Join LF

answer this 196 views Question by Shajahanlink in db2 | Mar 1 '12 | last reply: Shajahanlink

Installation of IBM DB2 spatial extension for mac os

answer this 215 views Question by Pras403 in db2 | Feb 28 '12 | last reply: Pras403

db2 ibm mac spatial

JDBC callable insert with registered parameter??

answer this 204 views Question by bruce randall in db2 | Feb 23 '12 | last reply: bruce randall

Datastage conversion

1 reply 204 views Question by gorav tri in db2 | Feb 21 '12 | last reply: Rabbit

SQL0289N Unable to allocate new pages in table space "<tablespace-name>".

1 reply 275 views Question by sreehari9 in db2 | Feb 17 '12 | last reply: vijay2082

Compare 2 columns having similar data

1 reply 301 views Question by swamim in db2 | Feb 14 '12 | last reply: Rabbit

A minor error occurred while installing "DB2 ESE"

answer this 279 views Question by klinaev in db2 | Feb 8 '12 | last reply: klinaev

If we give this year and weekid like 201106 we have to find last week data?

3 replies 283 views Question by rkboss9 in db2 | Feb 8 '12 | last reply: Rabbit

Db2top

answer this 260 views Question by Fairoze Ahmed M in db2 | Feb 8 '12 | last reply: Fairoze Ahmed M

Any one have a powershell script to prune DB2 Logfiles?

answer this 350 views Question by coreyfrankel in db2 | Feb 3 '12 | last reply: coreyfrankel

db2 logfiles powershell prune script

SQL0204N error in reverse engineering from db2 to power designer

answer this 321 views Question by hkaf in db2 | Jan 28 '12 | last reply: hkaf

Why explain plan not same?

1 reply 341 views Question by automona in db2 | Jan 26 '12 | last reply: chendan

VARCHAR vs CHAR in DB2 z/OS

answer this 361 views Question by Lynn Monty in db2 | Jan 26 '12 | last reply: Lynn Monty

DB2 tablespace (USERSPACE1) from Drop Pending to Normal stats?

1 reply 482 views Question by calvinyin in db2 | Jan 26 '12 | last reply: chendan

DB2 Nested Stored Procedures and labeled_begin_atomic error

1 reply 295 views Question by rjj1 in db2 | Jan 25 '12 | last reply: rjj1

db2 labeled_begin_atomic nested stored procedures

Db2 get diagnostic does not returns # of rows

answer this 292 views Question by erickup in db2 | Jan 25 '12 | last reply: erickup

ALIAS ON Remote SYSIBM.SYSCOLUMNS

answer this 329 views Question by James Yattaw in db2 | Jan 19 '12 | last reply: James Yattaw

Comparing a string consisting of two single quotes

answer this 296 views Question by varun789 in db2 | Jan 19 '12 | last reply: varun789

db2 strings with quotes

SQLDA max length for sqlname

answer this 261 views Question by Arco Simonse in db2 | Jan 18 '12 | last reply: Arco Simonse

" SQL0440N " - error while executing store procedure on v9.7fp4

answer this 324 views Question by exp123 in db2 | Jan 16 '12 | last reply: exp123

Jar for DB2 type 2 driver

answer this 357 views Question by exp123 in db2 | Jan 16 '12 | last reply: exp123

Errorcode=-668, sqlstate=57016

answer this 411 views Question by Alka Agrawal in db2 | Jan 13 '12 | last reply: Alka Agrawal

Create schema

1 reply 333 views Question by heartwork in db2 | Jan 11 '12 | last reply: heartwork

Find Tables/Views used in a View.

answer this 267 views Question by Amad Khan in db2 | Jan 5 '12 | last reply: Amad Khan

Migrate from oracle to DB2 incl. 32 to 64 bit unicode

answer this 342 views Question by hwi051 in db2 | Jan 2 '12 | last reply: hwi051

cursor for

1 reply 300 views Question by Divya k in db2 | Jan 2 '12 | last reply: Rabbit

Deleting a column data from table

3 replies 5,230 views Question by Srireddy in db2 | Jan 1 '12 | last reply: dineshampili

Data partitioning

answer this 348 views Question by Tom Johnson in db2 | Dec 22 '11 | last reply: Tom Johnson

DB2_CREATE_DB_ON_PATH registry entry does not exist

answer this 436 views Question by MikeOliverAZ in db2 | Dec 7 '11 | last reply: MikeOliverAZ

Backup Failure - 4 node DPF Setup One node is down

1 reply 438 views Question by pankaj modi in db2 | Dec 5 '11 | last reply: pankaj modi

Ask a Question

1
2
3
11
>
Last »

Channels

Most Active

Most Questions Answered

Latest Questions

DB2 relational database management system (IBM) - Get answers to questions about DB2 administration and development, tuning, clustering, queries, security, API, views, joins, XML, schemas, tables, triggers, SQL and more.

BYTES.COM © 2012
Formerly "TheScripts.com" from 2005-2008
About Bytes | Advertise on Bytes
Sitemap | DB2 Database Answers Sitemap | DB2 Database Insights Sitemap

DB2 Database Questions and Answers

Channels

Most Active

Most Questions Answered

Top Questions

Latest Questions

More