DBzTech-Technology Dossier

Home
DB2
COBOL
Cloud
JCL
SAS
AI
  • Public Cloud

    Public Cloud is an IT model where services and infrastructure are managed by a third-party provider and shared with multiple organizations using the public Internet. That means it offloads much of the physical responsibility of operating a data center to a third party. This helps to abstract away much of…

    Continue reading →: Public Cloud
  • Private Cloud

    When Organizations uses private dedicated environments, i.e. organization is running an environment where the sole tenant is the company itself. The company is ultimately responsible for maintaining the hardware, software, and networking infrastructure. On premises servers are also referred to as private clouds, just that on premise servers runs in…

    Continue reading →: Private Cloud
  • How COMP-3 Saves Space-In COBOL

    Having a clear understanding of Zoned Decimal format is essential before diving into Packed Decimal (COMP-3) format in COBOL. In Packed Decimal format, each byte’s zone portion stores the next numeric digit, allowing two digits to be packed into a single byte—hence the name packed decimal. Each byte in a…

    Continue reading →: How COMP-3 Saves Space-In COBOL
  • What is Zoned Decimal In COBOL

    The two computer codes mostly used for internal binary representation are EBCDIC and ASCII. Mainframe uses EBCDIC coding system. In EBCDIC, each byte consists of eight bits which are subdivided into two 4 bit segment; The Zone part(First 4 bits) and the Digit part(last 4 bits).For Reference the following table…

    Continue reading →: What is Zoned Decimal In COBOL
  • Buffer Pool In DB2

    In IBM Db2 databases, data is physically stored on disk across multiple files. Each file is divided into fixed-size blocks known as pages, which serve as the smallest unit of data exchange between disk storage and main memory. To optimize DB2 database performance, it is critical to keep as many…

    Continue reading →: Buffer Pool In DB2
  • Catalog Tables In DB2

    The word catalog signifies a list of items. When DB2 is installed, DB2 creates a set of tables which stores the information about DB2 objects as and when it gets created/updated, like definition of the objects, security information, statistical information etc. The information of every object known and available to…

    Continue reading →: Catalog Tables In DB2
  • Identity Column in DB2

    This identifier is a number that is updated sequentially as new records are added. In DB2, this feature will automatically generate the values. The values for an identity column can be generated by the Db2 database manager in two ways using the keywords ALWAYS or BY DEFAULT. When using GENRATED ALWAYS keyword,…

    Continue reading →: Identity Column in DB2
  • Database Objects in IBM DB2

    A database is an organized collection of related objects. Broadly the database objects can be classified as :TablesAliasesSynonymsViewsIndexesTable spacesIndex spacesDatabasesStorage groups. In this post we will see types of tables. In subsequent posts, we will visit the other DB objects Tables: A table is an unordered set of data records.…

    Continue reading →: Database Objects in IBM DB2
  • What is SMS in mainframe ? -Understanding z/OS Storage Management Subsystem (SMS)

    Introduction: The Storage Management Subsystem (SMS) automates the use of storage for data sets.  The system is not aware of how much space a dataset will need, where it will be stored(Disk or Tape) ,what will be its record format and other details. Z/OS storage team need to decide whether…

    Continue reading →: What is SMS in mainframe ? -Understanding z/OS Storage Management Subsystem (SMS)
Previous Page

AI Bare Metal BigQuery Cloud Cloud SQL COBOL comp comp-3 comp-5 CONSTRAINTS Container database Data Lake Dataset contention Data Warehouse DB2 Docker FaaS GCF GCP Google App Engine Google Cloud Google Cloud Function google Cloud run Google cloud spanner Google Cloud Storage ISPF Command JCL JCL command LLM Mainframe ML NoSQL Datasbse packed decimal in cobol PROC SQL SAS SAS SAS in Mainframe SAS mainframe Serverless Apps sql technology TSO Command VSAM z/OS SAS tutorial ZONED DECIMAL IN COBOL

DBzTech-Technology Dossier

  • Pinterest
  • Instagram
  • Facebook
  • Mail

Blog at WordPress.com.

Notifications