DB2 Kernels

DB2 Kernel Variables:

With Version 8 and later, DB2 checks values of the kernel.sem, kernel.msgmni,
and kernel.shmmax parameters automatically at DB2 start time and changes
them for you if the current values are not optimal. The db2start command:
Changes SEMMNI kernel parameter to 1024
Changes MSGMNI kernel parameter to 1024
Changes SHMMAX kernel parameter to 268435456 (32-bit) or 1073741824 (64-bit)

Manually updating kernel parameters
If any of the default kernel parameter settings do not meet the requirements of
your particular system, you can update them manually.
To check your current shared memory segment, semaphore array, and message
queue limits, use the ipcs -l command. Your output looks similar to this output:
------ Shared Memory Limits --------
max number of segments = 4096 // SHMMNI
max seg size (kbytes) = 32768 // SHMMAX
max total shared memory (kbytes) = 8388608 // SHMALL
min seg size (bytes) = 1
------ Semaphore Limits --------
max number of arrays = 1024 // SEMMNI
max semaphores per array = 250 // SEMMSL
max semaphores system wide = 256000 // SEMMNS
max ops per semop call = 32 // SEMOPM
semaphore max value = 32767
------ Messages: Limits --------
max queues system wide = 1024 // MSGMNI
max size of message (bytes) = 65536 // MSGMAX
default max size of queue (bytes) = 65536 // MSGMNB

Modifying kernel parameters on SUSE and Red Hat
In this example, we explain how to update kernel parameters and set them after
each reboot:
1. Log in as root.
2. Using a text editor, add the following entries to /etc/sysctl.conf:
# Example shmmax for a 64-bit system
kernel.shmmax=1073741824
# Example shmall for 90 percent of 16 GB memory. The kernel requires this
value as a number of pages
kernel.shmall=3774873
kernel.sem=250 256000 32 1024
kernel.msgmni=1024
kernel.msgmax=65536
kernel.msgmnb=65536
3. Load these entries into sysctl by using the following command:
sysctl -p
Now if you enter the command ipcs -l, you can see that the kernel
parameters have been updated in sysctl. To view all sysctl settings, use the
command:
sysctl -a

AIX user and group administration

Hi All,

The best link for AIX User and Group Administration and some important files:

http://www.ibm.com/developerworks/aix/library/au-aixuseradmin/index.html

Look at the some of the files that affect the user itself:
* /etc/passwd
* /etc/security/.profile
* /etc/security/limits
* /etc/security/passwd
* /etc/security/user
* /usr/lib/security/mkuser.default

bye
Pawan

How to reset CMS Password in BO?

CMS Password:


1. Open the Crystal Configuration Manager (CCM).
2. Stop the SIA.
3. Open the CMS database administrator application (for example: SQL server enterprise manager if you are using MS SQL2000).
4. Run the following SQL statement on the CMS database:
SELECT * FROM CMS_InfoObjects6 WHERE (ObjectID = 12)
5. Delete the record that is returned.
DELETE FROM CMS_InfoObjects6 WHERE (ObjectID = 12)
6. Restart the SIA server from the CCM. This will recreate the administrator account with a blank password.
7. Log on to the Central Management Console (CMC) using Administrator as a user name and a blank password.

Standard Language Codes

Langs:

LCID Language

1025 Arabic
1028 Chinse - Traditional
1029 Czech
1030 Danish
1031 German
1032 Greek
1033 English
1034 Spanish
1035 Finnish
1036 French
1037 Hebrew
1038 Hungarian
1040 Italian
1041 Japanese
1042 Korean
1043 Dutch
1044 Norwegian
1045 Polish
1046 Portuguese - Brazilian
1049 Russian
1053 Swedish
1054 Thai
1055 Turkish
2052 Chinese - Simplified
2070 Portuguese

MYSQL DB Commands

MYSQL:

User Creation:

GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'localhost' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'%' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';

OR

mysql --user=root mysql
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;


* CREATE DATABASE boe;
* show databases;
* use databases;
* show tables;
* mysqladmin -h -P -u -p version variables extended-status ( To check for Mysql Configuration)
[mysqld]

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock- replace this value with the full path of your mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

MYSQL DB Commands

MYSQL:

User Creation:

GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'localhost' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'%' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';

OR

mysql --user=root mysql
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;


* CREATE DATABASE boe;
* show databases;
* use databases;
* show tables;
* mysqladmin -h -P -u -p version variables extended-status ( To check for Mysql Configuration)
[mysqld]

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock- replace this value with the full path of your mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

How to create Uninstallation Log?

Uninstall:

HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Installer
Reg_SZ: Logging
Value: voicewarmupx

The letters in the value field can be in any order. Each letter turns on a different logging mode. Each letter's actual function is as follows for MSI version 1.1:

v - Verbose output
o - Out-of-disk-space messages
i - Status messages
c - Initial UI parameters
e - All error messages
w - Non-fatal warnings
a - Start up of actions
r - Action-specific records
m - Out-of-memory or fatal exit information
u - User requests
p - Terminal properties
+ - Append to existing file
! - Flush each line to the log
x - Extra debugging information. The "x" flag is available only on Windows Server 2003 and later operating systems, and on the MSI redistributable version 3.0, and on later versions of the MSI redistributable.