Quick cheat sheet on creating an ObjectServer in Windows

Quick creation:

C:\Program Files\IBM\tivoli\netcool\omnibus\bin>nco_dbinit.exe -server COL1

Error Opening Log File C:\Program Files\IBM\tivoli\netcool\omnibus\LOG\NCOMS_audit_file.log 2016-11-10T11:32:48: Information: I-MEM-003-001: Creating 'C:\Program Files\IBM\tivoli\netcool\omnibus\db\COL1' 2016-11-10T11:32:48: Information: I-MEM-003-004: Using lock to chain ratio of '32'. 2016-11-10T11:32:49: Information: I-STO-104-006: Creating internal database persist 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table persist.restrictions 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.connections 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.properties 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.profiles 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.restrictions 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.security_permissions 2016-11-10T11:32:49: Information: I-DBI-003-001: Processing system file: C:\Program Files\IBM\tivoli\netcool\omnibus\ETC\system.sql 2016-11-10T11:32:49: Information: I-STO-104-006: Creating internal database security 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.owners 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.users 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.roles 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.role_grants 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.permissions 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.groups 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.group_members 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table security.restriction_filters 2016-11-10T11:32:49: Information: I-STO-104-006: Creating internal database transfer 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.users 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.roles 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.role_grants 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.permissions 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.groups 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.group_members 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.restrictions 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table transfer.security_restrictions 2016-11-10T11:32:49: Information: I-DBI-003-002: Processing application file: C:\Program Files\IBM\tivoli\netcool\omnibus\ETC\application.sql 2016-11-10T11:32:49: Information: I-STO-104-005: User root creating database alerts 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.status 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.journal 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.details 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.objclass 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.objmenus 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.objmenuitems 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.resolutions 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.conversions 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.col_visuals 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.colors 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.iduc_messages 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.application_types 2016-11-10T11:32:49: Information: I-STO-104-005: User root creating database service 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table service.status 2016-11-10T11:32:49: Information: I-STO-104-005: User root creating database tools 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table tools.actions 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table tools.action_access 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table tools.menus 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table tools.menu_items 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table tools.menu_defs 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table tools.prompt_defs 2016-11-10T11:32:49: Information: I-STO-104-005: User root creating database master 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table master.permissions 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table master.profiles 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table master.servergroups 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table master.class_membership 2016-11-10T11:32:49: Information: I-STO-104-005: User root creating database iduc_system 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table iduc_system.channel 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table iduc_system.channel_interest 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table iduc_system.channel_summary 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table iduc_system.channel_summary_cols 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table iduc_system.iduc_stats 2016-11-10T11:32:49: Information: I-STO-104-005: User root creating database custom 2016-11-10T11:32:49: Information: I-STO-104-005: User root creating database precision 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table precision.entity_service 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table precision.service_details 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table precision.service_affecting_event 2016-11-10T11:32:49: Information: I-DBI-003-003: Processing desktop file: C:\Program Files\IBM\tivoli\netcool\omnibus\ETC\desktop.sql 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table persist.procedures 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.procedures 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.sql_procedures 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.external_procedures 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.procedure_parameters 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table persist.signals 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table persist.triggers 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table persist.trigger_groups 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.primitive_signals 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.primitive_signal_parameters 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.triggers 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.database_triggers 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.signal_triggers 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.temporal_triggers 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.trigger_groups 2016-11-10T11:32:49: Information: I-STO-104-015: Creating table catalog.trigger_stats 2016-11-10T11:32:49: Information: I-DBI-003-004: Processing automation file: C:\Program Files\IBM\tivoli\netcool\omnibus\ETC\automation.sql 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group system_watch 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group connection_watch 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group security_watch 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group default_triggers 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group compatibility_triggers 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group audit_config 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group iduc_triggers 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group gateway_triggers 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group primary_only 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group sae 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger system_watch_startup 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger system_watch_shutdown 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger connection_watch_disconnect 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger connection_watch_connect 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger security_watch_security_failure 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger new_row 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger deduplication 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger state_change 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger deduplicate_details 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger service_insert 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger service_reinsert 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger service_update 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger clean_details_table 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger clean_journal_table 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger delete_clears 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger escalate_off 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger expire 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger flash_not_ack 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.problem_events 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger generic_clear 2016-11-10T11:32:49: Information: I-PRO-007-004: User root creating procedure send_email 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger mail_on_critical 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group automatic_backup_system 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table alerts.backup_state 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger backup_state_integrity 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger automatic_backup 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger backup_succeeded 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger backup_failed 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group profiler_triggers 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger profiler_toggle 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger profiler_report 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger profiler_group_report 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group trigger_stat_reports 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger trigger_stats_report 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table master.stats 2016-11-10T11:32:49: Information: I-STO-104-014: User root creating table master.activity_stats 2016-11-10T11:32:49: Information: I-AUT-104-001: User root creating primitive signal stats_reset 2016-11-10T11:32:49: Information: I-AUT-005-005: User root creating trigger group stats_triggers 2016-11-10T11:32:49: Information: I-AUT-005-015: User root altering trigger group stats_triggers 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger new_status_inserts 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger dedup_status_inserts 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger journal_inserts 2016-11-10T11:32:49: Information: I-AUT-005-009: User root creating database trigger details_inserts 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger statistics_gather 2016-11-10T11:32:49: Information: I-AUT-005-010: User root creating temporal trigger statistics_cleanup 2016-11-10T11:32:49: Information: I-AUT-005-011: User root creating signal trigger stats_reset 2016-11-10T11:32:50: Information: I-STO-104-014: User root creating table alerts.login_failures 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger disable_user 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger reset_user 2016-11-10T11:32:50: Information: I-AUT-005-010: User root creating temporal trigger disable_inactive_users 2016-11-10T11:32:50: Information: I-AUT-005-010: User root creating temporal trigger webtop_compatibility 2016-11-10T11:32:50: Information: I-AUT-005-015: User root altering trigger group audit_config 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger audit_config_create_object 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger audit_config_alter_object 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger audit_config_drop_object 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger audit_config_alter_property 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger audit_config_permission_denied 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_create_class 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_alter_class 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_drop_class 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_create_menu 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_alter_menu 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_drop_menu 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_create_conv 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_alter_conv 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_drop_conv 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_create_col_visual 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_alter_col_visual 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_drop_col_visual 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_create_tool 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_alter_tool 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_drop_tool 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_create_prompt 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_alter_prompt 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger audit_config_drop_prompt 2016-11-10T11:32:50: Information: I-PRO-007-004: User root creating procedure jinsert 2016-11-10T11:32:50: Information: I-AUT-005-010: User root creating temporal trigger iduc_messages_tblclean 2016-11-10T11:32:50: Information: I-PRO-007-004: User root creating procedure automation_disable 2016-11-10T11:32:50: Information: I-PRO-007-004: User root creating procedure automation_enable 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger backup_counterpart_down 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger backup_counterpart_up 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger backup_startup 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger disconnect_iduc_missed 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger iduc_stats_insert 2016-11-10T11:32:50: Information: I-AUT-005-009: User root creating database trigger deduplicate_iduc_stats 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger iduc_stats_update 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger pass_deletes 2016-11-10T11:32:50: Information: I-AUT-005-011: User root creating signal trigger resync_finished 2016-11-10T11:32:50: Information: I-AUT-005-010: User root creating temporal trigger update_service_affecting_events 2016-11-10T11:32:50: Information: I-DBI-003-006: Processing security file: C:\Program Files\IBM\tivoli\netcool\omnibus\ETC\security.sql 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role CatalogUser 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role AlertsUser 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role AlertsProbe 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role AlertsGateway 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role ChannelUser 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role DatabaseAdmin 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role AutoAdmin 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role SecurityAdmin 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role ToolsAdmin 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role DesktopAdmin 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role ISQL 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role ISQLWrite 2016-11-10T11:32:50: Information: I-OBJ-100-008: User root creating role ChannelAdmin 2016-11-10T11:32:50: Information: I-OBJ-100-011: User root creating group Probe 2016-11-10T11:32:50: Information: I-OBJ-100-011: User root creating group Gateway 2016-11-10T11:32:50: Information: I-OBJ-100-011: User root creating group ISQLWrite 2016-11-10T11:32:50: Information: I-OBJ-100-011: User root creating group ISQL 2016-11-10T11:32:50: Information: I-PRO-007-004: User root creating procedure setup_group_conversions 2016-11-10T11:32:50: Information: I-PRO-007-005: User root dropping procedure setup_group_conversions

