ibm 1.85.0-beta0 published on Wednesday, Oct 29, 2025 by ibm-cloud
ibm.Db2
Example Usage
To find an example for provisioning and configuring a Db2 SaaS instance , see here.
Example coming soon!
Example coming soon!
Example coming soon!
Example coming soon!
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.ibm.IbmFunctions;
import com.pulumi.ibm.inputs.GetResourceGroupArgs;
import com.pulumi.ibm.Db2;
import com.pulumi.ibm.Db2Args;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var group = IbmFunctions.getResourceGroup(GetResourceGroupArgs.builder()
.name("<your_group>")
.build());
var _yourDatabase_ = new Db2("<yourDatabase>", Db2Args.builder()
.service("dashdb-for-transactions")
.plan("performance")
.location("us-south")
.resourceGroupId(group.applyValue(getResourceGroupResult -> getResourceGroupResult.id()))
.serviceEndpoints("public-and-private")
.instanceType("bx2.4x16")
.highAvailability("yes")
.backupLocation("us")
.diskEncryptionInstanceCrn("none")
.diskEncryptionKeyCrn("none")
.oracleCompatibility("no")
.subscriptionId("<id_of_subscription_plan>")
.timeouts(Db2TimeoutsArgs.builder()
.create("720m")
.update("30m")
.delete("30m")
.build())
.build());
}
}
resources:
<yourDatabase>:
type: ibm:Db2
properties:
service: dashdb-for-transactions
plan: performance
location: us-south
resourceGroupId: ${group.id}
serviceEndpoints: public-and-private
instanceType: bx2.4x16
highAvailability: yes
backupLocation: us
diskEncryptionInstanceCrn: none
diskEncryptionKeyCrn: none
oracleCompatibility: no
subscriptionId: <id_of_subscription_plan>
timeouts:
- create: 720m
update: 30m
delete: 30m
variables:
group:
fn::invoke:
function: ibm:getResourceGroup
arguments:
name: <your_group>
Sample Db2 SaaS instance using users_config attribute
Example coming soon!
Example coming soon!
Example coming soon!
Example coming soon!
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.ibm.IbmFunctions;
import com.pulumi.ibm.inputs.GetResourceGroupArgs;
import com.pulumi.ibm.Db2;
import com.pulumi.ibm.Db2Args;
import com.pulumi.ibm.inputs.Db2UsersConfigArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var group = IbmFunctions.getResourceGroup(GetResourceGroupArgs.builder()
.name("<your_group>")
.build());
var _yourDatabase_ = new Db2("<yourDatabase>", Db2Args.builder()
.service("dashdb-for-transactions")
.plan("performance")
.location("us-south")
.resourceGroupId(group.applyValue(getResourceGroupResult -> getResourceGroupResult.id()))
.serviceEndpoints("public-and-private")
.instanceType("bx2.4x16")
.highAvailability("yes")
.backupLocation("us")
.diskEncryptionInstanceCrn("none")
.diskEncryptionKeyCrn("none")
.oracleCompatibility("no")
.subscriptionId("<id_of_subscription_plan>")
.timeouts(Db2TimeoutsArgs.builder()
.create("720m")
.update("30m")
.delete("30m")
.build())
.usersConfigs(Db2UsersConfigArgs.builder()
.email("test_user@mycompany.com")
.iam(false)
.ibmid("test-ibm-id")
.locked("no")
.name("test_user")
.password("dEkMc43@gfAPl!867^dSbu")
.role("bluuser")
.authentications(Db2UsersConfigAuthenticationArgs.builder()
.method("method")
.policyId("policy_id")
.build())
.build())
.build());
}
}
resources:
<yourDatabase>:
type: ibm:Db2
properties:
service: dashdb-for-transactions
plan: performance
location: us-south
resourceGroupId: ${group.id}
serviceEndpoints: public-and-private
instanceType: bx2.4x16
highAvailability: yes
backupLocation: us
diskEncryptionInstanceCrn: none
diskEncryptionKeyCrn: none
oracleCompatibility: no
subscriptionId: <id_of_subscription_plan>
timeouts:
- create: 720m
update: 30m
delete: 30m
usersConfigs:
- email: test_user@mycompany.com
iam: false
ibmid: test-ibm-id
locked: no
name: test_user
password: dEkMc43@gfAPl!867^dSbu
role: bluuser
authentications:
- method: method
policyId: policy_id
variables:
group:
fn::invoke:
function: ibm:getResourceGroup
arguments:
name: <your_group>
Sample Db2 SaaS instance using allowlist_config attribute
Example coming soon!
Example coming soon!
Example coming soon!
Example coming soon!
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.ibm.IbmFunctions;
import com.pulumi.ibm.inputs.GetResourceGroupArgs;
import com.pulumi.ibm.Db2;
import com.pulumi.ibm.Db2Args;
import com.pulumi.ibm.inputs.Db2AllowlistConfigArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var group = IbmFunctions.getResourceGroup(GetResourceGroupArgs.builder()
.name("<your_group>")
.build());
var _yourDatabase_ = new Db2("<yourDatabase>", Db2Args.builder()
.service("dashdb-for-transactions")
.plan("performance")
.location("us-south")
.resourceGroupId(group.applyValue(getResourceGroupResult -> getResourceGroupResult.id()))
.serviceEndpoints("public-and-private")
.instanceType("bx2.4x16")
.highAvailability("yes")
.backupLocation("us")
.diskEncryptionInstanceCrn("none")
.diskEncryptionKeyCrn("none")
.oracleCompatibility("no")
.subscriptionId("<id_of_subscription_plan>")
.timeouts(Db2TimeoutsArgs.builder()
.create("720m")
.update("30m")
.delete("30m")
.build())
.allowlistConfigs(Db2AllowlistConfigArgs.builder()
.ipAddresses(Db2AllowlistConfigIpAddressArgs.builder()
.address("127.0.0.1")
.description("A sample IP address")
.build())
.build())
.build());
}
}
resources:
<yourDatabase>:
type: ibm:Db2
properties:
service: dashdb-for-transactions
plan: performance
location: us-south
resourceGroupId: ${group.id}
serviceEndpoints: public-and-private
instanceType: bx2.4x16
highAvailability: yes
backupLocation: us
diskEncryptionInstanceCrn: none
diskEncryptionKeyCrn: none
oracleCompatibility: no
subscriptionId: <id_of_subscription_plan>
timeouts:
- create: 720m
update: 30m
delete: 30m
allowlistConfigs:
- ipAddresses:
- address: 127.0.0.1
description: A sample IP address
variables:
group:
fn::invoke:
function: ibm:getResourceGroup
arguments:
name: <your_group>
Sample Db2 SaaS instance using autoscale_config attribute
Example coming soon!
Example coming soon!
Example coming soon!
Example coming soon!
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.ibm.IbmFunctions;
import com.pulumi.ibm.inputs.GetResourceGroupArgs;
import com.pulumi.ibm.Db2;
import com.pulumi.ibm.Db2Args;
import com.pulumi.ibm.inputs.Db2AutoscaleConfigArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var group = IbmFunctions.getResourceGroup(GetResourceGroupArgs.builder()
.name("<your_group>")
.build());
var _yourDatabase_ = new Db2("<yourDatabase>", Db2Args.builder()
.service("dashdb-for-transactions")
.plan("performance")
.location("us-south")
.resourceGroupId(group.applyValue(getResourceGroupResult -> getResourceGroupResult.id()))
.serviceEndpoints("public-and-private")
.instanceType("bx2.4x16")
.highAvailability("yes")
.backupLocation("us")
.diskEncryptionInstanceCrn("none")
.diskEncryptionKeyCrn("none")
.oracleCompatibility("no")
.subscriptionId("<id_of_subscription_plan>")
.timeouts(Db2TimeoutsArgs.builder()
.create("720m")
.update("30m")
.delete("30m")
.build())
.autoscaleConfigs(Db2AutoscaleConfigArgs.builder()
.autoScalingEnabled("true")
.autoScalingThreshold("60")
.autoScalingOverTimePeriod("15")
.autoScalingPauseLimit("70")
.autoScalingAllowPlanLimit("true")
.build())
.build());
}
}
resources:
<yourDatabase>:
type: ibm:Db2
properties:
service: dashdb-for-transactions
plan: performance
location: us-south
resourceGroupId: ${group.id}
serviceEndpoints: public-and-private
instanceType: bx2.4x16
highAvailability: yes
backupLocation: us
diskEncryptionInstanceCrn: none
diskEncryptionKeyCrn: none
oracleCompatibility: no
subscriptionId: <id_of_subscription_plan>
timeouts:
- create: 720m
update: 30m
delete: 30m
autoscaleConfigs:
- autoScalingEnabled: 'true'
autoScalingThreshold: '60'
autoScalingOverTimePeriod: '15'
autoScalingPauseLimit: '70'
autoScalingAllowPlanLimit: 'true'
variables:
group:
fn::invoke:
function: ibm:getResourceGroup
arguments:
name: <your_group>
Sample Db2 SaaS instance using custom_setting_config attribute
Example coming soon!
Example coming soon!
Example coming soon!
Example coming soon!
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.ibm.IbmFunctions;
import com.pulumi.ibm.inputs.GetResourceGroupArgs;
import com.pulumi.ibm.Db2;
import com.pulumi.ibm.Db2Args;
import com.pulumi.ibm.inputs.Db2CustomSettingConfigArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var group = IbmFunctions.getResourceGroup(GetResourceGroupArgs.builder()
.name("<your_group>")
.build());
var _yourDatabase_ = new Db2("<yourDatabase>", Db2Args.builder()
.service("dashdb-for-transactions")
.plan("performance")
.location("us-south")
.resourceGroupId(group.applyValue(getResourceGroupResult -> getResourceGroupResult.id()))
.serviceEndpoints("public-and-private")
.instanceType("bx2.4x16")
.highAvailability("yes")
.backupLocation("us")
.diskEncryptionInstanceCrn("none")
.diskEncryptionKeyCrn("none")
.oracleCompatibility("no")
.subscriptionId("<id_of_subscription_plan>")
.timeouts(Db2TimeoutsArgs.builder()
.create("720m")
.update("30m")
.delete("30m")
.build())
.customSettingConfigs(Db2CustomSettingConfigArgs.builder()
.dbs(Db2CustomSettingConfigDbArgs.builder()
.actSortmemLimit("NONE")
.altCollate("IDENTITY_16BIT")
.appgroupMemSz("1000")
.applheapsz("AUTOMATIC")
.applMemory("AUTOMATIC")
.appCtlHeapSz("500")
.archretrydelay("60")
.authnCacheDuration("300")
.autorestart("ON")
.autoCgStats("OFF")
.autoMaint("ON")
.autoReorg("OFF")
.autoReval("IMMEDIATE")
.autoRunstats("ON")
.autoSampling("OFF")
.autoStatsViews("ON")
.autoStmtStats("OFF")
.autoTblMaint("ON")
.chngpgsThresh("50")
.curCommit("AVAILABLE")
.databaseMemory("AUTOMATIC")
.dbheap("AUTOMATIC")
.dbMemThresh("80")
.ddlCompressionDef("YES")
.ddlConstraintDef("NO")
.decfltRounding("ROUND_HALF_UP")
.decToCharFmt("NEW")
.dftDegree("ANY")
.dftExtentSz("32")
.dftLoadrecSes("1000")
.dftPrefetchSz("AUTOMATIC")
.dftQueryopt("5")
.dftSchemasDcc("NO")
.dftSqlmathwarn("YES")
.dftTableOrg("ROW")
.dlchktime("30000")
.enableXmlchar("NO")
.extendedRowSz("ENABLE")
.groupheapRatio("75")
.indexrec("ACCESS")
.largeAggregation("NO")
.locklist("AUTOMATIC")
.locktimeout("10")
.logindexbuild("OFF")
.logApplInfo("YES")
.logDdlStmts("NO")
.logDiskCap("1000000")
.maxappls("500")
.maxfilop("1024")
.maxlocks("AUTOMATIC")
.minDecDiv3("NO")
.monActMetrics("BASE")
.monDeadlock("HISTORY")
.monLckMsgLvl("2")
.monLocktimeout("HISTORY")
.monLockwait("WITHOUT_HIST")
.monLwThresh("5000")
.monObjMetrics("EXTENDED")
.monPkglistSz("512")
.monReqMetrics("BASE")
.monRtnData("NONE")
.monRtnExeclist("OFF")
.monUowData("BASE")
.monUowExeclist("ON")
.monUowPkglist("OFF")
.ncharMapping("GRAPHIC_CU32")
.numFreqvalues("1000")
.numIocleaners("AUTOMATIC")
.numIoservers("AUTOMATIC")
.numLogSpan("10000")
.numQuantiles("1000")
.optDirectWrkld("YES")
.pageAgeTrgtGcr("5000")
.pageAgeTrgtMcr("5000")
.pckcachesz("AUTOMATIC")
.plStackTrace("ALL")
.selfTuningMem("ON")
.seqdetect("YES")
.sheapthresShr("AUTOMATIC")
.sortheap("AUTOMATIC")
.statHeapSz("AUTOMATIC")
.stmtheap("AUTOMATIC")
.stmtConc("LITERALS")
.stringUnits("SYSTEM")
.systimePeriodAdj("NO")
.trackmod("YES")
.utilHeapSz("AUTOMATIC")
.wlmAdmissionCtrl("YES")
.wlmAgentLoadTrgt("AUTOMATIC")
.wlmCpuLimit("50")
.wlmCpuShares("1000")
.wlmCpuShareMode("SOFT")
.build())
.dbms(Db2CustomSettingConfigDbmArgs.builder()
.commBandwidth("1000")
.cpuspeed("-1")
.dftMonBufpool("ON")
.dftMonLock("OFF")
.dftMonSort("ON")
.dftMonStmt("OFF")
.dftMonTable("ON")
.dftMonTimestamp("OFF")
.dftMonUow("ON")
.diaglevel("2")
.federatedAsync("ANY")
.indexrec("ACCESS")
.intraParallel("YES")
.keepfenced("NO")
.maxConnretries("10")
.maxQuerydegree("ANY")
.monHeapSz("AUTOMATIC")
.multipartsizemb("100")
.notifylevel("3")
.numInitagents("500")
.numInitfenced("1000")
.numPoolagents("2000")
.resyncInterval("300")
.rqrioblk("8192")
.startStopTime("60")
.utilImpactLim("50")
.wlmDispatcher("YES")
.wlmDispConcur("COMPUTED")
.wlmDispCpuShares("YES")
.wlmDispMinUtil("75")
.build())
.registries(Db2CustomSettingConfigRegistryArgs.builder()
.db2Bidi("YES")
.db2LockToRb("STATEMENT")
.db2Stmm("YES")
.db2AlternateAuthzBehaviour("EXTERNAL_ROUTINE_DBADM")
.db2Antijoin("EXTEND")
.db2AtsEnable("YES")
.db2DeferredPrepareSemantics("NO")
.db2Evaluncommitted("YES")
.db2IndexPctfreeDefault("10")
.db2InlistToNljn("YES")
.db2MinimizeListprefetch("NO")
.db2ObjectTableEntries("5000")
.db2Optprofile("NO")
.db2Selectivity("ALL")
.db2Skipdeleted("YES")
.db2Skipinserted("NO")
.db2SyncReleaseLockAttributes("YES")
.db2TruncateReusestorage("IMPORT")
.db2UseAlternatePageCleaning("ON")
.db2ViewReoptValues("NO")
.db2Workload("SAP")
.build())
.build())
.build());
}
}
resources:
<yourDatabase>:
type: ibm:Db2
properties:
service: dashdb-for-transactions
plan: performance
location: us-south
resourceGroupId: ${group.id}
serviceEndpoints: public-and-private
instanceType: bx2.4x16
highAvailability: yes
backupLocation: us
diskEncryptionInstanceCrn: none
diskEncryptionKeyCrn: none
oracleCompatibility: no
subscriptionId: <id_of_subscription_plan>
timeouts:
- create: 720m
update: 30m
delete: 30m
customSettingConfigs:
- dbs:
- actSortmemLimit: NONE
altCollate: IDENTITY_16BIT
appgroupMemSz: '1000'
applheapsz: AUTOMATIC
applMemory: AUTOMATIC
appCtlHeapSz: '500'
archretrydelay: '60'
authnCacheDuration: '300'
autorestart: ON
autoCgStats: OFF
autoMaint: ON
autoReorg: OFF
autoReval: IMMEDIATE
autoRunstats: ON
autoSampling: OFF
autoStatsViews: ON
autoStmtStats: OFF
autoTblMaint: ON
chngpgsThresh: '50'
curCommit: AVAILABLE
databaseMemory: AUTOMATIC
dbheap: AUTOMATIC
dbMemThresh: '80'
ddlCompressionDef: YES
ddlConstraintDef: NO
decfltRounding: ROUND_HALF_UP
decToCharFmt: NEW
dftDegree: ANY
dftExtentSz: '32'
dftLoadrecSes: '1000'
dftPrefetchSz: AUTOMATIC
dftQueryopt: '5'
dftSchemasDcc: NO
dftSqlmathwarn: YES
dftTableOrg: ROW
dlchktime: '30000'
enableXmlchar: NO
extendedRowSz: ENABLE
groupheapRatio: '75'
indexrec: ACCESS
largeAggregation: NO
locklist: AUTOMATIC
locktimeout: '10'
logindexbuild: OFF
logApplInfo: YES
logDdlStmts: NO
logDiskCap: '1000000'
maxappls: '500'
maxfilop: '1024'
maxlocks: AUTOMATIC
minDecDiv3: NO
monActMetrics: BASE
monDeadlock: HISTORY
monLckMsgLvl: '2'
monLocktimeout: HISTORY
monLockwait: WITHOUT_HIST
monLwThresh: '5000'
monObjMetrics: EXTENDED
monPkglistSz: '512'
monReqMetrics: BASE
monRtnData: NONE
monRtnExeclist: OFF
monUowData: BASE
monUowExeclist: ON
monUowPkglist: OFF
ncharMapping: GRAPHIC_CU32
numFreqvalues: '1000'
numIocleaners: AUTOMATIC
numIoservers: AUTOMATIC
numLogSpan: '10000'
numQuantiles: '1000'
optDirectWrkld: YES
pageAgeTrgtGcr: '5000'
pageAgeTrgtMcr: '5000'
pckcachesz: AUTOMATIC
plStackTrace: ALL
selfTuningMem: ON
seqdetect: YES
sheapthresShr: AUTOMATIC
sortheap: AUTOMATIC
statHeapSz: AUTOMATIC
stmtheap: AUTOMATIC
stmtConc: LITERALS
stringUnits: SYSTEM
systimePeriodAdj: NO
trackmod: YES
utilHeapSz: AUTOMATIC
wlmAdmissionCtrl: YES
wlmAgentLoadTrgt: AUTOMATIC
wlmCpuLimit: '50'
wlmCpuShares: '1000'
wlmCpuShareMode: SOFT
dbms:
- commBandwidth: '1000'
cpuspeed: '-1'
dftMonBufpool: ON
dftMonLock: OFF
dftMonSort: ON
dftMonStmt: OFF
dftMonTable: ON
dftMonTimestamp: OFF
dftMonUow: ON
diaglevel: '2'
federatedAsync: ANY
indexrec: ACCESS
intraParallel: YES
keepfenced: NO
maxConnretries: '10'
maxQuerydegree: ANY
monHeapSz: AUTOMATIC
multipartsizemb: '100'
notifylevel: '3'
numInitagents: '500'
numInitfenced: '1000'
numPoolagents: '2000'
resyncInterval: '300'
rqrioblk: '8192'
startStopTime: '60'
utilImpactLim: '50'
wlmDispatcher: YES
wlmDispConcur: COMPUTED
wlmDispCpuShares: YES
wlmDispMinUtil: '75'
registries:
- db2Bidi: YES
db2LockToRb: STATEMENT
db2Stmm: YES
db2AlternateAuthzBehaviour: EXTERNAL_ROUTINE_DBADM
db2Antijoin: EXTEND
db2AtsEnable: YES
db2DeferredPrepareSemantics: NO
db2Evaluncommitted: YES
db2IndexPctfreeDefault: '10'
db2InlistToNljn: YES
db2MinimizeListprefetch: NO
db2ObjectTableEntries: '5000'
db2Optprofile: NO
db2Selectivity: ALL
db2Skipdeleted: YES
db2Skipinserted: NO
db2SyncReleaseLockAttributes: YES
db2TruncateReusestorage: IMPORT
db2UseAlternatePageCleaning: ON
db2ViewReoptValues: NO
db2Workload: SAP
variables:
group:
fn::invoke:
function: ibm:getResourceGroup
arguments:
name: <your_group>
provider.tf
Please make sure to target right region in the provider block. If database is created in region other than us-south , please specify it in provider block.
import * as pulumi from "@pulumi/pulumi";
import pulumi
package main
import (
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
return await Deployment.RunAsync(() =>
{
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
}
}
{}
Create Db2 Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new Db2(name: string, args: Db2Args, opts?: CustomResourceOptions);@overload
def Db2(resource_name: str,
args: Db2Args,
opts: Optional[ResourceOptions] = None)
@overload
def Db2(resource_name: str,
opts: Optional[ResourceOptions] = None,
location: Optional[str] = None,
service: Optional[str] = None,
plan: Optional[str] = None,
name: Optional[str] = None,
parameters: Optional[Mapping[str, str]] = None,
disk_encryption_instance_crn: Optional[str] = None,
disk_encryption_key_crn: Optional[str] = None,
high_availability: Optional[str] = None,
instance_type: Optional[str] = None,
custom_setting_configs: Optional[Sequence[Db2CustomSettingConfigArgs]] = None,
allowlist_configs: Optional[Sequence[Db2AllowlistConfigArgs]] = None,
oracle_compatibility: Optional[str] = None,
db2_id: Optional[str] = None,
parameters_json: Optional[str] = None,
backup_location: Optional[str] = None,
resource_group_id: Optional[str] = None,
autoscale_configs: Optional[Sequence[Db2AutoscaleConfigArgs]] = None,
service_endpoints: Optional[str] = None,
subscription_id: Optional[str] = None,
tags: Optional[Sequence[str]] = None,
timeouts: Optional[Db2TimeoutsArgs] = None,
users_configs: Optional[Sequence[Db2UsersConfigArgs]] = None)func NewDb2(ctx *Context, name string, args Db2Args, opts ...ResourceOption) (*Db2, error)public Db2(string name, Db2Args args, CustomResourceOptions? opts = null)type: ibm:Db2
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args Db2Args
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args Db2Args
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args Db2Args
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args Db2Args
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args Db2Args
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var db2Resource = new Ibm.Db2("db2Resource", new()
{
Location = "string",
Service = "string",
Plan = "string",
Name = "string",
Parameters =
{
{ "string", "string" },
},
DiskEncryptionInstanceCrn = "string",
DiskEncryptionKeyCrn = "string",
HighAvailability = "string",
InstanceType = "string",
CustomSettingConfigs = new[]
{
new Ibm.Inputs.Db2CustomSettingConfigArgs
{
Dbms = new[]
{
new Ibm.Inputs.Db2CustomSettingConfigDbmArgs
{
CommBandwidth = "string",
Cpuspeed = "string",
DftMonBufpool = "string",
DftMonLock = "string",
DftMonSort = "string",
DftMonStmt = "string",
DftMonTable = "string",
DftMonTimestamp = "string",
DftMonUow = "string",
Diaglevel = "string",
FederatedAsync = "string",
Indexrec = "string",
IntraParallel = "string",
Keepfenced = "string",
MaxConnretries = "string",
MaxQuerydegree = "string",
MonHeapSz = "string",
Multipartsizemb = "string",
Notifylevel = "string",
NumInitagents = "string",
NumInitfenced = "string",
NumPoolagents = "string",
ResyncInterval = "string",
Rqrioblk = "string",
StartStopTime = "string",
UtilImpactLim = "string",
WlmDispConcur = "string",
WlmDispCpuShares = "string",
WlmDispMinUtil = "string",
WlmDispatcher = "string",
},
},
Dbs = new[]
{
new Ibm.Inputs.Db2CustomSettingConfigDbArgs
{
ActSortmemLimit = "string",
AltCollate = "string",
AppCtlHeapSz = "string",
AppgroupMemSz = "string",
ApplMemory = "string",
Applheapsz = "string",
Archretrydelay = "string",
AuthnCacheDuration = "string",
AutoCgStats = "string",
AutoMaint = "string",
AutoReorg = "string",
AutoReval = "string",
AutoRunstats = "string",
AutoSampling = "string",
AutoStatsViews = "string",
AutoStmtStats = "string",
AutoTblMaint = "string",
Autorestart = "string",
AvgAppls = "string",
CatalogcacheSz = "string",
ChngpgsThresh = "string",
CurCommit = "string",
DatabaseMemory = "string",
DbCollname = "string",
DbMemThresh = "string",
Dbheap = "string",
DdlCompressionDef = "string",
DdlConstraintDef = "string",
DecArithmetic = "string",
DecToCharFmt = "string",
DecfltRounding = "string",
DftDegree = "string",
DftExtentSz = "string",
DftLoadrecSes = "string",
DftMttbTypes = "string",
DftPrefetchSz = "string",
DftQueryopt = "string",
DftRefreshAge = "string",
DftSchemasDcc = "string",
DftSqlmathwarn = "string",
DftTableOrg = "string",
Dlchktime = "string",
EnableXmlchar = "string",
ExtendedRowSz = "string",
GroupheapRatio = "string",
Indexrec = "string",
LargeAggregation = "string",
Locklist = "string",
Locktimeout = "string",
LogApplInfo = "string",
LogDdlStmts = "string",
LogDiskCap = "string",
Logindexbuild = "string",
Maxappls = "string",
Maxfilop = "string",
Maxlocks = "string",
MinDecDiv3 = "string",
MonActMetrics = "string",
MonDeadlock = "string",
MonLckMsgLvl = "string",
MonLocktimeout = "string",
MonLockwait = "string",
MonLwThresh = "string",
MonObjMetrics = "string",
MonPkglistSz = "string",
MonReqMetrics = "string",
MonRtnData = "string",
MonRtnExeclist = "string",
MonUowData = "string",
MonUowExeclist = "string",
MonUowPkglist = "string",
NcharMapping = "string",
NumFreqvalues = "string",
NumIocleaners = "string",
NumIoservers = "string",
NumLogSpan = "string",
NumQuantiles = "string",
OptBuffpage = "string",
OptDirectWrkld = "string",
OptLocklist = "string",
OptMaxlocks = "string",
OptSortheap = "string",
PageAgeTrgtGcr = "string",
PageAgeTrgtMcr = "string",
Pckcachesz = "string",
PlStackTrace = "string",
SelfTuningMem = "string",
Seqdetect = "string",
SheapthresShr = "string",
Softmax = "string",
Sortheap = "string",
SqlCcflags = "string",
StatHeapSz = "string",
StmtConc = "string",
Stmtheap = "string",
StringUnits = "string",
SystimePeriodAdj = "string",
Trackmod = "string",
UtilHeapSz = "string",
WlmAdmissionCtrl = "string",
WlmAgentLoadTrgt = "string",
WlmCpuLimit = "string",
WlmCpuShareMode = "string",
WlmCpuShares = "string",
},
},
Registries = new[]
{
new Ibm.Inputs.Db2CustomSettingConfigRegistryArgs
{
Db2AlternateAuthzBehaviour = "string",
Db2Antijoin = "string",
Db2AtsEnable = "string",
Db2Bidi = "string",
Db2Compopt = "string",
Db2DeferredPrepareSemantics = "string",
Db2Evaluncommitted = "string",
Db2ExtendedOptimization = "string",
Db2IndexPctfreeDefault = "string",
Db2InlistToNljn = "string",
Db2LockToRb = "string",
Db2MinimizeListprefetch = "string",
Db2ObjectTableEntries = "string",
Db2OptMaxTempSize = "string",
Db2Optprofile = "string",
Db2OptstatsLog = "string",
Db2ParallelIo = "string",
Db2ReducedOptimization = "string",
Db2Selectivity = "string",
Db2Skipdeleted = "string",
Db2Skipinserted = "string",
Db2Stmm = "string",
Db2SyncReleaseLockAttributes = "string",
Db2TruncateReusestorage = "string",
Db2UseAlternatePageCleaning = "string",
Db2ViewReoptValues = "string",
Db2WlmSettings = "string",
Db2Workload = "string",
},
},
},
},
AllowlistConfigs = new[]
{
new Ibm.Inputs.Db2AllowlistConfigArgs
{
IpAddresses = new[]
{
new Ibm.Inputs.Db2AllowlistConfigIpAddressArgs
{
Address = "string",
Description = "string",
},
},
},
},
OracleCompatibility = "string",
Db2Id = "string",
ParametersJson = "string",
BackupLocation = "string",
ResourceGroupId = "string",
AutoscaleConfigs = new[]
{
new Ibm.Inputs.Db2AutoscaleConfigArgs
{
AutoScalingAllowPlanLimit = false,
AutoScalingEnabled = false,
AutoScalingOverTimePeriod = "string",
AutoScalingPauseLimit = 0,
AutoScalingThreshold = "string",
},
},
ServiceEndpoints = "string",
SubscriptionId = "string",
Tags = new[]
{
"string",
},
Timeouts = new Ibm.Inputs.Db2TimeoutsArgs
{
Create = "string",
Delete = "string",
Update = "string",
},
UsersConfigs = new[]
{
new Ibm.Inputs.Db2UsersConfigArgs
{
Authentications = new[]
{
new Ibm.Inputs.Db2UsersConfigAuthenticationArgs
{
Method = "string",
PolicyId = "string",
},
},
Email = "string",
Iam = false,
Ibmid = "string",
Id = "string",
Locked = "string",
Name = "string",
Password = "string",
Role = "string",
},
},
});
example, err := ibm.NewDb2(ctx, "db2Resource", &ibm.Db2Args{
Location: pulumi.String("string"),
Service: pulumi.String("string"),
Plan: pulumi.String("string"),
Name: pulumi.String("string"),
Parameters: pulumi.StringMap{
"string": pulumi.String("string"),
},
DiskEncryptionInstanceCrn: pulumi.String("string"),
DiskEncryptionKeyCrn: pulumi.String("string"),
HighAvailability: pulumi.String("string"),
InstanceType: pulumi.String("string"),
CustomSettingConfigs: ibm.Db2CustomSettingConfigArray{
&ibm.Db2CustomSettingConfigArgs{
Dbms: ibm.Db2CustomSettingConfigDbmArray{
&ibm.Db2CustomSettingConfigDbmArgs{
CommBandwidth: pulumi.String("string"),
Cpuspeed: pulumi.String("string"),
DftMonBufpool: pulumi.String("string"),
DftMonLock: pulumi.String("string"),
DftMonSort: pulumi.String("string"),
DftMonStmt: pulumi.String("string"),
DftMonTable: pulumi.String("string"),
DftMonTimestamp: pulumi.String("string"),
DftMonUow: pulumi.String("string"),
Diaglevel: pulumi.String("string"),
FederatedAsync: pulumi.String("string"),
Indexrec: pulumi.String("string"),
IntraParallel: pulumi.String("string"),
Keepfenced: pulumi.String("string"),
MaxConnretries: pulumi.String("string"),
MaxQuerydegree: pulumi.String("string"),
MonHeapSz: pulumi.String("string"),
Multipartsizemb: pulumi.String("string"),
Notifylevel: pulumi.String("string"),
NumInitagents: pulumi.String("string"),
NumInitfenced: pulumi.String("string"),
NumPoolagents: pulumi.String("string"),
ResyncInterval: pulumi.String("string"),
Rqrioblk: pulumi.String("string"),
StartStopTime: pulumi.String("string"),
UtilImpactLim: pulumi.String("string"),
WlmDispConcur: pulumi.String("string"),
WlmDispCpuShares: pulumi.String("string"),
WlmDispMinUtil: pulumi.String("string"),
WlmDispatcher: pulumi.String("string"),
},
},
Dbs: ibm.Db2CustomSettingConfigDbArray{
&ibm.Db2CustomSettingConfigDbArgs{
ActSortmemLimit: pulumi.String("string"),
AltCollate: pulumi.String("string"),
AppCtlHeapSz: pulumi.String("string"),
AppgroupMemSz: pulumi.String("string"),
ApplMemory: pulumi.String("string"),
Applheapsz: pulumi.String("string"),
Archretrydelay: pulumi.String("string"),
AuthnCacheDuration: pulumi.String("string"),
AutoCgStats: pulumi.String("string"),
AutoMaint: pulumi.String("string"),
AutoReorg: pulumi.String("string"),
AutoReval: pulumi.String("string"),
AutoRunstats: pulumi.String("string"),
AutoSampling: pulumi.String("string"),
AutoStatsViews: pulumi.String("string"),
AutoStmtStats: pulumi.String("string"),
AutoTblMaint: pulumi.String("string"),
Autorestart: pulumi.String("string"),
AvgAppls: pulumi.String("string"),
CatalogcacheSz: pulumi.String("string"),
ChngpgsThresh: pulumi.String("string"),
CurCommit: pulumi.String("string"),
DatabaseMemory: pulumi.String("string"),
DbCollname: pulumi.String("string"),
DbMemThresh: pulumi.String("string"),
Dbheap: pulumi.String("string"),
DdlCompressionDef: pulumi.String("string"),
DdlConstraintDef: pulumi.String("string"),
DecArithmetic: pulumi.String("string"),
DecToCharFmt: pulumi.String("string"),
DecfltRounding: pulumi.String("string"),
DftDegree: pulumi.String("string"),
DftExtentSz: pulumi.String("string"),
DftLoadrecSes: pulumi.String("string"),
DftMttbTypes: pulumi.String("string"),
DftPrefetchSz: pulumi.String("string"),
DftQueryopt: pulumi.String("string"),
DftRefreshAge: pulumi.String("string"),
DftSchemasDcc: pulumi.String("string"),
DftSqlmathwarn: pulumi.String("string"),
DftTableOrg: pulumi.String("string"),
Dlchktime: pulumi.String("string"),
EnableXmlchar: pulumi.String("string"),
ExtendedRowSz: pulumi.String("string"),
GroupheapRatio: pulumi.String("string"),
Indexrec: pulumi.String("string"),
LargeAggregation: pulumi.String("string"),
Locklist: pulumi.String("string"),
Locktimeout: pulumi.String("string"),
LogApplInfo: pulumi.String("string"),
LogDdlStmts: pulumi.String("string"),
LogDiskCap: pulumi.String("string"),
Logindexbuild: pulumi.String("string"),
Maxappls: pulumi.String("string"),
Maxfilop: pulumi.String("string"),
Maxlocks: pulumi.String("string"),
MinDecDiv3: pulumi.String("string"),
MonActMetrics: pulumi.String("string"),
MonDeadlock: pulumi.String("string"),
MonLckMsgLvl: pulumi.String("string"),
MonLocktimeout: pulumi.String("string"),
MonLockwait: pulumi.String("string"),
MonLwThresh: pulumi.String("string"),
MonObjMetrics: pulumi.String("string"),
MonPkglistSz: pulumi.String("string"),
MonReqMetrics: pulumi.String("string"),
MonRtnData: pulumi.String("string"),
MonRtnExeclist: pulumi.String("string"),
MonUowData: pulumi.String("string"),
MonUowExeclist: pulumi.String("string"),
MonUowPkglist: pulumi.String("string"),
NcharMapping: pulumi.String("string"),
NumFreqvalues: pulumi.String("string"),
NumIocleaners: pulumi.String("string"),
NumIoservers: pulumi.String("string"),
NumLogSpan: pulumi.String("string"),
NumQuantiles: pulumi.String("string"),
OptBuffpage: pulumi.String("string"),
OptDirectWrkld: pulumi.String("string"),
OptLocklist: pulumi.String("string"),
OptMaxlocks: pulumi.String("string"),
OptSortheap: pulumi.String("string"),
PageAgeTrgtGcr: pulumi.String("string"),
PageAgeTrgtMcr: pulumi.String("string"),
Pckcachesz: pulumi.String("string"),
PlStackTrace: pulumi.String("string"),
SelfTuningMem: pulumi.String("string"),
Seqdetect: pulumi.String("string"),
SheapthresShr: pulumi.String("string"),
Softmax: pulumi.String("string"),
Sortheap: pulumi.String("string"),
SqlCcflags: pulumi.String("string"),
StatHeapSz: pulumi.String("string"),
StmtConc: pulumi.String("string"),
Stmtheap: pulumi.String("string"),
StringUnits: pulumi.String("string"),
SystimePeriodAdj: pulumi.String("string"),
Trackmod: pulumi.String("string"),
UtilHeapSz: pulumi.String("string"),
WlmAdmissionCtrl: pulumi.String("string"),
WlmAgentLoadTrgt: pulumi.String("string"),
WlmCpuLimit: pulumi.String("string"),
WlmCpuShareMode: pulumi.String("string"),
WlmCpuShares: pulumi.String("string"),
},
},
Registries: ibm.Db2CustomSettingConfigRegistryArray{
&ibm.Db2CustomSettingConfigRegistryArgs{
Db2AlternateAuthzBehaviour: pulumi.String("string"),
Db2Antijoin: pulumi.String("string"),
Db2AtsEnable: pulumi.String("string"),
Db2Bidi: pulumi.String("string"),
Db2Compopt: pulumi.String("string"),
Db2DeferredPrepareSemantics: pulumi.String("string"),
Db2Evaluncommitted: pulumi.String("string"),
Db2ExtendedOptimization: pulumi.String("string"),
Db2IndexPctfreeDefault: pulumi.String("string"),
Db2InlistToNljn: pulumi.String("string"),
Db2LockToRb: pulumi.String("string"),
Db2MinimizeListprefetch: pulumi.String("string"),
Db2ObjectTableEntries: pulumi.String("string"),
Db2OptMaxTempSize: pulumi.String("string"),
Db2Optprofile: pulumi.String("string"),
Db2OptstatsLog: pulumi.String("string"),
Db2ParallelIo: pulumi.String("string"),
Db2ReducedOptimization: pulumi.String("string"),
Db2Selectivity: pulumi.String("string"),
Db2Skipdeleted: pulumi.String("string"),
Db2Skipinserted: pulumi.String("string"),
Db2Stmm: pulumi.String("string"),
Db2SyncReleaseLockAttributes: pulumi.String("string"),
Db2TruncateReusestorage: pulumi.String("string"),
Db2UseAlternatePageCleaning: pulumi.String("string"),
Db2ViewReoptValues: pulumi.String("string"),
Db2WlmSettings: pulumi.String("string"),
Db2Workload: pulumi.String("string"),
},
},
},
},
AllowlistConfigs: ibm.Db2AllowlistConfigArray{
&ibm.Db2AllowlistConfigArgs{
IpAddresses: ibm.Db2AllowlistConfigIpAddressArray{
&ibm.Db2AllowlistConfigIpAddressArgs{
Address: pulumi.String("string"),
Description: pulumi.String("string"),
},
},
},
},
OracleCompatibility: pulumi.String("string"),
Db2Id: pulumi.String("string"),
ParametersJson: pulumi.String("string"),
BackupLocation: pulumi.String("string"),
ResourceGroupId: pulumi.String("string"),
AutoscaleConfigs: ibm.Db2AutoscaleConfigArray{
&ibm.Db2AutoscaleConfigArgs{
AutoScalingAllowPlanLimit: pulumi.Bool(false),
AutoScalingEnabled: pulumi.Bool(false),
AutoScalingOverTimePeriod: pulumi.String("string"),
AutoScalingPauseLimit: pulumi.Float64(0),
AutoScalingThreshold: pulumi.String("string"),
},
},
ServiceEndpoints: pulumi.String("string"),
SubscriptionId: pulumi.String("string"),
Tags: pulumi.StringArray{
pulumi.String("string"),
},
Timeouts: &ibm.Db2TimeoutsArgs{
Create: pulumi.String("string"),
Delete: pulumi.String("string"),
Update: pulumi.String("string"),
},
UsersConfigs: ibm.Db2UsersConfigArray{
&ibm.Db2UsersConfigArgs{
Authentications: ibm.Db2UsersConfigAuthenticationArray{
&ibm.Db2UsersConfigAuthenticationArgs{
Method: pulumi.String("string"),
PolicyId: pulumi.String("string"),
},
},
Email: pulumi.String("string"),
Iam: pulumi.Bool(false),
Ibmid: pulumi.String("string"),
Id: pulumi.String("string"),
Locked: pulumi.String("string"),
Name: pulumi.String("string"),
Password: pulumi.String("string"),
Role: pulumi.String("string"),
},
},
})
var db2Resource = new Db2("db2Resource", Db2Args.builder()
.location("string")
.service("string")
.plan("string")
.name("string")
.parameters(Map.of("string", "string"))
.diskEncryptionInstanceCrn("string")
.diskEncryptionKeyCrn("string")
.highAvailability("string")
.instanceType("string")
.customSettingConfigs(Db2CustomSettingConfigArgs.builder()
.dbms(Db2CustomSettingConfigDbmArgs.builder()
.commBandwidth("string")
.cpuspeed("string")
.dftMonBufpool("string")
.dftMonLock("string")
.dftMonSort("string")
.dftMonStmt("string")
.dftMonTable("string")
.dftMonTimestamp("string")
.dftMonUow("string")
.diaglevel("string")
.federatedAsync("string")
.indexrec("string")
.intraParallel("string")
.keepfenced("string")
.maxConnretries("string")
.maxQuerydegree("string")
.monHeapSz("string")
.multipartsizemb("string")
.notifylevel("string")
.numInitagents("string")
.numInitfenced("string")
.numPoolagents("string")
.resyncInterval("string")
.rqrioblk("string")
.startStopTime("string")
.utilImpactLim("string")
.wlmDispConcur("string")
.wlmDispCpuShares("string")
.wlmDispMinUtil("string")
.wlmDispatcher("string")
.build())
.dbs(Db2CustomSettingConfigDbArgs.builder()
.actSortmemLimit("string")
.altCollate("string")
.appCtlHeapSz("string")
.appgroupMemSz("string")
.applMemory("string")
.applheapsz("string")
.archretrydelay("string")
.authnCacheDuration("string")
.autoCgStats("string")
.autoMaint("string")
.autoReorg("string")
.autoReval("string")
.autoRunstats("string")
.autoSampling("string")
.autoStatsViews("string")
.autoStmtStats("string")
.autoTblMaint("string")
.autorestart("string")
.avgAppls("string")
.catalogcacheSz("string")
.chngpgsThresh("string")
.curCommit("string")
.databaseMemory("string")
.dbCollname("string")
.dbMemThresh("string")
.dbheap("string")
.ddlCompressionDef("string")
.ddlConstraintDef("string")
.decArithmetic("string")
.decToCharFmt("string")
.decfltRounding("string")
.dftDegree("string")
.dftExtentSz("string")
.dftLoadrecSes("string")
.dftMttbTypes("string")
.dftPrefetchSz("string")
.dftQueryopt("string")
.dftRefreshAge("string")
.dftSchemasDcc("string")
.dftSqlmathwarn("string")
.dftTableOrg("string")
.dlchktime("string")
.enableXmlchar("string")
.extendedRowSz("string")
.groupheapRatio("string")
.indexrec("string")
.largeAggregation("string")
.locklist("string")
.locktimeout("string")
.logApplInfo("string")
.logDdlStmts("string")
.logDiskCap("string")
.logindexbuild("string")
.maxappls("string")
.maxfilop("string")
.maxlocks("string")
.minDecDiv3("string")
.monActMetrics("string")
.monDeadlock("string")
.monLckMsgLvl("string")
.monLocktimeout("string")
.monLockwait("string")
.monLwThresh("string")
.monObjMetrics("string")
.monPkglistSz("string")
.monReqMetrics("string")
.monRtnData("string")
.monRtnExeclist("string")
.monUowData("string")
.monUowExeclist("string")
.monUowPkglist("string")
.ncharMapping("string")
.numFreqvalues("string")
.numIocleaners("string")
.numIoservers("string")
.numLogSpan("string")
.numQuantiles("string")
.optBuffpage("string")
.optDirectWrkld("string")
.optLocklist("string")
.optMaxlocks("string")
.optSortheap("string")
.pageAgeTrgtGcr("string")
.pageAgeTrgtMcr("string")
.pckcachesz("string")
.plStackTrace("string")
.selfTuningMem("string")
.seqdetect("string")
.sheapthresShr("string")
.softmax("string")
.sortheap("string")
.sqlCcflags("string")
.statHeapSz("string")
.stmtConc("string")
.stmtheap("string")
.stringUnits("string")
.systimePeriodAdj("string")
.trackmod("string")
.utilHeapSz("string")
.wlmAdmissionCtrl("string")
.wlmAgentLoadTrgt("string")
.wlmCpuLimit("string")
.wlmCpuShareMode("string")
.wlmCpuShares("string")
.build())
.registries(Db2CustomSettingConfigRegistryArgs.builder()
.db2AlternateAuthzBehaviour("string")
.db2Antijoin("string")
.db2AtsEnable("string")
.db2Bidi("string")
.db2Compopt("string")
.db2DeferredPrepareSemantics("string")
.db2Evaluncommitted("string")
.db2ExtendedOptimization("string")
.db2IndexPctfreeDefault("string")
.db2InlistToNljn("string")
.db2LockToRb("string")
.db2MinimizeListprefetch("string")
.db2ObjectTableEntries("string")
.db2OptMaxTempSize("string")
.db2Optprofile("string")
.db2OptstatsLog("string")
.db2ParallelIo("string")
.db2ReducedOptimization("string")
.db2Selectivity("string")
.db2Skipdeleted("string")
.db2Skipinserted("string")
.db2Stmm("string")
.db2SyncReleaseLockAttributes("string")
.db2TruncateReusestorage("string")
.db2UseAlternatePageCleaning("string")
.db2ViewReoptValues("string")
.db2WlmSettings("string")
.db2Workload("string")
.build())
.build())
.allowlistConfigs(Db2AllowlistConfigArgs.builder()
.ipAddresses(Db2AllowlistConfigIpAddressArgs.builder()
.address("string")
.description("string")
.build())
.build())
.oracleCompatibility("string")
.db2Id("string")
.parametersJson("string")
.backupLocation("string")
.resourceGroupId("string")
.autoscaleConfigs(Db2AutoscaleConfigArgs.builder()
.autoScalingAllowPlanLimit(false)
.autoScalingEnabled(false)
.autoScalingOverTimePeriod("string")
.autoScalingPauseLimit(0.0)
.autoScalingThreshold("string")
.build())
.serviceEndpoints("string")
.subscriptionId("string")
.tags("string")
.timeouts(Db2TimeoutsArgs.builder()
.create("string")
.delete("string")
.update("string")
.build())
.usersConfigs(Db2UsersConfigArgs.builder()
.authentications(Db2UsersConfigAuthenticationArgs.builder()
.method("string")
.policyId("string")
.build())
.email("string")
.iam(false)
.ibmid("string")
.id("string")
.locked("string")
.name("string")
.password("string")
.role("string")
.build())
.build());
db2_resource = ibm.Db2("db2Resource",
location="string",
service="string",
plan="string",
name="string",
parameters={
"string": "string",
},
disk_encryption_instance_crn="string",
disk_encryption_key_crn="string",
high_availability="string",
instance_type="string",
custom_setting_configs=[{
"dbms": [{
"comm_bandwidth": "string",
"cpuspeed": "string",
"dft_mon_bufpool": "string",
"dft_mon_lock": "string",
"dft_mon_sort": "string",
"dft_mon_stmt": "string",
"dft_mon_table": "string",
"dft_mon_timestamp": "string",
"dft_mon_uow": "string",
"diaglevel": "string",
"federated_async": "string",
"indexrec": "string",
"intra_parallel": "string",
"keepfenced": "string",
"max_connretries": "string",
"max_querydegree": "string",
"mon_heap_sz": "string",
"multipartsizemb": "string",
"notifylevel": "string",
"num_initagents": "string",
"num_initfenced": "string",
"num_poolagents": "string",
"resync_interval": "string",
"rqrioblk": "string",
"start_stop_time": "string",
"util_impact_lim": "string",
"wlm_disp_concur": "string",
"wlm_disp_cpu_shares": "string",
"wlm_disp_min_util": "string",
"wlm_dispatcher": "string",
}],
"dbs": [{
"act_sortmem_limit": "string",
"alt_collate": "string",
"app_ctl_heap_sz": "string",
"appgroup_mem_sz": "string",
"appl_memory": "string",
"applheapsz": "string",
"archretrydelay": "string",
"authn_cache_duration": "string",
"auto_cg_stats": "string",
"auto_maint": "string",
"auto_reorg": "string",
"auto_reval": "string",
"auto_runstats": "string",
"auto_sampling": "string",
"auto_stats_views": "string",
"auto_stmt_stats": "string",
"auto_tbl_maint": "string",
"autorestart": "string",
"avg_appls": "string",
"catalogcache_sz": "string",
"chngpgs_thresh": "string",
"cur_commit": "string",
"database_memory": "string",
"db_collname": "string",
"db_mem_thresh": "string",
"dbheap": "string",
"ddl_compression_def": "string",
"ddl_constraint_def": "string",
"dec_arithmetic": "string",
"dec_to_char_fmt": "string",
"decflt_rounding": "string",
"dft_degree": "string",
"dft_extent_sz": "string",
"dft_loadrec_ses": "string",
"dft_mttb_types": "string",
"dft_prefetch_sz": "string",
"dft_queryopt": "string",
"dft_refresh_age": "string",
"dft_schemas_dcc": "string",
"dft_sqlmathwarn": "string",
"dft_table_org": "string",
"dlchktime": "string",
"enable_xmlchar": "string",
"extended_row_sz": "string",
"groupheap_ratio": "string",
"indexrec": "string",
"large_aggregation": "string",
"locklist": "string",
"locktimeout": "string",
"log_appl_info": "string",
"log_ddl_stmts": "string",
"log_disk_cap": "string",
"logindexbuild": "string",
"maxappls": "string",
"maxfilop": "string",
"maxlocks": "string",
"min_dec_div3": "string",
"mon_act_metrics": "string",
"mon_deadlock": "string",
"mon_lck_msg_lvl": "string",
"mon_locktimeout": "string",
"mon_lockwait": "string",
"mon_lw_thresh": "string",
"mon_obj_metrics": "string",
"mon_pkglist_sz": "string",
"mon_req_metrics": "string",
"mon_rtn_data": "string",
"mon_rtn_execlist": "string",
"mon_uow_data": "string",
"mon_uow_execlist": "string",
"mon_uow_pkglist": "string",
"nchar_mapping": "string",
"num_freqvalues": "string",
"num_iocleaners": "string",
"num_ioservers": "string",
"num_log_span": "string",
"num_quantiles": "string",
"opt_buffpage": "string",
"opt_direct_wrkld": "string",
"opt_locklist": "string",
"opt_maxlocks": "string",
"opt_sortheap": "string",
"page_age_trgt_gcr": "string",
"page_age_trgt_mcr": "string",
"pckcachesz": "string",
"pl_stack_trace": "string",
"self_tuning_mem": "string",
"seqdetect": "string",
"sheapthres_shr": "string",
"softmax": "string",
"sortheap": "string",
"sql_ccflags": "string",
"stat_heap_sz": "string",
"stmt_conc": "string",
"stmtheap": "string",
"string_units": "string",
"systime_period_adj": "string",
"trackmod": "string",
"util_heap_sz": "string",
"wlm_admission_ctrl": "string",
"wlm_agent_load_trgt": "string",
"wlm_cpu_limit": "string",
"wlm_cpu_share_mode": "string",
"wlm_cpu_shares": "string",
}],
"registries": [{
"db2_alternate_authz_behaviour": "string",
"db2_antijoin": "string",
"db2_ats_enable": "string",
"db2_bidi": "string",
"db2_compopt": "string",
"db2_deferred_prepare_semantics": "string",
"db2_evaluncommitted": "string",
"db2_extended_optimization": "string",
"db2_index_pctfree_default": "string",
"db2_inlist_to_nljn": "string",
"db2_lock_to_rb": "string",
"db2_minimize_listprefetch": "string",
"db2_object_table_entries": "string",
"db2_opt_max_temp_size": "string",
"db2_optprofile": "string",
"db2_optstats_log": "string",
"db2_parallel_io": "string",
"db2_reduced_optimization": "string",
"db2_selectivity": "string",
"db2_skipdeleted": "string",
"db2_skipinserted": "string",
"db2_stmm": "string",
"db2_sync_release_lock_attributes": "string",
"db2_truncate_reusestorage": "string",
"db2_use_alternate_page_cleaning": "string",
"db2_view_reopt_values": "string",
"db2_wlm_settings": "string",
"db2_workload": "string",
}],
}],
allowlist_configs=[{
"ip_addresses": [{
"address": "string",
"description": "string",
}],
}],
oracle_compatibility="string",
db2_id="string",
parameters_json="string",
backup_location="string",
resource_group_id="string",
autoscale_configs=[{
"auto_scaling_allow_plan_limit": False,
"auto_scaling_enabled": False,
"auto_scaling_over_time_period": "string",
"auto_scaling_pause_limit": 0,
"auto_scaling_threshold": "string",
}],
service_endpoints="string",
subscription_id="string",
tags=["string"],
timeouts={
"create": "string",
"delete": "string",
"update": "string",
},
users_configs=[{
"authentications": [{
"method": "string",
"policy_id": "string",
}],
"email": "string",
"iam": False,
"ibmid": "string",
"id": "string",
"locked": "string",
"name": "string",
"password": "string",
"role": "string",
}])
const db2Resource = new ibm.Db2("db2Resource", {
location: "string",
service: "string",
plan: "string",
name: "string",
parameters: {
string: "string",
},
diskEncryptionInstanceCrn: "string",
diskEncryptionKeyCrn: "string",
highAvailability: "string",
instanceType: "string",
customSettingConfigs: [{
dbms: [{
commBandwidth: "string",
cpuspeed: "string",
dftMonBufpool: "string",
dftMonLock: "string",
dftMonSort: "string",
dftMonStmt: "string",
dftMonTable: "string",
dftMonTimestamp: "string",
dftMonUow: "string",
diaglevel: "string",
federatedAsync: "string",
indexrec: "string",
intraParallel: "string",
keepfenced: "string",
maxConnretries: "string",
maxQuerydegree: "string",
monHeapSz: "string",
multipartsizemb: "string",
notifylevel: "string",
numInitagents: "string",
numInitfenced: "string",
numPoolagents: "string",
resyncInterval: "string",
rqrioblk: "string",
startStopTime: "string",
utilImpactLim: "string",
wlmDispConcur: "string",
wlmDispCpuShares: "string",
wlmDispMinUtil: "string",
wlmDispatcher: "string",
}],
dbs: [{
actSortmemLimit: "string",
altCollate: "string",
appCtlHeapSz: "string",
appgroupMemSz: "string",
applMemory: "string",
applheapsz: "string",
archretrydelay: "string",
authnCacheDuration: "string",
autoCgStats: "string",
autoMaint: "string",
autoReorg: "string",
autoReval: "string",
autoRunstats: "string",
autoSampling: "string",
autoStatsViews: "string",
autoStmtStats: "string",
autoTblMaint: "string",
autorestart: "string",
avgAppls: "string",
catalogcacheSz: "string",
chngpgsThresh: "string",
curCommit: "string",
databaseMemory: "string",
dbCollname: "string",
dbMemThresh: "string",
dbheap: "string",
ddlCompressionDef: "string",
ddlConstraintDef: "string",
decArithmetic: "string",
decToCharFmt: "string",
decfltRounding: "string",
dftDegree: "string",
dftExtentSz: "string",
dftLoadrecSes: "string",
dftMttbTypes: "string",
dftPrefetchSz: "string",
dftQueryopt: "string",
dftRefreshAge: "string",
dftSchemasDcc: "string",
dftSqlmathwarn: "string",
dftTableOrg: "string",
dlchktime: "string",
enableXmlchar: "string",
extendedRowSz: "string",
groupheapRatio: "string",
indexrec: "string",
largeAggregation: "string",
locklist: "string",
locktimeout: "string",
logApplInfo: "string",
logDdlStmts: "string",
logDiskCap: "string",
logindexbuild: "string",
maxappls: "string",
maxfilop: "string",
maxlocks: "string",
minDecDiv3: "string",
monActMetrics: "string",
monDeadlock: "string",
monLckMsgLvl: "string",
monLocktimeout: "string",
monLockwait: "string",
monLwThresh: "string",
monObjMetrics: "string",
monPkglistSz: "string",
monReqMetrics: "string",
monRtnData: "string",
monRtnExeclist: "string",
monUowData: "string",
monUowExeclist: "string",
monUowPkglist: "string",
ncharMapping: "string",
numFreqvalues: "string",
numIocleaners: "string",
numIoservers: "string",
numLogSpan: "string",
numQuantiles: "string",
optBuffpage: "string",
optDirectWrkld: "string",
optLocklist: "string",
optMaxlocks: "string",
optSortheap: "string",
pageAgeTrgtGcr: "string",
pageAgeTrgtMcr: "string",
pckcachesz: "string",
plStackTrace: "string",
selfTuningMem: "string",
seqdetect: "string",
sheapthresShr: "string",
softmax: "string",
sortheap: "string",
sqlCcflags: "string",
statHeapSz: "string",
stmtConc: "string",
stmtheap: "string",
stringUnits: "string",
systimePeriodAdj: "string",
trackmod: "string",
utilHeapSz: "string",
wlmAdmissionCtrl: "string",
wlmAgentLoadTrgt: "string",
wlmCpuLimit: "string",
wlmCpuShareMode: "string",
wlmCpuShares: "string",
}],
registries: [{
db2AlternateAuthzBehaviour: "string",
db2Antijoin: "string",
db2AtsEnable: "string",
db2Bidi: "string",
db2Compopt: "string",
db2DeferredPrepareSemantics: "string",
db2Evaluncommitted: "string",
db2ExtendedOptimization: "string",
db2IndexPctfreeDefault: "string",
db2InlistToNljn: "string",
db2LockToRb: "string",
db2MinimizeListprefetch: "string",
db2ObjectTableEntries: "string",
db2OptMaxTempSize: "string",
db2Optprofile: "string",
db2OptstatsLog: "string",
db2ParallelIo: "string",
db2ReducedOptimization: "string",
db2Selectivity: "string",
db2Skipdeleted: "string",
db2Skipinserted: "string",
db2Stmm: "string",
db2SyncReleaseLockAttributes: "string",
db2TruncateReusestorage: "string",
db2UseAlternatePageCleaning: "string",
db2ViewReoptValues: "string",
db2WlmSettings: "string",
db2Workload: "string",
}],
}],
allowlistConfigs: [{
ipAddresses: [{
address: "string",
description: "string",
}],
}],
oracleCompatibility: "string",
db2Id: "string",
parametersJson: "string",
backupLocation: "string",
resourceGroupId: "string",
autoscaleConfigs: [{
autoScalingAllowPlanLimit: false,
autoScalingEnabled: false,
autoScalingOverTimePeriod: "string",
autoScalingPauseLimit: 0,
autoScalingThreshold: "string",
}],
serviceEndpoints: "string",
subscriptionId: "string",
tags: ["string"],
timeouts: {
create: "string",
"delete": "string",
update: "string",
},
usersConfigs: [{
authentications: [{
method: "string",
policyId: "string",
}],
email: "string",
iam: false,
ibmid: "string",
id: "string",
locked: "string",
name: "string",
password: "string",
role: "string",
}],
});
type: ibm:Db2
properties:
allowlistConfigs:
- ipAddresses:
- address: string
description: string
autoscaleConfigs:
- autoScalingAllowPlanLimit: false
autoScalingEnabled: false
autoScalingOverTimePeriod: string
autoScalingPauseLimit: 0
autoScalingThreshold: string
backupLocation: string
customSettingConfigs:
- dbms:
- commBandwidth: string
cpuspeed: string
dftMonBufpool: string
dftMonLock: string
dftMonSort: string
dftMonStmt: string
dftMonTable: string
dftMonTimestamp: string
dftMonUow: string
diaglevel: string
federatedAsync: string
indexrec: string
intraParallel: string
keepfenced: string
maxConnretries: string
maxQuerydegree: string
monHeapSz: string
multipartsizemb: string
notifylevel: string
numInitagents: string
numInitfenced: string
numPoolagents: string
resyncInterval: string
rqrioblk: string
startStopTime: string
utilImpactLim: string
wlmDispConcur: string
wlmDispCpuShares: string
wlmDispMinUtil: string
wlmDispatcher: string
dbs:
- actSortmemLimit: string
altCollate: string
appCtlHeapSz: string
appgroupMemSz: string
applMemory: string
applheapsz: string
archretrydelay: string
authnCacheDuration: string
autoCgStats: string
autoMaint: string
autoReorg: string
autoReval: string
autoRunstats: string
autoSampling: string
autoStatsViews: string
autoStmtStats: string
autoTblMaint: string
autorestart: string
avgAppls: string
catalogcacheSz: string
chngpgsThresh: string
curCommit: string
databaseMemory: string
dbCollname: string
dbMemThresh: string
dbheap: string
ddlCompressionDef: string
ddlConstraintDef: string
decArithmetic: string
decToCharFmt: string
decfltRounding: string
dftDegree: string
dftExtentSz: string
dftLoadrecSes: string
dftMttbTypes: string
dftPrefetchSz: string
dftQueryopt: string
dftRefreshAge: string
dftSchemasDcc: string
dftSqlmathwarn: string
dftTableOrg: string
dlchktime: string
enableXmlchar: string
extendedRowSz: string
groupheapRatio: string
indexrec: string
largeAggregation: string
locklist: string
locktimeout: string
logApplInfo: string
logDdlStmts: string
logDiskCap: string
logindexbuild: string
maxappls: string
maxfilop: string
maxlocks: string
minDecDiv3: string
monActMetrics: string
monDeadlock: string
monLckMsgLvl: string
monLocktimeout: string
monLockwait: string
monLwThresh: string
monObjMetrics: string
monPkglistSz: string
monReqMetrics: string
monRtnData: string
monRtnExeclist: string
monUowData: string
monUowExeclist: string
monUowPkglist: string
ncharMapping: string
numFreqvalues: string
numIocleaners: string
numIoservers: string
numLogSpan: string
numQuantiles: string
optBuffpage: string
optDirectWrkld: string
optLocklist: string
optMaxlocks: string
optSortheap: string
pageAgeTrgtGcr: string
pageAgeTrgtMcr: string
pckcachesz: string
plStackTrace: string
selfTuningMem: string
seqdetect: string
sheapthresShr: string
softmax: string
sortheap: string
sqlCcflags: string
statHeapSz: string
stmtConc: string
stmtheap: string
stringUnits: string
systimePeriodAdj: string
trackmod: string
utilHeapSz: string
wlmAdmissionCtrl: string
wlmAgentLoadTrgt: string
wlmCpuLimit: string
wlmCpuShareMode: string
wlmCpuShares: string
registries:
- db2AlternateAuthzBehaviour: string
db2Antijoin: string
db2AtsEnable: string
db2Bidi: string
db2Compopt: string
db2DeferredPrepareSemantics: string
db2Evaluncommitted: string
db2ExtendedOptimization: string
db2IndexPctfreeDefault: string
db2InlistToNljn: string
db2LockToRb: string
db2MinimizeListprefetch: string
db2ObjectTableEntries: string
db2OptMaxTempSize: string
db2Optprofile: string
db2OptstatsLog: string
db2ParallelIo: string
db2ReducedOptimization: string
db2Selectivity: string
db2Skipdeleted: string
db2Skipinserted: string
db2Stmm: string
db2SyncReleaseLockAttributes: string
db2TruncateReusestorage: string
db2UseAlternatePageCleaning: string
db2ViewReoptValues: string
db2WlmSettings: string
db2Workload: string
db2Id: string
diskEncryptionInstanceCrn: string
diskEncryptionKeyCrn: string
highAvailability: string
instanceType: string
location: string
name: string
oracleCompatibility: string
parameters:
string: string
parametersJson: string
plan: string
resourceGroupId: string
service: string
serviceEndpoints: string
subscriptionId: string
tags:
- string
timeouts:
create: string
delete: string
update: string
usersConfigs:
- authentications:
- method: string
policyId: string
email: string
iam: false
ibmid: string
id: string
locked: string
name: string
password: string
role: string
Db2 Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The Db2 resource accepts the following input properties:
- Location string
- The location where the instance available
- Plan string
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - Service string
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - Allowlist
Configs List<Db2AllowlistConfig> - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - Autoscale
Configs List<Db2AutoscaleConfig> - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - Backup
Location string - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- Custom
Setting List<Db2CustomConfigs Setting Config> - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - Db2Id string
- (String) The CRN of the database instance.
- Disk
Encryption stringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- Disk
Encryption stringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- High
Availability string - By default, it is
no.if you want please change toyes - Instance
Type string - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- Name string
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- Oracle
Compatibility string - If you require Oracle compatibility, please choose this option(YES/NO).
- Parameters Dictionary<string, string>
- Arbitrary parameters to pass. Must be a JSON object
- Parameters
Json string Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- Resource
Group stringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - Service
Endpoints string - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - Subscription
Id string - ID which is required for subscription plans, for example: PerformanceSubscription.
- List<string>
- A list of tags that you want to add to your instance.
- Timeouts Db2Timeouts
- Users
Configs List<Db2UsersConfig> - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- Location string
- The location where the instance available
- Plan string
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - Service string
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - Allowlist
Configs []Db2AllowlistConfig Args - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - Autoscale
Configs []Db2AutoscaleConfig Args - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - Backup
Location string - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- Custom
Setting []Db2CustomConfigs Setting Config Args - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - Db2Id string
- (String) The CRN of the database instance.
- Disk
Encryption stringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- Disk
Encryption stringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- High
Availability string - By default, it is
no.if you want please change toyes - Instance
Type string - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- Name string
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- Oracle
Compatibility string - If you require Oracle compatibility, please choose this option(YES/NO).
- Parameters map[string]string
- Arbitrary parameters to pass. Must be a JSON object
- Parameters
Json string Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- Resource
Group stringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - Service
Endpoints string - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - Subscription
Id string - ID which is required for subscription plans, for example: PerformanceSubscription.
- []string
- A list of tags that you want to add to your instance.
- Timeouts
Db2Timeouts
Args - Users
Configs []Db2UsersConfig Args - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- location String
- The location where the instance available
- plan String
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - service String
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - allowlist
Configs List<Db2AllowlistConfig> - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale
Configs List<Db2AutoscaleConfig> - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup
Location String - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- custom
Setting List<Db2CustomConfigs Setting Config> - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - db2Id String
- (String) The CRN of the database instance.
- disk
Encryption StringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk
Encryption StringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- high
Availability String - By default, it is
no.if you want please change toyes - instance
Type String - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- name String
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- oracle
Compatibility String - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters Map<String,String>
- Arbitrary parameters to pass. Must be a JSON object
- parameters
Json String Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- resource
Group StringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - service
Endpoints String - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - subscription
Id String - ID which is required for subscription plans, for example: PerformanceSubscription.
- List<String>
- A list of tags that you want to add to your instance.
- timeouts Db2Timeouts
- users
Configs List<Db2UsersConfig> - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- location string
- The location where the instance available
- plan string
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - service string
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - allowlist
Configs Db2AllowlistConfig[] - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale
Configs Db2AutoscaleConfig[] - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup
Location string - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- custom
Setting Db2CustomConfigs Setting Config[] - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - db2Id string
- (String) The CRN of the database instance.
- disk
Encryption stringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk
Encryption stringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- high
Availability string - By default, it is
no.if you want please change toyes - instance
Type string - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- name string
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- oracle
Compatibility string - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters {[key: string]: string}
- Arbitrary parameters to pass. Must be a JSON object
- parameters
Json string Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- resource
Group stringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - service
Endpoints string - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - subscription
Id string - ID which is required for subscription plans, for example: PerformanceSubscription.
- string[]
- A list of tags that you want to add to your instance.
- timeouts Db2Timeouts
- users
Configs Db2UsersConfig[] - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- location str
- The location where the instance available
- plan str
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - service str
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - allowlist_
configs Sequence[Db2AllowlistConfig Args] - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale_
configs Sequence[Db2AutoscaleConfig Args] - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup_
location str - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- custom_
setting_ Sequence[Db2Customconfigs Setting Config Args] - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - db2_
id str - (String) The CRN of the database instance.
- disk_
encryption_ strinstance_ crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk_
encryption_ strkey_ crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- high_
availability str - By default, it is
no.if you want please change toyes - instance_
type str - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- name str
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- oracle_
compatibility str - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters Mapping[str, str]
- Arbitrary parameters to pass. Must be a JSON object
- parameters_
json str Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- resource_
group_ strid - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - service_
endpoints str - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - subscription_
id str - ID which is required for subscription plans, for example: PerformanceSubscription.
- Sequence[str]
- A list of tags that you want to add to your instance.
- timeouts
Db2Timeouts
Args - users_
configs Sequence[Db2UsersConfig Args] - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- location String
- The location where the instance available
- plan String
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - service String
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - allowlist
Configs List<Property Map> - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale
Configs List<Property Map> - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup
Location String - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- custom
Setting List<Property Map>Configs - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - db2Id String
- (String) The CRN of the database instance.
- disk
Encryption StringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk
Encryption StringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- high
Availability String - By default, it is
no.if you want please change toyes - instance
Type String - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- name String
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- oracle
Compatibility String - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters Map<String>
- Arbitrary parameters to pass. Must be a JSON object
- parameters
Json String Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- resource
Group StringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - service
Endpoints String - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - subscription
Id String - ID which is required for subscription plans, for example: PerformanceSubscription.
- List<String>
- A list of tags that you want to add to your instance.
- timeouts Property Map
- users
Configs List<Property Map> - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
Outputs
All input properties are implicitly available as output properties. Additionally, the Db2 resource produces the following output properties:
- Account
Id string - An alpha-numeric value identifying the account ID.
- Allow
Cleanup bool - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Created
At string - The date when the instance was created.
- Created
By string - The subject who created the instance.
- Crn string
- CRN of resource instance
- Dashboard
Url string - Dashboard URL to access resource.
- Deleted
At string - The date when the instance was deleted.
- Deleted
By string - The subject who deleted the instance.
- Extensions Dictionary<string, string>
- The extended metadata as a map associated with the resource instance.
- Guid string
- Guid of resource instance
- Id string
- The provider-assigned unique ID for this managed resource.
- Last
Operation Dictionary<string, string> - The status of the last operation requested on the instance
- Locked bool
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Onetime
Credentials bool - A boolean that dictates if the onetime_credentials is true or false.
- Plan
Histories List<Db2PlanHistory> - The plan history of the instance.
- Resource
Aliases stringUrl - The relative path to the resource aliases for the instance.
- Resource
Bindings stringUrl - The relative path to the resource bindings for the instance.
- Resource
Controller stringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- Resource
Crn string - The crn of the resource
- Resource
Group stringCrn - The long ID (full CRN) of the resource group
- Resource
Group stringName - The resource group name in which resource is provisioned
- Resource
Id string - The unique ID of the offering
- Resource
Keys stringUrl - The relative path to the resource keys for the instance.
- Resource
Name string - The name of the resource
- Resource
Plan stringId - The unique ID of the plan associated with the offering
- Resource
Status string - The status of the resource
- Restored
At string - The date when the instance under reclamation was restored.
- Restored
By string - The subject who restored the instance back from reclamation.
- Scheduled
Reclaim stringAt - The date when the instance was scheduled for reclamation.
- Scheduled
Reclaim stringBy - The subject who initiated the instance reclamation.
- State string
- The current state of the instance.
- Status string
- (String) The status of the instance.
- Sub
Type string - The sub-type of instance, e.g. cfaas .
- Target
Crn string - The full deployment CRN as defined in the global catalog
- Type string
- The type of the instance, e.g. service_instance.
- Update
At string - The date when the instance was last updated.
- Update
By string - The subject who updated the instance.
- Account
Id string - An alpha-numeric value identifying the account ID.
- Allow
Cleanup bool - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Created
At string - The date when the instance was created.
- Created
By string - The subject who created the instance.
- Crn string
- CRN of resource instance
- Dashboard
Url string - Dashboard URL to access resource.
- Deleted
At string - The date when the instance was deleted.
- Deleted
By string - The subject who deleted the instance.
- Extensions map[string]string
- The extended metadata as a map associated with the resource instance.
- Guid string
- Guid of resource instance
- Id string
- The provider-assigned unique ID for this managed resource.
- Last
Operation map[string]string - The status of the last operation requested on the instance
- Locked bool
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Onetime
Credentials bool - A boolean that dictates if the onetime_credentials is true or false.
- Plan
Histories []Db2PlanHistory - The plan history of the instance.
- Resource
Aliases stringUrl - The relative path to the resource aliases for the instance.
- Resource
Bindings stringUrl - The relative path to the resource bindings for the instance.
- Resource
Controller stringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- Resource
Crn string - The crn of the resource
- Resource
Group stringCrn - The long ID (full CRN) of the resource group
- Resource
Group stringName - The resource group name in which resource is provisioned
- Resource
Id string - The unique ID of the offering
- Resource
Keys stringUrl - The relative path to the resource keys for the instance.
- Resource
Name string - The name of the resource
- Resource
Plan stringId - The unique ID of the plan associated with the offering
- Resource
Status string - The status of the resource
- Restored
At string - The date when the instance under reclamation was restored.
- Restored
By string - The subject who restored the instance back from reclamation.
- Scheduled
Reclaim stringAt - The date when the instance was scheduled for reclamation.
- Scheduled
Reclaim stringBy - The subject who initiated the instance reclamation.
- State string
- The current state of the instance.
- Status string
- (String) The status of the instance.
- Sub
Type string - The sub-type of instance, e.g. cfaas .
- Target
Crn string - The full deployment CRN as defined in the global catalog
- Type string
- The type of the instance, e.g. service_instance.
- Update
At string - The date when the instance was last updated.
- Update
By string - The subject who updated the instance.
- account
Id String - An alpha-numeric value identifying the account ID.
- allow
Cleanup Boolean - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- created
At String - The date when the instance was created.
- created
By String - The subject who created the instance.
- crn String
- CRN of resource instance
- dashboard
Url String - Dashboard URL to access resource.
- deleted
At String - The date when the instance was deleted.
- deleted
By String - The subject who deleted the instance.
- extensions Map<String,String>
- The extended metadata as a map associated with the resource instance.
- guid String
- Guid of resource instance
- id String
- The provider-assigned unique ID for this managed resource.
- last
Operation Map<String,String> - The status of the last operation requested on the instance
- locked Boolean
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- onetime
Credentials Boolean - A boolean that dictates if the onetime_credentials is true or false.
- plan
Histories List<Db2PlanHistory> - The plan history of the instance.
- resource
Aliases StringUrl - The relative path to the resource aliases for the instance.
- resource
Bindings StringUrl - The relative path to the resource bindings for the instance.
- resource
Controller StringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource
Crn String - The crn of the resource
- resource
Group StringCrn - The long ID (full CRN) of the resource group
- resource
Group StringName - The resource group name in which resource is provisioned
- resource
Id String - The unique ID of the offering
- resource
Keys StringUrl - The relative path to the resource keys for the instance.
- resource
Name String - The name of the resource
- resource
Plan StringId - The unique ID of the plan associated with the offering
- resource
Status String - The status of the resource
- restored
At String - The date when the instance under reclamation was restored.
- restored
By String - The subject who restored the instance back from reclamation.
- scheduled
Reclaim StringAt - The date when the instance was scheduled for reclamation.
- scheduled
Reclaim StringBy - The subject who initiated the instance reclamation.
- state String
- The current state of the instance.
- status String
- (String) The status of the instance.
- sub
Type String - The sub-type of instance, e.g. cfaas .
- target
Crn String - The full deployment CRN as defined in the global catalog
- type String
- The type of the instance, e.g. service_instance.
- update
At String - The date when the instance was last updated.
- update
By String - The subject who updated the instance.
- account
Id string - An alpha-numeric value identifying the account ID.
- allow
Cleanup boolean - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- created
At string - The date when the instance was created.
- created
By string - The subject who created the instance.
- crn string
- CRN of resource instance
- dashboard
Url string - Dashboard URL to access resource.
- deleted
At string - The date when the instance was deleted.
- deleted
By string - The subject who deleted the instance.
- extensions {[key: string]: string}
- The extended metadata as a map associated with the resource instance.
- guid string
- Guid of resource instance
- id string
- The provider-assigned unique ID for this managed resource.
- last
Operation {[key: string]: string} - The status of the last operation requested on the instance
- locked boolean
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- onetime
Credentials boolean - A boolean that dictates if the onetime_credentials is true or false.
- plan
Histories Db2PlanHistory[] - The plan history of the instance.
- resource
Aliases stringUrl - The relative path to the resource aliases for the instance.
- resource
Bindings stringUrl - The relative path to the resource bindings for the instance.
- resource
Controller stringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource
Crn string - The crn of the resource
- resource
Group stringCrn - The long ID (full CRN) of the resource group
- resource
Group stringName - The resource group name in which resource is provisioned
- resource
Id string - The unique ID of the offering
- resource
Keys stringUrl - The relative path to the resource keys for the instance.
- resource
Name string - The name of the resource
- resource
Plan stringId - The unique ID of the plan associated with the offering
- resource
Status string - The status of the resource
- restored
At string - The date when the instance under reclamation was restored.
- restored
By string - The subject who restored the instance back from reclamation.
- scheduled
Reclaim stringAt - The date when the instance was scheduled for reclamation.
- scheduled
Reclaim stringBy - The subject who initiated the instance reclamation.
- state string
- The current state of the instance.
- status string
- (String) The status of the instance.
- sub
Type string - The sub-type of instance, e.g. cfaas .
- target
Crn string - The full deployment CRN as defined in the global catalog
- type string
- The type of the instance, e.g. service_instance.
- update
At string - The date when the instance was last updated.
- update
By string - The subject who updated the instance.
- account_
id str - An alpha-numeric value identifying the account ID.
- allow_
cleanup bool - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- created_
at str - The date when the instance was created.
- created_
by str - The subject who created the instance.
- crn str
- CRN of resource instance
- dashboard_
url str - Dashboard URL to access resource.
- deleted_
at str - The date when the instance was deleted.
- deleted_
by str - The subject who deleted the instance.
- extensions Mapping[str, str]
- The extended metadata as a map associated with the resource instance.
- guid str
- Guid of resource instance
- id str
- The provider-assigned unique ID for this managed resource.
- last_
operation Mapping[str, str] - The status of the last operation requested on the instance
- locked bool
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- onetime_
credentials bool - A boolean that dictates if the onetime_credentials is true or false.
- plan_
histories Sequence[Db2PlanHistory] - The plan history of the instance.
- resource_
aliases_ strurl - The relative path to the resource aliases for the instance.
- resource_
bindings_ strurl - The relative path to the resource bindings for the instance.
- resource_
controller_ strurl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource_
crn str - The crn of the resource
- resource_
group_ strcrn - The long ID (full CRN) of the resource group
- resource_
group_ strname - The resource group name in which resource is provisioned
- resource_
id str - The unique ID of the offering
- resource_
keys_ strurl - The relative path to the resource keys for the instance.
- resource_
name str - The name of the resource
- resource_
plan_ strid - The unique ID of the plan associated with the offering
- resource_
status str - The status of the resource
- restored_
at str - The date when the instance under reclamation was restored.
- restored_
by str - The subject who restored the instance back from reclamation.
- scheduled_
reclaim_ strat - The date when the instance was scheduled for reclamation.
- scheduled_
reclaim_ strby - The subject who initiated the instance reclamation.
- state str
- The current state of the instance.
- status str
- (String) The status of the instance.
- sub_
type str - The sub-type of instance, e.g. cfaas .
- target_
crn str - The full deployment CRN as defined in the global catalog
- type str
- The type of the instance, e.g. service_instance.
- update_
at str - The date when the instance was last updated.
- update_
by str - The subject who updated the instance.
- account
Id String - An alpha-numeric value identifying the account ID.
- allow
Cleanup Boolean - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- created
At String - The date when the instance was created.
- created
By String - The subject who created the instance.
- crn String
- CRN of resource instance
- dashboard
Url String - Dashboard URL to access resource.
- deleted
At String - The date when the instance was deleted.
- deleted
By String - The subject who deleted the instance.
- extensions Map<String>
- The extended metadata as a map associated with the resource instance.
- guid String
- Guid of resource instance
- id String
- The provider-assigned unique ID for this managed resource.
- last
Operation Map<String> - The status of the last operation requested on the instance
- locked Boolean
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- onetime
Credentials Boolean - A boolean that dictates if the onetime_credentials is true or false.
- plan
Histories List<Property Map> - The plan history of the instance.
- resource
Aliases StringUrl - The relative path to the resource aliases for the instance.
- resource
Bindings StringUrl - The relative path to the resource bindings for the instance.
- resource
Controller StringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource
Crn String - The crn of the resource
- resource
Group StringCrn - The long ID (full CRN) of the resource group
- resource
Group StringName - The resource group name in which resource is provisioned
- resource
Id String - The unique ID of the offering
- resource
Keys StringUrl - The relative path to the resource keys for the instance.
- resource
Name String - The name of the resource
- resource
Plan StringId - The unique ID of the plan associated with the offering
- resource
Status String - The status of the resource
- restored
At String - The date when the instance under reclamation was restored.
- restored
By String - The subject who restored the instance back from reclamation.
- scheduled
Reclaim StringAt - The date when the instance was scheduled for reclamation.
- scheduled
Reclaim StringBy - The subject who initiated the instance reclamation.
- state String
- The current state of the instance.
- status String
- (String) The status of the instance.
- sub
Type String - The sub-type of instance, e.g. cfaas .
- target
Crn String - The full deployment CRN as defined in the global catalog
- type String
- The type of the instance, e.g. service_instance.
- update
At String - The date when the instance was last updated.
- update
By String - The subject who updated the instance.
Look up Existing Db2 Resource
Get an existing Db2 resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: Db2State, opts?: CustomResourceOptions): Db2@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
account_id: Optional[str] = None,
allow_cleanup: Optional[bool] = None,
allowlist_configs: Optional[Sequence[Db2AllowlistConfigArgs]] = None,
autoscale_configs: Optional[Sequence[Db2AutoscaleConfigArgs]] = None,
backup_location: Optional[str] = None,
created_at: Optional[str] = None,
created_by: Optional[str] = None,
crn: Optional[str] = None,
custom_setting_configs: Optional[Sequence[Db2CustomSettingConfigArgs]] = None,
dashboard_url: Optional[str] = None,
db2_id: Optional[str] = None,
deleted_at: Optional[str] = None,
deleted_by: Optional[str] = None,
disk_encryption_instance_crn: Optional[str] = None,
disk_encryption_key_crn: Optional[str] = None,
extensions: Optional[Mapping[str, str]] = None,
guid: Optional[str] = None,
high_availability: Optional[str] = None,
instance_type: Optional[str] = None,
last_operation: Optional[Mapping[str, str]] = None,
location: Optional[str] = None,
locked: Optional[bool] = None,
name: Optional[str] = None,
onetime_credentials: Optional[bool] = None,
oracle_compatibility: Optional[str] = None,
parameters: Optional[Mapping[str, str]] = None,
parameters_json: Optional[str] = None,
plan: Optional[str] = None,
plan_histories: Optional[Sequence[Db2PlanHistoryArgs]] = None,
resource_aliases_url: Optional[str] = None,
resource_bindings_url: Optional[str] = None,
resource_controller_url: Optional[str] = None,
resource_crn: Optional[str] = None,
resource_group_crn: Optional[str] = None,
resource_group_id: Optional[str] = None,
resource_group_name: Optional[str] = None,
resource_id: Optional[str] = None,
resource_keys_url: Optional[str] = None,
resource_name: Optional[str] = None,
resource_plan_id: Optional[str] = None,
resource_status: Optional[str] = None,
restored_at: Optional[str] = None,
restored_by: Optional[str] = None,
scheduled_reclaim_at: Optional[str] = None,
scheduled_reclaim_by: Optional[str] = None,
service: Optional[str] = None,
service_endpoints: Optional[str] = None,
state: Optional[str] = None,
status: Optional[str] = None,
sub_type: Optional[str] = None,
subscription_id: Optional[str] = None,
tags: Optional[Sequence[str]] = None,
target_crn: Optional[str] = None,
timeouts: Optional[Db2TimeoutsArgs] = None,
type: Optional[str] = None,
update_at: Optional[str] = None,
update_by: Optional[str] = None,
users_configs: Optional[Sequence[Db2UsersConfigArgs]] = None) -> Db2func GetDb2(ctx *Context, name string, id IDInput, state *Db2State, opts ...ResourceOption) (*Db2, error)public static Db2 Get(string name, Input<string> id, Db2State? state, CustomResourceOptions? opts = null)public static Db2 get(String name, Output<String> id, Db2State state, CustomResourceOptions options)resources: _: type: ibm:Db2 get: id: ${id}- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Account
Id string - An alpha-numeric value identifying the account ID.
- Allow
Cleanup bool - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Allowlist
Configs List<Db2AllowlistConfig> - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - Autoscale
Configs List<Db2AutoscaleConfig> - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - Backup
Location string - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- Created
At string - The date when the instance was created.
- Created
By string - The subject who created the instance.
- Crn string
- CRN of resource instance
- Custom
Setting List<Db2CustomConfigs Setting Config> - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - Dashboard
Url string - Dashboard URL to access resource.
- Db2Id string
- (String) The CRN of the database instance.
- Deleted
At string - The date when the instance was deleted.
- Deleted
By string - The subject who deleted the instance.
- Disk
Encryption stringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- Disk
Encryption stringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- Extensions Dictionary<string, string>
- The extended metadata as a map associated with the resource instance.
- Guid string
- Guid of resource instance
- High
Availability string - By default, it is
no.if you want please change toyes - Instance
Type string - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- Last
Operation Dictionary<string, string> - The status of the last operation requested on the instance
- Location string
- The location where the instance available
- Locked bool
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Name string
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- Onetime
Credentials bool - A boolean that dictates if the onetime_credentials is true or false.
- Oracle
Compatibility string - If you require Oracle compatibility, please choose this option(YES/NO).
- Parameters Dictionary<string, string>
- Arbitrary parameters to pass. Must be a JSON object
- Parameters
Json string Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- Plan string
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - Plan
Histories List<Db2PlanHistory> - The plan history of the instance.
- Resource
Aliases stringUrl - The relative path to the resource aliases for the instance.
- Resource
Bindings stringUrl - The relative path to the resource bindings for the instance.
- Resource
Controller stringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- Resource
Crn string - The crn of the resource
- Resource
Group stringCrn - The long ID (full CRN) of the resource group
- Resource
Group stringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - Resource
Group stringName - The resource group name in which resource is provisioned
- Resource
Id string - The unique ID of the offering
- Resource
Keys stringUrl - The relative path to the resource keys for the instance.
- Resource
Name string - The name of the resource
- Resource
Plan stringId - The unique ID of the plan associated with the offering
- Resource
Status string - The status of the resource
- Restored
At string - The date when the instance under reclamation was restored.
- Restored
By string - The subject who restored the instance back from reclamation.
- Scheduled
Reclaim stringAt - The date when the instance was scheduled for reclamation.
- Scheduled
Reclaim stringBy - The subject who initiated the instance reclamation.
- Service string
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - Service
Endpoints string - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - State string
- The current state of the instance.
- Status string
- (String) The status of the instance.
- Sub
Type string - The sub-type of instance, e.g. cfaas .
- Subscription
Id string - ID which is required for subscription plans, for example: PerformanceSubscription.
- List<string>
- A list of tags that you want to add to your instance.
- Target
Crn string - The full deployment CRN as defined in the global catalog
- Timeouts Db2Timeouts
- Type string
- The type of the instance, e.g. service_instance.
- Update
At string - The date when the instance was last updated.
- Update
By string - The subject who updated the instance.
- Users
Configs List<Db2UsersConfig> - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- Account
Id string - An alpha-numeric value identifying the account ID.
- Allow
Cleanup bool - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Allowlist
Configs []Db2AllowlistConfig Args - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - Autoscale
Configs []Db2AutoscaleConfig Args - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - Backup
Location string - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- Created
At string - The date when the instance was created.
- Created
By string - The subject who created the instance.
- Crn string
- CRN of resource instance
- Custom
Setting []Db2CustomConfigs Setting Config Args - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - Dashboard
Url string - Dashboard URL to access resource.
- Db2Id string
- (String) The CRN of the database instance.
- Deleted
At string - The date when the instance was deleted.
- Deleted
By string - The subject who deleted the instance.
- Disk
Encryption stringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- Disk
Encryption stringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- Extensions map[string]string
- The extended metadata as a map associated with the resource instance.
- Guid string
- Guid of resource instance
- High
Availability string - By default, it is
no.if you want please change toyes - Instance
Type string - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- Last
Operation map[string]string - The status of the last operation requested on the instance
- Location string
- The location where the instance available
- Locked bool
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- Name string
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- Onetime
Credentials bool - A boolean that dictates if the onetime_credentials is true or false.
- Oracle
Compatibility string - If you require Oracle compatibility, please choose this option(YES/NO).
- Parameters map[string]string
- Arbitrary parameters to pass. Must be a JSON object
- Parameters
Json string Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- Plan string
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - Plan
Histories []Db2PlanHistory Args - The plan history of the instance.
- Resource
Aliases stringUrl - The relative path to the resource aliases for the instance.
- Resource
Bindings stringUrl - The relative path to the resource bindings for the instance.
- Resource
Controller stringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- Resource
Crn string - The crn of the resource
- Resource
Group stringCrn - The long ID (full CRN) of the resource group
- Resource
Group stringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - Resource
Group stringName - The resource group name in which resource is provisioned
- Resource
Id string - The unique ID of the offering
- Resource
Keys stringUrl - The relative path to the resource keys for the instance.
- Resource
Name string - The name of the resource
- Resource
Plan stringId - The unique ID of the plan associated with the offering
- Resource
Status string - The status of the resource
- Restored
At string - The date when the instance under reclamation was restored.
- Restored
By string - The subject who restored the instance back from reclamation.
- Scheduled
Reclaim stringAt - The date when the instance was scheduled for reclamation.
- Scheduled
Reclaim stringBy - The subject who initiated the instance reclamation.
- Service string
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - Service
Endpoints string - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - State string
- The current state of the instance.
- Status string
- (String) The status of the instance.
- Sub
Type string - The sub-type of instance, e.g. cfaas .
- Subscription
Id string - ID which is required for subscription plans, for example: PerformanceSubscription.
- []string
- A list of tags that you want to add to your instance.
- Target
Crn string - The full deployment CRN as defined in the global catalog
- Timeouts
Db2Timeouts
Args - Type string
- The type of the instance, e.g. service_instance.
- Update
At string - The date when the instance was last updated.
- Update
By string - The subject who updated the instance.
- Users
Configs []Db2UsersConfig Args - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- account
Id String - An alpha-numeric value identifying the account ID.
- allow
Cleanup Boolean - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- allowlist
Configs List<Db2AllowlistConfig> - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale
Configs List<Db2AutoscaleConfig> - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup
Location String - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- created
At String - The date when the instance was created.
- created
By String - The subject who created the instance.
- crn String
- CRN of resource instance
- custom
Setting List<Db2CustomConfigs Setting Config> - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - dashboard
Url String - Dashboard URL to access resource.
- db2Id String
- (String) The CRN of the database instance.
- deleted
At String - The date when the instance was deleted.
- deleted
By String - The subject who deleted the instance.
- disk
Encryption StringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk
Encryption StringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- extensions Map<String,String>
- The extended metadata as a map associated with the resource instance.
- guid String
- Guid of resource instance
- high
Availability String - By default, it is
no.if you want please change toyes - instance
Type String - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- last
Operation Map<String,String> - The status of the last operation requested on the instance
- location String
- The location where the instance available
- locked Boolean
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- name String
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- onetime
Credentials Boolean - A boolean that dictates if the onetime_credentials is true or false.
- oracle
Compatibility String - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters Map<String,String>
- Arbitrary parameters to pass. Must be a JSON object
- parameters
Json String Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- plan String
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - plan
Histories List<Db2PlanHistory> - The plan history of the instance.
- resource
Aliases StringUrl - The relative path to the resource aliases for the instance.
- resource
Bindings StringUrl - The relative path to the resource bindings for the instance.
- resource
Controller StringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource
Crn String - The crn of the resource
- resource
Group StringCrn - The long ID (full CRN) of the resource group
- resource
Group StringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - resource
Group StringName - The resource group name in which resource is provisioned
- resource
Id String - The unique ID of the offering
- resource
Keys StringUrl - The relative path to the resource keys for the instance.
- resource
Name String - The name of the resource
- resource
Plan StringId - The unique ID of the plan associated with the offering
- resource
Status String - The status of the resource
- restored
At String - The date when the instance under reclamation was restored.
- restored
By String - The subject who restored the instance back from reclamation.
- scheduled
Reclaim StringAt - The date when the instance was scheduled for reclamation.
- scheduled
Reclaim StringBy - The subject who initiated the instance reclamation.
- service String
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - service
Endpoints String - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - state String
- The current state of the instance.
- status String
- (String) The status of the instance.
- sub
Type String - The sub-type of instance, e.g. cfaas .
- subscription
Id String - ID which is required for subscription plans, for example: PerformanceSubscription.
- List<String>
- A list of tags that you want to add to your instance.
- target
Crn String - The full deployment CRN as defined in the global catalog
- timeouts Db2Timeouts
- type String
- The type of the instance, e.g. service_instance.
- update
At String - The date when the instance was last updated.
- update
By String - The subject who updated the instance.
- users
Configs List<Db2UsersConfig> - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- account
Id string - An alpha-numeric value identifying the account ID.
- allow
Cleanup boolean - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- allowlist
Configs Db2AllowlistConfig[] - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale
Configs Db2AutoscaleConfig[] - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup
Location string - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- created
At string - The date when the instance was created.
- created
By string - The subject who created the instance.
- crn string
- CRN of resource instance
- custom
Setting Db2CustomConfigs Setting Config[] - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - dashboard
Url string - Dashboard URL to access resource.
- db2Id string
- (String) The CRN of the database instance.
- deleted
At string - The date when the instance was deleted.
- deleted
By string - The subject who deleted the instance.
- disk
Encryption stringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk
Encryption stringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- extensions {[key: string]: string}
- The extended metadata as a map associated with the resource instance.
- guid string
- Guid of resource instance
- high
Availability string - By default, it is
no.if you want please change toyes - instance
Type string - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- last
Operation {[key: string]: string} - The status of the last operation requested on the instance
- location string
- The location where the instance available
- locked boolean
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- name string
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- onetime
Credentials boolean - A boolean that dictates if the onetime_credentials is true or false.
- oracle
Compatibility string - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters {[key: string]: string}
- Arbitrary parameters to pass. Must be a JSON object
- parameters
Json string Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- plan string
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - plan
Histories Db2PlanHistory[] - The plan history of the instance.
- resource
Aliases stringUrl - The relative path to the resource aliases for the instance.
- resource
Bindings stringUrl - The relative path to the resource bindings for the instance.
- resource
Controller stringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource
Crn string - The crn of the resource
- resource
Group stringCrn - The long ID (full CRN) of the resource group
- resource
Group stringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - resource
Group stringName - The resource group name in which resource is provisioned
- resource
Id string - The unique ID of the offering
- resource
Keys stringUrl - The relative path to the resource keys for the instance.
- resource
Name string - The name of the resource
- resource
Plan stringId - The unique ID of the plan associated with the offering
- resource
Status string - The status of the resource
- restored
At string - The date when the instance under reclamation was restored.
- restored
By string - The subject who restored the instance back from reclamation.
- scheduled
Reclaim stringAt - The date when the instance was scheduled for reclamation.
- scheduled
Reclaim stringBy - The subject who initiated the instance reclamation.
- service string
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - service
Endpoints string - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - state string
- The current state of the instance.
- status string
- (String) The status of the instance.
- sub
Type string - The sub-type of instance, e.g. cfaas .
- subscription
Id string - ID which is required for subscription plans, for example: PerformanceSubscription.
- string[]
- A list of tags that you want to add to your instance.
- target
Crn string - The full deployment CRN as defined in the global catalog
- timeouts Db2Timeouts
- type string
- The type of the instance, e.g. service_instance.
- update
At string - The date when the instance was last updated.
- update
By string - The subject who updated the instance.
- users
Configs Db2UsersConfig[] - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- account_
id str - An alpha-numeric value identifying the account ID.
- allow_
cleanup bool - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- allowlist_
configs Sequence[Db2AllowlistConfig Args] - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale_
configs Sequence[Db2AutoscaleConfig Args] - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup_
location str - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- created_
at str - The date when the instance was created.
- created_
by str - The subject who created the instance.
- crn str
- CRN of resource instance
- custom_
setting_ Sequence[Db2Customconfigs Setting Config Args] - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - dashboard_
url str - Dashboard URL to access resource.
- db2_
id str - (String) The CRN of the database instance.
- deleted_
at str - The date when the instance was deleted.
- deleted_
by str - The subject who deleted the instance.
- disk_
encryption_ strinstance_ crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk_
encryption_ strkey_ crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- extensions Mapping[str, str]
- The extended metadata as a map associated with the resource instance.
- guid str
- Guid of resource instance
- high_
availability str - By default, it is
no.if you want please change toyes - instance_
type str - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- last_
operation Mapping[str, str] - The status of the last operation requested on the instance
- location str
- The location where the instance available
- locked bool
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- name str
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- onetime_
credentials bool - A boolean that dictates if the onetime_credentials is true or false.
- oracle_
compatibility str - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters Mapping[str, str]
- Arbitrary parameters to pass. Must be a JSON object
- parameters_
json str Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- plan str
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - plan_
histories Sequence[Db2PlanHistory Args] - The plan history of the instance.
- resource_
aliases_ strurl - The relative path to the resource aliases for the instance.
- resource_
bindings_ strurl - The relative path to the resource bindings for the instance.
- resource_
controller_ strurl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource_
crn str - The crn of the resource
- resource_
group_ strcrn - The long ID (full CRN) of the resource group
- resource_
group_ strid - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - resource_
group_ strname - The resource group name in which resource is provisioned
- resource_
id str - The unique ID of the offering
- resource_
keys_ strurl - The relative path to the resource keys for the instance.
- resource_
name str - The name of the resource
- resource_
plan_ strid - The unique ID of the plan associated with the offering
- resource_
status str - The status of the resource
- restored_
at str - The date when the instance under reclamation was restored.
- restored_
by str - The subject who restored the instance back from reclamation.
- scheduled_
reclaim_ strat - The date when the instance was scheduled for reclamation.
- scheduled_
reclaim_ strby - The subject who initiated the instance reclamation.
- service str
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - service_
endpoints str - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - state str
- The current state of the instance.
- status str
- (String) The status of the instance.
- sub_
type str - The sub-type of instance, e.g. cfaas .
- subscription_
id str - ID which is required for subscription plans, for example: PerformanceSubscription.
- Sequence[str]
- A list of tags that you want to add to your instance.
- target_
crn str - The full deployment CRN as defined in the global catalog
- timeouts
Db2Timeouts
Args - type str
- The type of the instance, e.g. service_instance.
- update_
at str - The date when the instance was last updated.
- update_
by str - The subject who updated the instance.
- users_
configs Sequence[Db2UsersConfig Args] - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
- account
Id String - An alpha-numeric value identifying the account ID.
- allow
Cleanup Boolean - A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- allowlist
Configs List<Property Map> - Defines allowlist configurations you want to set to Db2 SaaS instance.
Nested schema for
allowlist_config - autoscale
Configs List<Property Map> - Defines autoscale configurations you want to set to Db2 SaaS instance.
Nested schema for
autoscale_config - backup
Location String - Cross Regional backups can be stored across multiple regions in a zone. Regional backups are stored in only one specific region.
- created
At String - The date when the instance was created.
- created
By String - The subject who created the instance.
- crn String
- CRN of resource instance
- custom
Setting List<Property Map>Configs - Indicates the custom configuration fields related to database which you want to set to Db2 SaaS instance.
Nested schema for
custom_setting_config - dashboard
Url String - Dashboard URL to access resource.
- db2Id String
- (String) The CRN of the database instance.
- deleted
At String - The date when the instance was deleted.
- deleted
By String - The subject who deleted the instance.
- disk
Encryption StringInstance Crn - Please ensure Databases for Db2 has been authorized to access the selected KMS instance.
- disk
Encryption StringKey Crn - Warning: deleting this key will result in the loss of all data stored in this Db2 instance.
- extensions Map<String>
- The extended metadata as a map associated with the resource instance.
- guid String
- Guid of resource instance
- high
Availability String - By default, it is
no.if you want please change toyes - instance
Type String - The hosting infrastructure identifier.By Default
bx2.1x4taken automatically. With this identifier, minimum resource configurations apply. Alternatively, setting the identifier to any of the following host sizes places your database on the specified host size with no other tenants.bx2.4x16bx2.8x32bx2.16x64bx2.32x128bx2.48x192mx2.4x32mx2.16x128mx2.128x1024
- last
Operation Map<String> - The status of the last operation requested on the instance
- location String
- The location where the instance available
- locked Boolean
- A boolean that dictates if the resource instance should be deleted (cleaned up) during the processing of a region instance delete call.
- name String
- A descriptive name that is used to identify the database instance. The name must not include spaces.
- onetime
Credentials Boolean - A boolean that dictates if the onetime_credentials is true or false.
- oracle
Compatibility String - If you require Oracle compatibility, please choose this option(YES/NO).
- parameters Map<String>
- Arbitrary parameters to pass. Must be a JSON object
- parameters
Json String Parameters to create Db2 SaaS instance. The value must be a JSON string.
Nested schema for
parameters_json:- plan String
- The name of the service plan to use when provisioning. Currently the only supported option is
performance. - plan
Histories List<Property Map> - The plan history of the instance.
- resource
Aliases StringUrl - The relative path to the resource aliases for the instance.
- resource
Bindings StringUrl - The relative path to the resource bindings for the instance.
- resource
Controller StringUrl - The URL of the IBM Cloud dashboard that can be used to explore and view details about the resource
- resource
Crn String - The crn of the resource
- resource
Group StringCrn - The long ID (full CRN) of the resource group
- resource
Group StringId - The ID of the resource group where you want to create the instance. To retrieve this value, run
ibmcloud resource groupsor use theibm.ResourceGroupdata source. If no value is provided, thedefaultresource group is used. - resource
Group StringName - The resource group name in which resource is provisioned
- resource
Id String - The unique ID of the offering
- resource
Keys StringUrl - The relative path to the resource keys for the instance.
- resource
Name String - The name of the resource
- resource
Plan StringId - The unique ID of the plan associated with the offering
- resource
Status String - The status of the resource
- restored
At String - The date when the instance under reclamation was restored.
- restored
By String - The subject who restored the instance back from reclamation.
- scheduled
Reclaim StringAt - The date when the instance was scheduled for reclamation.
- scheduled
Reclaim StringBy - The subject who initiated the instance reclamation.
- service String
- The type of Cloud Db2 SaaS that you want to create. Only the following services are currently accepted:
dashdb-for-transactionsonly. - service
Endpoints String - Specify whether you want to enable the public, private, or both service endpoints. Supported values are
public,private, orpublic-and-private. - state String
- The current state of the instance.
- status String
- (String) The status of the instance.
- sub
Type String - The sub-type of instance, e.g. cfaas .
- subscription
Id String - ID which is required for subscription plans, for example: PerformanceSubscription.
- List<String>
- A list of tags that you want to add to your instance.
- target
Crn String - The full deployment CRN as defined in the global catalog
- timeouts Property Map
- type String
- The type of the instance, e.g. service_instance.
- update
At String - The date when the instance was last updated.
- update
By String - The subject who updated the instance.
- users
Configs List<Property Map> - Defines users configurations you want to set to Db2 SaaS instance.
Nested schema for
users_config
Supporting Types
Db2AllowlistConfig, Db2AllowlistConfigArgs
- Ip
Addresses List<Db2AllowlistConfig Ip Address> - The ip_addresses allowed to access the Db2 instance
- Ip
Addresses []Db2AllowlistConfig Ip Address - The ip_addresses allowed to access the Db2 instance
- ip
Addresses List<Db2AllowlistConfig Ip Address> - The ip_addresses allowed to access the Db2 instance
- ip
Addresses Db2AllowlistConfig Ip Address[] - The ip_addresses allowed to access the Db2 instance
- ip_
addresses Sequence[Db2AllowlistConfig Ip Address] - The ip_addresses allowed to access the Db2 instance
- ip
Addresses List<Property Map> - The ip_addresses allowed to access the Db2 instance
Db2AllowlistConfigIpAddress, Db2AllowlistConfigIpAddressArgs
- Address string
- The IP address
- Description string
- The description for the ip address
- Address string
- The IP address
- Description string
- The description for the ip address
- address String
- The IP address
- description String
- The description for the ip address
- address string
- The IP address
- description string
- The description for the ip address
- address str
- The IP address
- description str
- The description for the ip address
- address String
- The IP address
- description String
- The description for the ip address
Db2AutoscaleConfig, Db2AutoscaleConfigArgs
- Auto
Scaling boolAllow Plan Limit - Indicates the maximum number of scaling actions that are allowed within a specified time period.
- Auto
Scaling boolEnabled - Indicates if automatic scaling is enabled or not.
- Auto
Scaling stringOver Time Period - Defines the time period over which auto-scaling adjustments are monitored and applied.
- Auto
Scaling doublePause Limit - Specifies the duration to pause auto-scaling actions after a scaling event has occurred.
- Auto
Scaling stringThreshold - Specifies the resource utilization level that triggers an auto-scaling.
- Auto
Scaling boolAllow Plan Limit - Indicates the maximum number of scaling actions that are allowed within a specified time period.
- Auto
Scaling boolEnabled - Indicates if automatic scaling is enabled or not.
- Auto
Scaling stringOver Time Period - Defines the time period over which auto-scaling adjustments are monitored and applied.
- Auto
Scaling float64Pause Limit - Specifies the duration to pause auto-scaling actions after a scaling event has occurred.
- Auto
Scaling stringThreshold - Specifies the resource utilization level that triggers an auto-scaling.
- auto
Scaling BooleanAllow Plan Limit - Indicates the maximum number of scaling actions that are allowed within a specified time period.
- auto
Scaling BooleanEnabled - Indicates if automatic scaling is enabled or not.
- auto
Scaling StringOver Time Period - Defines the time period over which auto-scaling adjustments are monitored and applied.
- auto
Scaling DoublePause Limit - Specifies the duration to pause auto-scaling actions after a scaling event has occurred.
- auto
Scaling StringThreshold - Specifies the resource utilization level that triggers an auto-scaling.
- auto
Scaling booleanAllow Plan Limit - Indicates the maximum number of scaling actions that are allowed within a specified time period.
- auto
Scaling booleanEnabled - Indicates if automatic scaling is enabled or not.
- auto
Scaling stringOver Time Period - Defines the time period over which auto-scaling adjustments are monitored and applied.
- auto
Scaling numberPause Limit - Specifies the duration to pause auto-scaling actions after a scaling event has occurred.
- auto
Scaling stringThreshold - Specifies the resource utilization level that triggers an auto-scaling.
- auto_
scaling_ boolallow_ plan_ limit - Indicates the maximum number of scaling actions that are allowed within a specified time period.
- auto_
scaling_ boolenabled - Indicates if automatic scaling is enabled or not.
- auto_
scaling_ strover_ time_ period - Defines the time period over which auto-scaling adjustments are monitored and applied.
- auto_
scaling_ floatpause_ limit - Specifies the duration to pause auto-scaling actions after a scaling event has occurred.
- auto_
scaling_ strthreshold - Specifies the resource utilization level that triggers an auto-scaling.
- auto
Scaling BooleanAllow Plan Limit - Indicates the maximum number of scaling actions that are allowed within a specified time period.
- auto
Scaling BooleanEnabled - Indicates if automatic scaling is enabled or not.
- auto
Scaling StringOver Time Period - Defines the time period over which auto-scaling adjustments are monitored and applied.
- auto
Scaling NumberPause Limit - Specifies the duration to pause auto-scaling actions after a scaling event has occurred.
- auto
Scaling StringThreshold - Specifies the resource utilization level that triggers an auto-scaling.
Db2CustomSettingConfig, Db2CustomSettingConfigArgs
- Dbms
List<Db2Custom
Setting Config Dbm> - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for dbm:
- Dbs
List<Db2Custom
Setting Config Db> - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for db:
- Registries
List<Db2Custom
Setting Config Registry> - Tunable parameters related to the Db2 registry.
- Dbms
[]Db2Custom
Setting Config Dbm - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for dbm:
- Dbs
[]Db2Custom
Setting Config Db - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for db:
- Registries
[]Db2Custom
Setting Config Registry - Tunable parameters related to the Db2 registry.
- dbms
List<Db2Custom
Setting Config Dbm> - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for dbm:
- dbs
List<Db2Custom
Setting Config Db> - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for db:
- registries
List<Db2Custom
Setting Config Registry> - Tunable parameters related to the Db2 registry.
- dbms
Db2Custom
Setting Config Dbm[] - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for dbm:
- dbs
Db2Custom
Setting Config Db[] - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for db:
- registries
Db2Custom
Setting Config Registry[] - Tunable parameters related to the Db2 registry.
- dbms
Sequence[Db2Custom
Setting Config Dbm] - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for dbm:
- dbs
Sequence[Db2Custom
Setting Config Db] - Tunable parameters related to the Db2 instance manager (dbm). Nested schema for db:
- registries
Sequence[Db2Custom
Setting Config Registry] - Tunable parameters related to the Db2 registry.
- dbms List<Property Map>
- Tunable parameters related to the Db2 instance manager (dbm). Nested schema for dbm:
- dbs List<Property Map>
- Tunable parameters related to the Db2 instance manager (dbm). Nested schema for db:
- registries List<Property Map>
- Tunable parameters related to the Db2 registry.
Db2CustomSettingConfigDb, Db2CustomSettingConfigDbArgs
- Act
Sortmem stringLimit - Configures the sort memory limit for DB2. Valid values: range(10, 100)
- Alt
Collate string - Configures the collation sequence, Valid values: "NULL", "IDENTITY_16BIT"
- App
Ctl stringHeap Sz - Configures the application control heap size. Valid values: range(1, 64000)
- Appgroup
Mem stringSz - Sets the application group memory size. Valid values: range(1, 1000000)
- Appl
Memory string - Configures the application memory allocation. Valid values: AUTOMATIC range(128, 4294967295)
- Applheapsz string
- Configures the application heap size,Valid values: "AUTOMATIC" "range(16, 2147483647)
- Archretrydelay string
- Configures the archive retry delay time. Valid values: range(0, 65535)
- Authn
Cache stringDuration - onfigures the authentication cache duration. Valid values: range(1,10000)
- Auto
Cg stringStats - Configures whether auto collection of CG statistics is enabled ,Valid values: ON, OFF
- Auto
Maint string - Configures automatic maintenance for the database,Valid values: ON ,OFF
- Auto
Reorg string - Configures automatic reorganization for the database,Valid values: ON ,OFF
- Auto
Reval string - Configures the auto refresh or revalidation method,Valid values: 'IMMEDIATE', 'DISABLED', 'DEFERRED', 'DEFERRED_FORCE'
- Auto
Runstats string - Configures automatic collection of run-time statistics,Valid values:'ON', 'OFF'
- Auto
Sampling string - Configures whether auto-sampling is enabled,Valid values: 'ON', 'OFF'
- Auto
Stats stringViews - Configures automatic collection of statistics on views,Valid values: 'ON', 'OFF'
- Auto
Stmt stringStats - Configures automatic collection of statement-level statistics,Valid values: 'ON', 'OFF'
- Auto
Tbl stringMaint - Configures automatic table maintenance,Valid values: 'ON', 'OFF'
- Autorestart string
- Configures whether the database will automatically restart,Valid values: 'ON', 'OFF'
- Avg
Appls string - Average number of applications.
- Catalogcache
Sz string - Configures the catalog cache size,
- Chngpgs
Thresh string - Configures the change pages threshold percentage, Valid values: range(5,99)
- Cur
Commit string - Configures the commit behavior, Valid values: "ON" "AVAILABLE" "DISABLED
- Database
Memory string - Configures the database memory management, Valid values: "AUTOMATIC" "COMPUTED" "range(0,4294967295)"
- Db
Collname string - Specifies the database collation name
- Db
Mem stringThresh - Configures the memory threshold percentage for database,Valid values: range(0,100)
- Dbheap string
- Configures the database heap size,Valid values: "AUTOMATIC" range(32, 2147483647)
- Ddl
Compression stringDef - Defines the default DDL compression behavior,Valid values: YES, NO
- Ddl
Constraint stringDef - Defines the default constraint behavior in DDL,Valid values: YES ,NO
- Dec
Arithmetic string - Configures the default arithmetic for decimal operations
- Dec
To stringChar Fmt - Configures the decimal-to-character conversion format, Valid values: "NEW" "V95"
- Decflt
Rounding string - Configures the decimal floating-point rounding method, Valid values: 'ROUND_HALF_EVEN', 'ROUND_CEILING', 'ROUND_FLOOR', 'ROUND_HALF_UP', 'ROUND_DOWN'
- Dft
Degree string - Configures the default degree for parallelism, Valid values:'-1', 'ANY', 'range(1, 32767)'
- Dft
Extent stringSz - Configures the default extent size for tables, Valid values: range(2, 256)
- Dft
Loadrec stringSes - Configures the default load record session count, Valid values: range(1, 30000)
- Dft
Mttb stringTypes - Configures the default MTTB (multi-table table scan) types
- Dft
Prefetch stringSz - Configures the default prefetch size for queries, Valid values: 'range(0, 32767)', 'AUTOMATIC'
- Dft
Queryopt string - onfigures the default query optimization level, Valid values: range(0, 9)
- Dft
Refresh stringAge - Configures the default refresh age for views
- Dft
Schemas stringDcc - Configures whether DCC (database control center) is enabled for schemas,Valid values:'YES', 'NO'
- Dft
Sqlmathwarn string - Configures whether SQL math warnings are enabled,Valid values: 'YES', 'NO'
- Dft
Table stringOrg - Configures the default table organization (ROW or COLUMN),Valid values: 'COLUMN', 'ROW'
- Dlchktime string
- Configures the deadlock check time in milliseconds, Valid values: range(1000, 600000)'
- Enable
Xmlchar string - Configures whether XML character support is enabled,Valid values: YES', 'NO'
- Extended
Row stringSz - Configures whether extended row size is enabled,Valid values: ENABLE', 'DISABLE'
- Groupheap
Ratio string - Configures the heap ratio for group heap memory, Valid values: range(1, 99)'
- Indexrec string
- Configures the index recovery method, Valid values:'SYSTEM', 'ACCESS', 'ACCESS_NO_REDO', 'RESTART', 'RESTART_NO_REDO'
- Large
Aggregation string - Configures whether large aggregation is enabled, Valid values:'YES', 'NO'
- Locklist string
- Configures the lock list memory size, Valid values:'AUTOMATIC', 'range(4, 134217728)'
- Locktimeout string
- Configures the lock timeout duration,Valid values: '-1', 'range(0, 32767)'
- Log
Appl stringInfo - Configures whether application information is logged,Valid values: 'YES', 'NO'
- Log
Ddl stringStmts - Configures whether DDL statements are logged, Valid values:'YES', 'NO'
- Log
Disk stringCap - Configures the disk capacity log setting,Valid values: '0', '-1', 'range(1, 2147483647)'
- Logindexbuild string
- Configures whether index builds are logged, Valid values:'ON', 'OFF'
- Maxappls string
- Configures the maximum number of applications,Valid values:range(1, 60000)
- Maxfilop string
- Configures the maximum number of file operations,Valid values: range(64, 61440)
- Maxlocks string
- Configures the maximum number of locks, Valid values:'AUTOMATIC', 'range(1, 100)'
- Min
Dec stringDiv3 - Configures whether decimal division by 3 should be handled,Valid values: 'YES', 'NO'
- Mon
Act stringMetrics - Configures the level of activity metrics to be monitored,Valid values: 'NONE', 'BASE', 'EXTENDED'
- Mon
Deadlock string - Configures deadlock monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- Mon
Lck stringMsg Lvl - Configures the lock message level for monitoring, Valid values: range(0, 3)
- Mon
Locktimeout string - Configures lock timeout monitoring settings, Valid values:'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- Mon
Lockwait string - Configures lock wait monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- Mon
Lw stringThresh - Configures the lightweight threshold for monitoring, Valid values: range(1000, 4294967295)
- Mon
Obj stringMetrics - Configures the object metrics level for monitoring,Valid values: 'NONE', 'BASE', 'EXTENDED'
- Mon
Pkglist stringSz - Configures the package list size for monitoring, Valid values: range(0, 1024)
- Mon
Req stringMetrics - Configures the request metrics level for monitoring, Valid values: 'NONE', 'BASE', 'EXTENDED'
- Mon
Rtn stringData - Configures the level of return data for monitoring,Valid values: 'NONE', 'BASE'
- Mon
Rtn stringExeclist - Configures whether stored procedure execution list is monitored, Valid values:'OFF', 'ON'
- Mon
Uow stringData - Configures the level of unit of work (UOW) data for monitoring,Valid values: 'NONE', 'BASE'
- Mon
Uow stringExeclist - Configures whether UOW execution list is monitored,Valid values: 'ON', 'OFF'
- Mon
Uow stringPkglist - Configures whether UOW package list is monitored,Valid values: 'OFF', 'ON'
- Nchar
Mapping string - Configures the mapping of NCHAR character types, Valid values:'CHAR_CU32', 'GRAPHIC_CU32', 'GRAPHIC_CU16', 'NOT APPLICABLE'
- Num
Freqvalues string - Configures the number of frequent values for optimization, Valid values: range(0, 32767)
- Num
Iocleaners string - Configures the number of IO cleaners, 'AUTOMATIC', Valid values: 'range(0, 255)'
- Num
Ioservers string - Configures the number of IO servers, 'AUTOMATIC', Valid values: 'range(1, 255)'
- Num
Log stringSpan - Configures the number of log spans, Valid values: 'range(0, 65535)'
- Num
Quantiles string - Configures the number of quantiles for optimizations, Valid values: 'range(0, 32767)'
- Opt
Buffpage string - Configures the buffer page optimization setting
- Opt
Direct stringWrkld - Configures the direct workload optimization setting,Valid values: 'ON', 'OFF', 'YES', 'NO', 'AUTOMATIC'
- Opt
Locklist string - Configures the lock list optimization setting
- Opt
Maxlocks string - Configures the max locks optimization setting
- Opt
Sortheap string - Configures the sort heap optimization setting
- Page
Age stringTrgt Gcr - Configures the page age target for garbage collection, Valid values: 'range(1, 65535)'
- Page
Age stringTrgt Mcr - Configures the page age target for memory collection, Valid values: 'range(1, 65535)'
- Pckcachesz string
- Configures the package cache size,Valid values: 'AUTOMATIC', '-1', 'range(32, 2147483646)'
- Pl
Stack stringTrace - Configures the level of stack trace logging for stored procedures, Valid values:'NONE', 'ALL', 'UNHANDLED'
- Self
Tuning stringMem - Configures whether self-tuning memory is enabled,Valid values: 'ON', 'OFF'
- Seqdetect string
- Configures sequence detection for queries,Valid values: 'YES', 'NO'
- Sheapthres
Shr string - Configures the shared heap threshold size, Valid values:'AUTOMATIC', 'range(250, 2147483647)'
- Softmax string
- Configures the soft max setting
- Sortheap string
- Configures the sort heap memory size,Valid values: 'AUTOMATIC', 'range(16, 4294967295)'
- Sql
Ccflags string - Configures the SQL compiler flags
- Stat
Heap stringSz - Configures the statistics heap size, Valid values:'AUTOMATIC', 'range(1096, 2147483647)'
- Stmt
Conc string - Configures the statement concurrency, Valid values:'OFF', 'LITERALS', 'COMMENTS', 'COMM_LIT'
- Stmtheap string
- Configures the statement heap size,Valid values: 'AUTOMATIC', 'range(128, 2147483647)'
- String
Units string - Configures the string unit settings,Valid values: 'SYSTEM', 'CODEUNITS32'
- Systime
Period stringAdj - Configures whether system time period adjustments are enabled,Valid values: 'NO', 'YES'
- Trackmod string
- Configures whether modifications to tracked objects are logged,Valid values: 'YES', 'NO'
- Util
Heap stringSz - Configures the utility heap size, Valid values:'AUTOMATIC', 'range(16, 2147483647)'
- Wlm
Admission stringCtrl - Configures whether WLM (Workload Management) admission control is enabled, Valid values:'YES', 'NO'
- Wlm
Agent stringLoad Trgt - Configures the WLM agent load target,Valid values: 'AUTOMATIC', 'range(1, 65535)'
- Wlm
Cpu stringLimit - Configures the CPU limit for WLM workloads, Valid values: 'range(0, 100)'
- string
- Configures the mode of CPU shares for WLM workloads,Valid values: 'HARD', 'SOFT'
- string
- Configures the CPU share count for WLM workloads, Valid values: 'range(1, 65535)'
- Act
Sortmem stringLimit - Configures the sort memory limit for DB2. Valid values: range(10, 100)
- Alt
Collate string - Configures the collation sequence, Valid values: "NULL", "IDENTITY_16BIT"
- App
Ctl stringHeap Sz - Configures the application control heap size. Valid values: range(1, 64000)
- Appgroup
Mem stringSz - Sets the application group memory size. Valid values: range(1, 1000000)
- Appl
Memory string - Configures the application memory allocation. Valid values: AUTOMATIC range(128, 4294967295)
- Applheapsz string
- Configures the application heap size,Valid values: "AUTOMATIC" "range(16, 2147483647)
- Archretrydelay string
- Configures the archive retry delay time. Valid values: range(0, 65535)
- Authn
Cache stringDuration - onfigures the authentication cache duration. Valid values: range(1,10000)
- Auto
Cg stringStats - Configures whether auto collection of CG statistics is enabled ,Valid values: ON, OFF
- Auto
Maint string - Configures automatic maintenance for the database,Valid values: ON ,OFF
- Auto
Reorg string - Configures automatic reorganization for the database,Valid values: ON ,OFF
- Auto
Reval string - Configures the auto refresh or revalidation method,Valid values: 'IMMEDIATE', 'DISABLED', 'DEFERRED', 'DEFERRED_FORCE'
- Auto
Runstats string - Configures automatic collection of run-time statistics,Valid values:'ON', 'OFF'
- Auto
Sampling string - Configures whether auto-sampling is enabled,Valid values: 'ON', 'OFF'
- Auto
Stats stringViews - Configures automatic collection of statistics on views,Valid values: 'ON', 'OFF'
- Auto
Stmt stringStats - Configures automatic collection of statement-level statistics,Valid values: 'ON', 'OFF'
- Auto
Tbl stringMaint - Configures automatic table maintenance,Valid values: 'ON', 'OFF'
- Autorestart string
- Configures whether the database will automatically restart,Valid values: 'ON', 'OFF'
- Avg
Appls string - Average number of applications.
- Catalogcache
Sz string - Configures the catalog cache size,
- Chngpgs
Thresh string - Configures the change pages threshold percentage, Valid values: range(5,99)
- Cur
Commit string - Configures the commit behavior, Valid values: "ON" "AVAILABLE" "DISABLED
- Database
Memory string - Configures the database memory management, Valid values: "AUTOMATIC" "COMPUTED" "range(0,4294967295)"
- Db
Collname string - Specifies the database collation name
- Db
Mem stringThresh - Configures the memory threshold percentage for database,Valid values: range(0,100)
- Dbheap string
- Configures the database heap size,Valid values: "AUTOMATIC" range(32, 2147483647)
- Ddl
Compression stringDef - Defines the default DDL compression behavior,Valid values: YES, NO
- Ddl
Constraint stringDef - Defines the default constraint behavior in DDL,Valid values: YES ,NO
- Dec
Arithmetic string - Configures the default arithmetic for decimal operations
- Dec
To stringChar Fmt - Configures the decimal-to-character conversion format, Valid values: "NEW" "V95"
- Decflt
Rounding string - Configures the decimal floating-point rounding method, Valid values: 'ROUND_HALF_EVEN', 'ROUND_CEILING', 'ROUND_FLOOR', 'ROUND_HALF_UP', 'ROUND_DOWN'
- Dft
Degree string - Configures the default degree for parallelism, Valid values:'-1', 'ANY', 'range(1, 32767)'
- Dft
Extent stringSz - Configures the default extent size for tables, Valid values: range(2, 256)
- Dft
Loadrec stringSes - Configures the default load record session count, Valid values: range(1, 30000)
- Dft
Mttb stringTypes - Configures the default MTTB (multi-table table scan) types
- Dft
Prefetch stringSz - Configures the default prefetch size for queries, Valid values: 'range(0, 32767)', 'AUTOMATIC'
- Dft
Queryopt string - onfigures the default query optimization level, Valid values: range(0, 9)
- Dft
Refresh stringAge - Configures the default refresh age for views
- Dft
Schemas stringDcc - Configures whether DCC (database control center) is enabled for schemas,Valid values:'YES', 'NO'
- Dft
Sqlmathwarn string - Configures whether SQL math warnings are enabled,Valid values: 'YES', 'NO'
- Dft
Table stringOrg - Configures the default table organization (ROW or COLUMN),Valid values: 'COLUMN', 'ROW'
- Dlchktime string
- Configures the deadlock check time in milliseconds, Valid values: range(1000, 600000)'
- Enable
Xmlchar string - Configures whether XML character support is enabled,Valid values: YES', 'NO'
- Extended
Row stringSz - Configures whether extended row size is enabled,Valid values: ENABLE', 'DISABLE'
- Groupheap
Ratio string - Configures the heap ratio for group heap memory, Valid values: range(1, 99)'
- Indexrec string
- Configures the index recovery method, Valid values:'SYSTEM', 'ACCESS', 'ACCESS_NO_REDO', 'RESTART', 'RESTART_NO_REDO'
- Large
Aggregation string - Configures whether large aggregation is enabled, Valid values:'YES', 'NO'
- Locklist string
- Configures the lock list memory size, Valid values:'AUTOMATIC', 'range(4, 134217728)'
- Locktimeout string
- Configures the lock timeout duration,Valid values: '-1', 'range(0, 32767)'
- Log
Appl stringInfo - Configures whether application information is logged,Valid values: 'YES', 'NO'
- Log
Ddl stringStmts - Configures whether DDL statements are logged, Valid values:'YES', 'NO'
- Log
Disk stringCap - Configures the disk capacity log setting,Valid values: '0', '-1', 'range(1, 2147483647)'
- Logindexbuild string
- Configures whether index builds are logged, Valid values:'ON', 'OFF'
- Maxappls string
- Configures the maximum number of applications,Valid values:range(1, 60000)
- Maxfilop string
- Configures the maximum number of file operations,Valid values: range(64, 61440)
- Maxlocks string
- Configures the maximum number of locks, Valid values:'AUTOMATIC', 'range(1, 100)'
- Min
Dec stringDiv3 - Configures whether decimal division by 3 should be handled,Valid values: 'YES', 'NO'
- Mon
Act stringMetrics - Configures the level of activity metrics to be monitored,Valid values: 'NONE', 'BASE', 'EXTENDED'
- Mon
Deadlock string - Configures deadlock monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- Mon
Lck stringMsg Lvl - Configures the lock message level for monitoring, Valid values: range(0, 3)
- Mon
Locktimeout string - Configures lock timeout monitoring settings, Valid values:'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- Mon
Lockwait string - Configures lock wait monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- Mon
Lw stringThresh - Configures the lightweight threshold for monitoring, Valid values: range(1000, 4294967295)
- Mon
Obj stringMetrics - Configures the object metrics level for monitoring,Valid values: 'NONE', 'BASE', 'EXTENDED'
- Mon
Pkglist stringSz - Configures the package list size for monitoring, Valid values: range(0, 1024)
- Mon
Req stringMetrics - Configures the request metrics level for monitoring, Valid values: 'NONE', 'BASE', 'EXTENDED'
- Mon
Rtn stringData - Configures the level of return data for monitoring,Valid values: 'NONE', 'BASE'
- Mon
Rtn stringExeclist - Configures whether stored procedure execution list is monitored, Valid values:'OFF', 'ON'
- Mon
Uow stringData - Configures the level of unit of work (UOW) data for monitoring,Valid values: 'NONE', 'BASE'
- Mon
Uow stringExeclist - Configures whether UOW execution list is monitored,Valid values: 'ON', 'OFF'
- Mon
Uow stringPkglist - Configures whether UOW package list is monitored,Valid values: 'OFF', 'ON'
- Nchar
Mapping string - Configures the mapping of NCHAR character types, Valid values:'CHAR_CU32', 'GRAPHIC_CU32', 'GRAPHIC_CU16', 'NOT APPLICABLE'
- Num
Freqvalues string - Configures the number of frequent values for optimization, Valid values: range(0, 32767)
- Num
Iocleaners string - Configures the number of IO cleaners, 'AUTOMATIC', Valid values: 'range(0, 255)'
- Num
Ioservers string - Configures the number of IO servers, 'AUTOMATIC', Valid values: 'range(1, 255)'
- Num
Log stringSpan - Configures the number of log spans, Valid values: 'range(0, 65535)'
- Num
Quantiles string - Configures the number of quantiles for optimizations, Valid values: 'range(0, 32767)'
- Opt
Buffpage string - Configures the buffer page optimization setting
- Opt
Direct stringWrkld - Configures the direct workload optimization setting,Valid values: 'ON', 'OFF', 'YES', 'NO', 'AUTOMATIC'
- Opt
Locklist string - Configures the lock list optimization setting
- Opt
Maxlocks string - Configures the max locks optimization setting
- Opt
Sortheap string - Configures the sort heap optimization setting
- Page
Age stringTrgt Gcr - Configures the page age target for garbage collection, Valid values: 'range(1, 65535)'
- Page
Age stringTrgt Mcr - Configures the page age target for memory collection, Valid values: 'range(1, 65535)'
- Pckcachesz string
- Configures the package cache size,Valid values: 'AUTOMATIC', '-1', 'range(32, 2147483646)'
- Pl
Stack stringTrace - Configures the level of stack trace logging for stored procedures, Valid values:'NONE', 'ALL', 'UNHANDLED'
- Self
Tuning stringMem - Configures whether self-tuning memory is enabled,Valid values: 'ON', 'OFF'
- Seqdetect string
- Configures sequence detection for queries,Valid values: 'YES', 'NO'
- Sheapthres
Shr string - Configures the shared heap threshold size, Valid values:'AUTOMATIC', 'range(250, 2147483647)'
- Softmax string
- Configures the soft max setting
- Sortheap string
- Configures the sort heap memory size,Valid values: 'AUTOMATIC', 'range(16, 4294967295)'
- Sql
Ccflags string - Configures the SQL compiler flags
- Stat
Heap stringSz - Configures the statistics heap size, Valid values:'AUTOMATIC', 'range(1096, 2147483647)'
- Stmt
Conc string - Configures the statement concurrency, Valid values:'OFF', 'LITERALS', 'COMMENTS', 'COMM_LIT'
- Stmtheap string
- Configures the statement heap size,Valid values: 'AUTOMATIC', 'range(128, 2147483647)'
- String
Units string - Configures the string unit settings,Valid values: 'SYSTEM', 'CODEUNITS32'
- Systime
Period stringAdj - Configures whether system time period adjustments are enabled,Valid values: 'NO', 'YES'
- Trackmod string
- Configures whether modifications to tracked objects are logged,Valid values: 'YES', 'NO'
- Util
Heap stringSz - Configures the utility heap size, Valid values:'AUTOMATIC', 'range(16, 2147483647)'
- Wlm
Admission stringCtrl - Configures whether WLM (Workload Management) admission control is enabled, Valid values:'YES', 'NO'
- Wlm
Agent stringLoad Trgt - Configures the WLM agent load target,Valid values: 'AUTOMATIC', 'range(1, 65535)'
- Wlm
Cpu stringLimit - Configures the CPU limit for WLM workloads, Valid values: 'range(0, 100)'
- string
- Configures the mode of CPU shares for WLM workloads,Valid values: 'HARD', 'SOFT'
- string
- Configures the CPU share count for WLM workloads, Valid values: 'range(1, 65535)'
- act
Sortmem StringLimit - Configures the sort memory limit for DB2. Valid values: range(10, 100)
- alt
Collate String - Configures the collation sequence, Valid values: "NULL", "IDENTITY_16BIT"
- app
Ctl StringHeap Sz - Configures the application control heap size. Valid values: range(1, 64000)
- appgroup
Mem StringSz - Sets the application group memory size. Valid values: range(1, 1000000)
- appl
Memory String - Configures the application memory allocation. Valid values: AUTOMATIC range(128, 4294967295)
- applheapsz String
- Configures the application heap size,Valid values: "AUTOMATIC" "range(16, 2147483647)
- archretrydelay String
- Configures the archive retry delay time. Valid values: range(0, 65535)
- authn
Cache StringDuration - onfigures the authentication cache duration. Valid values: range(1,10000)
- auto
Cg StringStats - Configures whether auto collection of CG statistics is enabled ,Valid values: ON, OFF
- auto
Maint String - Configures automatic maintenance for the database,Valid values: ON ,OFF
- auto
Reorg String - Configures automatic reorganization for the database,Valid values: ON ,OFF
- auto
Reval String - Configures the auto refresh or revalidation method,Valid values: 'IMMEDIATE', 'DISABLED', 'DEFERRED', 'DEFERRED_FORCE'
- auto
Runstats String - Configures automatic collection of run-time statistics,Valid values:'ON', 'OFF'
- auto
Sampling String - Configures whether auto-sampling is enabled,Valid values: 'ON', 'OFF'
- auto
Stats StringViews - Configures automatic collection of statistics on views,Valid values: 'ON', 'OFF'
- auto
Stmt StringStats - Configures automatic collection of statement-level statistics,Valid values: 'ON', 'OFF'
- auto
Tbl StringMaint - Configures automatic table maintenance,Valid values: 'ON', 'OFF'
- autorestart String
- Configures whether the database will automatically restart,Valid values: 'ON', 'OFF'
- avg
Appls String - Average number of applications.
- catalogcache
Sz String - Configures the catalog cache size,
- chngpgs
Thresh String - Configures the change pages threshold percentage, Valid values: range(5,99)
- cur
Commit String - Configures the commit behavior, Valid values: "ON" "AVAILABLE" "DISABLED
- database
Memory String - Configures the database memory management, Valid values: "AUTOMATIC" "COMPUTED" "range(0,4294967295)"
- db
Collname String - Specifies the database collation name
- db
Mem StringThresh - Configures the memory threshold percentage for database,Valid values: range(0,100)
- dbheap String
- Configures the database heap size,Valid values: "AUTOMATIC" range(32, 2147483647)
- ddl
Compression StringDef - Defines the default DDL compression behavior,Valid values: YES, NO
- ddl
Constraint StringDef - Defines the default constraint behavior in DDL,Valid values: YES ,NO
- dec
Arithmetic String - Configures the default arithmetic for decimal operations
- dec
To StringChar Fmt - Configures the decimal-to-character conversion format, Valid values: "NEW" "V95"
- decflt
Rounding String - Configures the decimal floating-point rounding method, Valid values: 'ROUND_HALF_EVEN', 'ROUND_CEILING', 'ROUND_FLOOR', 'ROUND_HALF_UP', 'ROUND_DOWN'
- dft
Degree String - Configures the default degree for parallelism, Valid values:'-1', 'ANY', 'range(1, 32767)'
- dft
Extent StringSz - Configures the default extent size for tables, Valid values: range(2, 256)
- dft
Loadrec StringSes - Configures the default load record session count, Valid values: range(1, 30000)
- dft
Mttb StringTypes - Configures the default MTTB (multi-table table scan) types
- dft
Prefetch StringSz - Configures the default prefetch size for queries, Valid values: 'range(0, 32767)', 'AUTOMATIC'
- dft
Queryopt String - onfigures the default query optimization level, Valid values: range(0, 9)
- dft
Refresh StringAge - Configures the default refresh age for views
- dft
Schemas StringDcc - Configures whether DCC (database control center) is enabled for schemas,Valid values:'YES', 'NO'
- dft
Sqlmathwarn String - Configures whether SQL math warnings are enabled,Valid values: 'YES', 'NO'
- dft
Table StringOrg - Configures the default table organization (ROW or COLUMN),Valid values: 'COLUMN', 'ROW'
- dlchktime String
- Configures the deadlock check time in milliseconds, Valid values: range(1000, 600000)'
- enable
Xmlchar String - Configures whether XML character support is enabled,Valid values: YES', 'NO'
- extended
Row StringSz - Configures whether extended row size is enabled,Valid values: ENABLE', 'DISABLE'
- groupheap
Ratio String - Configures the heap ratio for group heap memory, Valid values: range(1, 99)'
- indexrec String
- Configures the index recovery method, Valid values:'SYSTEM', 'ACCESS', 'ACCESS_NO_REDO', 'RESTART', 'RESTART_NO_REDO'
- large
Aggregation String - Configures whether large aggregation is enabled, Valid values:'YES', 'NO'
- locklist String
- Configures the lock list memory size, Valid values:'AUTOMATIC', 'range(4, 134217728)'
- locktimeout String
- Configures the lock timeout duration,Valid values: '-1', 'range(0, 32767)'
- log
Appl StringInfo - Configures whether application information is logged,Valid values: 'YES', 'NO'
- log
Ddl StringStmts - Configures whether DDL statements are logged, Valid values:'YES', 'NO'
- log
Disk StringCap - Configures the disk capacity log setting,Valid values: '0', '-1', 'range(1, 2147483647)'
- logindexbuild String
- Configures whether index builds are logged, Valid values:'ON', 'OFF'
- maxappls String
- Configures the maximum number of applications,Valid values:range(1, 60000)
- maxfilop String
- Configures the maximum number of file operations,Valid values: range(64, 61440)
- maxlocks String
- Configures the maximum number of locks, Valid values:'AUTOMATIC', 'range(1, 100)'
- min
Dec StringDiv3 - Configures whether decimal division by 3 should be handled,Valid values: 'YES', 'NO'
- mon
Act StringMetrics - Configures the level of activity metrics to be monitored,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Deadlock String - Configures deadlock monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lck StringMsg Lvl - Configures the lock message level for monitoring, Valid values: range(0, 3)
- mon
Locktimeout String - Configures lock timeout monitoring settings, Valid values:'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lockwait String - Configures lock wait monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lw StringThresh - Configures the lightweight threshold for monitoring, Valid values: range(1000, 4294967295)
- mon
Obj StringMetrics - Configures the object metrics level for monitoring,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Pkglist StringSz - Configures the package list size for monitoring, Valid values: range(0, 1024)
- mon
Req StringMetrics - Configures the request metrics level for monitoring, Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Rtn StringData - Configures the level of return data for monitoring,Valid values: 'NONE', 'BASE'
- mon
Rtn StringExeclist - Configures whether stored procedure execution list is monitored, Valid values:'OFF', 'ON'
- mon
Uow StringData - Configures the level of unit of work (UOW) data for monitoring,Valid values: 'NONE', 'BASE'
- mon
Uow StringExeclist - Configures whether UOW execution list is monitored,Valid values: 'ON', 'OFF'
- mon
Uow StringPkglist - Configures whether UOW package list is monitored,Valid values: 'OFF', 'ON'
- nchar
Mapping String - Configures the mapping of NCHAR character types, Valid values:'CHAR_CU32', 'GRAPHIC_CU32', 'GRAPHIC_CU16', 'NOT APPLICABLE'
- num
Freqvalues String - Configures the number of frequent values for optimization, Valid values: range(0, 32767)
- num
Iocleaners String - Configures the number of IO cleaners, 'AUTOMATIC', Valid values: 'range(0, 255)'
- num
Ioservers String - Configures the number of IO servers, 'AUTOMATIC', Valid values: 'range(1, 255)'
- num
Log StringSpan - Configures the number of log spans, Valid values: 'range(0, 65535)'
- num
Quantiles String - Configures the number of quantiles for optimizations, Valid values: 'range(0, 32767)'
- opt
Buffpage String - Configures the buffer page optimization setting
- opt
Direct StringWrkld - Configures the direct workload optimization setting,Valid values: 'ON', 'OFF', 'YES', 'NO', 'AUTOMATIC'
- opt
Locklist String - Configures the lock list optimization setting
- opt
Maxlocks String - Configures the max locks optimization setting
- opt
Sortheap String - Configures the sort heap optimization setting
- page
Age StringTrgt Gcr - Configures the page age target for garbage collection, Valid values: 'range(1, 65535)'
- page
Age StringTrgt Mcr - Configures the page age target for memory collection, Valid values: 'range(1, 65535)'
- pckcachesz String
- Configures the package cache size,Valid values: 'AUTOMATIC', '-1', 'range(32, 2147483646)'
- pl
Stack StringTrace - Configures the level of stack trace logging for stored procedures, Valid values:'NONE', 'ALL', 'UNHANDLED'
- self
Tuning StringMem - Configures whether self-tuning memory is enabled,Valid values: 'ON', 'OFF'
- seqdetect String
- Configures sequence detection for queries,Valid values: 'YES', 'NO'
- sheapthres
Shr String - Configures the shared heap threshold size, Valid values:'AUTOMATIC', 'range(250, 2147483647)'
- softmax String
- Configures the soft max setting
- sortheap String
- Configures the sort heap memory size,Valid values: 'AUTOMATIC', 'range(16, 4294967295)'
- sql
Ccflags String - Configures the SQL compiler flags
- stat
Heap StringSz - Configures the statistics heap size, Valid values:'AUTOMATIC', 'range(1096, 2147483647)'
- stmt
Conc String - Configures the statement concurrency, Valid values:'OFF', 'LITERALS', 'COMMENTS', 'COMM_LIT'
- stmtheap String
- Configures the statement heap size,Valid values: 'AUTOMATIC', 'range(128, 2147483647)'
- string
Units String - Configures the string unit settings,Valid values: 'SYSTEM', 'CODEUNITS32'
- systime
Period StringAdj - Configures whether system time period adjustments are enabled,Valid values: 'NO', 'YES'
- trackmod String
- Configures whether modifications to tracked objects are logged,Valid values: 'YES', 'NO'
- util
Heap StringSz - Configures the utility heap size, Valid values:'AUTOMATIC', 'range(16, 2147483647)'
- wlm
Admission StringCtrl - Configures whether WLM (Workload Management) admission control is enabled, Valid values:'YES', 'NO'
- wlm
Agent StringLoad Trgt - Configures the WLM agent load target,Valid values: 'AUTOMATIC', 'range(1, 65535)'
- wlm
Cpu StringLimit - Configures the CPU limit for WLM workloads, Valid values: 'range(0, 100)'
- String
- Configures the mode of CPU shares for WLM workloads,Valid values: 'HARD', 'SOFT'
- String
- Configures the CPU share count for WLM workloads, Valid values: 'range(1, 65535)'
- act
Sortmem stringLimit - Configures the sort memory limit for DB2. Valid values: range(10, 100)
- alt
Collate string - Configures the collation sequence, Valid values: "NULL", "IDENTITY_16BIT"
- app
Ctl stringHeap Sz - Configures the application control heap size. Valid values: range(1, 64000)
- appgroup
Mem stringSz - Sets the application group memory size. Valid values: range(1, 1000000)
- appl
Memory string - Configures the application memory allocation. Valid values: AUTOMATIC range(128, 4294967295)
- applheapsz string
- Configures the application heap size,Valid values: "AUTOMATIC" "range(16, 2147483647)
- archretrydelay string
- Configures the archive retry delay time. Valid values: range(0, 65535)
- authn
Cache stringDuration - onfigures the authentication cache duration. Valid values: range(1,10000)
- auto
Cg stringStats - Configures whether auto collection of CG statistics is enabled ,Valid values: ON, OFF
- auto
Maint string - Configures automatic maintenance for the database,Valid values: ON ,OFF
- auto
Reorg string - Configures automatic reorganization for the database,Valid values: ON ,OFF
- auto
Reval string - Configures the auto refresh or revalidation method,Valid values: 'IMMEDIATE', 'DISABLED', 'DEFERRED', 'DEFERRED_FORCE'
- auto
Runstats string - Configures automatic collection of run-time statistics,Valid values:'ON', 'OFF'
- auto
Sampling string - Configures whether auto-sampling is enabled,Valid values: 'ON', 'OFF'
- auto
Stats stringViews - Configures automatic collection of statistics on views,Valid values: 'ON', 'OFF'
- auto
Stmt stringStats - Configures automatic collection of statement-level statistics,Valid values: 'ON', 'OFF'
- auto
Tbl stringMaint - Configures automatic table maintenance,Valid values: 'ON', 'OFF'
- autorestart string
- Configures whether the database will automatically restart,Valid values: 'ON', 'OFF'
- avg
Appls string - Average number of applications.
- catalogcache
Sz string - Configures the catalog cache size,
- chngpgs
Thresh string - Configures the change pages threshold percentage, Valid values: range(5,99)
- cur
Commit string - Configures the commit behavior, Valid values: "ON" "AVAILABLE" "DISABLED
- database
Memory string - Configures the database memory management, Valid values: "AUTOMATIC" "COMPUTED" "range(0,4294967295)"
- db
Collname string - Specifies the database collation name
- db
Mem stringThresh - Configures the memory threshold percentage for database,Valid values: range(0,100)
- dbheap string
- Configures the database heap size,Valid values: "AUTOMATIC" range(32, 2147483647)
- ddl
Compression stringDef - Defines the default DDL compression behavior,Valid values: YES, NO
- ddl
Constraint stringDef - Defines the default constraint behavior in DDL,Valid values: YES ,NO
- dec
Arithmetic string - Configures the default arithmetic for decimal operations
- dec
To stringChar Fmt - Configures the decimal-to-character conversion format, Valid values: "NEW" "V95"
- decflt
Rounding string - Configures the decimal floating-point rounding method, Valid values: 'ROUND_HALF_EVEN', 'ROUND_CEILING', 'ROUND_FLOOR', 'ROUND_HALF_UP', 'ROUND_DOWN'
- dft
Degree string - Configures the default degree for parallelism, Valid values:'-1', 'ANY', 'range(1, 32767)'
- dft
Extent stringSz - Configures the default extent size for tables, Valid values: range(2, 256)
- dft
Loadrec stringSes - Configures the default load record session count, Valid values: range(1, 30000)
- dft
Mttb stringTypes - Configures the default MTTB (multi-table table scan) types
- dft
Prefetch stringSz - Configures the default prefetch size for queries, Valid values: 'range(0, 32767)', 'AUTOMATIC'
- dft
Queryopt string - onfigures the default query optimization level, Valid values: range(0, 9)
- dft
Refresh stringAge - Configures the default refresh age for views
- dft
Schemas stringDcc - Configures whether DCC (database control center) is enabled for schemas,Valid values:'YES', 'NO'
- dft
Sqlmathwarn string - Configures whether SQL math warnings are enabled,Valid values: 'YES', 'NO'
- dft
Table stringOrg - Configures the default table organization (ROW or COLUMN),Valid values: 'COLUMN', 'ROW'
- dlchktime string
- Configures the deadlock check time in milliseconds, Valid values: range(1000, 600000)'
- enable
Xmlchar string - Configures whether XML character support is enabled,Valid values: YES', 'NO'
- extended
Row stringSz - Configures whether extended row size is enabled,Valid values: ENABLE', 'DISABLE'
- groupheap
Ratio string - Configures the heap ratio for group heap memory, Valid values: range(1, 99)'
- indexrec string
- Configures the index recovery method, Valid values:'SYSTEM', 'ACCESS', 'ACCESS_NO_REDO', 'RESTART', 'RESTART_NO_REDO'
- large
Aggregation string - Configures whether large aggregation is enabled, Valid values:'YES', 'NO'
- locklist string
- Configures the lock list memory size, Valid values:'AUTOMATIC', 'range(4, 134217728)'
- locktimeout string
- Configures the lock timeout duration,Valid values: '-1', 'range(0, 32767)'
- log
Appl stringInfo - Configures whether application information is logged,Valid values: 'YES', 'NO'
- log
Ddl stringStmts - Configures whether DDL statements are logged, Valid values:'YES', 'NO'
- log
Disk stringCap - Configures the disk capacity log setting,Valid values: '0', '-1', 'range(1, 2147483647)'
- logindexbuild string
- Configures whether index builds are logged, Valid values:'ON', 'OFF'
- maxappls string
- Configures the maximum number of applications,Valid values:range(1, 60000)
- maxfilop string
- Configures the maximum number of file operations,Valid values: range(64, 61440)
- maxlocks string
- Configures the maximum number of locks, Valid values:'AUTOMATIC', 'range(1, 100)'
- min
Dec stringDiv3 - Configures whether decimal division by 3 should be handled,Valid values: 'YES', 'NO'
- mon
Act stringMetrics - Configures the level of activity metrics to be monitored,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Deadlock string - Configures deadlock monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lck stringMsg Lvl - Configures the lock message level for monitoring, Valid values: range(0, 3)
- mon
Locktimeout string - Configures lock timeout monitoring settings, Valid values:'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lockwait string - Configures lock wait monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lw stringThresh - Configures the lightweight threshold for monitoring, Valid values: range(1000, 4294967295)
- mon
Obj stringMetrics - Configures the object metrics level for monitoring,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Pkglist stringSz - Configures the package list size for monitoring, Valid values: range(0, 1024)
- mon
Req stringMetrics - Configures the request metrics level for monitoring, Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Rtn stringData - Configures the level of return data for monitoring,Valid values: 'NONE', 'BASE'
- mon
Rtn stringExeclist - Configures whether stored procedure execution list is monitored, Valid values:'OFF', 'ON'
- mon
Uow stringData - Configures the level of unit of work (UOW) data for monitoring,Valid values: 'NONE', 'BASE'
- mon
Uow stringExeclist - Configures whether UOW execution list is monitored,Valid values: 'ON', 'OFF'
- mon
Uow stringPkglist - Configures whether UOW package list is monitored,Valid values: 'OFF', 'ON'
- nchar
Mapping string - Configures the mapping of NCHAR character types, Valid values:'CHAR_CU32', 'GRAPHIC_CU32', 'GRAPHIC_CU16', 'NOT APPLICABLE'
- num
Freqvalues string - Configures the number of frequent values for optimization, Valid values: range(0, 32767)
- num
Iocleaners string - Configures the number of IO cleaners, 'AUTOMATIC', Valid values: 'range(0, 255)'
- num
Ioservers string - Configures the number of IO servers, 'AUTOMATIC', Valid values: 'range(1, 255)'
- num
Log stringSpan - Configures the number of log spans, Valid values: 'range(0, 65535)'
- num
Quantiles string - Configures the number of quantiles for optimizations, Valid values: 'range(0, 32767)'
- opt
Buffpage string - Configures the buffer page optimization setting
- opt
Direct stringWrkld - Configures the direct workload optimization setting,Valid values: 'ON', 'OFF', 'YES', 'NO', 'AUTOMATIC'
- opt
Locklist string - Configures the lock list optimization setting
- opt
Maxlocks string - Configures the max locks optimization setting
- opt
Sortheap string - Configures the sort heap optimization setting
- page
Age stringTrgt Gcr - Configures the page age target for garbage collection, Valid values: 'range(1, 65535)'
- page
Age stringTrgt Mcr - Configures the page age target for memory collection, Valid values: 'range(1, 65535)'
- pckcachesz string
- Configures the package cache size,Valid values: 'AUTOMATIC', '-1', 'range(32, 2147483646)'
- pl
Stack stringTrace - Configures the level of stack trace logging for stored procedures, Valid values:'NONE', 'ALL', 'UNHANDLED'
- self
Tuning stringMem - Configures whether self-tuning memory is enabled,Valid values: 'ON', 'OFF'
- seqdetect string
- Configures sequence detection for queries,Valid values: 'YES', 'NO'
- sheapthres
Shr string - Configures the shared heap threshold size, Valid values:'AUTOMATIC', 'range(250, 2147483647)'
- softmax string
- Configures the soft max setting
- sortheap string
- Configures the sort heap memory size,Valid values: 'AUTOMATIC', 'range(16, 4294967295)'
- sql
Ccflags string - Configures the SQL compiler flags
- stat
Heap stringSz - Configures the statistics heap size, Valid values:'AUTOMATIC', 'range(1096, 2147483647)'
- stmt
Conc string - Configures the statement concurrency, Valid values:'OFF', 'LITERALS', 'COMMENTS', 'COMM_LIT'
- stmtheap string
- Configures the statement heap size,Valid values: 'AUTOMATIC', 'range(128, 2147483647)'
- string
Units string - Configures the string unit settings,Valid values: 'SYSTEM', 'CODEUNITS32'
- systime
Period stringAdj - Configures whether system time period adjustments are enabled,Valid values: 'NO', 'YES'
- trackmod string
- Configures whether modifications to tracked objects are logged,Valid values: 'YES', 'NO'
- util
Heap stringSz - Configures the utility heap size, Valid values:'AUTOMATIC', 'range(16, 2147483647)'
- wlm
Admission stringCtrl - Configures whether WLM (Workload Management) admission control is enabled, Valid values:'YES', 'NO'
- wlm
Agent stringLoad Trgt - Configures the WLM agent load target,Valid values: 'AUTOMATIC', 'range(1, 65535)'
- wlm
Cpu stringLimit - Configures the CPU limit for WLM workloads, Valid values: 'range(0, 100)'
- string
- Configures the mode of CPU shares for WLM workloads,Valid values: 'HARD', 'SOFT'
- string
- Configures the CPU share count for WLM workloads, Valid values: 'range(1, 65535)'
- act_
sortmem_ strlimit - Configures the sort memory limit for DB2. Valid values: range(10, 100)
- alt_
collate str - Configures the collation sequence, Valid values: "NULL", "IDENTITY_16BIT"
- app_
ctl_ strheap_ sz - Configures the application control heap size. Valid values: range(1, 64000)
- appgroup_
mem_ strsz - Sets the application group memory size. Valid values: range(1, 1000000)
- appl_
memory str - Configures the application memory allocation. Valid values: AUTOMATIC range(128, 4294967295)
- applheapsz str
- Configures the application heap size,Valid values: "AUTOMATIC" "range(16, 2147483647)
- archretrydelay str
- Configures the archive retry delay time. Valid values: range(0, 65535)
- authn_
cache_ strduration - onfigures the authentication cache duration. Valid values: range(1,10000)
- auto_
cg_ strstats - Configures whether auto collection of CG statistics is enabled ,Valid values: ON, OFF
- auto_
maint str - Configures automatic maintenance for the database,Valid values: ON ,OFF
- auto_
reorg str - Configures automatic reorganization for the database,Valid values: ON ,OFF
- auto_
reval str - Configures the auto refresh or revalidation method,Valid values: 'IMMEDIATE', 'DISABLED', 'DEFERRED', 'DEFERRED_FORCE'
- auto_
runstats str - Configures automatic collection of run-time statistics,Valid values:'ON', 'OFF'
- auto_
sampling str - Configures whether auto-sampling is enabled,Valid values: 'ON', 'OFF'
- auto_
stats_ strviews - Configures automatic collection of statistics on views,Valid values: 'ON', 'OFF'
- auto_
stmt_ strstats - Configures automatic collection of statement-level statistics,Valid values: 'ON', 'OFF'
- auto_
tbl_ strmaint - Configures automatic table maintenance,Valid values: 'ON', 'OFF'
- autorestart str
- Configures whether the database will automatically restart,Valid values: 'ON', 'OFF'
- avg_
appls str - Average number of applications.
- catalogcache_
sz str - Configures the catalog cache size,
- chngpgs_
thresh str - Configures the change pages threshold percentage, Valid values: range(5,99)
- cur_
commit str - Configures the commit behavior, Valid values: "ON" "AVAILABLE" "DISABLED
- database_
memory str - Configures the database memory management, Valid values: "AUTOMATIC" "COMPUTED" "range(0,4294967295)"
- db_
collname str - Specifies the database collation name
- db_
mem_ strthresh - Configures the memory threshold percentage for database,Valid values: range(0,100)
- dbheap str
- Configures the database heap size,Valid values: "AUTOMATIC" range(32, 2147483647)
- ddl_
compression_ strdef - Defines the default DDL compression behavior,Valid values: YES, NO
- ddl_
constraint_ strdef - Defines the default constraint behavior in DDL,Valid values: YES ,NO
- dec_
arithmetic str - Configures the default arithmetic for decimal operations
- dec_
to_ strchar_ fmt - Configures the decimal-to-character conversion format, Valid values: "NEW" "V95"
- decflt_
rounding str - Configures the decimal floating-point rounding method, Valid values: 'ROUND_HALF_EVEN', 'ROUND_CEILING', 'ROUND_FLOOR', 'ROUND_HALF_UP', 'ROUND_DOWN'
- dft_
degree str - Configures the default degree for parallelism, Valid values:'-1', 'ANY', 'range(1, 32767)'
- dft_
extent_ strsz - Configures the default extent size for tables, Valid values: range(2, 256)
- dft_
loadrec_ strses - Configures the default load record session count, Valid values: range(1, 30000)
- dft_
mttb_ strtypes - Configures the default MTTB (multi-table table scan) types
- dft_
prefetch_ strsz - Configures the default prefetch size for queries, Valid values: 'range(0, 32767)', 'AUTOMATIC'
- dft_
queryopt str - onfigures the default query optimization level, Valid values: range(0, 9)
- dft_
refresh_ strage - Configures the default refresh age for views
- dft_
schemas_ strdcc - Configures whether DCC (database control center) is enabled for schemas,Valid values:'YES', 'NO'
- dft_
sqlmathwarn str - Configures whether SQL math warnings are enabled,Valid values: 'YES', 'NO'
- dft_
table_ strorg - Configures the default table organization (ROW or COLUMN),Valid values: 'COLUMN', 'ROW'
- dlchktime str
- Configures the deadlock check time in milliseconds, Valid values: range(1000, 600000)'
- enable_
xmlchar str - Configures whether XML character support is enabled,Valid values: YES', 'NO'
- extended_
row_ strsz - Configures whether extended row size is enabled,Valid values: ENABLE', 'DISABLE'
- groupheap_
ratio str - Configures the heap ratio for group heap memory, Valid values: range(1, 99)'
- indexrec str
- Configures the index recovery method, Valid values:'SYSTEM', 'ACCESS', 'ACCESS_NO_REDO', 'RESTART', 'RESTART_NO_REDO'
- large_
aggregation str - Configures whether large aggregation is enabled, Valid values:'YES', 'NO'
- locklist str
- Configures the lock list memory size, Valid values:'AUTOMATIC', 'range(4, 134217728)'
- locktimeout str
- Configures the lock timeout duration,Valid values: '-1', 'range(0, 32767)'
- log_
appl_ strinfo - Configures whether application information is logged,Valid values: 'YES', 'NO'
- log_
ddl_ strstmts - Configures whether DDL statements are logged, Valid values:'YES', 'NO'
- log_
disk_ strcap - Configures the disk capacity log setting,Valid values: '0', '-1', 'range(1, 2147483647)'
- logindexbuild str
- Configures whether index builds are logged, Valid values:'ON', 'OFF'
- maxappls str
- Configures the maximum number of applications,Valid values:range(1, 60000)
- maxfilop str
- Configures the maximum number of file operations,Valid values: range(64, 61440)
- maxlocks str
- Configures the maximum number of locks, Valid values:'AUTOMATIC', 'range(1, 100)'
- min_
dec_ strdiv3 - Configures whether decimal division by 3 should be handled,Valid values: 'YES', 'NO'
- mon_
act_ strmetrics - Configures the level of activity metrics to be monitored,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon_
deadlock str - Configures deadlock monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon_
lck_ strmsg_ lvl - Configures the lock message level for monitoring, Valid values: range(0, 3)
- mon_
locktimeout str - Configures lock timeout monitoring settings, Valid values:'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon_
lockwait str - Configures lock wait monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon_
lw_ strthresh - Configures the lightweight threshold for monitoring, Valid values: range(1000, 4294967295)
- mon_
obj_ strmetrics - Configures the object metrics level for monitoring,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon_
pkglist_ strsz - Configures the package list size for monitoring, Valid values: range(0, 1024)
- mon_
req_ strmetrics - Configures the request metrics level for monitoring, Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon_
rtn_ strdata - Configures the level of return data for monitoring,Valid values: 'NONE', 'BASE'
- mon_
rtn_ strexeclist - Configures whether stored procedure execution list is monitored, Valid values:'OFF', 'ON'
- mon_
uow_ strdata - Configures the level of unit of work (UOW) data for monitoring,Valid values: 'NONE', 'BASE'
- mon_
uow_ strexeclist - Configures whether UOW execution list is monitored,Valid values: 'ON', 'OFF'
- mon_
uow_ strpkglist - Configures whether UOW package list is monitored,Valid values: 'OFF', 'ON'
- nchar_
mapping str - Configures the mapping of NCHAR character types, Valid values:'CHAR_CU32', 'GRAPHIC_CU32', 'GRAPHIC_CU16', 'NOT APPLICABLE'
- num_
freqvalues str - Configures the number of frequent values for optimization, Valid values: range(0, 32767)
- num_
iocleaners str - Configures the number of IO cleaners, 'AUTOMATIC', Valid values: 'range(0, 255)'
- num_
ioservers str - Configures the number of IO servers, 'AUTOMATIC', Valid values: 'range(1, 255)'
- num_
log_ strspan - Configures the number of log spans, Valid values: 'range(0, 65535)'
- num_
quantiles str - Configures the number of quantiles for optimizations, Valid values: 'range(0, 32767)'
- opt_
buffpage str - Configures the buffer page optimization setting
- opt_
direct_ strwrkld - Configures the direct workload optimization setting,Valid values: 'ON', 'OFF', 'YES', 'NO', 'AUTOMATIC'
- opt_
locklist str - Configures the lock list optimization setting
- opt_
maxlocks str - Configures the max locks optimization setting
- opt_
sortheap str - Configures the sort heap optimization setting
- page_
age_ strtrgt_ gcr - Configures the page age target for garbage collection, Valid values: 'range(1, 65535)'
- page_
age_ strtrgt_ mcr - Configures the page age target for memory collection, Valid values: 'range(1, 65535)'
- pckcachesz str
- Configures the package cache size,Valid values: 'AUTOMATIC', '-1', 'range(32, 2147483646)'
- pl_
stack_ strtrace - Configures the level of stack trace logging for stored procedures, Valid values:'NONE', 'ALL', 'UNHANDLED'
- self_
tuning_ strmem - Configures whether self-tuning memory is enabled,Valid values: 'ON', 'OFF'
- seqdetect str
- Configures sequence detection for queries,Valid values: 'YES', 'NO'
- sheapthres_
shr str - Configures the shared heap threshold size, Valid values:'AUTOMATIC', 'range(250, 2147483647)'
- softmax str
- Configures the soft max setting
- sortheap str
- Configures the sort heap memory size,Valid values: 'AUTOMATIC', 'range(16, 4294967295)'
- sql_
ccflags str - Configures the SQL compiler flags
- stat_
heap_ strsz - Configures the statistics heap size, Valid values:'AUTOMATIC', 'range(1096, 2147483647)'
- stmt_
conc str - Configures the statement concurrency, Valid values:'OFF', 'LITERALS', 'COMMENTS', 'COMM_LIT'
- stmtheap str
- Configures the statement heap size,Valid values: 'AUTOMATIC', 'range(128, 2147483647)'
- string_
units str - Configures the string unit settings,Valid values: 'SYSTEM', 'CODEUNITS32'
- systime_
period_ stradj - Configures whether system time period adjustments are enabled,Valid values: 'NO', 'YES'
- trackmod str
- Configures whether modifications to tracked objects are logged,Valid values: 'YES', 'NO'
- util_
heap_ strsz - Configures the utility heap size, Valid values:'AUTOMATIC', 'range(16, 2147483647)'
- wlm_
admission_ strctrl - Configures whether WLM (Workload Management) admission control is enabled, Valid values:'YES', 'NO'
- wlm_
agent_ strload_ trgt - Configures the WLM agent load target,Valid values: 'AUTOMATIC', 'range(1, 65535)'
- wlm_
cpu_ strlimit - Configures the CPU limit for WLM workloads, Valid values: 'range(0, 100)'
- str
- Configures the mode of CPU shares for WLM workloads,Valid values: 'HARD', 'SOFT'
- str
- Configures the CPU share count for WLM workloads, Valid values: 'range(1, 65535)'
- act
Sortmem StringLimit - Configures the sort memory limit for DB2. Valid values: range(10, 100)
- alt
Collate String - Configures the collation sequence, Valid values: "NULL", "IDENTITY_16BIT"
- app
Ctl StringHeap Sz - Configures the application control heap size. Valid values: range(1, 64000)
- appgroup
Mem StringSz - Sets the application group memory size. Valid values: range(1, 1000000)
- appl
Memory String - Configures the application memory allocation. Valid values: AUTOMATIC range(128, 4294967295)
- applheapsz String
- Configures the application heap size,Valid values: "AUTOMATIC" "range(16, 2147483647)
- archretrydelay String
- Configures the archive retry delay time. Valid values: range(0, 65535)
- authn
Cache StringDuration - onfigures the authentication cache duration. Valid values: range(1,10000)
- auto
Cg StringStats - Configures whether auto collection of CG statistics is enabled ,Valid values: ON, OFF
- auto
Maint String - Configures automatic maintenance for the database,Valid values: ON ,OFF
- auto
Reorg String - Configures automatic reorganization for the database,Valid values: ON ,OFF
- auto
Reval String - Configures the auto refresh or revalidation method,Valid values: 'IMMEDIATE', 'DISABLED', 'DEFERRED', 'DEFERRED_FORCE'
- auto
Runstats String - Configures automatic collection of run-time statistics,Valid values:'ON', 'OFF'
- auto
Sampling String - Configures whether auto-sampling is enabled,Valid values: 'ON', 'OFF'
- auto
Stats StringViews - Configures automatic collection of statistics on views,Valid values: 'ON', 'OFF'
- auto
Stmt StringStats - Configures automatic collection of statement-level statistics,Valid values: 'ON', 'OFF'
- auto
Tbl StringMaint - Configures automatic table maintenance,Valid values: 'ON', 'OFF'
- autorestart String
- Configures whether the database will automatically restart,Valid values: 'ON', 'OFF'
- avg
Appls String - Average number of applications.
- catalogcache
Sz String - Configures the catalog cache size,
- chngpgs
Thresh String - Configures the change pages threshold percentage, Valid values: range(5,99)
- cur
Commit String - Configures the commit behavior, Valid values: "ON" "AVAILABLE" "DISABLED
- database
Memory String - Configures the database memory management, Valid values: "AUTOMATIC" "COMPUTED" "range(0,4294967295)"
- db
Collname String - Specifies the database collation name
- db
Mem StringThresh - Configures the memory threshold percentage for database,Valid values: range(0,100)
- dbheap String
- Configures the database heap size,Valid values: "AUTOMATIC" range(32, 2147483647)
- ddl
Compression StringDef - Defines the default DDL compression behavior,Valid values: YES, NO
- ddl
Constraint StringDef - Defines the default constraint behavior in DDL,Valid values: YES ,NO
- dec
Arithmetic String - Configures the default arithmetic for decimal operations
- dec
To StringChar Fmt - Configures the decimal-to-character conversion format, Valid values: "NEW" "V95"
- decflt
Rounding String - Configures the decimal floating-point rounding method, Valid values: 'ROUND_HALF_EVEN', 'ROUND_CEILING', 'ROUND_FLOOR', 'ROUND_HALF_UP', 'ROUND_DOWN'
- dft
Degree String - Configures the default degree for parallelism, Valid values:'-1', 'ANY', 'range(1, 32767)'
- dft
Extent StringSz - Configures the default extent size for tables, Valid values: range(2, 256)
- dft
Loadrec StringSes - Configures the default load record session count, Valid values: range(1, 30000)
- dft
Mttb StringTypes - Configures the default MTTB (multi-table table scan) types
- dft
Prefetch StringSz - Configures the default prefetch size for queries, Valid values: 'range(0, 32767)', 'AUTOMATIC'
- dft
Queryopt String - onfigures the default query optimization level, Valid values: range(0, 9)
- dft
Refresh StringAge - Configures the default refresh age for views
- dft
Schemas StringDcc - Configures whether DCC (database control center) is enabled for schemas,Valid values:'YES', 'NO'
- dft
Sqlmathwarn String - Configures whether SQL math warnings are enabled,Valid values: 'YES', 'NO'
- dft
Table StringOrg - Configures the default table organization (ROW or COLUMN),Valid values: 'COLUMN', 'ROW'
- dlchktime String
- Configures the deadlock check time in milliseconds, Valid values: range(1000, 600000)'
- enable
Xmlchar String - Configures whether XML character support is enabled,Valid values: YES', 'NO'
- extended
Row StringSz - Configures whether extended row size is enabled,Valid values: ENABLE', 'DISABLE'
- groupheap
Ratio String - Configures the heap ratio for group heap memory, Valid values: range(1, 99)'
- indexrec String
- Configures the index recovery method, Valid values:'SYSTEM', 'ACCESS', 'ACCESS_NO_REDO', 'RESTART', 'RESTART_NO_REDO'
- large
Aggregation String - Configures whether large aggregation is enabled, Valid values:'YES', 'NO'
- locklist String
- Configures the lock list memory size, Valid values:'AUTOMATIC', 'range(4, 134217728)'
- locktimeout String
- Configures the lock timeout duration,Valid values: '-1', 'range(0, 32767)'
- log
Appl StringInfo - Configures whether application information is logged,Valid values: 'YES', 'NO'
- log
Ddl StringStmts - Configures whether DDL statements are logged, Valid values:'YES', 'NO'
- log
Disk StringCap - Configures the disk capacity log setting,Valid values: '0', '-1', 'range(1, 2147483647)'
- logindexbuild String
- Configures whether index builds are logged, Valid values:'ON', 'OFF'
- maxappls String
- Configures the maximum number of applications,Valid values:range(1, 60000)
- maxfilop String
- Configures the maximum number of file operations,Valid values: range(64, 61440)
- maxlocks String
- Configures the maximum number of locks, Valid values:'AUTOMATIC', 'range(1, 100)'
- min
Dec StringDiv3 - Configures whether decimal division by 3 should be handled,Valid values: 'YES', 'NO'
- mon
Act StringMetrics - Configures the level of activity metrics to be monitored,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Deadlock String - Configures deadlock monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lck StringMsg Lvl - Configures the lock message level for monitoring, Valid values: range(0, 3)
- mon
Locktimeout String - Configures lock timeout monitoring settings, Valid values:'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lockwait String - Configures lock wait monitoring settings,Valid values: 'NONE', 'WITHOUT_HIST', 'HISTORY', 'HIST_AND_VALUES'
- mon
Lw StringThresh - Configures the lightweight threshold for monitoring, Valid values: range(1000, 4294967295)
- mon
Obj StringMetrics - Configures the object metrics level for monitoring,Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Pkglist StringSz - Configures the package list size for monitoring, Valid values: range(0, 1024)
- mon
Req StringMetrics - Configures the request metrics level for monitoring, Valid values: 'NONE', 'BASE', 'EXTENDED'
- mon
Rtn StringData - Configures the level of return data for monitoring,Valid values: 'NONE', 'BASE'
- mon
Rtn StringExeclist - Configures whether stored procedure execution list is monitored, Valid values:'OFF', 'ON'
- mon
Uow StringData - Configures the level of unit of work (UOW) data for monitoring,Valid values: 'NONE', 'BASE'
- mon
Uow StringExeclist - Configures whether UOW execution list is monitored,Valid values: 'ON', 'OFF'
- mon
Uow StringPkglist - Configures whether UOW package list is monitored,Valid values: 'OFF', 'ON'
- nchar
Mapping String - Configures the mapping of NCHAR character types, Valid values:'CHAR_CU32', 'GRAPHIC_CU32', 'GRAPHIC_CU16', 'NOT APPLICABLE'
- num
Freqvalues String - Configures the number of frequent values for optimization, Valid values: range(0, 32767)
- num
Iocleaners String - Configures the number of IO cleaners, 'AUTOMATIC', Valid values: 'range(0, 255)'
- num
Ioservers String - Configures the number of IO servers, 'AUTOMATIC', Valid values: 'range(1, 255)'
- num
Log StringSpan - Configures the number of log spans, Valid values: 'range(0, 65535)'
- num
Quantiles String - Configures the number of quantiles for optimizations, Valid values: 'range(0, 32767)'
- opt
Buffpage String - Configures the buffer page optimization setting
- opt
Direct StringWrkld - Configures the direct workload optimization setting,Valid values: 'ON', 'OFF', 'YES', 'NO', 'AUTOMATIC'
- opt
Locklist String - Configures the lock list optimization setting
- opt
Maxlocks String - Configures the max locks optimization setting
- opt
Sortheap String - Configures the sort heap optimization setting
- page
Age StringTrgt Gcr - Configures the page age target for garbage collection, Valid values: 'range(1, 65535)'
- page
Age StringTrgt Mcr - Configures the page age target for memory collection, Valid values: 'range(1, 65535)'
- pckcachesz String
- Configures the package cache size,Valid values: 'AUTOMATIC', '-1', 'range(32, 2147483646)'
- pl
Stack StringTrace - Configures the level of stack trace logging for stored procedures, Valid values:'NONE', 'ALL', 'UNHANDLED'
- self
Tuning StringMem - Configures whether self-tuning memory is enabled,Valid values: 'ON', 'OFF'
- seqdetect String
- Configures sequence detection for queries,Valid values: 'YES', 'NO'
- sheapthres
Shr String - Configures the shared heap threshold size, Valid values:'AUTOMATIC', 'range(250, 2147483647)'
- softmax String
- Configures the soft max setting
- sortheap String
- Configures the sort heap memory size,Valid values: 'AUTOMATIC', 'range(16, 4294967295)'
- sql
Ccflags String - Configures the SQL compiler flags
- stat
Heap StringSz - Configures the statistics heap size, Valid values:'AUTOMATIC', 'range(1096, 2147483647)'
- stmt
Conc String - Configures the statement concurrency, Valid values:'OFF', 'LITERALS', 'COMMENTS', 'COMM_LIT'
- stmtheap String
- Configures the statement heap size,Valid values: 'AUTOMATIC', 'range(128, 2147483647)'
- string
Units String - Configures the string unit settings,Valid values: 'SYSTEM', 'CODEUNITS32'
- systime
Period StringAdj - Configures whether system time period adjustments are enabled,Valid values: 'NO', 'YES'
- trackmod String
- Configures whether modifications to tracked objects are logged,Valid values: 'YES', 'NO'
- util
Heap StringSz - Configures the utility heap size, Valid values:'AUTOMATIC', 'range(16, 2147483647)'
- wlm
Admission StringCtrl - Configures whether WLM (Workload Management) admission control is enabled, Valid values:'YES', 'NO'
- wlm
Agent StringLoad Trgt - Configures the WLM agent load target,Valid values: 'AUTOMATIC', 'range(1, 65535)'
- wlm
Cpu StringLimit - Configures the CPU limit for WLM workloads, Valid values: 'range(0, 100)'
- String
- Configures the mode of CPU shares for WLM workloads,Valid values: 'HARD', 'SOFT'
- String
- Configures the CPU share count for WLM workloads, Valid values: 'range(1, 65535)'
Db2CustomSettingConfigDbm, Db2CustomSettingConfigDbmArgs
- Comm
Bandwidth string - Configures the communication bandwidth for the database manager, Valid values: 'range(0.1, 100000)', '-1'
- Cpuspeed string
- Configures the CPU speed for the database manager, Valid values: 'range(0.0000000001, 1)', '-1'
- Dft
Mon stringBufpool - Configures whether the buffer pool is monitored by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringLock - Configures whether lock monitoring is enabled by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringSort - Configures whether sort operations are monitored by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringStmt - Configures whether statement execution is monitored by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringTable - Configures whether table operations are monitored by default, Valid values:'ON', 'OFF'
- Dft
Mon stringTimestamp - Configures whether timestamp monitoring is enabled by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringUow - Configures whether unit of work (UOW) monitoring is enabled by default,Valid values: 'ON', 'OFF'
- Diaglevel string
- Configures the diagnostic level for the database manager, Valid values: 'range(0, 4)'
- Federated
Async string - Configures whether federated asynchronous mode is enabled, Valid values: 'range(0, 32767)', '-1', 'ANY'
- Indexrec string
- Configures the type of indexing to be used in the database manager, Valid values:'RESTART', 'RESTART_NO_REDO', 'ACCESS', 'ACCESS_NO_REDO'
- Intra
Parallel string - Configures the parallelism settings for intra-query parallelism, Valid values:'SYSTEM', 'NO', 'YES'
- Keepfenced string
- Configures whether fenced routines are kept in memory,Valid values: 'YES', 'NO'
- Max
Connretries string - Configures the maximum number of connection retries, Valid values: 'range(0, 100)'
- Max
Querydegree string - Configures the maximum degree of parallelism for queries, Valid values: 'range(1, 32767)', '-1', 'ANY'
- Mon
Heap stringSz - Configures the size of the monitoring heap, Valid values: 'range(0, 2147483647)', 'AUTOMATIC'
- Multipartsizemb string
- Configures the size of multipart queries in MB, Valid values: 'range(5, 5120)'
- Notifylevel string
- Configures the level of notifications for the database manager, Valid values: 'range(0, 4)'
- Num
Initagents string - Configures the number of initial agents in the database manager, Valid values: 'range(0, 64000)'
- Num
Initfenced string - Configures the number of initial fenced routines, Valid values: 'range(0, 64000)'
- Num
Poolagents string - Configures the number of pool agents,Valid values: '-1', 'range(0, 64000)'
- Resync
Interval string - Configures the interval between resync operations, Valid values: 'range(1, 60000)'
- Rqrioblk string
- Configures the request/response I/O block size, Valid values: 'range(4096, 65535)'
- Start
Stop stringTime - Configures the time in minutes for start/stop operations, Valid values: 'range(1, 1440)'
- Util
Impact stringLim - Configures the utility impact limit, Valid values: 'range(1, 100)'
- Wlm
Disp stringConcur - Configures whether the WLM (Workload Management) dispatcher is enabled, Valid values:'YES', 'NO'
- string
- Wlm
Disp stringMin Util - Configures the minimum utility threshold for WLM dispatcher, Valid values: 'range(0, 100)'
- Wlm
Dispatcher string - Configures whether the WLM (Workload Management) dispatcher is enabled,Valid values:'YES', 'NO'
- Comm
Bandwidth string - Configures the communication bandwidth for the database manager, Valid values: 'range(0.1, 100000)', '-1'
- Cpuspeed string
- Configures the CPU speed for the database manager, Valid values: 'range(0.0000000001, 1)', '-1'
- Dft
Mon stringBufpool - Configures whether the buffer pool is monitored by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringLock - Configures whether lock monitoring is enabled by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringSort - Configures whether sort operations are monitored by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringStmt - Configures whether statement execution is monitored by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringTable - Configures whether table operations are monitored by default, Valid values:'ON', 'OFF'
- Dft
Mon stringTimestamp - Configures whether timestamp monitoring is enabled by default,Valid values: 'ON', 'OFF'
- Dft
Mon stringUow - Configures whether unit of work (UOW) monitoring is enabled by default,Valid values: 'ON', 'OFF'
- Diaglevel string
- Configures the diagnostic level for the database manager, Valid values: 'range(0, 4)'
- Federated
Async string - Configures whether federated asynchronous mode is enabled, Valid values: 'range(0, 32767)', '-1', 'ANY'
- Indexrec string
- Configures the type of indexing to be used in the database manager, Valid values:'RESTART', 'RESTART_NO_REDO', 'ACCESS', 'ACCESS_NO_REDO'
- Intra
Parallel string - Configures the parallelism settings for intra-query parallelism, Valid values:'SYSTEM', 'NO', 'YES'
- Keepfenced string
- Configures whether fenced routines are kept in memory,Valid values: 'YES', 'NO'
- Max
Connretries string - Configures the maximum number of connection retries, Valid values: 'range(0, 100)'
- Max
Querydegree string - Configures the maximum degree of parallelism for queries, Valid values: 'range(1, 32767)', '-1', 'ANY'
- Mon
Heap stringSz - Configures the size of the monitoring heap, Valid values: 'range(0, 2147483647)', 'AUTOMATIC'
- Multipartsizemb string
- Configures the size of multipart queries in MB, Valid values: 'range(5, 5120)'
- Notifylevel string
- Configures the level of notifications for the database manager, Valid values: 'range(0, 4)'
- Num
Initagents string - Configures the number of initial agents in the database manager, Valid values: 'range(0, 64000)'
- Num
Initfenced string - Configures the number of initial fenced routines, Valid values: 'range(0, 64000)'
- Num
Poolagents string - Configures the number of pool agents,Valid values: '-1', 'range(0, 64000)'
- Resync
Interval string - Configures the interval between resync operations, Valid values: 'range(1, 60000)'
- Rqrioblk string
- Configures the request/response I/O block size, Valid values: 'range(4096, 65535)'
- Start
Stop stringTime - Configures the time in minutes for start/stop operations, Valid values: 'range(1, 1440)'
- Util
Impact stringLim - Configures the utility impact limit, Valid values: 'range(1, 100)'
- Wlm
Disp stringConcur - Configures whether the WLM (Workload Management) dispatcher is enabled, Valid values:'YES', 'NO'
- string
- Wlm
Disp stringMin Util - Configures the minimum utility threshold for WLM dispatcher, Valid values: 'range(0, 100)'
- Wlm
Dispatcher string - Configures whether the WLM (Workload Management) dispatcher is enabled,Valid values:'YES', 'NO'
- comm
Bandwidth String - Configures the communication bandwidth for the database manager, Valid values: 'range(0.1, 100000)', '-1'
- cpuspeed String
- Configures the CPU speed for the database manager, Valid values: 'range(0.0000000001, 1)', '-1'
- dft
Mon StringBufpool - Configures whether the buffer pool is monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon StringLock - Configures whether lock monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft
Mon StringSort - Configures whether sort operations are monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon StringStmt - Configures whether statement execution is monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon StringTable - Configures whether table operations are monitored by default, Valid values:'ON', 'OFF'
- dft
Mon StringTimestamp - Configures whether timestamp monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft
Mon StringUow - Configures whether unit of work (UOW) monitoring is enabled by default,Valid values: 'ON', 'OFF'
- diaglevel String
- Configures the diagnostic level for the database manager, Valid values: 'range(0, 4)'
- federated
Async String - Configures whether federated asynchronous mode is enabled, Valid values: 'range(0, 32767)', '-1', 'ANY'
- indexrec String
- Configures the type of indexing to be used in the database manager, Valid values:'RESTART', 'RESTART_NO_REDO', 'ACCESS', 'ACCESS_NO_REDO'
- intra
Parallel String - Configures the parallelism settings for intra-query parallelism, Valid values:'SYSTEM', 'NO', 'YES'
- keepfenced String
- Configures whether fenced routines are kept in memory,Valid values: 'YES', 'NO'
- max
Connretries String - Configures the maximum number of connection retries, Valid values: 'range(0, 100)'
- max
Querydegree String - Configures the maximum degree of parallelism for queries, Valid values: 'range(1, 32767)', '-1', 'ANY'
- mon
Heap StringSz - Configures the size of the monitoring heap, Valid values: 'range(0, 2147483647)', 'AUTOMATIC'
- multipartsizemb String
- Configures the size of multipart queries in MB, Valid values: 'range(5, 5120)'
- notifylevel String
- Configures the level of notifications for the database manager, Valid values: 'range(0, 4)'
- num
Initagents String - Configures the number of initial agents in the database manager, Valid values: 'range(0, 64000)'
- num
Initfenced String - Configures the number of initial fenced routines, Valid values: 'range(0, 64000)'
- num
Poolagents String - Configures the number of pool agents,Valid values: '-1', 'range(0, 64000)'
- resync
Interval String - Configures the interval between resync operations, Valid values: 'range(1, 60000)'
- rqrioblk String
- Configures the request/response I/O block size, Valid values: 'range(4096, 65535)'
- start
Stop StringTime - Configures the time in minutes for start/stop operations, Valid values: 'range(1, 1440)'
- util
Impact StringLim - Configures the utility impact limit, Valid values: 'range(1, 100)'
- wlm
Disp StringConcur - Configures whether the WLM (Workload Management) dispatcher is enabled, Valid values:'YES', 'NO'
- String
- wlm
Disp StringMin Util - Configures the minimum utility threshold for WLM dispatcher, Valid values: 'range(0, 100)'
- wlm
Dispatcher String - Configures whether the WLM (Workload Management) dispatcher is enabled,Valid values:'YES', 'NO'
- comm
Bandwidth string - Configures the communication bandwidth for the database manager, Valid values: 'range(0.1, 100000)', '-1'
- cpuspeed string
- Configures the CPU speed for the database manager, Valid values: 'range(0.0000000001, 1)', '-1'
- dft
Mon stringBufpool - Configures whether the buffer pool is monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon stringLock - Configures whether lock monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft
Mon stringSort - Configures whether sort operations are monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon stringStmt - Configures whether statement execution is monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon stringTable - Configures whether table operations are monitored by default, Valid values:'ON', 'OFF'
- dft
Mon stringTimestamp - Configures whether timestamp monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft
Mon stringUow - Configures whether unit of work (UOW) monitoring is enabled by default,Valid values: 'ON', 'OFF'
- diaglevel string
- Configures the diagnostic level for the database manager, Valid values: 'range(0, 4)'
- federated
Async string - Configures whether federated asynchronous mode is enabled, Valid values: 'range(0, 32767)', '-1', 'ANY'
- indexrec string
- Configures the type of indexing to be used in the database manager, Valid values:'RESTART', 'RESTART_NO_REDO', 'ACCESS', 'ACCESS_NO_REDO'
- intra
Parallel string - Configures the parallelism settings for intra-query parallelism, Valid values:'SYSTEM', 'NO', 'YES'
- keepfenced string
- Configures whether fenced routines are kept in memory,Valid values: 'YES', 'NO'
- max
Connretries string - Configures the maximum number of connection retries, Valid values: 'range(0, 100)'
- max
Querydegree string - Configures the maximum degree of parallelism for queries, Valid values: 'range(1, 32767)', '-1', 'ANY'
- mon
Heap stringSz - Configures the size of the monitoring heap, Valid values: 'range(0, 2147483647)', 'AUTOMATIC'
- multipartsizemb string
- Configures the size of multipart queries in MB, Valid values: 'range(5, 5120)'
- notifylevel string
- Configures the level of notifications for the database manager, Valid values: 'range(0, 4)'
- num
Initagents string - Configures the number of initial agents in the database manager, Valid values: 'range(0, 64000)'
- num
Initfenced string - Configures the number of initial fenced routines, Valid values: 'range(0, 64000)'
- num
Poolagents string - Configures the number of pool agents,Valid values: '-1', 'range(0, 64000)'
- resync
Interval string - Configures the interval between resync operations, Valid values: 'range(1, 60000)'
- rqrioblk string
- Configures the request/response I/O block size, Valid values: 'range(4096, 65535)'
- start
Stop stringTime - Configures the time in minutes for start/stop operations, Valid values: 'range(1, 1440)'
- util
Impact stringLim - Configures the utility impact limit, Valid values: 'range(1, 100)'
- wlm
Disp stringConcur - Configures whether the WLM (Workload Management) dispatcher is enabled, Valid values:'YES', 'NO'
- string
- wlm
Disp stringMin Util - Configures the minimum utility threshold for WLM dispatcher, Valid values: 'range(0, 100)'
- wlm
Dispatcher string - Configures whether the WLM (Workload Management) dispatcher is enabled,Valid values:'YES', 'NO'
- comm_
bandwidth str - Configures the communication bandwidth for the database manager, Valid values: 'range(0.1, 100000)', '-1'
- cpuspeed str
- Configures the CPU speed for the database manager, Valid values: 'range(0.0000000001, 1)', '-1'
- dft_
mon_ strbufpool - Configures whether the buffer pool is monitored by default,Valid values: 'ON', 'OFF'
- dft_
mon_ strlock - Configures whether lock monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft_
mon_ strsort - Configures whether sort operations are monitored by default,Valid values: 'ON', 'OFF'
- dft_
mon_ strstmt - Configures whether statement execution is monitored by default,Valid values: 'ON', 'OFF'
- dft_
mon_ strtable - Configures whether table operations are monitored by default, Valid values:'ON', 'OFF'
- dft_
mon_ strtimestamp - Configures whether timestamp monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft_
mon_ struow - Configures whether unit of work (UOW) monitoring is enabled by default,Valid values: 'ON', 'OFF'
- diaglevel str
- Configures the diagnostic level for the database manager, Valid values: 'range(0, 4)'
- federated_
async str - Configures whether federated asynchronous mode is enabled, Valid values: 'range(0, 32767)', '-1', 'ANY'
- indexrec str
- Configures the type of indexing to be used in the database manager, Valid values:'RESTART', 'RESTART_NO_REDO', 'ACCESS', 'ACCESS_NO_REDO'
- intra_
parallel str - Configures the parallelism settings for intra-query parallelism, Valid values:'SYSTEM', 'NO', 'YES'
- keepfenced str
- Configures whether fenced routines are kept in memory,Valid values: 'YES', 'NO'
- max_
connretries str - Configures the maximum number of connection retries, Valid values: 'range(0, 100)'
- max_
querydegree str - Configures the maximum degree of parallelism for queries, Valid values: 'range(1, 32767)', '-1', 'ANY'
- mon_
heap_ strsz - Configures the size of the monitoring heap, Valid values: 'range(0, 2147483647)', 'AUTOMATIC'
- multipartsizemb str
- Configures the size of multipart queries in MB, Valid values: 'range(5, 5120)'
- notifylevel str
- Configures the level of notifications for the database manager, Valid values: 'range(0, 4)'
- num_
initagents str - Configures the number of initial agents in the database manager, Valid values: 'range(0, 64000)'
- num_
initfenced str - Configures the number of initial fenced routines, Valid values: 'range(0, 64000)'
- num_
poolagents str - Configures the number of pool agents,Valid values: '-1', 'range(0, 64000)'
- resync_
interval str - Configures the interval between resync operations, Valid values: 'range(1, 60000)'
- rqrioblk str
- Configures the request/response I/O block size, Valid values: 'range(4096, 65535)'
- start_
stop_ strtime - Configures the time in minutes for start/stop operations, Valid values: 'range(1, 1440)'
- util_
impact_ strlim - Configures the utility impact limit, Valid values: 'range(1, 100)'
- wlm_
disp_ strconcur - Configures whether the WLM (Workload Management) dispatcher is enabled, Valid values:'YES', 'NO'
- str
- wlm_
disp_ strmin_ util - Configures the minimum utility threshold for WLM dispatcher, Valid values: 'range(0, 100)'
- wlm_
dispatcher str - Configures whether the WLM (Workload Management) dispatcher is enabled,Valid values:'YES', 'NO'
- comm
Bandwidth String - Configures the communication bandwidth for the database manager, Valid values: 'range(0.1, 100000)', '-1'
- cpuspeed String
- Configures the CPU speed for the database manager, Valid values: 'range(0.0000000001, 1)', '-1'
- dft
Mon StringBufpool - Configures whether the buffer pool is monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon StringLock - Configures whether lock monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft
Mon StringSort - Configures whether sort operations are monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon StringStmt - Configures whether statement execution is monitored by default,Valid values: 'ON', 'OFF'
- dft
Mon StringTable - Configures whether table operations are monitored by default, Valid values:'ON', 'OFF'
- dft
Mon StringTimestamp - Configures whether timestamp monitoring is enabled by default,Valid values: 'ON', 'OFF'
- dft
Mon StringUow - Configures whether unit of work (UOW) monitoring is enabled by default,Valid values: 'ON', 'OFF'
- diaglevel String
- Configures the diagnostic level for the database manager, Valid values: 'range(0, 4)'
- federated
Async String - Configures whether federated asynchronous mode is enabled, Valid values: 'range(0, 32767)', '-1', 'ANY'
- indexrec String
- Configures the type of indexing to be used in the database manager, Valid values:'RESTART', 'RESTART_NO_REDO', 'ACCESS', 'ACCESS_NO_REDO'
- intra
Parallel String - Configures the parallelism settings for intra-query parallelism, Valid values:'SYSTEM', 'NO', 'YES'
- keepfenced String
- Configures whether fenced routines are kept in memory,Valid values: 'YES', 'NO'
- max
Connretries String - Configures the maximum number of connection retries, Valid values: 'range(0, 100)'
- max
Querydegree String - Configures the maximum degree of parallelism for queries, Valid values: 'range(1, 32767)', '-1', 'ANY'
- mon
Heap StringSz - Configures the size of the monitoring heap, Valid values: 'range(0, 2147483647)', 'AUTOMATIC'
- multipartsizemb String
- Configures the size of multipart queries in MB, Valid values: 'range(5, 5120)'
- notifylevel String
- Configures the level of notifications for the database manager, Valid values: 'range(0, 4)'
- num
Initagents String - Configures the number of initial agents in the database manager, Valid values: 'range(0, 64000)'
- num
Initfenced String - Configures the number of initial fenced routines, Valid values: 'range(0, 64000)'
- num
Poolagents String - Configures the number of pool agents,Valid values: '-1', 'range(0, 64000)'
- resync
Interval String - Configures the interval between resync operations, Valid values: 'range(1, 60000)'
- rqrioblk String
- Configures the request/response I/O block size, Valid values: 'range(4096, 65535)'
- start
Stop StringTime - Configures the time in minutes for start/stop operations, Valid values: 'range(1, 1440)'
- util
Impact StringLim - Configures the utility impact limit, Valid values: 'range(1, 100)'
- wlm
Disp StringConcur - Configures whether the WLM (Workload Management) dispatcher is enabled, Valid values:'YES', 'NO'
- String
- wlm
Disp StringMin Util - Configures the minimum utility threshold for WLM dispatcher, Valid values: 'range(0, 100)'
- wlm
Dispatcher String - Configures whether the WLM (Workload Management) dispatcher is enabled,Valid values:'YES', 'NO'
Db2CustomSettingConfigRegistry, Db2CustomSettingConfigRegistryArgs
- Db2Alternate
Authz stringBehaviour - Configures the alternate authorization behavior for Valid values:DB2, 'EXTERNAL_ROUTINE_DBADM', 'EXTERNAL_ROUTINE_DBAUTH'
- Db2Antijoin string
- Configures how DB2 handles anti-joins, Valid values:'YES', 'NO', 'EXTEND'
- Db2Ats
Enable string - Configures whether DB2 asynchronous table scanning (ATS) is enabled,Valid values: 'YES', 'NO'
- Db2Bidi string
- Configures the bidi (bidirectional) support for DB2,Valid values: 'YES', 'NO'
- Db2Compopt string
- Configures the DB2 component options (not specified in values)
- Db2Deferred
Prepare stringSemantics - Configures whether deferred prepare semantics are enabled in DB2,Valid values: 'NO', 'YES'
- Db2Evaluncommitted string
- Configures whether uncommitted data is evaluated by DB2,Valid values: 'NO', 'YES'
- Db2Extended
Optimization string - Configures extended optimization in DB2 (not specified in values)
- Db2Index
Pctfree stringDefault - Configures the default percentage of free space for DB2 indexes, Valid values: 'range(0, 99)'
- Db2Inlist
To stringNljn - Configures whether in-list queries are converted to nested loop joins,Valid values: 'NO', 'YES'
- Db2Lock
To stringRb - Configures the DB2 lock timeout behavior, Valid values:'STATEMENT'
- Db2Minimize
Listprefetch string - Configures whether DB2 minimizes list prefetching for queries, Valid values:'NO', 'YES'
- Db2Object
Table stringEntries - Configures the number of entries for DB2 object tables, Valid values: 'range(0, 65532)'
- Db2Opt
Max stringTemp Size - Configures the maximum temporary space size for DB2 optimizer
- Db2Optprofile string
- Configures whether DB2's optimizer profile is enabled, Valid values:'YES','NO'
- Db2Optstats
Log string - Configures the logging of optimizer statistics (not specified in values)
- Db2Parallel
Io string - Configures parallel I/O behavior in DB2 (not specified in values)
- Db2Reduced
Optimization string - Configures whether reduced optimization is applied in DB2 (not specified in values)
- Db2Selectivity string
- Configures the selectivity behavior for DB2 queries, Valid values:'YES', 'NO', 'ALL'
- Db2Skipdeleted string
- Configures whether DB2 skips deleted rows during query processing, Valid values:'NO', 'YES'
- Db2Skipinserted string
- Configures whether DB2 skips inserted rows during query processing, Valid values:'NO', 'YES'
- Db2Stmm string
- Configures whether DB2's self-tuning memory manager (STMM) is enabled, Valid values:'NO', 'YES'
- Db2Sync
Release stringLock Attributes - Configures whether DB2 synchronizes lock release attributes,Valid values: 'NO', 'YES'
- Db2Truncate
Reusestorage string - Configures the types of operations that reuse storage after truncation, Valid values:'IMPORT', 'LOAD', 'TRUNCATE'
- Db2Use
Alternate stringPage Cleaning - Configures whether DB2 uses alternate page cleaning methods, Valid values:'ON', 'OFF'
- Db2View
Reopt stringValues - Configures whether DB2 view reoptimization values are used,Valid values: 'NO', 'YES'
- Db2Wlm
Settings string - Configures the WLM (Workload Management) settings for DB2 (not specified in values)
- Db2Workload string
- Configures the DB2 workload type,Valid values: '1C', 'ANALYTICS', 'CM', 'COGNOS_CS', 'FILENET_CM', 'INFOR_ERP_LN', 'MAXIMO', 'MDM', 'SAP', 'TPM', 'WAS', 'WC', 'WP'
- Db2Alternate
Authz stringBehaviour - Configures the alternate authorization behavior for Valid values:DB2, 'EXTERNAL_ROUTINE_DBADM', 'EXTERNAL_ROUTINE_DBAUTH'
- Db2Antijoin string
- Configures how DB2 handles anti-joins, Valid values:'YES', 'NO', 'EXTEND'
- Db2Ats
Enable string - Configures whether DB2 asynchronous table scanning (ATS) is enabled,Valid values: 'YES', 'NO'
- Db2Bidi string
- Configures the bidi (bidirectional) support for DB2,Valid values: 'YES', 'NO'
- Db2Compopt string
- Configures the DB2 component options (not specified in values)
- Db2Deferred
Prepare stringSemantics - Configures whether deferred prepare semantics are enabled in DB2,Valid values: 'NO', 'YES'
- Db2Evaluncommitted string
- Configures whether uncommitted data is evaluated by DB2,Valid values: 'NO', 'YES'
- Db2Extended
Optimization string - Configures extended optimization in DB2 (not specified in values)
- Db2Index
Pctfree stringDefault - Configures the default percentage of free space for DB2 indexes, Valid values: 'range(0, 99)'
- Db2Inlist
To stringNljn - Configures whether in-list queries are converted to nested loop joins,Valid values: 'NO', 'YES'
- Db2Lock
To stringRb - Configures the DB2 lock timeout behavior, Valid values:'STATEMENT'
- Db2Minimize
Listprefetch string - Configures whether DB2 minimizes list prefetching for queries, Valid values:'NO', 'YES'
- Db2Object
Table stringEntries - Configures the number of entries for DB2 object tables, Valid values: 'range(0, 65532)'
- Db2Opt
Max stringTemp Size - Configures the maximum temporary space size for DB2 optimizer
- Db2Optprofile string
- Configures whether DB2's optimizer profile is enabled, Valid values:'YES','NO'
- Db2Optstats
Log string - Configures the logging of optimizer statistics (not specified in values)
- Db2Parallel
Io string - Configures parallel I/O behavior in DB2 (not specified in values)
- Db2Reduced
Optimization string - Configures whether reduced optimization is applied in DB2 (not specified in values)
- Db2Selectivity string
- Configures the selectivity behavior for DB2 queries, Valid values:'YES', 'NO', 'ALL'
- Db2Skipdeleted string
- Configures whether DB2 skips deleted rows during query processing, Valid values:'NO', 'YES'
- Db2Skipinserted string
- Configures whether DB2 skips inserted rows during query processing, Valid values:'NO', 'YES'
- Db2Stmm string
- Configures whether DB2's self-tuning memory manager (STMM) is enabled, Valid values:'NO', 'YES'
- Db2Sync
Release stringLock Attributes - Configures whether DB2 synchronizes lock release attributes,Valid values: 'NO', 'YES'
- Db2Truncate
Reusestorage string - Configures the types of operations that reuse storage after truncation, Valid values:'IMPORT', 'LOAD', 'TRUNCATE'
- Db2Use
Alternate stringPage Cleaning - Configures whether DB2 uses alternate page cleaning methods, Valid values:'ON', 'OFF'
- Db2View
Reopt stringValues - Configures whether DB2 view reoptimization values are used,Valid values: 'NO', 'YES'
- Db2Wlm
Settings string - Configures the WLM (Workload Management) settings for DB2 (not specified in values)
- Db2Workload string
- Configures the DB2 workload type,Valid values: '1C', 'ANALYTICS', 'CM', 'COGNOS_CS', 'FILENET_CM', 'INFOR_ERP_LN', 'MAXIMO', 'MDM', 'SAP', 'TPM', 'WAS', 'WC', 'WP'
- db2Alternate
Authz StringBehaviour - Configures the alternate authorization behavior for Valid values:DB2, 'EXTERNAL_ROUTINE_DBADM', 'EXTERNAL_ROUTINE_DBAUTH'
- db2Antijoin String
- Configures how DB2 handles anti-joins, Valid values:'YES', 'NO', 'EXTEND'
- db2Ats
Enable String - Configures whether DB2 asynchronous table scanning (ATS) is enabled,Valid values: 'YES', 'NO'
- db2Bidi String
- Configures the bidi (bidirectional) support for DB2,Valid values: 'YES', 'NO'
- db2Compopt String
- Configures the DB2 component options (not specified in values)
- db2Deferred
Prepare StringSemantics - Configures whether deferred prepare semantics are enabled in DB2,Valid values: 'NO', 'YES'
- db2Evaluncommitted String
- Configures whether uncommitted data is evaluated by DB2,Valid values: 'NO', 'YES'
- db2Extended
Optimization String - Configures extended optimization in DB2 (not specified in values)
- db2Index
Pctfree StringDefault - Configures the default percentage of free space for DB2 indexes, Valid values: 'range(0, 99)'
- db2Inlist
To StringNljn - Configures whether in-list queries are converted to nested loop joins,Valid values: 'NO', 'YES'
- db2Lock
To StringRb - Configures the DB2 lock timeout behavior, Valid values:'STATEMENT'
- db2Minimize
Listprefetch String - Configures whether DB2 minimizes list prefetching for queries, Valid values:'NO', 'YES'
- db2Object
Table StringEntries - Configures the number of entries for DB2 object tables, Valid values: 'range(0, 65532)'
- db2Opt
Max StringTemp Size - Configures the maximum temporary space size for DB2 optimizer
- db2Optprofile String
- Configures whether DB2's optimizer profile is enabled, Valid values:'YES','NO'
- db2Optstats
Log String - Configures the logging of optimizer statistics (not specified in values)
- db2Parallel
Io String - Configures parallel I/O behavior in DB2 (not specified in values)
- db2Reduced
Optimization String - Configures whether reduced optimization is applied in DB2 (not specified in values)
- db2Selectivity String
- Configures the selectivity behavior for DB2 queries, Valid values:'YES', 'NO', 'ALL'
- db2Skipdeleted String
- Configures whether DB2 skips deleted rows during query processing, Valid values:'NO', 'YES'
- db2Skipinserted String
- Configures whether DB2 skips inserted rows during query processing, Valid values:'NO', 'YES'
- db2Stmm String
- Configures whether DB2's self-tuning memory manager (STMM) is enabled, Valid values:'NO', 'YES'
- db2Sync
Release StringLock Attributes - Configures whether DB2 synchronizes lock release attributes,Valid values: 'NO', 'YES'
- db2Truncate
Reusestorage String - Configures the types of operations that reuse storage after truncation, Valid values:'IMPORT', 'LOAD', 'TRUNCATE'
- db2Use
Alternate StringPage Cleaning - Configures whether DB2 uses alternate page cleaning methods, Valid values:'ON', 'OFF'
- db2View
Reopt StringValues - Configures whether DB2 view reoptimization values are used,Valid values: 'NO', 'YES'
- db2Wlm
Settings String - Configures the WLM (Workload Management) settings for DB2 (not specified in values)
- db2Workload String
- Configures the DB2 workload type,Valid values: '1C', 'ANALYTICS', 'CM', 'COGNOS_CS', 'FILENET_CM', 'INFOR_ERP_LN', 'MAXIMO', 'MDM', 'SAP', 'TPM', 'WAS', 'WC', 'WP'
- db2Alternate
Authz stringBehaviour - Configures the alternate authorization behavior for Valid values:DB2, 'EXTERNAL_ROUTINE_DBADM', 'EXTERNAL_ROUTINE_DBAUTH'
- db2Antijoin string
- Configures how DB2 handles anti-joins, Valid values:'YES', 'NO', 'EXTEND'
- db2Ats
Enable string - Configures whether DB2 asynchronous table scanning (ATS) is enabled,Valid values: 'YES', 'NO'
- db2Bidi string
- Configures the bidi (bidirectional) support for DB2,Valid values: 'YES', 'NO'
- db2Compopt string
- Configures the DB2 component options (not specified in values)
- db2Deferred
Prepare stringSemantics - Configures whether deferred prepare semantics are enabled in DB2,Valid values: 'NO', 'YES'
- db2Evaluncommitted string
- Configures whether uncommitted data is evaluated by DB2,Valid values: 'NO', 'YES'
- db2Extended
Optimization string - Configures extended optimization in DB2 (not specified in values)
- db2Index
Pctfree stringDefault - Configures the default percentage of free space for DB2 indexes, Valid values: 'range(0, 99)'
- db2Inlist
To stringNljn - Configures whether in-list queries are converted to nested loop joins,Valid values: 'NO', 'YES'
- db2Lock
To stringRb - Configures the DB2 lock timeout behavior, Valid values:'STATEMENT'
- db2Minimize
Listprefetch string - Configures whether DB2 minimizes list prefetching for queries, Valid values:'NO', 'YES'
- db2Object
Table stringEntries - Configures the number of entries for DB2 object tables, Valid values: 'range(0, 65532)'
- db2Opt
Max stringTemp Size - Configures the maximum temporary space size for DB2 optimizer
- db2Optprofile string
- Configures whether DB2's optimizer profile is enabled, Valid values:'YES','NO'
- db2Optstats
Log string - Configures the logging of optimizer statistics (not specified in values)
- db2Parallel
Io string - Configures parallel I/O behavior in DB2 (not specified in values)
- db2Reduced
Optimization string - Configures whether reduced optimization is applied in DB2 (not specified in values)
- db2Selectivity string
- Configures the selectivity behavior for DB2 queries, Valid values:'YES', 'NO', 'ALL'
- db2Skipdeleted string
- Configures whether DB2 skips deleted rows during query processing, Valid values:'NO', 'YES'
- db2Skipinserted string
- Configures whether DB2 skips inserted rows during query processing, Valid values:'NO', 'YES'
- db2Stmm string
- Configures whether DB2's self-tuning memory manager (STMM) is enabled, Valid values:'NO', 'YES'
- db2Sync
Release stringLock Attributes - Configures whether DB2 synchronizes lock release attributes,Valid values: 'NO', 'YES'
- db2Truncate
Reusestorage string - Configures the types of operations that reuse storage after truncation, Valid values:'IMPORT', 'LOAD', 'TRUNCATE'
- db2Use
Alternate stringPage Cleaning - Configures whether DB2 uses alternate page cleaning methods, Valid values:'ON', 'OFF'
- db2View
Reopt stringValues - Configures whether DB2 view reoptimization values are used,Valid values: 'NO', 'YES'
- db2Wlm
Settings string - Configures the WLM (Workload Management) settings for DB2 (not specified in values)
- db2Workload string
- Configures the DB2 workload type,Valid values: '1C', 'ANALYTICS', 'CM', 'COGNOS_CS', 'FILENET_CM', 'INFOR_ERP_LN', 'MAXIMO', 'MDM', 'SAP', 'TPM', 'WAS', 'WC', 'WP'
- db2_
alternate_ strauthz_ behaviour - Configures the alternate authorization behavior for Valid values:DB2, 'EXTERNAL_ROUTINE_DBADM', 'EXTERNAL_ROUTINE_DBAUTH'
- db2_
antijoin str - Configures how DB2 handles anti-joins, Valid values:'YES', 'NO', 'EXTEND'
- db2_
ats_ strenable - Configures whether DB2 asynchronous table scanning (ATS) is enabled,Valid values: 'YES', 'NO'
- db2_
bidi str - Configures the bidi (bidirectional) support for DB2,Valid values: 'YES', 'NO'
- db2_
compopt str - Configures the DB2 component options (not specified in values)
- db2_
deferred_ strprepare_ semantics - Configures whether deferred prepare semantics are enabled in DB2,Valid values: 'NO', 'YES'
- db2_
evaluncommitted str - Configures whether uncommitted data is evaluated by DB2,Valid values: 'NO', 'YES'
- db2_
extended_ stroptimization - Configures extended optimization in DB2 (not specified in values)
- db2_
index_ strpctfree_ default - Configures the default percentage of free space for DB2 indexes, Valid values: 'range(0, 99)'
- db2_
inlist_ strto_ nljn - Configures whether in-list queries are converted to nested loop joins,Valid values: 'NO', 'YES'
- db2_
lock_ strto_ rb - Configures the DB2 lock timeout behavior, Valid values:'STATEMENT'
- db2_
minimize_ strlistprefetch - Configures whether DB2 minimizes list prefetching for queries, Valid values:'NO', 'YES'
- db2_
object_ strtable_ entries - Configures the number of entries for DB2 object tables, Valid values: 'range(0, 65532)'
- db2_
opt_ strmax_ temp_ size - Configures the maximum temporary space size for DB2 optimizer
- db2_
optprofile str - Configures whether DB2's optimizer profile is enabled, Valid values:'YES','NO'
- db2_
optstats_ strlog - Configures the logging of optimizer statistics (not specified in values)
- db2_
parallel_ strio - Configures parallel I/O behavior in DB2 (not specified in values)
- db2_
reduced_ stroptimization - Configures whether reduced optimization is applied in DB2 (not specified in values)
- db2_
selectivity str - Configures the selectivity behavior for DB2 queries, Valid values:'YES', 'NO', 'ALL'
- db2_
skipdeleted str - Configures whether DB2 skips deleted rows during query processing, Valid values:'NO', 'YES'
- db2_
skipinserted str - Configures whether DB2 skips inserted rows during query processing, Valid values:'NO', 'YES'
- db2_
stmm str - Configures whether DB2's self-tuning memory manager (STMM) is enabled, Valid values:'NO', 'YES'
- db2_
sync_ strrelease_ lock_ attributes - Configures whether DB2 synchronizes lock release attributes,Valid values: 'NO', 'YES'
- db2_
truncate_ strreusestorage - Configures the types of operations that reuse storage after truncation, Valid values:'IMPORT', 'LOAD', 'TRUNCATE'
- db2_
use_ stralternate_ page_ cleaning - Configures whether DB2 uses alternate page cleaning methods, Valid values:'ON', 'OFF'
- db2_
view_ strreopt_ values - Configures whether DB2 view reoptimization values are used,Valid values: 'NO', 'YES'
- db2_
wlm_ strsettings - Configures the WLM (Workload Management) settings for DB2 (not specified in values)
- db2_
workload str - Configures the DB2 workload type,Valid values: '1C', 'ANALYTICS', 'CM', 'COGNOS_CS', 'FILENET_CM', 'INFOR_ERP_LN', 'MAXIMO', 'MDM', 'SAP', 'TPM', 'WAS', 'WC', 'WP'
- db2Alternate
Authz StringBehaviour - Configures the alternate authorization behavior for Valid values:DB2, 'EXTERNAL_ROUTINE_DBADM', 'EXTERNAL_ROUTINE_DBAUTH'
- db2Antijoin String
- Configures how DB2 handles anti-joins, Valid values:'YES', 'NO', 'EXTEND'
- db2Ats
Enable String - Configures whether DB2 asynchronous table scanning (ATS) is enabled,Valid values: 'YES', 'NO'
- db2Bidi String
- Configures the bidi (bidirectional) support for DB2,Valid values: 'YES', 'NO'
- db2Compopt String
- Configures the DB2 component options (not specified in values)
- db2Deferred
Prepare StringSemantics - Configures whether deferred prepare semantics are enabled in DB2,Valid values: 'NO', 'YES'
- db2Evaluncommitted String
- Configures whether uncommitted data is evaluated by DB2,Valid values: 'NO', 'YES'
- db2Extended
Optimization String - Configures extended optimization in DB2 (not specified in values)
- db2Index
Pctfree StringDefault - Configures the default percentage of free space for DB2 indexes, Valid values: 'range(0, 99)'
- db2Inlist
To StringNljn - Configures whether in-list queries are converted to nested loop joins,Valid values: 'NO', 'YES'
- db2Lock
To StringRb - Configures the DB2 lock timeout behavior, Valid values:'STATEMENT'
- db2Minimize
Listprefetch String - Configures whether DB2 minimizes list prefetching for queries, Valid values:'NO', 'YES'
- db2Object
Table StringEntries - Configures the number of entries for DB2 object tables, Valid values: 'range(0, 65532)'
- db2Opt
Max StringTemp Size - Configures the maximum temporary space size for DB2 optimizer
- db2Optprofile String
- Configures whether DB2's optimizer profile is enabled, Valid values:'YES','NO'
- db2Optstats
Log String - Configures the logging of optimizer statistics (not specified in values)
- db2Parallel
Io String - Configures parallel I/O behavior in DB2 (not specified in values)
- db2Reduced
Optimization String - Configures whether reduced optimization is applied in DB2 (not specified in values)
- db2Selectivity String
- Configures the selectivity behavior for DB2 queries, Valid values:'YES', 'NO', 'ALL'
- db2Skipdeleted String
- Configures whether DB2 skips deleted rows during query processing, Valid values:'NO', 'YES'
- db2Skipinserted String
- Configures whether DB2 skips inserted rows during query processing, Valid values:'NO', 'YES'
- db2Stmm String
- Configures whether DB2's self-tuning memory manager (STMM) is enabled, Valid values:'NO', 'YES'
- db2Sync
Release StringLock Attributes - Configures whether DB2 synchronizes lock release attributes,Valid values: 'NO', 'YES'
- db2Truncate
Reusestorage String - Configures the types of operations that reuse storage after truncation, Valid values:'IMPORT', 'LOAD', 'TRUNCATE'
- db2Use
Alternate StringPage Cleaning - Configures whether DB2 uses alternate page cleaning methods, Valid values:'ON', 'OFF'
- db2View
Reopt StringValues - Configures whether DB2 view reoptimization values are used,Valid values: 'NO', 'YES'
- db2Wlm
Settings String - Configures the WLM (Workload Management) settings for DB2 (not specified in values)
- db2Workload String
- Configures the DB2 workload type,Valid values: '1C', 'ANALYTICS', 'CM', 'COGNOS_CS', 'FILENET_CM', 'INFOR_ERP_LN', 'MAXIMO', 'MDM', 'SAP', 'TPM', 'WAS', 'WC', 'WP'
Db2PlanHistory, Db2PlanHistoryArgs
- Resource
Plan stringId - Start
Date string
- Resource
Plan stringId - Start
Date string
- resource
Plan StringId - start
Date String
- resource
Plan stringId - start
Date string
- resource_
plan_ strid - start_
date str
- resource
Plan StringId - start
Date String
Db2Timeouts, Db2TimeoutsArgs
Db2UsersConfig, Db2UsersConfigArgs
- Authentications
List<Db2Users
Config Authentication> - Authentication details for the user. Nested schema for authentication:
- Email string
- Email address of the user.
- Iam bool
- Indicates if IAM is enabled or not.
- Ibmid string
- IBM ID of the user.
- Id string
- (String) The CRN of the database instance.
- Locked string
- Account lock status for the user.
- Constraints: Allowable values are:
yes,no.
- Constraints: Allowable values are:
- Name string
- The display name of the user.
- Password string
- User's password.
- Role string
- Role assigned to the user.
- Constraints: Allowable values are:
bluadmin,bluuser.
- Constraints: Allowable values are:
- Authentications
[]Db2Users
Config Authentication - Authentication details for the user. Nested schema for authentication:
- Email string
- Email address of the user.
- Iam bool
- Indicates if IAM is enabled or not.
- Ibmid string
- IBM ID of the user.
- Id string
- (String) The CRN of the database instance.
- Locked string
- Account lock status for the user.
- Constraints: Allowable values are:
yes,no.
- Constraints: Allowable values are:
- Name string
- The display name of the user.
- Password string
- User's password.
- Role string
- Role assigned to the user.
- Constraints: Allowable values are:
bluadmin,bluuser.
- Constraints: Allowable values are:
- authentications
List<Db2Users
Config Authentication> - Authentication details for the user. Nested schema for authentication:
- email String
- Email address of the user.
- iam Boolean
- Indicates if IAM is enabled or not.
- ibmid String
- IBM ID of the user.
- id String
- (String) The CRN of the database instance.
- locked String
- Account lock status for the user.
- Constraints: Allowable values are:
yes,no.
- Constraints: Allowable values are:
- name String
- The display name of the user.
- password String
- User's password.
- role String
- Role assigned to the user.
- Constraints: Allowable values are:
bluadmin,bluuser.
- Constraints: Allowable values are:
- authentications
Db2Users
Config Authentication[] - Authentication details for the user. Nested schema for authentication:
- email string
- Email address of the user.
- iam boolean
- Indicates if IAM is enabled or not.
- ibmid string
- IBM ID of the user.
- id string
- (String) The CRN of the database instance.
- locked string
- Account lock status for the user.
- Constraints: Allowable values are:
yes,no.
- Constraints: Allowable values are:
- name string
- The display name of the user.
- password string
- User's password.
- role string
- Role assigned to the user.
- Constraints: Allowable values are:
bluadmin,bluuser.
- Constraints: Allowable values are:
- authentications
Sequence[Db2Users
Config Authentication] - Authentication details for the user. Nested schema for authentication:
- email str
- Email address of the user.
- iam bool
- Indicates if IAM is enabled or not.
- ibmid str
- IBM ID of the user.
- id str
- (String) The CRN of the database instance.
- locked str
- Account lock status for the user.
- Constraints: Allowable values are:
yes,no.
- Constraints: Allowable values are:
- name str
- The display name of the user.
- password str
- User's password.
- role str
- Role assigned to the user.
- Constraints: Allowable values are:
bluadmin,bluuser.
- Constraints: Allowable values are:
- authentications List<Property Map>
- Authentication details for the user. Nested schema for authentication:
- email String
- Email address of the user.
- iam Boolean
- Indicates if IAM is enabled or not.
- ibmid String
- IBM ID of the user.
- id String
- (String) The CRN of the database instance.
- locked String
- Account lock status for the user.
- Constraints: Allowable values are:
yes,no.
- Constraints: Allowable values are:
- name String
- The display name of the user.
- password String
- User's password.
- role String
- Role assigned to the user.
- Constraints: Allowable values are:
bluadmin,bluuser.
- Constraints: Allowable values are:
Db2UsersConfigAuthentication, Db2UsersConfigAuthenticationArgs
Import
The database instance can be imported by using the ID, that is formed from the CRN. To import the resource, you must specify the region parameter in the provider block of your Terraform configuration file. If the region is not specified, us-south is used by default. An Terraform refresh or apply fails, if the database instance is not in the same region as configured in the provider or its alias.
CRN is a 120 digit character string of the form - crn:v1:bluemix:public:dashdb-for-transactions:us-south:a/60970f92286548d8a64cbb45bce39bc1:deae06ff-3966-4534-bfa0-4b42281e7cef::
Syntax
$ pulumi import ibm:index/db2:Db2 my_db <crn>
Example
$ pulumi import ibm:index/db2:Db2 my_db crn:v1:bluemix:public:dashdb-for-transactions:us-south:a/60970f92286548d8a64cbb45bce39bc1:deae06ff-3966-4534-bfa0-4b42281e7cef::
Import requires a minimal Terraform config file to allow importing.
Run terraform state show ibm_db2.<your_database> after import to retrieve the more values to be included in the resource config file. It does not export any more user IDs and passwords that are configured on the instance. These values must be retrieved from an alternative source.
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- ibm ibm-cloud/terraform-provider-ibm
- License
- Notes
- This Pulumi package is based on the
ibmTerraform Provider.
