3 votes

How to send and use the V7R3 created program object in V7R2 version of iseries/AS400?

SAVOBJ TGTRLS(V7R2M0) is what you need. However, the object has to be compatible with that prior release. Using the DSPxxx commands, such as DSPOBJD, DSPPGM you can see what version the object was ...
Charles's user avatar
  • 311
2 votes

ansible - Run "command db2 update database manager configuration using svcename db2c_db2inst1" as db2 user

Modify your last task like this: tasks: - name: setup svcename db2c_db2inst1 shell: db2 update database manager configuration using svcename db2c_db2inst1 become: yes ...
13dimitar's user avatar
  • 2,546
2 votes

Is it possible to build a queue sharing group on only a coupling facility and not use db2?

While it is true that you can create a Queue Sharing Group (QSG) that does not store messages in DB2, you still need DB2 for object definitions, and thus DB2 is still a pre-requisite to creating a QSG....
Morag Hughson's user avatar
1 vote

How to setup privileged in docker swarm?

As already said in the answer by mac, swarm mode does not support privileged mode still. There is a hacky workaround though if you want to run privileged containers in swarm today: Just create an ...
user11784's user avatar
1 vote

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

I think the easiest way would be to configure db2 audit on this specific table and then analize audit logs/records according to what do you want to track. Auditing can be configure to write to file ...
Aljaz Vidmar's user avatar
1 vote

Monitor SQL statements in DB2

I think, that I found the solution http://db2commerce.com/2013/12/03/using-an-event-monitor-to-capture-statements-with-values-for-parameter-markers/ (this link isn't working anymore. Use archive.org - ...
Alojzij Blatnik's user avatar
1 vote
Accepted

How do I know when a new IBM DB2 Express-C version is released?

DB2 Express-C has been withdrawn, so this question is no longer relevant. It has been replaced by Db2 11.5 Community License Edition.
Ian Bjorhovde's user avatar
1 vote
Accepted

Activation key part number for Db2 Data Server Client 11.5?

Got it, as explained here SQL1598N error connecting to mainframe DB2 from IBM Data Server Driver even though DB2 Connect license file exists in the license directory of the install path It is ...
rhellem's user avatar
  • 305
1 vote
Accepted

ODBC Driver for IBM iSeries AS400 version V7R1

The tool is no longer called iSeries Access, but IBM i Access Client Solutions. Look here, and scroll down to the bottom of the page for Linux Application Package. But, the last line on the page says ...
jmarkmurphy's user avatar
1 vote

ansible - Run "command db2 update database manager configuration using svcename db2c_db2inst1" as db2 user

Give the full path to your db2 binary.
EEAA's user avatar
  • 110k
1 vote
Accepted

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

With current versions of DB2 for Linux/Unix/Windows, such a function is not available. That is for a good reason. It is significantly safer and faster to export to a flat file (or an IXF file) and ...
mao's user avatar
  • 186
1 vote

IBM DB2 9.7, force all connections of a specific database

I use the following steps, and it works. db2 connect to TFBDW db2 list application for database TFBDW db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS; db2 "force application (39)" db2 CONNECT RESET ...
Kate YAN's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible