Project Management

Plan Academy

Plan Academy Project Controls Training & Courses

Di Andrea Di Dio, fa

Notizie sulla certificazione PMP

OnlinePMCourses Online Project Management Video Courses to Build Your Project Career

  • How to Build a Lessons Learned Log: Step-by-Step
    by Mike Clayton on 20 Marzo 2025 at 5:55

    I made a video: Lessons Learned Meeting: How to Make it Excellent. But, how do you capture those lessons in a structured lessons learned log? The post How to Build a Lessons Learned Log: Step-by-Step appeared first on OnlinePMCourses.

  • Risk Analysis 101: How to Understand Threats to Your Project
    by Mike Clayton on 17 Marzo 2025 at 5:55

    No Project Manager can get by without knowing how to analyze project risk. Risk analysis sounds confusing, but I’ll make everything clear. The post Risk Analysis 101: How to Understand Threats to Your Project appeared first on OnlinePMCourses.

  • What Exactly do Iterative, Incremental, and Adaptive Mean?
    by Mike Clayton on 13 Marzo 2025 at 7:14

    Agile methods focus on small increments, iterative refinement, & adapting to circumstances. What do iterative, incremental, & adaptive mean? The post What Exactly do Iterative, Incremental, and Adaptive Mean? appeared first on OnlinePMCourses.

  • Communication Skills: What are the Best Books for Project Managers?
    by Mike Clayton on 10 Marzo 2025 at 5:55

    The largest part of your job as a Project Manager is communication. There are many great books to help you with your communication skills. The post Communication Skills: What are the Best Books for Project Managers? appeared first on OnlinePMCourses.

  • The Rise of Online Project Management Courses: A Path to Advancing Your Nursing MBA
    by Mike Clayton on 7 Marzo 2025 at 13:44

    In today’s rapidly evolving healthcare environment, project management (PM) has become a vital skill for professionals across all industries, including nursing and healthcare administration. With the increasing complexity of healthcare systems and patient care, professionals with a background in both nursing and project management are in high demand. This is where Online Project Management (PM) The post The Rise of Online Project Management Courses: A Path to Advancing Your Nursing MBA appeared first on OnlinePMCourses.

  • Artificial Intelligence in Project Management: AI and PM Primer
    by Mike Clayton on 6 Marzo 2025 at 5:55

    I have a lot of content about Artificial Intelligence and Project Management. This video summarizes the key elements. The post Artificial Intelligence in Project Management: AI and PM Primer appeared first on OnlinePMCourses.

  • Lead with Gravitas: 5 Ways to Convey Authority and Substance
    by Mike Clayton on 3 Marzo 2025 at 5:55

    Every Project Manager should aim for gravitas. The sense of authority & substance leads people to trust your judgment and rely on your advice. The post Lead with Gravitas: 5 Ways to Convey Authority and Substance appeared first on OnlinePMCourses.

  • Sustainable Project Management: Interview with David Smyth of GPM Global
    by Mike Clayton on 27 Febbraio 2025 at 5:55

    Project Managers need to think about sustainability in all its forms. GPM Global is establishing standards and processes. Here’s David Smyth. The post Sustainable Project Management: Interview with David Smyth of GPM Global appeared first on OnlinePMCourses.

  • Fabulous Meetings: How Can You Lead an Excellent Project Meeting?
    by Mike Clayton on 24 Febbraio 2025 at 5:55

    Every project manager I have met spends a lot of their time in meetings. So, how can you Lead an excellent project meeting? The post Fabulous Meetings: How Can You Lead an Excellent Project Meeting? appeared first on OnlinePMCourses.

  • What is a Project Charter? [aka a Project Mandate]
    by Mike Clayton on 20 Febbraio 2025 at 5:22

    In this video, I answer the question, what is a Project Charter? Or what is a Project Mandate? How to kick your project off formally. The post What is a Project Charter? [aka a Project Mandate] appeared first on OnlinePMCourses.

Di Andrea Di Dio, fa

Primavera P6: ridurre il DB locale PPMDBSQLite per velocizzare l’esecuzione dell’applicazione

Ciao come va? Se sei arrivato fino a qui potresti avere bisogno di velocizzare l’esecuzione dell’applicazione Oracle Primavera P6.
La breve guida è riferita alle installazioni con il DB locale di Primavera PPMDBSQLite.db e alla versione P6 Professional R16.2 (x64) anche se questa procedura può funzionare anche con altre versioni.
Per le problematiche riferite a DB Oracle Server in rete chiedete supporto al vostro amministratore IT.

Veniamo al problema, in pratica per ordine e per velocizzare P6 ho rimosso molti progetti dal Primavera ma la dimensione del DB non è mai diminuita.
Come vedi sotto, nel corso del tempo avevo fatto delle copie de DB e si può vedere come la dimensione sia sempre aumentata, seppure abbia a volte cancellato intere annualità di progetti.
Questo penso che sia il problema per cui quando copio un Progetto, o quando ne importo uno grande il processo di import non mi va mai alla fine, o fallisce oppure devo spegnere il programma e riavviare.

Così come altri database, sqlite non riduce le dimensioni dei datafile automaticamente quando vengono cancellati i dati. Quantomeno non lo fa per default.

Per risolvere il problema prima effettuati una copia di sicurezza de DB stesso, chiudi P6, e poi connettiti al database con la console di amministrazione, ovvero lanciando il comando:

sqlite3 NomeDBnel tuo caso penso sia
sqlite3 PPMDBSQLite.db

Una volta connesso, va lanciato il comando
VACUUM;
che comprime il datafile
Alla fine si esce dalla console con il comando
.q

Purtroppo probabilmente non hai quel comando disponibile sul PC, il comendo sqlite3 deriva da una installazione sqlite stand alone che esula dall’istallazione di primavera P6 che ha il driver del DB già al suo interno.

Per cui ho installato il pacchetto:
sqlite-tools-win32-x86-3290000.zip
(1.71 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exeprogram, and the sqlite3_analyzer.exe program.
(sha1: f009ff42b8c22886675005e3e57c94d62bca12b3)

Dal sito
https://www.sqlite.org/download.html

A.C:\Users\ofgod>cd \Users\ofgod\Downloads

C:\Users\ofgod\Downloads>cd sqlite-tools-win32-x86-3290000

C:\Users\ofgod\Downloads\sqlite-tools-win32-x86-3290000>sqlite3.exe \TEMP\PPMDBSQLite.db
SQLite version 3.29.0 2019-07-10 17:32:03
Enter “.help” for usage hints.
sqlite> VACUUM;
sqlite>
sqlite>
sqlite> .q

C:\Users\ofgod\Downloads\sqlite-tools-win32-x86-3290000>

Ora il file è quasi la metà come dimensione e spero siano stati ricostruiti anche gli indici.

Adesso P6 lavora meglio ed è veloce come ala prima installazione vuota dello stesso applicativo.

Buon lavoro, ricorda prima di fare questa operazione esporta e svuota progetti non più recenti da P6,

Chiudi P6

Fai una copia di sicurezza del PMDBSQLite.db

Lancia sqlite3 e poi i comandi interni ricordando il ; dopo lo statemend VACUUM.

Buon lavoro

A.D.D.

Di Andrea Di Dio, fa
it_ITItalian
it_ITItalian en_GBEnglish