C:\Program Files\IBM\tivoli\netcool\omnibus\bin>nco_store_resize.exe -server COL1 -messagelevel debug

2016-11-10T11:33:05: Information: I-MEM-003-004: Using lock to chain ratio of '32'. 2016-11-10T11:33:05: Debug: D-ETC-004-049: THREAD MGR: started thread REGIONCHKPT (0100EFF8) 2016-11-10T11:33:05: Debug: D-ETC-004-050: THREAD MGR: thread REGIONCHKPT (0100EFF8) running 2016-11-10T11:33:05: Information: I-REG-002-015: Restoring master_store from TAB file 2016-11-10T11:33:05: Debug: D-REG-002-010: CHKPT: started 2016-11-10T11:33:05: Information: I-REG-005-001: Verifing region 'master_store'... 2016-11-10T11:33:05: Debug: D-REG-002-011: CHKPT: sleeping ... 2016-11-10T11:33:05: Debug: D-REG-002-020: Attempting to sync region "master_store" 2016-11-10T11:33:05: Information: I-STR-001-006: Successfully extended store 'table_store' to 500MB

C:\Program Files\IBM\tivoli\netcool\omnibus\bin>nco_objserv.exe /install /cmdline "-name COL1" /instance COL1

Netcool/OMNIbus Object Server - Version 7.3.1 (C) Copyright IBM Corp. 1994, 2007 Installing the Netcool/OMNIbus Object Server (COL1) service... The Netcool/OMNIbus Object Server (COL1) service was successfully installed

C:\Program Files\IBM\tivoli\netcool\omnibus\bin>net start NCOObjectServer$COL1

The Netcool/OMNIbus Object Server (COL1) service is starting. The Netcool/OMNIbus Object Server (COL1) service was started successfully.

C:\Program Files\IBM\tivoli\netcool\omnibus\bin>isql.bat -S COL1 -U root -P ""

1> select count(*) from alerts.status; 2> go  COUNT( * )  -----------            2 (1 row affected) 1>