Search results for query: *

Hello All I have five servers in my DB2 PureScale clusters as shown in the attached picture. Facility Servers F1, F2, and Node Servers N1, N2, N3. Supposing I want to increase the storage according to my research as follows: 1. List existing filesystems $ db2cluster -cfs -list -filesystem 2...

Hello All Can you help me with concatenation of BIG INT <select distinct CASE when pl.firstname IS NULL then '' else pl.firstname END as 'First Name', CASE when pl.lastname IS NULL then '' else pl.lastname END as 'Last Name', CASE when pl.playerId IS NULL then '' else pl.playerId END as...

Hello Can anyone point out what is wrong with my powershell not executed from Task Scheduler. Though manual execution works. Here is the content of the script: However, in Task Scheduler it does not work even though the history says successful below is the General Tab in Scheduler below is...

Hello All, I am trying to set up backups of multiple databases a multi-server environment while using Central Management Server and Server Groups. After I made IT-D-ADMIN2\SRVCEMNGR as my Master, in a Multi-server Administration from the SQL Server Agent, I was successful in adding and...

Hello I am new to a new organization - Las Vegas Casino as a SQL Server DBA to the organization. The databases are small as the organization is relatively small compared to others around here. Based on the fact that there is a lot of OLTP online transaction processing occurring everyday. Sorry...

Hello All, I was wondering if you can give me a lead or idea on how can perform the process described below: 1) Source (SQL Server databases ) 3) Target ( Azure Data Lake.) 4) The operation is to capture the DDL & DML changes from Source(1) databases and copy the changes to Target(2). Thanks...

Hello iN oRACLE 11G database , I am trying to start a workload load client after calibration: wrc sys/xxxxxxx$@enduserb mode=calibrate replaydir=/orahome/app/oracle/home/db_replay_capture Workload Replay Client: Release 11.2.0.4.0 - Production on Fri Apr 20 12:34:40 2018 Copyright (c) 1982...

Thanks fellas, I am familiar with sql loader and datapump as well. I thought there is a one line awk command that i can use to load this data.

Hello All, In a Korn Shell, I am trying to populate database table with the the contents of flat file. Here is the sample of my flat file and its contents: sample_file.txt - source: "\"GRP\".\"GEC_CLAIM_EVENT_SRI_PROCESS\"" target: "\"GRP\".\"GEC_CLAIM_EVENT_SRI_PROCESS\"" rsid...

Thanks, SamBones. Much appreciated.

Hello All, How can I hide the password on line 9 in the script below with using login as sysdba? #!/bin/ksh dbname=mydbname export ORACLE_SID=$dbname export ORACLE_HOME=/orahome/app/oracle/product/10.2.05/ . /usr/sislocal/$dbname/to$dbname #log into database sqlplus -s splex/password <<...

Yes, I want all the options to occur. That is: If file does not have list of tables(empty), send message om the body of email, "Though there was compare, but there is no mismatch". If contains ORA-error die and send error, die and send message in the body of email, "Though there was compare...

Hello All, The following routine is to Check the input file: if empty die and send error. OR if contains ORA-error die and send error. OR if empty die and send "no mismatch in tables" message. Please Help suggest how to achieve the last option lstoftables=`cat rowcount_sfgm_gtxs.txt`...

Hello, I am now using: if [ `ls -l rowcount_sfgp_ctxp.txt | awk '{print $5}'` -eq 0 ] or [`ls -l rowcount_sfgp_ctxp.txt | grep {'ORA-'} -ne 0`] but us giving error: grep: can't open -ne grep: can't open 0 Any advice..

Hello All, Additional help is required. Though my if conditional cluse is catching empty tables, it does not catch error files. Therefore my if routine is behaving as if there are table names in the output file. Question - how can I catch situation where the file is empty or contain error logs...

Thanks, I have ssolved this by using : if [ `ls -l rowcount.txt | awk '{print $5}'` -eq 0 ]

Hello Once Again, I am putting finishing touches to my script. Basically, it is functioning now, however, I wanted to additionally an if statement saying if there is no tables to be processed, the script should die, and exit with email saying there is no table to be repaired. The if statement...

Thanks for the suggestion.... Though my code has now move past that after implementing your suggestion. However, new error shows that it just hang once it goes into Shareplex Control panel: #log into Shareplex Console #`cd $SP_SYS_PRODDIR/bin` `/orahome/app/SharePlex/10g/prod/bin/./sp_ctrl` <<...

Hello All, Can you help review this with a fresh set of eyes. Not sure where the error is, but the output error is: E_PIN ESS_USER ESS_USER_SER_ROLE ./spx_repair_sfgi_2.sh[37]: syntax error at line 55 : `<<' unmatched Below is the code in full: #!/bin/ksh dbname=sfgi export...

Thanks to every one that help with this. I have decided on using a different route meet the requirement above.