Guru Of Geeks

Question How do I configure and use Datadirect JDBC Driver for Cassandra with JDBC Connector in IBM InfoSphere Information Server Answer Steps to configure the driver: In order to configure the driver and use it with the JDBC Connector, the following entries needs to be added to the isjdbc.config file under $DSHOME. In case, if the file does not exist, then the file needs to be created and the entries should be added to the file. CLASSPATH=/opt/IBM/InformationServer/ASBNode/lib/java/IScassandra.jar CLASS_NAMES=com.ibm.isf.jdbc.cassandra.CassandraDriver Configuring the Connection properties in the JDBC Connector : The following connection properties must be specified while using the Datadirect JDBC Driver for Cassandra. The URL in the JDBC Connector should include the connection URL to connect to Cassandra Server.  jdbc:ibm:cassandra://<CassandraServer>:<port>;SchemaDefinition=<path_to_directory_where_schema_definition_can_be_stored_locally>/SchemaDefinition.config;Key...

​Steps to restore table in Netezza: 1) Find the backup history of database you want to restore by running below query. 1 select DBName, DBNAMEORIG, OPTYPE as Backup_Type, StartTime, BackupSet, Logfile 2 from _v_backup_history 3 where DBName = 'TEST_DB' 4 -- DBNAMEORIG = 'TEST_DB' 5 and starttime > '2013-08-01 05:13:13' Output of above sql will be: DBNAME DBNAMEORIG BACKUP_TYPE STARTTIME BACKUPSET LOGFILE TEST_DB TEST_DB FULL 2013-08-19 07:40:18 20130819114018 backupsvr.1649.2013-08-19.log TEST_DB TEST_DB FULL 2013-08-12 06:39:15 20130812103915 backupsvr.29095.2013-08-12.log TEST_DB TEST_DB FULL 2013-08-05 07:09:39 20130805110939 backupsvr.9521.2013-08-05.log Here we pull information from column DBNAMEORIG also, this wil be helpful if the database need to be restored is deleted. 2) From above we can find the backup set that needs to be restored 3) Now you can find the path where backup was taken by looking into the log file by going to ...

Accessing the EC2 instance even if you loose the pem file is rather easy.  1. First, create a new instance by creating new access file, call it 'helper' instance with same region and VPC as of the lost pem file instance. 2. Now stop the lost pem file instance. Remember not to terminate instance but to stop it. 3. Goto EBS volumes, select the root volume of the lost pem file instance and detach. 4. Now again select the detached volume and this time you have to attach this volume to helper instance which we created before. Since helper instance already has a root volume by default as /dev/sda1, the newly attached volume will be secondary(eg: /dev/sdf). 5. Login to your helper instance with its pem file. 6. Execute below commands: # mount /dev/xvdf1 /mnt # cp /root/.ssh/.authorized_keys /mnt/root/.ssh/ # umount /mnt 7. Detach the secondary volume from helper instance.  8. Again attach the volume back to our recovery ...

Issue: ####<Jan 26, 2012 7:56:19 PM CST> <Critical> <WebLogicServer> <CMCK-VMCMSDR> <AdminServer> <Main Thread> <<WLS Kernel>> <> <> <1327629379936> <BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: Authentication for user denied weblogic.security.SecurityInitializationException: Authentication for user  denied      at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:965)      at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1050)      at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)      at weblogic.security.SecurityService.start(SecurityService.java:141)      at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)      ...

Source: https://github.com/kahun/awesome-sysadmin Awesome Sysadmin A curated list of amazingly awesome open source sysadmin resources. Table of Contents Awesome Sysadmin Backups Build Automation ChatOps Cloning Cloud Computing Cloud Storage Code Review Collaborative Software Configuration Management Database Configuration Management Continuous Integration & Continuous Deployment Control Panels Deployment Automation Distributed Filesystems DNS Editors IT Asset Management LDAP Log Management Mail Servers Messaging Monitoring Metric & Metric Collection Network Configuration Management Newsletter NoSQL Packaging Queuing RDBMS Security Service Discovery Software Containers SSH Statistics Status Pages Ticketing systems Troubleshooting Project Management Version control Virtualization VPN Web Webmails Wikis Resources Blogs Books Newsletters Repositories Websites Backups Backup software. Amanda   - Client-server model backup tool. Attic   - A deduplicating backup program written in Pyt...