### Run Jupyter Notebook Server Installer Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=icajns-installing-jupyter-notebook-server-linux Executes the primary installation script for the Jupyter Notebook Server. This script loads the Docker images and starts the necessary containers, completing the server setup. ```shell ./install.sh ``` -------------------------------- ### Install and Start Satellite Connector Service (Windows Batch) Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=iscawui-configuring-starting-satellite-connector-service This batch script is used to create and start the Satellite Connector service on a Windows host. It prompts for confirmation before proceeding and assumes the 'config.json' file has been updated. ```batch install.cmd ``` -------------------------------- ### Example: Load Connection Options (Java) Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=problems-using-jdbcinfo-tool Demonstrates loading connection options from a file named 'db2.info' using the LoadOptions action. This example uses a Java command line, specifying the classpath and the main class, followed by the loadoptions command and the file name. ```java java -cp jdbcinfo.jar:db2/%COGNOS_DRIVERS%/db2jcc4.jar com.ibm.cognos.jdbcinfo.App loadoptions db2.info ``` -------------------------------- ### Example: Save Connection Options (Java) Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=problems-using-jdbcinfo-tool Demonstrates saving connection options to a file named 'db2.info' using the SaveOptions action. This example uses a Java command line, specifying the classpath, main class, connection URL, driver, user, and password. ```java java -cp jdbcinfo.jar:db2/%COGNOS_DRIVERS%/db2jcc4.jar com.ibm.cognos.jdbcinfo.App \ -U jdbc:db2://server:50105/dbname -d com.ibm.db2.jcc.DB2Driver -u user \ -p password saveoptions db2.info ``` -------------------------------- ### Install libnsl.so.1 package using yum Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=analytics-javalangunsatisfiedlinkerror-message-when-starting-cognos-configuration This command installs the `libnsl.so.1` package, which is a common prerequisite for IBM Cognos Configuration on Linux systems. Ensure you have appropriate permissions to run `yum`. ```shell yum install libnsl.so.1 ``` -------------------------------- ### Run Sample Database Setup Script (Shell) Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=databases-restore-samples-db2-using-script Executes the setup script on the local computer to link to the remote GS_DB database. Requires the administration user ID and will prompt for a password. ```bash setupGSDB -database GS_DB -userid administration_user_ID ``` -------------------------------- ### Create and Start Satellite Connector Service using install.cmd Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=installer-configuring-starting-satellite-connector-service This script is used to create and start the Satellite Connector service on a Windows machine. It prompts the user for confirmation before proceeding with the service creation and startup. Ensure the config.json file is updated prior to running this script. ```batch REM Assuming the script is named install.cmd REM Right click and select 'Run as administrator' REM When prompted: REM Type 'y' and press Enter to confirm service creation and start. REM Type 'y' and press Enter again to proceed. ``` -------------------------------- ### Get PVC Information using kubectl (CLI) Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=install-creating-persistent-volume-claim This command uses kubectl to describe the properties and status of a specified Persistent Volume Claim (PVC). It is useful for verifying the PVC's configuration and ensuring it meets the installation requirements. ```bash kubectl describe pvc ``` -------------------------------- ### Manage Satellite Connector Agent Container Lifecycle Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=docker-command-reference-creating-running-agent Docker commands to manage the lifecycle of the Satellite Connector Agent container. These commands allow you to view logs, stop, and start the container using its name. ```docker docker logs $NAME ``` ```docker docker stop $NAME ``` ```docker docker start $NAME ``` -------------------------------- ### JDBC URL Example for Microsoft SQL Server Named Instance Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=snawsca-configuring-microsoft-sql-server-oracle-db2-informix-postgresql-content-store-in-cognos-configuration This example demonstrates the format of a JDBC URL for connecting to a named instance of Microsoft SQL Server. It includes the server, instance name, user, password, and database name, along with additional required properties. ```text jdbc:JSQLConnect://localhost\instance1/user=sa/more properties as required ``` -------------------------------- ### Configure Satellite Connector Agent Tags Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=docker-command-reference-creating-running-agent Example of how to set the SATELLITE_CONNECTOR_TAGS environment variable when running the Docker container. Tags are optional but recommended for identifying the agent for troubleshooting purposes. Tags should be space-separated strings enclosed in quotes. ```docker -e SATELLITE_CONNECTOR_TAGS='myhostname linux' ``` -------------------------------- ### Set Expression Example: Get Child Members Source: https://www.ibm.com/docs/en/cognos-analytics/12.1.x/index_topic=calculations-adding-row-column-calculated-values Demonstrates a set expression to retrieve child members of a specified member, like a previous year's member. This requires a hierarchy as a base and must only include members from that hierarchy. ```cognos children ([previousyear]) ```