Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [db2]

DB2 is a relational DBMS (Database Management System) created by IBM.

108 questions
1
vote
2 answers

Simulating AS400 iSeries for ADO.NET

I' have to write an import procedure in c# for a customer. The procedure needs to read data from an AS400 iSeries, so my first Question is: what's "better" (pro/cons) between direct connection (using ADO.NET) and an ODBC connection? Second question:…
Darko Romanov
  • 135
  • 1
  • 2
  • 10
1
vote
0 answers

Error code 610 backing up DB2 to TSM

I'm trying to back up a DB2 database using Tivoli Storage Manager (TSM), but it's erroring out. I'm now getting this error message: [db2inst1@hostname ~]$ export DSMI_CONFIG=/etc/adsm/dsm.opt [db2inst1@hostname ~]$ export…
Leo
  • 983
  • 7
  • 21
  • 39
1
vote
0 answers

LAMP using ODBC to DB2

I have connected an openSUSE LAMP and an Ubuntu LAMP server to DB2 using ODBC. The openSUSE system we're using for a development environment, and the final deployment is to be on the Ubuntu system. On Ubuntu we get segfaults when SQL statements…
MaKR
  • 111
  • 6
1
vote
1 answer

DB2 'The string constant beginning with...is too long' error when inserting 40000 characters to CLOB(50000) field

I have created a CLOB(50000) field in a DB2 table, and verified it has correctly created with DB2 DESCRIBE TABLE dbname ...however I received the following error message even when only attempting to insert a 40,000 character string into the field: …
dabayl
  • 302
  • 5
  • 12
1
vote
0 answers

Errors installing iSeries Access for Windows on Win 2008 server

I am desperately in need of help here. I am trying to install the iSeries Access for Windows software on our development server and can't get past the install. Here were my installation instructions: 1. Install MS KB patch from “First MS KB…
bltss
  • 111
  • 1
1
vote
3 answers

Will I need more system resources to run DB2 instead of MySQL?

I need to convert my web application from MySQL to run on DB2. I need to know in advance whether I will need a high spec server to ensure the web application performs at the same speed as it does now on MySQL. The application is a very database…
dabayl
  • 302
  • 5
  • 12
1
vote
2 answers

How to connect to DB2 when the password ends with '!' in Windows

I am facing a problem to use the DB2 tools when using generic account with a generated password which ends with the Bang sign '!' to connect to DB2 database. I am not allowed to change the password because it is already used by other processes. I…
AngocA
  • 111
  • 5
1
vote
1 answer

Installing DB2 9.7.4 Express-C on Ubuntu 11.04 64 bit

Im trying to install DB2 9.7.4 Express-C on Ubuntu 64 bit. Ive done it before on 32 bit Ubuntu with no problem, however on the 64 bit architecture the installation hangs / freezes. As per this webpage DB2 Installation Requirements I installed the…
Alex
  • 11
  • 1
1
vote
1 answer

cannot drop existing db2 database

db2 list database directory gives me Database 1 entry: Database alias = M Database name = M Local database directory = /var/lib/edumate/database Database release level =…
Radek
  • 1,153
  • 4
  • 26
  • 39
1
vote
1 answer

What could cause a file system to spontaneously unmount or become invalid for a short time?

We've got DB2 LUW running on a RHEL box. We had a crash of DB2 and IBM came back and said that a file that DB2 was trying to access (through open64()) unmounted or became invalid. We have done nothing but restart the database and things seem to be…
Ichorus
  • 485
  • 1
  • 6
  • 12
1
vote
3 answers

wrong character display in cmd windows in XP

When i install DB2 express-C in windows xp platform, the command windows cann't display correct chinese character, replace with wrong code display such as "??##". How can i fix it.
Johnny
1
vote
1 answer

SQL Error: -443, SQLState: 38111 when accessing table metadata on DB2 zOS

I'm getting following error when using Hibernate in a Java application over my DB2 database. This error occurs with one DB2 database and not with another (I'm almost sure the problem is in DB2 server side configuration), and I didn't found the…
snowflake
  • 127
  • 3
  • 12
1
vote
1 answer

DB2 runstats not working for xml columns

I am running runstats command to update the runtime statistics of a particular table called "CUSTOMER" in DB2. The customer has two columns- CID (integer) and INFO (xml column). After running the command, if I look into the SYSCOLDIST table, the…
Keshav Prasad
  • 125
  • 7
1
vote
2 answers

How to setup privileged in docker swarm?

I am running a db2 container sample using this docker command. Reference docker image docker run -itd --name mydb2 --privileged=true -p 50000:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=Notallowed1! -e DBNAME=testdb ibmcom/db2 It is working. If I…
uday
  • 352
  • 10
  • 30
0
votes
2 answers

Activation key part number for Db2 Data Server Client 11.5?

I think I have reached the end of Google, but still not able to find the part number I need to download the license file for IBM Data Server Client 11.5. Not listed here https://www.ibm.com/support/pages/db2-version-111-activation-key-part-numbers…
rhellem
  • 295
  • 1
  • 5
  • 14
1 2
3
4 5 6 7 8