|
|
-
|
|
Platform information
Informational tokens are DB2 v9.5.0.1, s080328, MI00225, Fix Pack 1.
Operating System Information:
OSName: Linux
NodeName: server1.mydomain.net
Version: 2
Release: 6
Machine: x86_64
Received the following message when I tried to initialise HADR and trigger t......
|
|
-
|
|
Database mirroring transfers transaction log records from one server to another server
and can quickly failover over to a standby server. There are some very useful features but is not always the best solution.
Beyond the technical aspects, consider also: management overheads, storage, network
B......
|
|
-
|
|
Follow the steps below to generate a key pair with ssh-keygen on Red Hat Linux
Replace: myserver1 and myserver2 with your server names
#SSH on both members of the cluster – Prepare SSH
/usr/bin/ssh-keygen -f /root/.ssh/id_dsa -q -t dsa -N ""
/usr/bin/ssh-keygen -f /root/.ssh/id_rsa -q -t......
|
|
-
|
|
I need to move ddl and data from one database to another. On the same server and instance.
The basic idea was going to be:
a) using db2move export all ddls and data into a file
b) using db2move import the ddls and data
STEP 1
--this exports all tables and data, the output files are stored in......
|
|
-
|
|
I was doing a security audit on SQL server 2005 server, where I discovered an administrator had assigned the permission "sysadmin" to a logon.
He explained to me the reason, being that when they were on SQL Server 2000 it was involved to allow a logon read\execute rights on SQL Agent Jobs.
We've n......
|
|
-
|
|
SQL Server Security Policy allows a basis for good practise and regular audits. A SQL Server environment is characterised by various developers(internal), administrators (internal) and third party access.All these groups must be considered when creating a policy.
The list becomes the basis of a c......
|
|
-
|
|
SQL0286N A default table space could not be found with a page size of at least "4096" that authorization ID "user1" is authorized to use. SQLSTATE=42727
This was after a DECLARE GLOBAL TEMPORARY TABLE type of statement
I had a look at the users permissions.They were
CREATE SCHEMA user1 ;
grant c......
|
|
-
|
|
I've found that executing similar code to the below was not creating the password.As a consequence I needed to run the passwd process separately.
$useradd -g db2fadm1 -m db2fenc1 -p mypassword -d /db2inst1/db2fenc1
The -p parameter is designed to pass encrytpted passwords.
The following method cr......
|
|