Db2 Tools for zOS

 View Only
  • 1.  Problem with CLI DB2 Plugin on z/OS USS

    Posted Fri May 26, 2023 09:11 AM

    Problem with CLI DB2 Plugin on z/OS USS, all other CLI plugins install seamlessly.

    zowe plugins install @zowe/db2-for-zowe-cli@zowe-v2-lts
    << NOTE: Lines truncated at line 132 >>

    npm ERR! code 1
    npm ERR! path /shared/home/xxxxx/.zowe/plugins/installed/lib/node_modules/@zowe/db2-for-zowe-cli/node_modules/ibm_db
    npm ERR! command failed
    npm ERR! command sh -c node installer/driverInstall.js
    npm ERR! platform = os390, arch = s390x, node.js version = v18.14.2
    npm ERR! Unable to find 'make' in PATH. Installation may fail!
    npm ERR!
    npm ERR! Error: Command failed: node-gyp configure build --IS_DOWNLOADED=false --IBM_DB_HOME="£IBM_DB_HOME"
    npm ERR! gyp info it worked if it ends with ok
    npm ERR! gyp info using node-gyp@9.3.1
    npm ERR! gyp info using node@18.14.2 | os390 | s390x
    npm ERR! gyp ERR! find Python
    npm ERR! gyp ERR! find Python Python is not set from command line or npm configuration
    npm ERR! gyp ERR! find Python Python is not set from environment variable PYTHON
    npm ERR! gyp ERR! find Python checking if "python3" can be used
    npm ERR! gyp ERR! find Python - "python3" is not in PATH or produced an error
    npm ERR! gyp ERR! find Python checking if "python" can be used
    npm ERR! gyp ERR! find Python - "python" is not in PATH or produced an error
    npm ERR! gyp ERR! find Python
    npm ERR! gyp ERR! find Python **********************************************************
    npm ERR! gyp ERR! find Python You need to install the latest version of Python.
    npm ERR! gyp ERR! find Python Node-gyp should be able to find and use Python. If not,
    npm ERR! gyp ERR! find Python you can try one of the following options:
    npm ERR! gyp ERR! find Python - Use the switch --python="/path/to/pythonexecutable"
    npm ERR! gyp ERR! find Python (accepted by both node-gyp and npm)
    npm ERR! gyp ERR! find Python - Set the environment variable PYTHON
    npm ERR! gyp ERR! find Python - Set the npm configuration variable python:
    npm ERR! gyp ERR! find Python npm config set python "/path/to/pythonexecutable"
    npm ERR! gyp ERR! find Python For more information consult the documentation at:
    npm ERR! gyp ERR! find Python https://github.com/nodejs/node-gyp#installation
    npm ERR! gyp ERR! find Python **********************************************************
    npm ERR! gyp ERR! find Python
    npm ERR! gyp ERR! configure error
    npm ERR! gyp ERR! stack Error: Could not find any Python installation to use
    npm ERR! gyp ERR! stack at PythonFinder.fail (/yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/npm/n
    npm ERR! gyp ERR! stack at PythonFinder.runChecks (/yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/
    npm ERR! gyp ERR! stack at PythonFinder. (/yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/lib/node_module
    npm ERR! gyp ERR! stack at PythonFinder.execFileCallback (/yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/lib/node_m
    npm ERR! gyp ERR! stack at exithandler (node:child_process:427:5)
    npm ERR! gyp ERR! stack at ChildProcess.errorhandler (node:child_process:439:5)
    npm ERR! gyp ERR! stack at ChildProcess.emit (node:events:513:28)
    npm ERR! gyp ERR! stack at ChildProcess._handle.onexit (node:internal/child_process:289:12)
    npm ERR! gyp ERR! stack at onErrorNT (node:internal/child_process:519:16)
    npm ERR! gyp ERR! stack at process.processTicksAndRejections (node:internal/process/task_queues:82:21)
    npm ERR! gyp ERR! System OS/390 28.00
    npm ERR! gyp ERR! command "/yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/bin/node" "/yyyy01/usr/lpp/zowe/node-v18.14.2
    npm ERR! gyp ERR! cwd /shared/home/xxxxx/.zowe/plugins/installed/lib/node_modules/@zowe/db2-for-zowe-cli/node_modules/ibm_db
    npm ERR! gyp ERR! node -v v18.14.2
    npm ERR! gyp ERR! node-gyp -v v9.3.1
    npm ERR! gyp ERR! not ok
    npm ERR!
    npm ERR! at ChildProcess.exithandler (node:child_process:419:12)
    npm ERR! at ChildProcess.emit (node:events:513:28)
    npm ERR! at maybeClose (node:internal/child_process:1134:16)
    npm ERR! at ChildProcess._handle.onexit (node:internal/child_process:302:5) {
    npm ERR! code: 1,
    npm ERR! killed: false,
    npm ERR! signal: null,
    npm ERR! cmd: 'node-gyp configure build --IS_DOWNLOADED=false --IBM_DB_HOME="£IBM_DB_HOME"'
    npm ERR! }
    npm ERR! make: Error -- FSUM8705 No target
    npm ERR! oput 'SWP.STDB2VC.M05.SDSNMACS(DSNAO64C)' '/shared/home/xxxxx/.zowe/plugins/installed/lib/node_modules/@zowe/db2-for-zowe-c
    npm ERR! A complete log of this run can be found in:
    npm ERR! /home/xxxxx/.npm/_logs/2023-05-24T13_21_10_172Z-debug-0.log
    Command Error:
    Install Failed
    Error Details:
    Command failed: /usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/bin/npm install @zowe/db2-for-zowe-cli@zowe-v2-lts --prefix /ho

    Do I have to install Python?

    zowe config report-env

    Zowe CLI version = 7.16.2
    Node.js version = 18.14.2
    Node Version Manager version = nvm failed to display any output.
    Reason = nvm: FSUM7351 not found
    O.S. platform = os390
    O.S. architecture = s390x

    O.S. PATH = /bin:/usr/lpp/zowe/bin:/usr/lpp/java/J8.0_64/bin:/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/bin

    ZOWE_CLI_HOME = undefined
    Default = /home/xxxxx/.zowe
    ZOWE_APP_LOG_LEVEL = undefined
    ZOWE_IMPERATIVE_LOG_LEVEL = undefined
    No other 'ZOWE_' variables have been set.

    NPM information:

    NPM version = 9.5.0                                                                                               
    Shell = sh                                                                                                        
    Global prefix = /yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340                             
        The directory above contains the Zowe Node.js command script.                                       
    Global root node modules = /yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/lib/node_modules 
    Global config = /yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/etc/npmrc                   
    Local prefix = /shared/home/xxxxx                                                                       
    Local root node modules = /shared/home/xxxxx/node_modules                                               
    User config = /home/xxxxx/.npmrc                                                                        
                                                                                                            
    "project" config from /shared/home/xxxxx/.npmrc                                                         
    node bin location = /yyyy01/usr/lpp/zowe/node-v18.14.2-os390-s390x-202303231340/bin/node                
    cwd = /shared/home/xxxxx                                                                                
    HOME = /home/xxxxx                                                                                      
    Zowe CLI configuration information:

    Zowe daemon mode = off                                                                                  
    Zowe config type = V1 Profiles                                                                          
    Available profiles:                                                                                     
    Installed plugins:

    @zowe/cics-for-zowe-cli                                                    
        Version = 5.0.1                                                        
        Package = @zowe/cics-for-zowe-cli@zowe-v2-lts                          
                                                                               
    @zowe/ims-for-zowe-cli                                                     
        Version = 3.0.0                                                        
        Package = @zowe/ims-for-zowe-cli@zowe-v2-lts                           
                                                                               
    @zowe/mq-for-zowe-cli                                                      
        Version = 3.0.1                                                        
        Package = @zowe/mq-for-zowe-cli@zowe-v2-lts                            
                                                                               
    @zowe/zos-ftp-for-zowe-cli                                                 
        Version = 2.1.3                                                        
        Package = @zowe/zos-ftp-for-zowe-cli@zowe-v2-lts                       



    ------------------------------
    charles macniven
    ------------------------------


  • 2.  RE: Problem with CLI DB2 Plugin on z/OS USS

    IBM Champion
    Posted Tue June 06, 2023 08:45 AM

    Hi Charles,

    This appears to be a node.js / IBM_DB issue, so one option is to try the node.js ibm_db community https://github.com/ibmdb/node-ibm_db/issues, or alternatively try  the Zowe community -- either through the Zowe github https://github.com/zowe/zowe-cli/issues or slack https://openmainframeproject.slack.com/archives/CC8AALGN6



    ------------------------------
    Jørn Thyssen
    Principal Solutions Advisor
    Rocket Software
    ------------------------------



  • 3.  RE: Problem with CLI DB2 Plugin on z/OS USS

    IBM Champion
    Posted Tue July 04, 2023 09:21 PM

    The error message suggests that the installation of the @zowe/db2-for-zowe-cli plugin failed due to the lack of a Python installation. The node-gyp tool, used during the installation process, requires Python to be available in the environment.

    To resolve this issue, you need to install Python on your system.



    ------------------------------
    Youssef Sbai Idrissi
    Software Engineer
    ------------------------------