Instance creation error com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011,

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011,

 when you creating the instance with workspace  the db2 database is will throw error ,
check the log of instance 

 com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011,
here the error describe 
the database log full ,so please update the logprimary and secondlog
path C:\IBM\WebSphere\CommerceServer70\bin\updateDB2Configuration
updateDB2Configuration:
here update the logsiz ,logprimary and second 

 now the instance will run with out error :

Comments

Post a Comment

Popular posts from this blog

Docker build

 The `docker build` command is used to build Docker images from a `Dockerfile`. This command automates the process of creating a Docker image by executing the instructions defined in the Dockerfile. Let’s break down the internal workings of `docker build` step by step: --- ### 1. **What is `docker build`?** The `docker build` command creates a Docker image from a **Dockerfile**, which is a text file that contains a series of instructions on how to assemble the image. The process takes the base image, applies modifications step-by-step (such as adding files, installing packages, or setting environment variables), and creates a final image that can be used to run containers. ### 2. **Command Syntax** ```bash docker build [OPTIONS] PATH | URL | - ``` - **PATH**: This is the path to the directory containing the `Dockerfile`. It can also be a URL or `-` (for reading from stdin). - **OPTIONS**: There are several options available, like `-t` for tagging, `--file` for specifying a differen...
Read more

Create Oracle users with correct permissions in wcs commerce

      Create Oracle users with correct permissions ·        Login to Oracle SQL developer as a master user ·        Run the following scripts to create a database user and DBA user. Make sure you change username according to the environment. If createInstance fails and you need to drop and recreate users, you don’t need to run the “create tablespace” command again.   # Install/Configure Oracle database # Configure the oracle database # Change the user and passwords according to the environment create tablespace WCTBLSPC datafile size 100M autoextend on next 2M maxsize unlimited; CREATE USER jbdev2user IDENTIFIED BY jbdev2user DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; CREATE USER jbdev2dba IDENTIFIED BY jbdev2dba DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; grant create procedure, create sequence, create session, create synonym, create table,cre...
Read more

Create wcs instance

      Create WCS instance ·        Log in to WCS server as wcsadmin. ·        Open the following file /opt/IBM/WebSphere/CommmerceServer80/schema/oracle/wcs.data.sql ·        Replace INSERT INTO dmelementnvp (dmelement_id, name, value) select i,n,v from (SELECT dmelement_id, 'socialActivityType', '*' FROM dmelement WHERE dmeletemplate_id IN (160, 215) UNION ALL SELECT dmelement_id, 'comparison', 'any' FROM dmelement WHERE dmeletemplate_id IN (160, 215)) s (i,n,v) where not exists (select 1 from dmelementnvp where dmelement_id = i and name = n and value = v);   With: INSERT INTO dmelementnvp (dmelement_id, name, value) select i,n,v from (SELECT dmelement_id i, 'socialActivityType' n, '*' v FROM dmelement WHERE dmeletemplate_id IN (160, 215)                    UNION...
Read more