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

Db2 backup only transaction log files

What is the possibility to take transaction log (Archive log) backup in Db2 database. I know that online backup takes archive log backup by default but what If I want the archive log backup after few hours of online incremental backup.
Naveed
  • 3
  • 2
0
votes
2 answers

DB2 users and groups

Just want to know everyone's experience and take on managing users/authentication on a multi-node db2 cluster with users groups. I have 17 apps in production (project based company, only 2 online apps), and some 30 users with 7 groups. prodsel -…
Arun Srini
  • 43
  • 6
0
votes
2 answers

DB2 10.5 HADR read only standby applications don't reconnect to primary

Scenario: server SERV_A, database DBNAME primary server SERV_B, database DBNAME standby with DB2_HADR_ROS enabled Then this situation occurs: connection CON is made from client to DBNAME when primary is on SERV_A takeover DBNAME to SERV_B -> DBNAME…
Aljaz Vidmar
  • 165
  • 4
0
votes
1 answer

How to track db2 database changes from linux without triggers or db modification

I've got an assignment where I need to create a shell script to track just the changes to the employees table (DB2 database) record for any insert, delete or update that the HR department perform to users hourly. No need for SQL or bash code. Just…
egmweb
  • 11
  • 5
0
votes
0 answers

Unable to install php_ibm_db2.dll on PHP 5.6

I'm getting the following error when trying to start Apache. I've confirmed the extension is in the folder and other extensions such as sqlsrv work just fine. This is the only one that seems to fail on load. I'm running 32-bit PHP and…
Julio Villalba
  • 41
  • 1
  • 5
0
votes
1 answer

How to do REORG command on DB2

I want to reorganize(offline) some db2 tables. Also I want to executing runstats command after reorg command. I have a question. Do I need to stop db2 database or deactivate or both of them before executing reorg command?
tekun
  • 3
  • 5
0
votes
1 answer

DB2 and Linux remote server replication

I'm using DB2 10.5 and SLES 11 SP4. My Question is, how would I replicate a remote server's db without having to ssh in and manually export/import.
Malan
  • 31
  • 1
  • 6
0
votes
1 answer

DB2: How to retain backups if automatic backup is enabled

Is there a way to retain the backups or configure the interval when they are deleted? According the manuals it's not possible: "If backup to disk is selected, the automatic backup feature will regularly delete backup images from the directory…
sahhai
  • 1
0
votes
1 answer

Export Data from IBM DB2 into an SQL-INSERT Skript using IBM Data Studio Client or another tool

I have here a running IBM DB2 Database. I would like to export data from some tables into an SQL-Insert Skript, for example for the table T1 with the following content: --------------- | Col1 | Col2 | --------------- | 1 | Foo …
erg
  • 223
  • 2
  • 8
0
votes
1 answer

Confused about database names and remote locations on AS400

I'm taked with buildig a web service that gets it's data from an old AS400 database server. I'm trying to connect over nodejs using https://github.com/ibmdb/node-ibm_db and i'm getting this error on most databases. SQL30061N The database alias or…
Joaquin Brandan
  • 133
  • 1
  • 5
0
votes
1 answer

IBM Cognos Business Intelligence 10.2.2 on WebSphere Application Server 7.0.0.29 fails to start, possibly due to a missing classpath entry

I have a server running IBM AIX 6.1.7.15 TL07 and I am trying to install Cognos Business Intelligence 10.2.2 on WebSphere Application Server Network Deployment 7.0.0.29, using a server cluster to deploy and manage my application and using an IBM DB2…
RAKK
  • 151
  • 1
  • 8
0
votes
1 answer

Making RUNSQLSTM Display errors interactively

If I run the command RUNSQLSTM SRCFILE(ZIPPY19811/QSQLSRC) SRCMBR(JUSTIN) from the greenscreen, I get the status message RUNSQLSTM command failed. but to get the actual error message I have to do a WRKSPLF. Is there any way I could get the error…
Justin Dearing
  • 1,037
  • 12
  • 33
0
votes
1 answer

DB2 Scale out for vendor solution

Currently I'm dealing with a vendor application that uses DB2 Workgroup Server Edition 10.1 on Windows Server 2012 . Right now I'm able to scale up as demand increases, but eventually we will hit a limit in terms of CPU. The application produces…
Beans
  • 125
  • 4
0
votes
1 answer

DB2 crash on production redhat server

We have a redhat virtual machine (vmware vsphere) that is hosting the database for our application. The application runs normally, until at some point it crashes with the error below seen on db2diag: 2015-03-05-14.35.13.380939+000 E1406160203E1391 …
hamzahir
  • 1
  • 2
0
votes
1 answer

Does DB2 accept SSL3 connections?

Does DB2 allow connection through Secure Sockets Layer version 3 (SSL3)? To be more exact, will a program using SSL3 connection get an access to DB2? or will it fail? If it does accept it, is there away to disable it?
M. A. Kishawy
  • 109
  • 4
1 2 3
4
5 6 7 8