Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [db2]

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

108 questions
0
votes
1 answer

Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some instructions on how I should proceed:…
Felipe
  • 113
  • 1
  • 7
0
votes
1 answer

How can I uninstall ‘DB2 Enterprise Server Edition – SAPDB2SMP without the server crashing?

In 'Control Panel | Programs | Programs and Features' of Windows Server 2008, I can see an entry for ‘DB2 Enterprise Server Edition – SAPDB2SMP’. When I select it and choose ‘Uninstall’, it goes though part of the uninstall process, then causes the…
Techboy
  • 1,550
  • 7
  • 31
  • 49
0
votes
1 answer

Create alias for UNIX username in LDAP for DB2

I want to use LDAP data for the authentication process in DB2. I have already configured DB2 via PAM to retrieve the information of the NIS server that is in the ActiveDirectory. It works perfect with usernames that have 8 characters or less. I…
AngocA
  • 111
  • 5
0
votes
2 answers

How to change the collation of a table/column?

I know, there is the database configuration parameter "Database collating sequence" for setting the collation in db2. But since this effects the whole database and can only be set when creating it, I'm looking for the possibility for setting this…
Tim Büthe
  • 352
  • 2
  • 5
  • 16
0
votes
0 answers

AIX JFS2 I/O performance problems

I have a fresh installation of AIX 7.1. I noticed that JFS2 file system with logging enabled (log=/dev/hd8) is dramatically slower than one with log=NULL. Simple zip archive extraction takes 5 minutes with logging enabled vs 5 seconds with no…
vooD
  • 101
  • 3
0
votes
0 answers

Windows DB2 9.7 FP8 - The request failed because private virtual memory could not be allocated. SQLSTATE=57011

I have a Windows DB2 9.7 FP8 server running on Windows 2003 x86 that for some reason every time I launch Center Administrator or the CLI and try to connect to a database, I get the error "[IBM][CLI Driver] SQL1219N The request failed because private…
user500741
  • 123
  • 4
0
votes
1 answer

php_ibm_db2.dll on IIS 7.5 using PHP 5.3 error message

I'm trying to use ibm_db2 extension to access iSeries DB2 database. This is the testcode (taken from here)
grmbl
  • 155
  • 1
  • 9
0
votes
2 answers

DB2 Client v9.5 on Win 2003 Taking Long time to establish Connection

I have a ASP.NET application running on Windows 2003 that needs to communicate with a DB2 database that resides on the mainframe. We installed DB2 Client driver v9.5 on our server so the application can perform the connection and work with the…
Justin Largey
  • 129
  • 1
  • 7
0
votes
1 answer

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event monitors? I'm currently using DB2 9.7 but am…
Jason Axelson
  • 334
  • 1
  • 5
  • 17
0
votes
2 answers

No match for a database image file was found based on the source database alias "URCDB"

I used IBM Data Studio to backup a test database named URCTEST. Now, I want to restore it to the actual (empty) database, URCDB. I've got little experience with IBM DB2, so I assumed this was something similar to SQL Server, where I can create a…
zack_falcon
  • 165
  • 2
  • 11
0
votes
1 answer

DB2-Express-C and Postgresql using raw harddrive as datastore

I have a system running Solaris with 2 harddrives. One holding the OS and the other unpartitioned. I was thinking about using the second as database space. My question is, if it is possible to let DB2-Express-C or Postgresql use the second harddrive…
Michael Maenz
  • 3
  • 1
0
votes
1 answer

How do I configure SMTP for DB2 9.5?

During install I know the wizard asks for an SMTP server for notification. But I can't find these properties now when we really need it. We're running on Windows Server 2008.
Tommy
  • 195
  • 1
  • 2
  • 9
0
votes
1 answer

OS LDAP auth when LDAP server located in same machine

Is it normal to make LDAP authorization on Linux OS (CentOS 6.3) when LDAP server will run on same machine? I think I can't make authetication through LDAP when I start operating system, because my LDAP server will be still not loaded at boot…
MyTitle
  • 551
  • 1
  • 8
  • 18
0
votes
1 answer

Why does database of db2 HADR standby server deactivate automatically?

Im trying to configure SAP HADR with the primary and standby server. Configurations seems to be ok but the database of standby server deactivates automatically. When i run the command db2 activate database in the standby server it will successfully…
user1540349
  • 1
  • 1
0
votes
1 answer

What causes DB2 to have log file times out of order?

I routinely see the following in the logs of a DB2 LUW 9.7.4 server: -rw------- 1 db2inst1 db2iadm1 129M Feb 23 11:20 S0000045.LOG -rw------- 1 db2inst1 db2iadm1 129M Feb 23 12:10 S0000046.LOG -rw------- 1 db2inst1 db2iadm1 129M Feb 23 13:05…
benjarrell
  • 188
  • 1
  • 8
1 2 3 4
5
6 7 8