[IQUG] IQUG Digest, Vol 77, Issue 3

Amoolya Ajmera Amoolya.Ajmera at rci.rogers.com
Fri May 10 13:01:30 MST 2019


Yes, block factor works successfully,  sql statement as below, and striped the backup across multiple partitioned disks / directories.

backup database block factor 100  to
'/export/dbdump/ backup1/EDB_backup_1'  size 50000000 to
'/export/dbdump/ backup2/EDB_backup_2'  size 50000000  to
'/export/dbdump/ backup3/EDB_backup_3'  size 50000000  to
'/export/dbdump/ backup4/EDB_backup_4' size 50000000 to
'/export/dbdump/ backup5/EDB_backup_5' size 50000000 to
'/export/dbdump/ backup6/EDB_backup_6'  size 50000000;
commit;

will have split into 6 different directories of 50G each.


-----Original Message-----
From: iqug-bounces at iqug.org <iqug-bounces at iqug.org> On Behalf Of iqug-request at iqug.org
Sent: May 9, 2019 1:49 PM
To: iqug at iqug.org
Subject: IQUG Digest, Vol 77, Issue 3

Send IQUG mailing list submissions to
iqug at iqug.org

To subscribe or unsubscribe via the World Wide Web, visit
http://iqug.org/mailman/listinfo/iqug
or, via email, send a message with subject or body 'help' to
iqug-request at iqug.org

You can reach the person managing the list at
iqug-owner at iqug.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of IQUG digest..."


Today's Topics:

   1. Re: IQUG Digest, Vol 77, Issue 2
      (Alhandra, Hugo, Vodafone Group (External))
   2. [iqug] IQ SQL trace -zr does not give userid or logins ?
      (Louie, David)


----------------------------------------------------------------------

Message: 1
Date: Thu, 9 May 2019 08:09:26 +0000
From: "Alhandra, Hugo, Vodafone Group (External)"
<hugo.alhandra at vodafone.com>
To: "iqug at iqug.org" <iqug at iqug.org>
Subject: Re: [IQUG] IQUG Digest, Vol 77, Issue 2
Message-ID:
<577B5F825377F544A85A69AC447B2413A122CBFC at VOEXM27W.internal.vodafone.com>

Content-Type: text/plain; charset="iso-8859-1"

Hi,
Have you tried to backup via virtual backup?

Also it's possible to tune the backup parameters, but it's better to check with storage guys what is the HBA bandwidth, and if you are getting there.
Ask them if it's possible to add more HBAs and if the storage is able to keep up.

Regards,
- ?
Hugo Alhandra
Database Administrator
hugo.alhandra at vodafone.com

gfi.pt? I? gfi.pt/jobs? I? Gfi News


C2 General

-----Original Message-----
From: iqug-bounces at iqug.org <iqug-bounces at iqug.org> On Behalf Of iqug-request at iqug.org
Sent: 8 de maio de 2019 20:00
To: iqug at iqug.org
Subject: IQUG Digest, Vol 77, Issue 2

Send IQUG mailing list submissions to
iqug at iqug.org

To subscribe or unsubscribe via the World Wide Web, visit
http://iqug.org/mailman/listinfo/iqug
or, via email, send a message with subject or body 'help' to
iqug-request at iqug.org

You can reach the person managing the list at
iqug-owner at iqug.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of IQUG digest..."


Today's Topics:

   1. [iqug] Improving FULL backups timings in IQ (Louie, David)


----------------------------------------------------------------------

Message: 1
Date: Wed, 8 May 2019 16:21:44 +0000
From: "Louie, David" <David.Louie at blackrock.com>
To: "iqug at dssolutions.com" <iqug at dssolutions.com>
Subject: [IQUG] [iqug] Improving FULL backups timings in IQ
Message-ID: <7665a12b467f439d8ee570142d4707b0 at blackrock.com>
Content-Type: text/plain; charset="utf-8"

There are several ways to increase performance of IQ backups.

Our database is now 40 TB and our full backups take 25 hours.

We dump the database currently to 12 stripes.  Any suggestions or best practices to determine the best number of stripes?

Has anyone tried turning off CRC or adding memory via the BLOCK FACTOR parm in the backup statement?

Thanks
David



This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/compliance/privacy-policy for more information about BlackRock?s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/about-us/contacts-locations.

? 2019 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20190508/451d744e/attachment-0001.html>

------------------------------

_______________________________________________
IQUG mailing list
IQUG at iqug.org
http://iqug.org/mailman/listinfo/iqug

End of IQUG Digest, Vol 77, Issue 2
***********************************


------------------------------

Message: 2
Date: Thu, 9 May 2019 17:47:28 +0000
From: "Louie, David" <David.Louie at blackrock.com>
To: "iqug at dssolutions.com" <iqug at dssolutions.com>
Subject: [IQUG] [iqug] IQ SQL trace -zr does not give userid or logins
?
Message-ID: <cc4ed8d6e49e4b7d88d63466fd1f6acc at blackrock.com>
Content-Type: text/plain; charset="utf-8"

We enabled 'sql' traces on a server and using the interface to get data



call sa_get_request_profile('/dump1/adwewd_tst_iq_zr.out')

go

select * from satmp_request_profile

go


While the output has sql statements we are not seeing login info which we need.


[cid:e0b18fbb-9502-4034-acaa-a6f43cd92807]


is this data not available in the sql traces?


Thanks

David





This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/compliance/privacy-policy for more information about BlackRock?s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/about-us/contacts-locations.

? 2019 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20190509/cd487e8c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pastedImage.png
Type: image/png
Size: 26757 bytes
Desc: pastedImage.png
URL: <http://iqug.org/pipermail/iqug/attachments/20190509/cd487e8c/attachment.png>

------------------------------

_______________________________________________
IQUG mailing list
IQUG at iqug.org
http://iqug.org/mailman/listinfo/iqug

End of IQUG Digest, Vol 77, Issue 3
***********************************




________________________________
This communication is confidential. We only send and receive email on the basis of the terms set out at www.rogers.com/web/content/emailnotice<http://www.rogers.com/web/content/emailnotice>



Ce message est confidentiel. Notre transmission et réception de courriels se fait strictement suivant les modalités énoncées dans l’avis publié à www.rogers.com/aviscourriel <http://www.rogers.com/aviscourriel>
________________________________


More information about the IQUG mailing list