- Blog
- Blog
- Homepage
- Homepage
-
DB2 11- Advanced Featutres
CPU reductions and performance improvements for certain OLTP, heavy insert, select query workloads, and when running queries against compressed tables. Improved data sharing performance and efficiency. Improved utility performance and additional zIIP eligible workload. Cost-effective archiving of warm and cold data with easy access to both within a single query Intelligent statistics gathering and advanced optimization…
-
Mainframe SyncSort: How to Use Learn Today
SyncSort for z/OS is a high-performance sort/merge/copy utility designed to exploit the advanced facilities of the z/OS operating system and zSeries computers. SyncSort for z/OS also supports the OS/390 operating system and S/390 and compatible computers. SyncSort is used in over fifty countries and is the most frequently installed third-party software product on IBM and plug-compatible mainframes. Over 95…
-
Real Questions on Informatica Repository and client Applications
Services: Integration Service – conducts and implements the ETL logic Repository Service – manages connectivity to the metadata repositories, where mapping and workflow definitions are saved Repository Service Process – retrieves, inserts and updates repository metadata. It is a multi-threaded process. Repository – a database which contains the ETL metadata Client Applications: Designer – a developer tool…
-
Exclusive 3 Types of Slowly Changing Dimension
There are 3 types of dimensions that being used in data warehousing projects. These are called Type1, Type2 and Type3 dimensions. Each one has its own purpose. SCD Type 2 is most popular in data warehousing projects.
-
Hadoop Integration With Mainframe Here is Useful Story
Hadoop Integration with Mainframe. Latest development, which helps to get great insights with the Date lying in Mainframe.
-
Life Cycle of Data Processing: Handy Flowchart
The complete life cycle of data science for all developers.
-
DB2: What is Atomic in SQL Query
Use Atomic to insert multiple rows at a time into Table. Explained SQL query to use in Db2.
-
How to Invoke a DB2 Stored Procedure in Mainframe
We can implement stored procedures for DB2 for z/OS including C, C++, COBOL, z/OS Assembler, PL/I, REXX, SQL Procedures language (both external and native), and Java. The parameters required to Store procedures we define in the Linkage section. Nesting Stored Procedure: When one stored procedure calls another stored procedure, it is referred to as a nested procedure call. DB2…
-
10 Top DB2 SQL Common Mistakes
DB2 is popularly use database in mainframe. Developing DB2 applications that show highest perforce is a challenging task. During development, many performance related things you may encounter while working on DB2 applications. Else, it is expensive for the projects, since it takes more CPU time. I am just quoting Craig Mullen’s DB2 expert tips: Assuming an…
-
Pig, Hive, Jaql- Differences
Pig, Hive, and Jaql have much in common. They all translate high-level languages into MapReduce jobs. There are few key differences among those,which help you understand much better of these high level languages.
-
COBOL Low Values Vs High Values
Low values and High values in COBOL explained with examples
Srinimf 