Здравствуйте! Недавно были вопросы,теперь теперь прошу помочь уже по другой теме (сорри,я все-таки новичок))) !
я пытаюсь для WebSphere portal v.5.1.0.1 заменить его родную БД Cloudscape на db2/делаю через WPSconfig,но не могу выполнить задачу до конца.
ошибка возникает при выполнении следующей команды: ./WPSconfig.sh create-local-database-db2
такая вот:
action-create-database:

action-switch-database:

create-wps-db:

action-create-wps-db-mp:
[logmsg] 2008.09.14 07:45:47.266 action-create-wps-db-mp
[logmsg] EJPCA3103I: Creating database "wpsdb"

[exec] -bash: db2start: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2: command not found
[exec] -bash: db2set: command not found
[exec] -bash: db2set: command not found
[exec] -bash: db2set: command not found
[exec] -bash: db2: command not found

BUILD FAILED
file:../config/actions/db_cfg.xml:123: exec returned: 127

Total time: 50 seconds


Я пробовал ставить в файл transfer_db2.properties сследующих юзеров:wpsadmin(это админ портала, db2inst1(это пользователь экземпляра моего db2).
Подскажите почему возникает ошибка,если это связано с пользователем,то какого надо еще создать или кому какие св-ва добавить.........или как сделать чтоб wpsadmin видел db2шные команды,добавить его в группу?......

Вообще не могу найти файлы ".profile" и "bash_rc"........

кстати может я вообще неправильно делаю:ID и пароли должны совпадать у db2 в websphere portal?
Мне сказали нет,а в документации я не могу понять как должно быть(

Хотя нет нашел файлы /etc/bashrc и такой же есть /etc/profile/ то это или не то я не знаю,но там нет ничего,что связано с db2profile
И,кстати, если на вопрос перед этим вопрос утвердиительный,то это вообще не актуально

Я создал руками базы данных.
Теперь пытаюсь осуществить команду ./WPSconfig.sh validate-database-connection-wps

[root@lis config]# ./WPSconfig.sh validate-database-connection-WPS
Licensed Materials - Property of IBM
5724-E76, 5724-E77, 5655-M44
(C) Copyright IBM Corp. 2001, 2005 All Rights Reserved.

Running WebSphere Portal 5.1.0.1 configuration
Executing native2ascii with native encoding 'UTF-8': wpconfig.properties -> wpconfig_ascii.properties
Native2ascii execution was successful!
Setting cfg.file.name.original to wpconfig.properties
Setting cfg.file.name to wpconfig_ascii.properties
Adding ENTITY for pzndemo_cfg
Adding ENTITY for lmdb_cfg
Adding ENTITY for lm_cfg
Adding ENTITY for d128459
Adding ENTITY for wps_arcfixup
Adding ENTITY for d121855
Adding ENTITY for pzn_validation
Adding ENTITY for fbk_cfg
Adding ENTITY for fbkdb_cfg
Adding ENTITY for bpe_membermanager_cfg
Adding ENTITY for pzn_cfg
Adding entity include for pzndemo_cfg
Adding entity include for lmdb_cfg
Adding entity include for lm_cfg
Adding entity include for d128459
Adding entity include for wps_arcfixup
Adding entity include for d121855
Adding entity include for pzn_validation
Adding entity include for fbk_cfg
Adding entity include for fbkdb_cfg
Adding entity include for bpe_membermanager_cfg
Adding entity include for pzn_cfg
Setting build file name to wpconfig_dynamic.xml
Buildfile: wpconfig_dynamic.xml
Trying to override old definition of task exec

action-set-managed-node-flag:
[echo] Is this a Managed Node ? false

action-set-conntype-property:

action-init-zos:
[echo] Setting property isZos to ${isZos}
[echo] Setting property jvmArgForZos to -Dzos.argsconversion=none
[echo] Setting property isZosDb to ${isZosDb}

action-validate-zos-db:

set-properties:
[setproperty] Property PortalAdminId was set to uid=wpsadmin,o=default organization
[setproperty] Property PortalAdminGroupId was set to cn=wpsadmins,o=default organization
[setproperty] Property WpsDocReviewer was set to cn=wpsDocReviewer,o=default organization
[setproperty] Property WpsContentAdministrators was set to cn=wpsContentAdministrators,o=default organization
[setproperty] Property NewDbLibrary was set to "/opt/IBM/db2/V8.1/java/db2java.zip":
[setproperty] Property UserSuffix was set to cn=users,dc=yourco,dc=com
[setproperty] Property GroupSuffix was set to cn=groups,dc=yourco,dc=com
[setproperty] Property WasUseridShort was set to ReplaceWithYourWASUserId
[generate-portalid] Generated portal ID: 0050569809380136BDB8
[generate-portalid] Generated machineid: 190BC36E3329

action-pre-config:

BUILD FAILED
Target `validate-database-connection-WPS' does not exist in this project.

Total time: 10 seconds
Можут теперь кто0нибудь объснит мне,как сделать чтоб было Build successful?????????????

Вернее так:
[root@lis config]# ./WPSconfig.sh validate-database-connection-wps
Licensed Materials - Property of IBM
5724-E76, 5724-E77, 5655-M44
(C) Copyright IBM Corp. 2001, 2005 All Rights Reserved.

Running WebSphere Portal 5.1.0.1 configuration
Executing native2ascii with native encoding 'UTF-8': wpconfig.properties -> wpconfig_ascii.properties
Native2ascii execution was successful!
Setting cfg.file.name.original to wpconfig.properties
Setting cfg.file.name to wpconfig_ascii.properties
Adding ENTITY for pzndemo_cfg
Adding ENTITY for lmdb_cfg
Adding ENTITY for lm_cfg
Adding ENTITY for d128459
Adding ENTITY for wps_arcfixup
Adding ENTITY for d121855
Adding ENTITY for pzn_validation
Adding ENTITY for fbk_cfg
Adding ENTITY for fbkdb_cfg
Adding ENTITY for bpe_membermanager_cfg
Adding ENTITY for pzn_cfg
Adding entity include for pzndemo_cfg
Adding entity include for lmdb_cfg
Adding entity include for lm_cfg
Adding entity include for d128459
Adding entity include for wps_arcfixup
Adding entity include for d121855
Adding entity include for pzn_validation
Adding entity include for fbk_cfg
Adding entity include for fbkdb_cfg
Adding entity include for bpe_membermanager_cfg
Adding entity include for pzn_cfg
Setting build file name to wpconfig_dynamic.xml
Buildfile: wpconfig_dynamic.xml
Trying to override old definition of task exec

action-set-managed-node-flag:
[echo] Is this a Managed Node ? false

action-set-conntype-property:

action-init-zos:
[echo] Setting property isZos to ${isZos}
[echo] Setting property jvmArgForZos to -Dzos.argsconversion=none
[echo] Setting property isZosDb to ${isZosDb}

action-validate-zos-db:

set-properties:
[setproperty] Property PortalAdminId was set to uid=wpsadmin,o=default organization
[setproperty] Property PortalAdminGroupId was set to cn=wpsadmins,o=default organization
[setproperty] Property WpsDocReviewer was set to cn=wpsDocReviewer,o=default organization
[setproperty] Property WpsContentAdministrators was set to cn=wpsContentAdministrators,o=default organization
[setproperty] Property NewDbLibrary was set to "/opt/IBM/db2/V8.1/java/db2java.zip":
[setproperty] Property UserSuffix was set to cn=users,dc=yourco,dc=com
[setproperty] Property GroupSuffix was set to cn=groups,dc=yourco,dc=com
[setproperty] Property WasUseridShort was set to ReplaceWithYourWASUserId
[generate-portalid] Generated portal ID: 0050569809380136BDB9
[generate-portalid] Generated machineid: BDF68A3465BD

action-pre-config:

validate-database-connection-wps:

iseries-switch-ccsid-specific:

iseries-switch-ccsid-default:

iseries-switch-ccsid:
[echo] DbDriver == COM.ibm.db2.jdbc.app.DB2Driver
[echo] DbUrl == jdbc:db2:WPSDB
[echo] DbUser == dasusr1
[echo] DbLibrary == /opt/IBM/db2/V8.1/java/db2java.zip
[echo] WpsInstallLocation == /opt/WebSphere/PortalServer
[java] Could not connect to database
[java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:192)
[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:423)
[java] at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:545)
[java] at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:428)
[java] at COM.ibm.db2.jdbc.app.DB2Driver.connect(Unknown Source)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:539)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:189)
[java] at com.ibm.wps.config.SqlProcessor.process(SqlProcessor.java:108)
[java] at com.ibm.wps.config.SqlProcessor.main(SqlProcessor.java:631)
[java] (ErrCode=-30082, SqlState=08001)

BUILD FAILED
file:../config/actions/validation.xml:102: Java returned: 2

Total time: 19 seconds

Короче все та же тема,но из следующего сообщения ошибки,вроде ясно в чем проблема,хотелось бы чтобы кто-то мне помог и сказал что требуется написать,т.е. как закатологизировать Node и БД.!!!
create-wps-db:

action-create-wps-db-mp:
[logmsg] 2008.09.24 13:06:27.213 action-create-wps-db-mp
[logmsg] EJPCA3103I: Creating database "wpsdb"

[exec] 09/24/2008 13:06:28 0 0 SQL1026N The database manager is already active.
[exec] SQL1026N The database manager is already active.
[exec] UNCATALOG DATABASE wpsdb
[exec] SQL1031N The database directory cannot be found on the indicated file system.
[exec] SQLSTATE=58031

[exec] UNCATALOG NODE lis.informika
[exec] SQL0104N An unexpected token "lis.informika" was found following "NODE".
[exec] Expected tokens may include: "<node-name>". SQLSTATE=42601

[exec] DROP DATABASE wps5TCP
[exec] SQL1031N The database directory cannot be found on the indicated file system.
[exec] SQLSTATE=58031

[exec] CATALOG TCPIP NODE lis.informika remote lis.informika server db2c_db2inst4
[exec] SQL0104N An unexpected token "lis.informika" was found following "NODE".
[exec] Expected tokens may include: "<node-name>". SQLSTATE=42601

[exec] CREATE DATABASE wps5TCP USING CODESET UTF-8 TERRITORY us
[exec] DB20000I The CREATE DATABASE command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING APPLHEAPSZ 16384
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING STMTHEAP 60000
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING APP_CTL_HEAP_SZ 8192
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING LOCKLIST 400
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING INDEXREC RESTART
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING LOGFILSIZ 1000
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING LOGPRIMARY 12
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] UPDATE DATABASE CONFIGURATION FOR wps5TCP USING LOGSECOND 10
[exec] DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.

[exec] CATALOG DATABASE wps5TCP AS wpsdb AT NODE lis.informika
[exec] SQL0104N An unexpected token "lis.informika" was found following "NODE".
[exec] Expected tokens may include: "<node-name>". SQLSTATE=42601


BUILD FAILED
file:../config/actions/db_cfg.xml:123: exec returned: 4

Total time: 1 minute 32 seconds

этап создания БД я прошел,теперь пытаюсь законнектиться не коннектится!



[root@lis config]# ./WPSconfig.sh validate-database-connection-wps
Licensed Materials - Property of IBM
5724-E76, 5724-E77, 5655-M44
(C) Copyright IBM Corp. 2001, 2005 All Rights Reserved.

Running WebSphere Portal 5.1.0.1 configuration
Executing native2ascii with native encoding 'UTF-8': wpconfig.properties -> wpconfig_ascii.properties
Native2ascii execution was successful!
Setting cfg.file.name.original to wpconfig.properties
Setting cfg.file.name to wpconfig_ascii.properties
Adding ENTITY for pzndemo_cfg
Adding ENTITY for lmdb_cfg
Adding ENTITY for lm_cfg
Adding ENTITY for d128459
Adding ENTITY for wps_arcfixup
Adding ENTITY for d121855
Adding ENTITY for pzn_validation
Adding ENTITY for fbk_cfg
Adding ENTITY for fbkdb_cfg
Adding ENTITY for bpe_membermanager_cfg
Adding ENTITY for pzn_cfg
Adding entity include for pzndemo_cfg
Adding entity include for lmdb_cfg
Adding entity include for lm_cfg
Adding entity include for d128459
Adding entity include for wps_arcfixup
Adding entity include for d121855
Adding entity include for pzn_validation
Adding entity include for fbk_cfg
Adding entity include for fbkdb_cfg
Adding entity include for bpe_membermanager_cfg
Adding entity include for pzn_cfg
Setting build file name to wpconfig_dynamic.xml
Buildfile: wpconfig_dynamic.xml
Trying to override old definition of task exec

action-set-managed-node-flag:
[echo] Is this a Managed Node ? false

action-set-conntype-property:

action-init-zos:
[echo] Setting property isZos to ${isZos}
[echo] Setting property jvmArgForZos to -Dzos.argsconversion=none
[echo] Setting property isZosDb to ${isZosDb}

action-validate-zos-db:

set-properties:
[setproperty] Property PortalAdminId was set to uid=wpsadmin,o=default organization
[setproperty] Property PortalAdminGroupId was set to cn=wpsadmins,o=default organization
[setproperty] Property WpsDocReviewer was set to cn=wpsDocReviewer,o=default organization
[setproperty] Property WpsContentAdministrators was set to cn=wpsContentAdministrators,o=default organization
[setproperty] Property NewDbLibrary was set to "/opt/IBM/db2/V8.1/java/db2java.zip":
[setproperty] Property UserSuffix was set to cn=users,dc=yourco,dc=com
[setproperty] Property GroupSuffix was set to cn=groups,dc=yourco,dc=com
[setproperty] Property WasUseridShort was set to ReplaceWithYourWASUserId
[generate-portalid] Generated portal ID: 0050569809380136E0F3
[generate-portalid] Generated machineid: B0B0F4A8F425

action-pre-config:

validate-database-connection-wps:

iseries-switch-ccsid-specific:

iseries-switch-ccsid-default:

iseries-switch-ccsid:
[echo] DbDriver == COM.ibm.db2.jdbc.app.DB2Driver
[echo] DbUrl == jdbc:db2:wpsdb
[echo] DbUser == db2inst4
[echo] DbLibrary == /opt/IBM/db2/V8.1/java/db2java.zip
[echo] WpsInstallLocation == /opt/WebSphere/PortalServer
[java] Could not connect to database
[java] java.sql.SQLException: No suitable driver
[java] at java.sql.DriverManager.getConnection(DriverManager.java:559)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:189)
[java] at com.ibm.wps.config.SqlProcessor.process(SqlProcessor.java:108)
[java] at com.ibm.wps.config.SqlProcessor.main(SqlProcessor.java:631)
[java] (ErrCode=0, SqlState=08001)

BUILD FAILED
file:../config/actions/validation.xml:102: Java returned: 2

Total time: 10 seconds

Народ,в других темах уже было,no suitable driver,там предлагали использовать get connection для настройки драйверов,я попрбовал,не получилось,напишите плиз ,где и каком виде её применять?