All Questions
22 questions
1
vote
2
answers
662
views
DB2 Linux authentication fails
I have DB2 Express-C v10.5 instance configured to authenticate against LDAP. The LDAP sever is going to be shutdown and I should configure the same DB2 instance to use Linux authentication.
I copied ...
- 111
0
votes
1
answer
641
views
For SSL renewal procedure in Db2 LUW , DO i need to create CSR request for each instance residing in same server?
I am trying to renew my SSL certs . Stuck here if we need to have create a Certificate Signing Request for each instance residing on the same server and send it to CA who will provide us the ...
- 1
0
votes
1
answer
129
views
How to remotely run commands for a DB2 instance, preferably using ibm_db?
My objective is to see the size of Audit Buffer size, normally I would use below command on my Db2 instance
db2 get database manager configuration | grep AUDIT_BUF_SZ
But now I need to do it ...
Divik Shrivastava
1
vote
1
answer
7k
views
db2 expired password but cannot reset
Has anybody encountered this problem with a db2 server? I'm running a development database and connecting to the database gives me a password expired error. Trying to reset it will give me an invalid ...
- 13
0
votes
1
answer
459
views
DB2 reporting incorrect filesystem full error? [closed]
DB2 V10.5, RHEL 7.5
We had an issue when DB2 was stuck not being able to write log files to disk because of disk full error just that there was more than enough free disk space on the filesystem ...
5
votes
1
answer
9k
views
Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error
Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
- 1,225
2
votes
1
answer
73
views
How to reinstall a legacy DB2 Server 7.x for Linux?
We have to move our legacy database dump to a new Linux installation. I know DB2 7.x is out of support for over a decade, but is there a way to obtain a DB2 7.x Server installation media for Linux? ...
- 21
1
vote
1
answer
3k
views
ONLINE BACKUP is not performed from the CRON Job on LINUX server (manually it works)
I made a script which executes successfully online backup when it is run manually by the instance owner.
Script is the following (two lines originally).
#!/bin/bash
/opt/ibm/db2/V9.7/bin/db2 ...
- 695
0
votes
1
answer
5k
views
SQL2542N - No match for a database image file was found based on the source database alias
I'm trying to restore a DB from a Linux system to a Windows. I'm working with DB2 9.7.7. I want to create a new DB with the restored DB.
The DB file has this name: DBBACKUP.0.db2inst1.DBPART000....
- 1
1
vote
1
answer
61
views
How can I create DB2 objects with Linux SUDOer authority?
All,
I am relatively new to Red hat linux and I have SUDOer authority but unable to create DB2 database or other objects. How can I accomplish this task? Please give examples.
Also, is there any ...
- 11
1
vote
3
answers
299
views
Best practice to query administrative views for instance level elements
I want to query a monitor element at instance level (for example the memory used for the instance) via a query like this:
SELECT MEMBER, MAX_MEMBER_MEM, CURRENT_MEMBER_MEM, PEAK_MEMBER_MEM
FROM TABLE(...
- 575
1
vote
1
answer
564
views
command line tool on linux to convert oracle sql into db2 sql
IBM has a GUI based tool to convert Oracle SQL into DB2 SQL.
Is there a command line tool (preferably on linux) that does the same thing? The reason being, we want to do this work as part of a ...
- 251
1
vote
1
answer
404
views
creating 2 database at the same time in db2
Do you know whether it is safe to have in one shell user db2inst1 creating a database A and having another shell the same user creating at the same time database B?
create database A # shell 1
...
4
votes
2
answers
21k
views
db2 database alias not listed via list database directory but still unable to create that database
I am trying to create a database by logging on to the linux server on which the db2 server is installed, as the instance owner
db2 => list database directory
System Database Directory
Number ...
- 251
0
votes
1
answer
3k
views
db2 SQL0930N error on linux - not enough space to process this statement
This is another newbie question on db2, related to space.
How to I start diagnosing and then solving what the problem is so that users can connect to this database?
This error is displayed when both ...
- 251
2
votes
1
answer
8k
views
SQL1641N error on linux while running db2start using db2 express c on linux (LUW) but the file system is not mounted using nosuid
I am trying to install and start db2 on my linux machine using the following script:
#!/usr/bin/env bash
MKDIR=/bin/mkdir
RM=/bin/rm
TAR=/bin/tar
DB2_SERVER_PROGRAM_PATH=/home/alok/Documents/...
- 251
1
vote
1
answer
2k
views
error when trying to connect to remote db2 luw database on linux
I have a db2 client on my local linux machine:
alok@hostname:~$ uname -a
Linux hostname 3.2.0-53-generic #81-Ubuntu SMP Thu Aug 22 21:01:03 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
alok@hostname:~$ ...
- 251
3
votes
2
answers
3k
views
DB2 (LUW) equivalent for Oracle "drop user cascade"
This question is related to creating and initialising test and development databases for an application that has the database running on LUW (linux-unix-windows)
On oracle, we have
an os user (on ...
- 251
3
votes
1
answer
2k
views
db2 LUW help for an oracle user : create database hangs without any output, but database got created
I am new to db2 but have worked on oracle before. Trying to create a database and it succeeds, but the session where I issued a database creation command hangs.
I have installed db2 10.5 on a 64 bit ...
- 251
2
votes
2
answers
1k
views
How can I automate copying DB2 table data between remote Servers?
I have two IBM DB2 servers at separate remote locations.
I need to copy data from several tables on one database on the first server to another database in the second server.
Previously I've used ...
- 143
1
vote
1
answer
660
views
What program to use for the best compression ratio for DB2 log files?
What linux program to use to compress DB2 log files with the best compression ratio?
UPDATE
I thought that these log files would be text type files. But viewing them didn't prove this. I tried to ...
- 143
5
votes
1
answer
225
views
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 ...
- 163