DB2 - Table Like parameter

First Page
Next Page

DB2 Table Like parameter

For the driver to create and bind packages with your user ID, these privileges are required: BINDADD for binding packages, CREATEIN for the collection specified by the Package Collection option, and GRANT EXECUTE for the PUBLIC group for executing the packages. Typically, a Database Administrator (DBA) has these privileges. If your user ID does not have these privileges, someone that has a user ID with DBA privileges must create packages by connecting to the connectivity service.

When connecting for the first time, the connectivity service determines whether bind packages exist on the server. If packages do not exist, the service creates them using the default values. The following basic information enables you to connect with your data source and test your connection after installation.

  • General tab

  • OData tab

  • Security tab

  • Advanced tab

What is DB2 Table Like parameter ?

LIKE used to create a new table as the same as the existing table. In other words, creating a table that has exactly the same name and description as the columns of the identified table or view. The table name specified after LIKE should be identified in the existing system.

Syntax

CREATE TABLE Table name
	(Column1 data-type [NOT][NULL] [WITH DEFUALT default-value],
	 Column2 data-type [NOT][NULL] [WITH DEFUALT default-value],
	 Column3 data-type [NOT][NULL] [WITH DEFUALT default-value],
		.
		.
	 Column-n data-type [NOT][NULL] [WITH DEFUALT default-value]
	 Primary key/foreign key column1,column2….column-n,
	 [LIKE reference table name]
  ON database-name.tablespace-name)

DB2 configuration parameters

Configuration parameters identify database objects to be stored in the database. Their corresponding values identify how the object will be stored in the database. The parameters and their configuration strings are grouped by configuration keywords. In geodatabases stored in an IBM DB2 database, parameter name–configuration string pairs are used by ArcGIS to do the following -

  • Establish the storage characteristics of tables and indexes.

  • Define how XML documents are stored.

  • Make keywords available for users in the ArcGIS interface.

  • Provide comments that describe the configuration keyword.

If you want to create a geodatabase in DB2 on an IBM z operating system (z/OS), you must uncomment and alter parameters in the dbtune.sde configuration file before you create the geodatabase. If you do not uncomment and provide storage information for these parameters prior to creating the geodatabase, the geodatabase will not be functional because tables will be created in the wrong database in the subsystem.

To alter these values prior to geodatabase creation, open the dbtune.sde file for DB2 z/OS that is installed in the DatabaseSupport folder of the ArcGIS client installation directory from which you will run the Enable Enterprise Geodatabase tool. Uncomment and change values in this file before running the tool to create the geodatabase.

First Page
Next Page