The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows servers.

learn more… | top users | synonyms

0
votes
1answer
195 views

DB2 - Not enough storage in the database heap error when trying to create database

So like the title says I'm trying to create a database using this script db2 -v -t "CREATE DATABASE %DBNAME% ON '%DBDRIVE%' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM CATALOG TABLESPACE ...
0
votes
0answers
37 views

DB2 manual asynchrounous real-time replication to NON-DB2 database

I have been given a Proof-of-Concept task to find out whether it is possible to set up manual (=no 3rd party tools allowed) asynchrounous real-time replication in DB2 that replicates all data changes ...
0
votes
0answers
28 views

MySQL manual asynchrounous real-time replication to NON-MySQL database

I have been given a Proof-of-Concept task to find out whether it is possible to set up manual (No 3rd party tools allowed) asynchronous real-time replication in MySQL that replicates all data changes ...
0
votes
0answers
189 views

Export to csv using db2 v10 for z/os

in db2-luw, I can create a csv using the export command. However, running the same command in z/os results in: SQL1325N The remote database environment does not support the command or one of ...
0
votes
0answers
194 views

db2 - after the reboot - database is restarting itself after some time (urgent help needed)

we had to reboot server because storage administrators had to extend storage for db2data. We have 9.7 FP 0 on Linux. After that when we started the DB database is restarting itself after some time. It ...
0
votes
1answer
51 views

DB2 - how to track IOPS statistics?

DB2 9.7. Is there some easy way in every moment go have statistics about IO operations per second? I am not interested for hit ration on Buffer Pool but really on IOPS? THANK YOU
0
votes
2answers
99 views

DBI1011I Error when using db2iupdt to enable Text Search

I'm trying to enable Text Search in my DB2 instance. I'm running this command: # /opt/ibm/db2/V10.5/instance/db2iupdt db2inst1 -j "TEXT_SEARCH,db2j_db2inst1,55000" I get this error: DBI1011I An ...
0
votes
0answers
18 views

What is the “Other” Memory Pool in DB2 LUW?

I have a Memory Pool consuming the better part of my server's memory, but I can't seem to find any proper documentation on what this Memory Pool actually is for. What is the "Other" Memory Pool in ...
0
votes
0answers
35 views

Issue with refactoring columns and how ODBC query receives data

We just installed iSeries 7 box and migrated a database from i5. The migration was to accommodate a new version of vendor's application. They made some changes to the columns by increasing them from ...
0
votes
1answer
131 views

Problem deleting detached partition in DB2 LUW V9.7

Recently in prod environment we are having problems while dropping the detached partitions its giving this error """ DB21034E The command was processed as an SQL statement because it was not a ...
0
votes
0answers
105 views

db2 cannot execute C-function for Reason code 4

I've implemented a function as C code for db2. The library name is called libmyfoo.so and is stored id /usr/local/lib as declared in the External declaration. When I try to execute this function I get ...
0
votes
0answers
12 views

how do we comes to know that a tablespace in dms or automatic storage in db2 udb? [duplicate]

i am b.tech graduate learning db2 udb,i real time(in production) how do we comes to that a specific tablespace is DMS or Automatic storage?
0
votes
1answer
659 views

“connectivity libraries needed are not found” error in IBM Data Studio

UPDATE I am getting the following error when I try to create a new database in IBM Data Studio v3.1.1.0. The connectivity libraries that are needed for local or remote non-JDBC operations were not ...
0
votes
2answers
953 views

Freeware GUI tool for DB2 , usable in Ubuntu Linux [closed]

Are there any freeware user interface tools for DB2 to be used in Linux (Ubuntu 11.04)? RazorSQL is pretty good, but it's not freeware.
-1
votes
1answer
310 views

Important distinctions between DBMSs [closed]

DBA is a career I'm strongly considering after school, but my limited experience mostly involves some PL/SQL Oracle web programming, some basic PHP/MySQL web pages, and some queries in SQL Server. ...
-1
votes
3answers
54 views

Retrieve recently inserted 5 rows [closed]

I want to fetch recently inserted 5 rows from my table. I want to know the sql query for the same. My table is: table xyz ( id integer generated always as identity (start with 1 increment by 1), ...