DB2

5K

Solutions

3

Articles & Videos

2K

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.

Refine results

I need to create a store procedure which calls a CL program.
I want the stored procedure to return the output when called.But when i define a stored procedure with input and output parameters im not …

15 views
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Hi DB2 gurus,

I am trying to compile a simple score to assist in determining the type of tool I will like to have for my new brand new DB2 environment. I have worked with a few but I do need some a…

260 views

I hear db2 can't snapshot... we just have to live with the fact that during backup some oprations (like changes to tables) might hang.... Is this true?

337 views

Experts,

I am able to query a DB2 table from SAS EG using a connection to DB2.
 I can assign a library using:
LIBNAME TST DB2 USER=&USR. PASSWORD=&PWD. DATASRC=&SRC.;

The problem is the lib is…

124 views

Historically our IBM i Developers have done their own "Database Administration".   We recently got a new manager for our IBM i Development team and they are requesting that our System Administrators t…

637 views

Hi,

  I want to check if a Month-Year falls in a date range.
Example: 10-2014 between 01/01/2014 and 12/31/2014

How can i do this in DB2 UDB SQL?

1550 views

Dear Techies,
I have to create a table output based on the following conditions.
Three COLUMNS : TX_Vereinbart, DISCOUNTS, IA_Vereinbart
They all are coming from table called EP101T

The below ar…

453 views

Hi,

  Well, this is an Oracle DBA helping an application user that uses DB2.
 
  I am having the below error register in the event viewer of the database server.

  Also when i execute the co…

3746 views

Is there a query to run in DB2 (or a command to run that would accomplish the same thing) that will show me all tables with an owner of "username".

I know in Oracle - we would run the following com…

252 views

Using DB2 on an iSeries I need to create a query that will produce sales results for the week, month, and year in one query. I can create them individually and my code for the week is as follows:

759 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

I am writing a program where the boss wants the calc specs in RPG Free.  I am struggling with what used to be a simple thing but its not so simple for me in Free format .  The input file has a single …

364 views

I am trying to build a DDL statement off a COBOL program layout.  I have never used COBOL syntax before.

I AM NOT SURE WHAT PIC X(26) , PIC XX OR PIC X MEAN?
Example:
Cobol layout
TIMESTAMP     …

378 views

In DB2 for i (a.k.a. DB2/400) at V6R1, I want to write a SELECT statement that returns some columns from a header record and some columns from ONLY ONE of the matching detail records. It can be ANY of…

363 views

I have extracted data into Microsoft Access from a DB2-based Finance Application.
Now, I want to be able to see the names of fields in a few tables.
I have the odbc connection set up and my script i…

537 views

I had a DB2 table, mytable, with a field named flr that was defined as char(9). A column was added with a alter table mytable add column flr_num generated always as cast(flr as decimal(5,0). After the…

559 views

Hello all,

I have a need to deploy a DB2 tablespace, diagnostic log files and especially the filesystem monitoring for potential "Log full", and/or  "Filesystem Full" situation. I am hoping to "bor…

688 views

I just started a job at a shop that has implemented new standards of programming prior to my hire.  We are to write in RPG free format only the C specs curenlty and and use newer solutions in the RPGL…

5116 views

Could any one help me to convert Goergoin Data to Hijri date given in parameter in SSRS. The parameter is integer type where date is converted as =CInt(Format(DateAdd("d",-1,today()), "yyyyMMdd")) the…

6112 views

Is there a way to insert a row into a Microsoft SQL server table from an SQLRPGLE program? Thanks

593 views
Shellfire Box VPN + Lifetime Subscription

The Shellfire Box easily connects all of your devices, even those that don't offer the possibility to establish a safe vpn connection. Access blocked content and surf safely, no matter where in the world you are located.

How to handle Indicatiors for dynmaic subfile (RPG/DDS) :

Atribute                             Sys1     Sys2     Sys3      Sys4      Sys6      Sys7      Sys8  
Diskstatus                        V…

2195 views

How to mark a field in a subfile record   with special color ?

If there is a condition for the subfile-line-field (columne in this line), the filed should be display in special color.
Because Subf…

483 views

Dear Experts,

We have switchover from our Servers (IBM PureFlex) Remote site to Server (IBM PureFlex) Local site. After switchover when I am trying to connect to STRSQL I am getting following messa…

7186 views

Hi all,

I have a situation where a third-party application accessing a DB2 database periodically fills up the log files
which eventually leads to filesystem full problems. Since we don't have any…

685 views

I am seeing a repeated deadlock scenario in an update query and that query seems to be updating the column with the same value . Loooks fishy , is this a reason for the deadlocks ?

UPDATE BAL SET …

555 views

I know I can catalog a DB2 Database with an Alias.    Is there a way to do the same thing with a TCPIP node?

We would like to test using a new DB2 connect server without breaking the existing conne…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Databases
    (53,323)
  2. IBM System i
    (3,499)
  3. Query Syntax
    (47,076)
  4. Operating Systems
    (34,394)
  5. MS SQL Server
    (156,011)
  6. Oracle Database
    (77,636)
  7. Unix OS
    (32,621)
  8. Java
    (98,408)
  9. MS SQL Server 2005
    (71,382)
  10. Mainframe OS
    (453)