Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
 View Only
  • 1.  Db2 Genius Hub: Log Analysis

    Posted Thu March 19, 2026 05:06 AM

    Hello Db2 Genius Hub Support Team,

    After the Database Management Console is deprecated I setup the new Db2 Genius Hub on a Red Hat Linux 9.7 System. On the same system I installed the Db2 Repository database.

    ==========================================
    IBM Db2 Genius Hub - Product Status Check
    ==========================================

    Component Status Summary:
    ---------------------------------------------------------------------------------
    Component Status Details
    ---------------------------------------------------------------------------------
    Liberty Server RUNNING PID: 720888 | Port(s): 11100(HTTP),11101(HTTPS)
    Agentic AI Service RUNNING PID: 721801 | Port(s): 11108
    Anomaly Detection Service RUNNING PID: 1015294 | Port(s): 11109
    DRS Agent Service RUNNING PID: 721300 | Port(s): 11096
    Job Scheduler Service RUNNING PID: 721382 | Port(s): 11107
    Redis Service RUNNING PID: 721648 | Port(s): 6379
    ---------------------------------------------------------------------------------

    Overall Status: [OK] All components are running

    Trying the new Log Analysis following error occured:
    Error
    The RemoteOS service on the system dwqdb:50200 is down. Please enable it using https://ibm.com/docs/en/db2?topic=enable-remoteos-db2

    For the setup I enabled the Remote OS service on the Db2 db2dwq instance on an AIX Server:
    /db2/db2dwq/db2-remote-svc-1.0.0-aix/scripts> ./start.sh --jwt

    ========================================
    db2remotesvc Start Script
    ========================================

    [INFO] 2026-03-13 15:46:52 - Starting db2remotesvc service...
    [INFO] 2026-03-13 15:46:52 - Using binary: /db2/db2dwq/db2-remote-svc-1.0.0-aix/db2remotesvc
    [INFO] 2026-03-13 15:46:52 - Loading environment variables from .env file
    [INFO] 2026-03-13 15:46:52 - Starting service with arguments: --enable-jwt=true
    [INFO] 2026-03-13 15:46:52 - Starting in daemon mode...
    [INFO] 2026-03-13 15:46:54 - Successfully started db2remotesvc (PID: 45154812)
    [INFO] 2026-03-13 15:46:54 - Log file: /db2/db2dwq/db2-remote-svc-1.0.0-aix/logs/db2remotesvc.log
    [INFO] 2026-03-13 15:46:54 - PID file: /db2/db2dwq/db2-remote-svc-1.0.0-aix/db2remotesvc.pid

    ========================================
    [INFO] 2026-03-13 15:46:54 - Service started successfully
    ========================================

    [INFO] 2026-03-13 15:46:54 - To check status: /db2/db2dwq/db2-remote-svc-1.0.0-aix/scripts/status.sh
    [INFO] 2026-03-13 15:46:54 - To stop service: /db2/db2dwq/db2-remote-svc-1.0.0-aix/scripts/stop.sh
    [INFO] 2026-03-13 15:46:54 - To view logs: tail -f /db2/db2dwq/db2-remote-svc-1.0.0-aix/logs/db2remotesvc.log

    /db2/db2dwq/db2-remote-svc-1.0.0-aix/scripts> ./status.sh
    db2remotesvc is RUNNING (PID: 45154812)

    This is the changed .env file:
    /db2/db2dwq/db2-remote-svc-1.0.0-aix> cat .env
    # DB2 Agentic Utility Configuration

    # Server configuration
    SERVER_PORT=8080

    # Metrics configuration
    METRICS_CACHE_TTL=60

    # DB2 configuration
    # DB2 Profile Path Configuration (choose one of the following):
    # Option 1: Set DB2_HOME and profile path will be automatically derived as DB2_HOME/db2profile
    DB2_HOME=/db2/db2dwq/sqllib
    # Option 2: Set DB2_PROFILE_PATH explicitly (overrides DB2_HOME if both are set)
    # DB2_PROFILE_PATH=/home/db2inst1/sqllib/db2profile
    # Option 3: Use pattern with %s for instance name (if neither DB2_HOME nor DB2_PROFILE_PATH is set)
    # Default: /home/%s/sqllib/db2profile

    # DB2 Timeout Configuration (in seconds)
    # Timeout for individual DB2 commands (default: 120 seconds)
    DB2_COMMAND_TIMEOUT=120
    # Timeout for DB2 query operations (default: 120 seconds)
    DB2_QUERY_TIMEOUT=120

    # DB2 Connection Pool Configuration
    # Maximum number of connections in the pool (default: 10)
    DB2_POOL_MAX_SIZE=10
    # Minimum number of connections to maintain (default: 2)
    DB2_POOL_MIN_SIZE=2
    # Maximum time a connection can be idle in minutes (default: 5)
    DB2_POOL_MAX_IDLE_MINUTES=5
    # Maximum lifetime of a connection in minutes (default: 30)
    DB2_POOL_MAX_LIFETIME_MINUTES=30

    # Security configuration
    # API key is always required
    # For production, generate a strong random key (min 16 chars)
    # Example: API_KEY=$(openssl rand -base64 24)
    #API_KEY=change_me_in_production
    # Rate limit (requests per minute)
    RATE_LIMIT=200
    # TLS configuration
    TLS_ENABLED=false
    TLS_CERT=cert.pem
    TLS_KEY=key.pem

    # Application mode
    # Set to "release" for production deployment
    GIN_MODE=debug

    # Development configuration
    # Set to "true" to enable mock mode for development
    MOCK_ENABLED=false

    # Logging configuration
    # Log level: DEBUG, INFO, WARN, ERROR, FATAL (default: INFO)
    LOG_LEVEL=INFO
    # Log file path (default: logs/db2remotesvc.log)
    LOG_FILE_PATH=logs/db2remotesvc.log
    # Maximum log file size in MB before rotation (default: 100)
    LOG_MAX_SIZE_MB=100
    # Maximum number of old log files to keep (default: 5)
    LOG_MAX_BACKUPS=5

    Why the message has the port 50200 - which is the the connection port (db2c_db2dwq 50200/tcp) (TCP/IP Service name (SVCENAME) = db2c_db2dwq) for the database and not the default 8080 port?

    Best regards, Joachim



    ------------------------------
    Joachim Müller
    ------------------------------


  • 2.  RE: Db2 Genius Hub: Log Analysis

    Posted Thu March 19, 2026 08:27 AM
    Hello Joachim,
    I am on vacation until April 1st.   From what I can see from my phone, the 8080 port is for the communication between the remote Db2 Genius Hub component with the Db2 Genius Hub Server, but the remote component still needs to connect to the database to get additional information.
    Question: did you open the 8080 port in your firewall for the communication between the remote component with the server?






  • 3.  RE: Db2 Genius Hub: Log Analysis

    Posted Fri March 20, 2026 06:59 AM

    Hello Cintia,

    Both ports are open:

    (ip-address)8080 port [udp/webcache] succeeded!

    (ip-address) 50200 port [udp/*] succeeded!

    Best regards, Joachim



    ------------------------------
    Joachim Müller
    ------------------------------



  • 4.  RE: Db2 Genius Hub: Log Analysis

    Posted Fri March 20, 2026 07:31 AM
    Joachim,
    Do you have any error messages in the log files:
    Monitored machine:
    Log file: /db2/db2dwq/db2-remote-svc-1.0.0-aix/logs/db2remotesvc.log

    Db2 Genius Hub:
    Under addons directory.

    Output of the status.sh script.

    Just keep in mind, avoid sharing sensitive information here.   My recommendation is to create a case with support team and someone from the team can help you while I am away on vacation.
    Make sure that you attach the collector, the log files from the monitored machine, and the output of the status.sh command to speed up the analysis.







  • 5.  RE: Db2 Genius Hub: Log Analysis

    Posted Fri March 20, 2026 08:36 AM

    Hello Cintia,

    Unfortunately no help from your colleagues (Case TS021657723):

    Dear  Mr. Mueller,

     

    Your case TS021657723 for Db2 Genius Hub is currently with the Entitlement Exception Team.

    Research has been conducted using your IBM Customer Number and your Company Name but a support agreement for Db2 Genius Hub  was not found in place.   Please provide us with a Proof of Support such as:

    •           An IBM Customer Number/ Site number with active support services for the product

    •           A copy of a purchase invoice for support services for the product

    •           A copy of a contract for support services for the product

    If required, we can have our sales team to contact you to assist you with your support needs.

    We look forward to hearing from you.

    Regards,

    Entitlement Exception Handling D.A.CH

    swstatus@de.ibm.com

    But you're right, I can't send sensitive data that way. I'll wait; enjoy your vacation. 

    Best regards, Joachim



    ------------------------------
    Joachim Müller
    ------------------------------



  • 6.  RE: Db2 Genius Hub: Log Analysis

    Posted Fri March 20, 2026 12:41 PM

    Hi Joachim,

    Thanks for reaching out. I have asked the support team to reopen the case TS021657723 and if you could upload the log files and the details for the issue. The team will review and update the case.

    Regards,

    Nidhi



    ------------------------------
    NIDHI GAMBHIR
    NIDHI
    ------------------------------



  • 7.  RE: Db2 Genius Hub: Log Analysis

    Posted Sun March 22, 2026 09:04 PM

    I am asking control center team's help to route this case to console support team to continue the investigation. 



    ------------------------------
    Su Li Hou
    ------------------------------



  • 8.  RE: Db2 Genius Hub: Log Analysis

    Posted Mon March 23, 2026 04:05 AM

    Hello Su Li Hou,

    Thank you.

    Best regards, Joachim



    ------------------------------
    Joachim Müller
    ------------------------------



  • 9.  RE: Db2 Genius Hub: Log Analysis

    Posted Fri March 20, 2026 04:29 PM

    Hello Joachim,

    Could you please let me know the port number provided in the Connections page under 'Enable Remote OS Service' ? 
    After modifying the .env file, did you restart the remote OS Service in AIX?



    ------------------------------
    Thomas James
    ------------------------------



  • 10.  RE: Db2 Genius Hub: Log Analysis

    Posted Mon March 23, 2026 04:12 AM

    Hello Thomas,

    The port number in the connection profile for Remote OS Service is defined as 8080. And yes I restarted the service on AIX in the past after creating the .env file , also just now but without success.
    I'll go into the rest of it in the reopend case.

    Best regards, Joachim



    ------------------------------
    Joachim Müller
    ------------------------------