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 for Me (Login required).

Search for additional results

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