DB2

5K

Solutions

3

Articles & Videos

3K

Contributors

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

Related Topics

  1. Databases
  2. IBM System i
  3. Query Syntax
  4. Operating Systems
  5. Microsoft SQL Server
  6. Oracle Database
  7. Unix OS
  8. Java
  9. Linux
  10. Microsoft SQL Server 2005
Refine results

Greetings!

As I make my transition from working on "DB2 for I" to "DB2 for z/OS", I'm finding subtle differences that are tripping me up.

For example, I copied the following simple stored …

219 views
Major Incident Management Communications
Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

How do I find out to see if there is any open transaction in DB2 database ? in sql server we used to use DBCC OPENTRAN. I am using toad for db2

Many Thanks

233 views

Greetings, experts!

After almost 25 years of working primarily on DB2 for the midrange (AS/400, IBM i), I now have a new job where I need to quickly come up to speed on DB2 for the mainframe …

632 views

Hi,

  How can i disconnect sessions ( idle or active ) from a DB2 database after some period of time.

  I would like to know how to do it for idle and for active connections.

  The problem …

338 views

I have access database that runs 3 business rules and updates a final table in access.  The logic is in the module rule mod.   I need to loop through 1 million row tables in access and perform …

1886 views

I need to pull out only the alpha characters from an ID file not numeric values, but this returns the numeric values as well

Please assist have found the following for DB2
SELECT CIN, …

637 views

Hi,
  We are on DB2 9.7 Linux OS.
We have a Stored Procedure SP_CLIENT_PROGRAM which calls a lot of other Stored Procedures and has a number of tables involved in Select and Inserts.

We have a …

461 views

Is there a difference bwteen selecting rows in the WHERE clause on in the JOIN clause.

For example,

SELECT t2.*
  FROM orderHdr t1
  JOIN orderDtl  t2 on t2.orderno = t1.orderno
  WHERE …

450 views

I'm creating a simple Access frontend for a DB2 table. Using the following code updates the contents of the pass through query correctly but fails to execute the query. What do I need to change to get…

550 views

Hi All,

     We are on DB2 Linux 9.7 database version.
I have a Stored Procedure which returns a result set. I need to store that result set into a table.
How can i do it?
Please advise.

836 views
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have installed Client Access (7.1) on our MS SQL 2014 server.  I am using the IBMDA400 OLE driver to create a linked server to DB2 database one the iSeries. When I run a select statement on the data…

8105 views

Hi All,

   We are on DB2 Linux 9.7 database.
I have a Stored Procedure, which passes the client's first name, last name, DOB and SSN, to retrieve client's information.
In the below query, the …

364 views

i want to check if the Windows server has the following software installed on it.

IBM DB2
IBM IMS
Unisys RDMS
Unisys DMS
Sybase
Oracle

I believe we can check this if there are services …

374 views

This is an ongoing project to sync Office Vision on a 610 (v4r5) to backup system a 170 (v4r4).

We did a full system save of the main system and restored it to the backup system, changed license …

353 views

LPSDT and LPFDT are date and time stored as Packed Decimal. I am attempting to extract the information out and put it in time format and calculate Time Spent.

(CODE)

577 views

Update: I'm trying to sync office vision email changes between to old systems for recovery purposes. Office vision is the only application running both systems:  active system is a 610 v4r5 and the …

569 views

Hi,
Our shop has not used journal until a couple months ago when I added them to a couple master files for audit trail purpose. So, my experience with journaling is very limited. I don’t mind …

887 views

I had this question after viewing How to remove table from super exclusive lock in db2 (https://www.experts-exchange.com/questions/26449737/How-to-remove-table-from-super-exclusive-lock-in-db2.html).

4085 views

I'm asking this for a co-worker.  He has been tasked with migrating data from an IBM AS/400 iSeries DB2 database to a MS SQL 2016 environment.  He tried to use the Microsoft SQL Server Migration …

4112 views
Forrester Webinar: xMatters Delivers 261% ROI
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Hi,
I have two tables join as below giving  results as below:

query:

select a.emplid,a.name,b.erncd
from ps_check a
left outer join ps_earning b
on a.paygroup=b.paygroup
a.line_num …

1067 views

Hi experts,

I have a SQLRPGLE program that has to insert thousands of records (possible from multiple instances)
If the file is full (Msg CPA5305) the program will wait until the QSYSOPR message …

8122 views

Hi,
I'm trying to make a bash script (oslevel = AIX 7100-04-02-1614) that's going to restore my DB2 database from an existing backup into a different database (DB2PRD3 - DB2PRD4)

below are the …

7179 views

Hi,
I have table as below:

emplid  effdt                     date_of_birth
123       2016-01-01            1950-01-01
234       2015-01-01           2000-01-01


result should be:

emplid  …

5100 views

Hi,

We need to start using a new tape each night for the backup and keep these tape indefinitely (long story).  I would like to have BRMS use the tape without enrolling all the tapes.  Can I do …

6109 views

I'm attempting to use a form instead of InputBoxes to grab the data for the variables in my VBA code. This code opens the form but throws error 424: Object Required. I'm not sure how to call the form …

2106 views
Show more content
201506-LO-Top-001

DB2

5K

Solutions

3

Articles & Videos

3K

Contributors

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

Related Topics

  1. Databases
  2. IBM System i
  3. Query Syntax
  4. Operating Systems
  5. Microsoft SQL Server
  6. Oracle Database
Top Experts In
DB2
<
Monthly
>