What does Atlan crawl from IBM Db2 for z/OS?
Metadata Atlan extracts from IBM Db2 for z/OS - databases, schemas, tables, views, columns, stored procedures, and functions - mapped to Atlan assets.
Atlan extracts metadata for databases, schemas, tables, views, columns, stored procedures, and functions from the IBM Db2 for z/OS system catalog and maps each property to its internal asset model. The tables below list which source properties Atlan reads and how they appear on the corresponding Atlan asset.
Atlan automatically excludes the system schemas SYSIBM, SYSPROC, SYSSTAT, SYSCTRL, SYSFUN, SYSIBMTS, NULLID, DSNRGCOL, DSNRGNXT, DSNUTILS, and DSNTRACE, along with Db2 directory and catalog databases (DSNDB0*), work-file databases, and implicitly created databases.
Asset types
| Source object | Atlan asset type |
|---|---|
| Database | Database |
| Schema, that is, a table or routine qualifier | Schema |
| Base table | Table |
| View | View |
| Column of a table or view | Column |
| Stored procedure | Procedure |
| User-defined function | Function |
Atlan doesn't catalog materialized query tables, aliases, synonyms, history tables, global temporary tables, indexes, triggers, or sequences.
Databases
Atlan maps databases to its Database asset type.
| Source property | Atlan property | Description |
|---|---|---|
NAME | name | Database name |
CREATOR | sourceCreatedBy | Authorization ID that created the database |
| Number of schemas that own tables in the database | schemaCount | Count derived during the crawl |
Schemas
Atlan derives schemas from the qualifiers of the tables and views it crawls, combined with the qualifiers of the stored procedures and functions it crawls. This means a schema that owns only routines still appears in Atlan.
| Source property | Atlan property | Description |
|---|---|---|
CREATOR or SCHEMA | name | Schema name |
| Number of tables | tableCount | Count derived during the crawl |
| Number of views | viewsCount | Count derived during the crawl |
| Databases whose tables the schema owns | sqlDatabases | Set of related Database assets |
In Db2 for z/OS, a schema's tables can live in several databases through their table spaces, so a schema is a peer of the databases rather than a child of one. Atlan reflects this by relating each schema to every database whose tables it owns.
Tables
Atlan maps base tables to its Table asset type.
| Source property | Atlan property | Description |
|---|---|---|
NAME | name | Table name |
CREATOR | schemaName | Owning schema |
DBNAME | databaseName | Database that holds the table's table space |
REMARKS | description | Table comment |
CREATEDBY | sourceCreatedBy | Authorization ID that created the table |
CREATEDTS | sourceCreatedAt | Creation timestamp |
ALTEREDTS | sourceUpdatedAt | Last alteration timestamp |
| Number of columns | columnCount | Recounted from the columns Atlan crawled |
Views
Atlan maps views to its View asset type. Db2 stores long view text as numbered fragments, so Atlan reassembles the statement in sequence order and uses it to generate lineage to the view's source tables.
| Source property | Atlan property | Description |
|---|---|---|
NAME | name | View name |
CREATOR | schemaName | Owning schema |
DBNAME | databaseName | Database that holds the view |
| View statement text | definition | View SQL, reassembled from its fragments |
REMARKS | description | View comment |
CREATEDBY | sourceCreatedBy | Authorization ID that created the view |
CREATEDTS | sourceCreatedAt | Creation timestamp |
ALTEREDTS | sourceUpdatedAt | Last alteration timestamp |
| Number of columns | columnCount | Recounted from the columns Atlan crawled |
Columns
Atlan maps columns of tables and views to its Column asset type.
| Source property | Atlan property | Description |
|---|---|---|
NAME | name | Column name |
COLNO | order | Ordinal position |
COLTYPE | dataType | Db2 data type |
LENGTH | maxLength | Declared length |
SCALE | numericScale | Numeric scale, when non-zero |
NULLS | isNullable | Whether the column accepts nulls |
KEYSEQ | isPrimary | True when the column belongs to the primary key |
| Foreign key membership | isForeign | True when the column belongs to a foreign key |
REMARKS | description | Column comment |
Stored procedures
Atlan maps stored procedures to its Procedure asset type. The procedure body is used to generate lineage.
| Source property | Atlan property | Description |
|---|---|---|
NAME | name | Procedure name |
SCHEMA | schemaName | Owning schema |
TEXT | definition | Procedure body |
LANGUAGE | sqlLanguage | Implementation language |
REMARKS | description | Procedure comment |
OWNER | sourceCreatedBy | Authorization ID that owns the procedure |
CREATEDTS | sourceCreatedAt | Creation timestamp |
ALTEREDTS | sourceUpdatedAt | Last alteration timestamp |
Functions
Atlan maps user-defined functions to its Function asset type. The function body is used to generate lineage.
| Source property | Atlan property | Description |
|---|---|---|
NAME | name | Function name |
SCHEMA | schemaName | Owning schema |
TEXT | functionDefinition | Function body |
LANGUAGE | functionLanguage | Implementation language |
REMARKS | description | Function comment |
OWNER | sourceCreatedBy | Authorization ID that owns the function |
CREATEDTS | sourceCreatedAt | Creation timestamp |
ALTEREDTS | sourceUpdatedAt | Last alteration timestamp |
Lineage
Atlan generates lineage by parsing the SQL definitions of views, stored procedures, and functions. Query history mining and usage metrics aren't supported for Db2 for z/OS.
See also
- Set up IBM Db2 for z/OS: Configure authentication and permissions
- Crawl IBM Db2 for z/OS: Configure and run the crawler