2085367 - The DDLGEN utility fails to generate correct DDL for CREATE DATABASE using WITH DBID = <value> - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2085367 - The DDLGEN utility fails to generate correct DDL for CREATE DATABASE using WITH DBID = <value> - SAP ASE

Symptom

  • CREATE DATABASE executed with syntax similar to:

         create database ddltest on datadev = 10 log on logdev = 10 with dbid = 9

  • DDLGEN utility executed to generate a DDL script for the ddltest database:

         ddlgen -Usa -Pxxx -Sxxx -TDB -Nddltest -O/tmp/ddltest.out


  • DDLGEN output file for the CREATE DATABASE looks similar to:

         CREATE DATABASE ddltest
                     ON datadev = '10M' -- 2560 pages
                 LOG ON logdev = '10M' -- 2560 pages
         WITH DURABILITY = FULL
         go


  • DDLGEN fails to generate CREATE DATABASE syntax that includes WITH DBID = 9

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

DDLGEN, DDL , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.