DB2 DBA,DB2101,Math News,Equations

 

 

DB2 database zOS software database software mainframe

 

DB2 Cloud DB2 database tables

DB2101.Com

* DB2 News, Jobs, Resources    

* DB2 Products, ISVs, Solutions

* Sysprogs, Linux on z, Tools

* Mainframe Jobs, Software Jobs   

Filter= DB2-DBA

 

  Exact Time

 

 

 

 

        Like us:      Follow us:   
   


 

* Go To Z101.COM *

 

 

 

 

* Internet Search Results 

  *** Search Filter: "DB2-DBA"

  

DB2 — DBA to DBA
Information about DB2: Problem Resolution, How To, Articles, DB2 Chats and Hints

DB2 Materials - DBA to DBA
The Fundamentals tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2® 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation.

How to run REORG, REORGCHK and RUNSTAT on all tables in a ... - DBA to DBA
Write the following scripts in a .out file, then execute it by issuing the db2 command with option -tvf. Reorg for all tables db2 -x "select 'reorg table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,50),';'from syscat.tables where type = 'T' " > reorg.out

HADR and TSA — DBA to DBA
In this example, there is a Active-Passive TSA cluster domain consisting of two nodes (Node1 and Node2) that share a common shared storage consisting of the actual DB2 database files and software.

Monitor CPU, MEM and I/O usage - DBA to DBA
In working with your database, you might notice a certain DB2 process consuming a high amount of CPU space. This section describes some AIX utilities and commands which you can use either to analyze the issue yourself or to gather data before submitting a PMR to IBM Technical Support:

How to list the tablespaces and their % usage — DBA to DBA
To check the tablespaces and their percentage usage you can run the following select command, and connect to the database first. db2 connect to Then run the the select bellow and alter dbname with your database name.

Checking the privileges, authorities and authorizations - DBA to DBA
How to find on System Catalog Views the authorities, privileges and authorizations for a specific user on database

How to create and use sequence on DB2 — DBA to DBA
By default the sequence number starts at one and increments by one at a time and is of an INTEGER data type. The application needs to get the next value in the sequence by using the NEXT VALUE function.

How to grant privileges on DB2 9.7 - DBA to DBA
Grants the database administrator authority. A database administrator holds nearly all privileges on nearly all objects in the database. The only exceptions are those privileges that are part of the access control, data access, and security administrator authorities.

Monitoring performance with SQL -Long running SQL — DBA ... - DBA to DBA
If the status is waiting on User, this means that DB2 is not doing anything, but rather is waiting for the application to do something (like issue the next FETCH or submit the next SQL statement).

 

 

  FIRE101 Jobs: 

  FIREMEN, EMS, Emergency, Rescue

  POLICE101 Jobs:

   Cops,Officers,Security

  Mainframe IT Jobs:

   z/OS, z/VM, DB2, COBOL,QA,INTERNs

  Software Jobs:

   Web, Linux, C++, Java, INTERNs

  Finance Jobs:

   Accounting, INTERNS, Brokers, Invest

  Legal, Lawyer Jobs:

   Paralegals, INTERNs,Law Firms

  Medical, Nurse Jobs:

   Doctors, INTERNs, Nurses, ER

  Genetic, Science Jobs

   Genetics, Research, INTERNs, Labwork

* Latest DB2 Mainframe News

       *** News Filter: "DB2-DBA"

 

 

 

DB2101.COM --- DB2 News, DB2 Software, Linux on System z, Linux, DB2 Jobs, System Programmers, ...

 * Contact us:  Support@Z101.com

Copyright 2007-2025  DB2101.COM