Life is changing

------------------ THE END --------------------

 From 1. January, 2021 I am not responsible for

Lotus/IBM/HCL software anymore.

HCL Connections - HOMEPAGE database migration with with dbt tool

https://www.ibm.com/support/knowledgecenter/SSYGQH_5.5.0/admin/migrate/t_migrate_db2__side_by_side.html

My personal practical experience:


Case #1
dbt ran 17 hours
Database_Transfer.log.0          18 Mbyte

Case #2
dbt ran 16 hours
Database_Transfer.log.0          16 Mbyte

Case #3
dbt ran 24 hours
Database_Transfer.log.0          21 Mbyte

I recommend you to plan 24 hours for HOMEPAGE migration with dbt tool. You do not need to tail log file. It is very boring. You may see hundreds of thousands rows like these:

[07/04/19 03:55:36.235 CEST] doing the check invalid pk for where clause for column: DOCUMENT
[07/04/19 03:55:36.235 CEST] PKs: [DOCUMENT_ID]



I recommend you to start process, wait 20 minutes and check status. In case of error the process usually stops in 20 minutes with error messages.
In case of errors:

• Check homepage.xml (if you use the same name)
• URLs
• username and password
• dbType
• Be very careful with source and target
• you should increment Xms and Xmx   *if you do not use these parameters process can fail after 8 - 12 hours
• run db2 update cfg for HOMEPAGE

Here you are an example homepage.xml:



driver="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://1.1.1.1:50000/HOMEPAGE"
userId="LCUSER"
schema="HOMEPAGE"
dbType="DB2"/>

driver="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://2.2.2.2:50000/HOMEPAGE"
userId="db2inst1"
schema="HOMEPAGE"
dbType="DB2"/>



Here you are an example to run dbt (migrateHomepage.sh):

run the tool as db2 user, for example: db2inst

export DBT_HOME=/opt/ibm/install/dbt
export JAVA_HOME=/opt/ibm/install/conns6wiz/Wizards/jvm/linux/jre
export PATH=$PATH:/opt/ibm/install/conns6wiz/Wizards/jvm/linux/jre
export DB2_HOME=/opt/ibm/install
sleep 5
echo "db2stop force and sleep 10"
db2stop force
sleep 10
echo
echo "db2start and sleep 10"
db2start
echo "update db cfg for HOMEPAGE using APPLHEAPSZ automatic APPL_MEMORY automatic SELF_TUNING_MEM ON - and sleep 10"
sleep 10
echo
db2 "update db cfg for HOMEPAGE using APPLHEAPSZ automatic APPL_MEMORY automatic SELF_TUNING_MEM ON"
sleep 10
echo "run dbt"
echo
$JAVA_HOME/bin/java -Xms4096m -Xmx4096m -cp $DBT_HOME/dbt.jar:$DB2_HOME/febjava/db2jcc4.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir $DBT_HOME/logs -xmlfile $DBT_HOME/homepage.xml -sourcepassword 123456789 -targetpassword 987654321
echo
sleep 10
echo
echo "db2stop force at the end of the process"
db2stop force
echo
sleep 10
echo
echo "db2start at the end of the process"

db2start

At the end of the log file you should see something like this:

[07/04/19 09:41:54.222 CEST] Population of NR_FOLLOWS (31042 rows) completed successfully
[07/04/19 09:41:54.222 CEST] Processing table -{ SR_GLOBAL_SAND_PROPS->SR_GLOBAL_SAND_PROPS }-
[07/04/19 09:41:54.222 CEST] SELECT * FROM "HOMEPAGE"."SR_GLOBAL_SAND_PROPS"
[07/04/19 09:41:54.445 CEST] INSERT INTO "HOMEPAGE"."SR_GLOBAL_SAND_PROPS" ("GSP_ID","GSP_NAME","GSP_VALUE","GSP_TYPE") VALUES( ?, ?, ?, ? )
[07/04/19 09:41:54.446 CEST] Transferring table --{ HOMEPAGE.SR_GLOBAL_SAND_PROPS}-- to table --{HOMEPAGE.SR_GLOBAL_SAND_PROPS }--
[07/04/19 09:41:54.525 CEST] Population of SR_GLOBAL_SAND_PROPS (0 rows) completed successfully
[07/04/19 09:41:54.525 CEST] Transfer finished

During the process you have Database_Transfer.log.0.lock or similar with lock at the end. If it exists the process is still running.

IBM (vagy újból Lotus) Domino/Notes feltámadás ???

Feltámadás ???

Mostanában sokat cikkeznek arról, hogy hamarosan lesz IBM Domino/Notes 10. Jó, de mi lesz benne? Arról sem ártana már cikkezni, hiszen mindjárt 2018 van.

https://www.ibm.com/blogs/social-business/2017/10/25/ibm-announces-investment-notes-domino-version-10-beyond/

IBM Verse licencek és kapcsolódó szolgáltatások

#IBM, #NewWayOfCollaboration, #Verse

Sokakban felmerülhet a kérdés, hogy melyik Verse licenc milyen szolgáltatásokat nyújt. Íme egy összefoglaló táblázat, amelyben például egyértelműen meghatározzák, hogy az iPhone-ra letölthető IBM Verse kliens melyik licenccel engedélyezett. A táblázatot INNEN másoltam ki.

	IBM Verse Basic	IBM Verse
Client UI	Verse browser UI only	Support for all client environments, including mobile.
Mailbox & Message Size	500 MB mailbox 100 MB maximum message size	50 GB 100 MB maximum message size
Mail Domain	ibmverse.com	IBM-assigned or customer defined. Optional hybrid support
Mail Throughput	Send up to 100 emails per day to a maximum of 10 recipients per email	Unlimited
Calendar	Personal calendar	Standard
Profiles & My Network	Profile visible to everyone inside IBM Verse Basic. Ability to build custom network Contacts list.	See the user profiles with report-to-chain and Social Contacts. Ability to collaborate in a private environment within your organization.
Guests	Invite others to join the Verse Basic environment to collaborate	Invite guess to collaborate in a private environment
Social File Sharing	Share files in the cloud with individuals or your network	With guests in the cloud or anyone in your Organization or data center
File Storage	500 MB	30 GB
Status Updates	Visible to your network only	Visible to your organization
Team Analytics	Not applicable in a flat org environment	Standard
Basic Chat	Web chat	Basic chat from any client type
Admin Features	No	Full
Authentication	Basic Password only	Choice - including enterprise SSO / SAML
Support	Monitored online forum	Standard
Data Center Location	IBM defined	Customer selects