Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tekpr00

    Adding storage to DB2 PureScale Cluster

    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...
  2. tekpr00

    Help with concatenation of BIG integers

    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...
  3. tekpr00

    PowerShell Task Scheduler Not Working

    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...
  4. tekpr00

    Backups in a multiserver environment while using Central Management Server and Server Groups

    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...
  5. tekpr00

    Hello I am new to a new organizatio

    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...
  6. tekpr00

    Capture and Replicate Changes from Source to Target.

    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...
  7. tekpr00

    Starting a Client before starting Workload Replay

    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...
  8. tekpr00

    populate database table with the the contents of flat file.

    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.
  9. tekpr00

    populate database table with the the contents of flat file.

    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...
  10. tekpr00

    Hide Password in scrypt withouth using &quot;/ as sysdba&quot;

    Thanks, SamBones. Much appreciated.
  11. tekpr00

    Hide Password in scrypt withouth using &quot;/ as sysdba&quot;

    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 <<...
  12. tekpr00

    Hello All, The following routine

    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...
  13. tekpr00

    Hello All, The following routine

    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`...
  14. tekpr00

    If file Empty, then die giving error

    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..
  15. tekpr00

    If file Empty, then die giving error

    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...
  16. tekpr00

    If file Empty, then die giving error

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

    If file Empty, then die giving error

    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...
  18. tekpr00

    Syntax error at line 55 : `&lt;&lt;' unmatched

    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` <<...
  19. tekpr00

    Syntax error at line 55 : `&lt;&lt;' unmatched

    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...
  20. tekpr00

    Compare &amp; Repair Automatic Shell scripts error out

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

Part and Inventory Search

Back
Top